Oracle : Check Partition Summary More than N Days (60 Days)

Dear Readers, In this article, we will see the following Check Partition Summary More than N Days (60 Days). Script :

Out Put :

  Thank you for giving your valuable time to read the above information. Follow us on  Website     … 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

Oracle: Comparison between Python and Shell Script for sending email for the set of SQL commands

Dear Readers, In this article, we will see the following Comparison between Python and Shell Script for sending email for the set of SQL commands. Python and Shell Script for sending email for the set of SQL commands: Shell Script:

Output:

Python Script:… 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