Oracle Performance Tuning Overview
This guide is a practical collection of shell scripts designed to assist Oracle Database Administrators in automating routine tasks. It empowers DBAs to save…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
Oracle Alert Log Monitoring with ORA- Error Notifications
Oracle alert logs contain critical information, including internal errors, startup/shutdown events, and ORA- errors. Monitoring these logs in real-time ensures issues are detected and…
Oracle Tablespace Usage Monitor with Email Alerts
Oracle tablespaces can grow unexpectedly due to user activity, data load, or long-running transactions. Proactive monitoring ensures that DBAs are notified before tablespaces run…
Automatically Archive and Compress Oracle Alert Logs
Oracle alert logs grow continuously and can consume significant disk space if not managed regularly. This automated script helps keep the logs tidy by…
Filesystem & ZFS Usage Alert Script for Unix/Linux
Keeping a close watch on disk space usage is critical for avoiding service disruptions in production environments. This shell script provides a unified solution…
Monitor Failed Login Attempts
This script reports failed login attempts (like ORA-1017 and ORA-28000) by querying the DBA_AUDIT_SESSION view. It scans for invalid logins in the last 15…
Monitor ASM Diskgroup Usage
This shell script monitors the space utilization of ASM diskgroups and sends an email alert when usage exceeds 90%. It’s essential for Oracle DBAs…
Monitoring Blocking Sessions in Oracle (RAC & Single Instance)
This script is part of the Shell Script Automations series for Oracle DBAs. It proactively checks for blocking sessions in the database and alerts…
Automate Deletion of Old Archive Logs Using RMAN
This shell script is part of the Shell Script Automations toolkit for Oracle DBAs. It helps automatically delete archive logs that are older than…
Monitoring Standby Apply Lag with Shell Script
This shell script is part of the Shell Script Automations toolkit for Oracle DBAs. It monitors Apply Lag on a standby database using Oracle…
GoldenGate Process Monitor
Automated Monitoring of Oracle GoldenGate Processes Using Shell Script This shell script is part of a broader Shell Script Automation toolkit designed for Oracle…
Shell Scripts Overview
This guide is a practical collection of shell scripts designed to assist Oracle Database Administrators in automating routine tasks. It empowers DBAs to save…