AUD$ table is used in oracle to store the auditing information. Auditing can be enabled for CREATE SESSION, LOGON, LOGOFF, SELECT, INSERT, DELETE statement You can enable auditing only when the AUDIT_TRAIL parameter is set to either DB or DB_EXTENDED value. You can check the parameter value as sqlplus / as sysdbashow parameter AUDIT_TRAIL 11g …
How to purge SYS.AUD$ table in Oracle Read More »
Oracle Apps DBA has too often troubleshoot various issues. I am giving here the Top 30 Useful oracle apps queries for DBA how to find form session id in oracle The below query will provide the session details for all the forms opened in the applications set linesize 1000 column username format a8 heading “User|Name” …
Sometimes, we may have done some mistakes and we are facing issues with TDE. If you have a good backup of the wallet then we can go back to the backup file.There are two files pertaining to the TDEewallet.p12 – This is the actual wallet filecwallet.sso – This is the autologin wallet To restore the …
How To Restore TDE Wallet Files From Backup in Oracle Database Read More »
TDE stands for Transparent Data Encryption. We can encrypt both the tablespace and individual table columns using TDE.This article, we will see the step by step process for TDE encryption in oracle 12c What is TDE (Transparent Data Encryption) How is TDE licensed? TDE is part of Oracle Advanced Security, which also includes Data Redaction. …
This post is about library cache lock and How to resolve library cache lock in oracle What is library cache lock This is used to control concurrency between clients of the library cache by acquiring a lock on the object handle. Uses are(a)One client can prevent other clients from accessing the same object(b)The client can …
In this post, we will see what is library cache pin and how to resolve library cache pin in oracle What is library cache Pin In the library cache, a database object is cached in 2 parts: “handle” and “object”. Library cache lock works on Handle and the Library cache pin is only held when …
how to resolve library cache pin in oracle Read More »
