Fragmentation is caused in table when we do update, delete operation within the table which make the space available in between the table which lead to fragmentation. The space is …

 Enable DDL logging in Oracle can be done in several ways. Enable the parameter ENABLE_DDL_LOGGING in Oracle 12c Enable the audit of the database and enable DDL auditing on objects …

 Check the Size and free space in ASM Disks set pagesize 200 set lines 200 set long 1000 col path for a50 col name for a10 col header_Status for a12 …

  ORA-31650: timeout waiting for master process response Error During execution of EXPDP or IMPDP, we are getting the following error: Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 …

  Trace logon failure in Oracle In Oracle we are going to trace the logon session which is not successfully for some reasons. Trace with Auditing 1. Check the auditing …

  Check the Size of Oracle Database and PDB databases Following Queries for NON-CDB database: Check the database size physical consume on disk.select sum(bytes)/1024/1024 size_in_mb from dba_data_files; Check the total …

 Undo tablespace is used for the rollback of the transaction when commit or rollback occurs during the transaction. The system will give preference to the DML operations against the undo …

  Check physical Standby is in sync Dataguard The following command will help to check the Standby is synced with Primary Database in Oracle Dataguard Environment. On Primary Server: Check …