Shell Script to get EMAIL alerts for ABENDED PROCESSES in Oracle GoldenGate

Hi Readers, Below article will help you on  Shell Script to get EMAIL  alerts for ABENDED Processes in Oracle GoldenGate. Script : 

  Keep Script in Crontab :

The above script  will execute for every 5 minutes   Now check Output file in… Read More

ORACLE: GET NOTIFIED FOR TOP SQL’s ORDERED BY ELAPSED TIME

TOP SQL’s In this article,we will get notified for TOP SQL’s ORDERED BY ELAPSED TIME Step 1 : Create temporary tables to store  TOP SQL’s

Another table to store ALL SQL’s.

Step 2 : Create the below scripts to capture TOP SQL’s in tables… Read More

Oracle:HEALTH CHECK REPORT(Capturing Archive information).

Oracle:HEALTH CHECK REPORT(Capturing Archive information). In this article we will implement to capture the Archive information using Shell script. Lets create a table which can store Archive  information. Connect to SYS user and execute below statement.

Create unique index and primary key  on  ARCHIVE_USAGE_HISTORY… Read More

Oracle : SQLTREND.sql

 

Oracle : Shell script for Health Check in HTML Format