Oracle : Shell Script to Send email if RAC services not running

Dear Readers, In this article, we wrote an automation job for  Shell Script to Send email if RAC services not running The below script will be sending an email if any services are stopped on RAC Nodes.

Script : 

–> It ignores some… 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 Sample Unix script to monitor select query during Load Test

Hi Dears, In this article, we will see Oracle Sample Unix script to monitor select query during Load Test  

Output :

  Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates KTEXPERTS is always… 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: 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