Oracle : Shell script for Crontab Monitoring alert

Hi Readers, In this article, we will see the Oracle : Shell script for Crontab Monitoring alert THIS SCRIPT WILL IDENTIFY changes with the crontab file made comparing with original file.

Config file :

Create original crontab file :

Add below… Read More

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

Autonomous Transaction Processing

Autonomous Transaction Processing In this article, we will know about “ATP”   Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet the demands of a variety of applications: mission-critical transaction processing, mixed transactions and analytics, IoT, JSON… 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 Architecture Articles

Dear Readers, Please check the below articles to get good knowledge on Oracle Architecture. SNO Article Name Article Link 1 Startup and Shutdown modes in Oracle https://www.ktexperts.com/startup-and-shutdown-modes-in-oracle/ 2 ORACLE ARCHITECTURE -4(PHYSICAL REPRESENTATION OF DATABASE) https://www.ktexperts.com/oracle-architecture-4physical-representation-of-database/ 3 ORACLE OPTIONAL BACKGROUND PROCESSES https://www.ktexperts.com/oracle-optional-background-processes/ 4 ORACLE ARCHITECTURE -2… Read More