Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes

Hello Readers,   In this article, we will learn Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes   Step 1 : Check GoldenGate processes

Step 2 : Create a script

  Step 3 :  Add entry in Crontab

 … Read More

SecureCRT Buttons for Default

Hello Reader In this article , we will cover SecureCRT Buttons for Default. ############Setting up Format (format): To convert invalid timestamp value and to check current date.

######### Instance Information (inst_info): This SQL outputs the information of instance that is up and running like… Read More

Shell Script to get EMAIL  alerts for STOPPED Processes in Oracle GoldenGate.

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

  Keep Script in Crontab :  

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

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