I have created a simple but very useful Unix shell script driven menu to enable easy monitoring of any number of Oracle databases from a single central location. This covers most of the normal DBA day to day standard monitoring requirements as well as a good interface for aiding in performance tuning.
Set up is pretty simple requiring a single user called MONITOR in each database with SELECT privilege on the data dictionary tables.
Drop me an email at gavin.soorma@bankwest.com.au so that I can send you the zip file along with the installation instructions.
A few screen shots of the various menu options are shown below
#######################################################
[DBA Menu - PRDU010]
Connected to Database- cpsprd
#######################################################
(1) Database Overview
(2) Database Storage
(3) Database Objects
(4) Database Security
(5) Database Monitor
(6) Database Performance
Enter your choice (q to quit):
########################################################
#######################################################
Database Monitoring Menu - cpsprd
#######################################################
(1) User Sessions
(2) Redo Log File Switches
(3) Current SQL (by Unix PID)
(4) Current SQL (by SID)
(5) Current SQL (by Oracle Username)
(6) Rollback Segment Usage
(7) Locked Sessions
(8) Locked Objects
(9) Datafile I/O
(10) DBMS Jobs Status
(11) View Long Operations
(12) Active Transactions
(13) Idle Sessions
(14) Flashback Logging
(15) Sessions With High I/O
(16) Data Guard Log Shipping
(17) Redo Generation By Day
Enter your choice (q to quit):
#######################################################
#######################################################
Database Performance Menu - cpsprd
#######################################################
(1) Waits - Instance Level (by time waited)
(2) Waits - By Class
(3) Waits - Waiting Session's SQL
(4) Waits - What are users currently waiting on?
(5) Waits - Datafile Level
(6) Waits - Block & Object Level
(7) Locked Sessions
(8) Large Objects In Shared Pool
(9) Hit Ratios - Quick Check
(10) Top 5 Problem Queries (Disk Reads)
(11) Top 5 Problem Queries (Buffer Gets)
(12) Top 5 Problem Queries (Disk Reads/Executions)
(13) Top 5 Queries (Executions)
(14) Top 5 Latch Waits (by sleeps)
(15) Top 5 Latch Waits (by misses)
(16) Current Waits On Latches
(17) Enqueue Waits - By Session
(18) Enqueue Waits - By Database
(19) Enqueue Waits - By Object
(20) Key CBO init.ora Parameters
(21) Tables ANALYZE Status
(22) Indexes ANALYZE Status
(23) Top Segments with most I/O
Enter your choice (q to quit):
#######################################################
The following two tabs change content below.
Gavin Soorma
Is this for Windows also?
mirza2k8@gmail.com
Hi Mirza – this needs to be installed on a UNIX platform as it is Unix shell script – but once installed you can monitor a database on any platform including Windows as long as there is SQL*Net connectivity between the machine where the menu is installed and the target machine
Dear Gavin,
Can you pls send us the DBA Monitoring Menu scripts to the provided email id.
Thanks for the support!!!
Regards,
Aman
Oracle DBA
Hi Aman – there is a download link in the post itself. Let me know if you cannot find it