Check table fragmentation in Oracle
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…
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…