Oracle Database from 18c and above can authenticate and authorize Microsoft Active Directory users with the database directly without intermediate directories or Oracle Enterprise User Security (like Oracle EUS 12c)…. Read more »
Oracle has finally certified Oracle Database solutions for KVM products.To have less problems with the Oracle auditor it is advisable to use their (free) solution called Oracle Linux Virtualization. Oracle Linux… Read more »
The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace, makes this information available in a uniform format in the UNIFIED_AUDIT_TRAIL data… Read more »
Automatically purging Sometimes we are facing with space related issues due to the huge number of trace file generation. Automatic purging can help us in this situations if set short… Read more »
This article is intended to provide an example for how to audit access by proxy users using the Unified Auditing feature brought out in Oracle Enterprise Database 12c. The sample… Read more »
The new features of Oracle 12c I had looked closer at possibility to move partitions online. You can move the partition while it is being accessed by DMLs and queries,… Read more »
The Unified Audit Trail has become too big, you cannot directly delete or truncate the table. You must call the dbms_audit_mgmt.clean_audit_trail. But then you want to know if it will… Read more »
Actually one of our slides gives a parameter recommendation to set AUDIT_TRAIL since Oracle 11g explicitly to the value you want as otherwise it may switch to “DB” and you… Read more »