Oracle : Shell script for Crontab Monitoring alert

Hi Readers, In this article, we will see the Oracle : Shell script for Crontab Monitoring alert THIS SCRIPT WILL IDENTIFY changes with the crontab file made comparing with original file.

Config file :

Create original crontab file :

Add below… Read More

Oracle : RAC Important Commands (SecureCRT)

RAC Important Commands (SecureCRT) Dear Readers, In this article, we will see the Oracle : Important Commands for RAC (SecureCRT) Menu Bar : RAC Button : VD_Location

Button : ocrcheck

Button : ConfigDB

Button : config service

Button… Read More

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