Shell script to alert us when specified background process exceeds limit

Hello Everyone, The below script will help us to find number of processes runs in the background and send us alerts based on warning and critical thresholds. Script : # ]$ cat /home/oracle/DBA/bin/running_process.sh

Script execution : Syntax : ./running_process.sh <PROCESS_NAME> <WARNING> <CRITICAL> Here I… Read More

Oracle : Shell Script to gather stats for Stale tables

Dear Readers, In this article, we wrote an automation job for Shell Script to gather stats for Stale tables. Note : 1) Please test the Shell script in Non-Prod before implementing it in Production. Script for gather stats for Stale tables

Output :

Read More

Oracle Production Support Scripts

Dear Readers, Please check the below articles to get good knowledge on Oracle Production Support Scripts. SNO Article Name Article Link 1 Oracle : Check Partition Summary More than N Days (60 Days) https://www.ktexperts.com/oracle-partition-check-summary-more-than-n-days-60-days/ 2 UNDO segments not Releasing Space https://www.ktexperts.com/undo-segments-not-releasing-space/ 3 Oracle : How… Read More

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