12c New Feature: Multi-Process Multi-Threaded Oracle

Starting with 12c the multithreaded Oracle model allows you to start threads within OS processes. This model is similar to windows where you have only one process and different threads from this one process. This Architecture have some Benefits: CPU usage reduction Memory usage reduction Better performance for parallel executions / operations Better system reliability…

Tablespace Encryption in Oracle 11g

Transparent Data Encryption (TDE) was introduced in Oracle 10G Release 2. Tablespace encryption helps you to secure the complete contents of one Tablespace instead of encrypt column by column. Oracle has also built in support for hardware-based crypto accelaration 11.2.0.2 for Intel XEON 5600 CPUs with AES-NI. Keep in mind that TDE can also be…

Client Process ID und Server Process ID in einer dedicated Verbindung ermitteln

Hallo, mit dem folgenden Beispiel bekommt man die Server Prozess ID bzw. seine Client Prozess ID in einer dedicated Session. SQL> SELECT p.spid oracle_dedicated_process, s.process clientpid FROM v$process p, v$session s WHERE p.addr = s.paddr AND s.sid = (select sid from v$mystat where rownum = 1); ORACLE_DEDICATED_PROCESS CLIENTPID ———————— ———————— 31831             31824…