ORACLE

In Oracle 12c and later versions, auditing is possible with Unified audit as well as standard auditing. This feature allows role-based auditing. It is possible …

With Oracle 12.2.0.1, SQL * Plus is capable of displaying the result of a query as CSV. Its use is as follows. [crayon-6742a54457684239380802/] Options DELIMI[TER] …

This article contains information about Oracle User Operations like creating a new Oracle user, authorizing, changing password and dropping Oracle User. Create Oracle User CREATE …

if your Oracle client version is 11.1.0.7 and you use Oracle 12.2 databases with a patch applied after April 2018 PSU, you receive an error …

Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows. [crayon-6742a54457ae7399342263/] After the archives are created, sometimes writing …

This article contains information about Oracle SQL Plus tool. What is Oracle SQL Plus? SQL Plus is a tool for managing the database management system …

If you enable the unified audit feature announced with 12c, all audit records will be in the UNIFIED_AUDIT_TRAIL table. Logon failure records will not be …

If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell …

What is the SYSAUX Tablespace and What is it used for? In Oracle databases, SYSAUX tablespace is an auxiliary storage space for SYSTEM tablespace. Most …

What is Redo Apply? Redo Apply performs the task of creating a block-by-block copy of the Primary database. The operations are as follows; The RFS …