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

Oracle (SecureCRT) : Important Queries for UNDO Management

Dear Readers, In this article, we will see the following Oracle (SecureCRT) : Important Queries for UNDO Management. MenuBar : UNDO Tab Name : Undo_Usage

Tab Name : Undo_Contetion

Tab Name : Undo_Trend_Today

Tab Name : Undo_Usage_For_Sessions

Tab… Read More

Oracle : Important ASM Commands

Dear Readers, In this article, we will see the following Important ASM Commands. Tab Name : asm_free

Tab Name : ASMCMD>find file find +DATA01 undo* Tab Name : WhatInstances

Tab Name : Rebalance_status

Tab Name : ASM_Candidate

Tab… Read More

Oracle : TableSpace Menu Bar in SecureCRT

Dear Readers, In this article, we will see TableSpace Menu Bar in SecureCRT . TBS_FREE :

Out Put :

TBS_FILE :

SEGMENTBYNAME :

DBSIZE :

Seg_With_Highest_IO_Reads :

Out Put :

Seg_With_Highest_IO_Writes :… Read More

Oracle : How to Kill Blocking Sessions in RAC

Dear Readers, In this article, we will see Kill blocking sessions in RAC . Kill blocking sessions in RAC:

Output:

  Thank you for giving your valuable time to read the above information. Follow us on  Website             … Read More