Also some changes have done to the Password file in the New Oracle 12c Database. Password file can now be stored in the ASM. This feature eliminates the behavior where the sys Passwort is changed on one RAC site only and the DBA forget to change it on the other nodes or after a recover…
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…
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…
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…
Peter`s DBA Blog 