Important Oracle v$parameters (SecureCRT)

Hi Dears, In this article, we will see Important Oracle v$parameters (SecureCRT) Tab Name : v$parameter Button Name : SGA

Output :

Button Name : SGA_TARGET

Output :

Button Name : PGA_Aggregate_target

Output :

Button Name :… Read More

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 : 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

SecureCRT Articles

Please check below articles to get good knowledge on SecureCRT . SNO DESCRIPTION ARTICLE LINK 1 Ease of DB Administration Via SecureCRT https://www.ktexperts.com/ease-of-db-administration-via-securecrt/ 2 SecureCRT Buttons for Default https://www.ktexperts.com/securecrt-buttons-for-default/ 3 Oracle : TableSpace Menu Bar in SecureCRT https://www.ktexperts.com/oracle-tablespace-menu-bar-in-securecrt/ 4 Oracle : Important ASM Commands https://www.ktexperts.com/oracle-important-asm-commands/… Read More

Oracle : Important Monitoring commands for EXPDP/IMPDP (SecureCRT)

Dear Readers, In this article, we will see the following Important Monitoring commands for EXPDP/IMPDP (SecureCRT). MenuBar : Datapump (Exports and Imports) Tab : DataPump_Sessions

Tab : Datapump_Progress

Tab : Datapump_jobs

Tab : DBA Directories

Tab :… Read More

Oracle : Important commands for Flashback (SecureCRT)

Dear Readers, In this article, we will see the following Important commands for Flashback (SecureCRT). Menubar : Flashback (FB) Tab : FRA_Usage

Tab : Check Restore Point

Tab : Flashback_DB_Logfile

Tab : dba_recyclebin

Tab : Check FB is or not?

Read More

Oracle (SecureCRT) : Temp Tablespace Monitoring Queries

Dear Readers, In this article, we will see Oracle (SecureCRT) : Temp Tablespace Monitoring Queries. Menubar : TEMP Tabname : Def_temp

Tabname : TS_Temp_Usage

Tabname : Temp_Space_Usage_SQLID

Tabname : Temp_sort_users

Tabname : Temp_Space_Usage_SQLID_Login_Active_InActive

Tabname : Addspace… Read More