Oracle : Important Commands for Dataguard (SecureCRT)

  Dear Readers, In this article, we will see the Oracle : Important Commands for Dataguard (SecureCRT) Menubar Name : Dataguard Tab Name : Instance_info

Tab Name : DG_GAP

Tab Name : ERR_DEST

Tab Name : Date Format

Tab Name :… Read More

Oracle : Important Queries for Parallel Feature (SecureCRT)

Dear Readers, In this article, we will see the Oracle : Important Queries for Parallel Feature (SecureCRT). Menubar Name : Parallel Tab Name : Create table show parameter parallel_max_servers

Tab Name : Finding_Parallel_Queries

Tab Name : Select Query with Parallel Option… Read More

Oracle: Important commands for Lock/Unlock Stats and Backup/Restore Old Stats (SecureCRT)

Dear Readers, In this article, we will see the Oracle: Important commands for Lock/Unlock Stats and Backup/Restore Old Stats (SecureCRT). MenuBar Name : Lock/Unlock Stats and Backup/Restore Old Stats Tab Name : Check Stats for Table

Tab Name : Backup Existing Stats

Tab… Read More

Oracle 19c Software Installation On Linux 7.6

In this article, we will see Oracle 19c (19.3) Software Installation On Linux 7.6 Click here to Download Oracle 19c Software from Oracle Support. Create a directory for ORACLE_HOME

Unzip the oracle 19c software

Goto Oracle home location and run the ./runinstaller

Start… Read More

Oracle : Important Queries to check Table Fragmentation (SecureCRT)

Dear Readers, In this article, we will see the Oracle : Important Queries to check Table Fragmentation (SecureCRT). Menubar Name : Fragmentation Tab name : Fragmented_tablesList in HTML

Output : Tab name : BLOCKS Size

Tab name : Rows Size

Tab name… Read More

Oracle : Important Queries to check Blocking sessions (SecureCRT)

Dear Readers, In this article, we will see the Oracle : Important Queries to check Blocking sessions (SecureCRT). Menubar : Blocking Tab : Blocking Sessions

Tab : Blocking_session_event

Tab : SQLs INVOLVED IN BLOCKING

Tab : Objects involved in Blocking Lock… Read More