News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

DBA Monitoring Menu

  • Posted by Gavin Soorma
  • On September 3, 2009
  • 4 Comments
  • monitor database, monitoring menu

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):

        #######################################################
 1

4 Comments

Mirza
  • Oct 12 2009
Is this for Windows also? mirza2k8@gmail.com
Gavin Soorma
  • Oct 14 2009
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
aman
  • Jun 7 2012
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
Gavin Soorma
  • Jun 8 2012
Hi Aman - there is a download link in the post itself. Let me know if you cannot find it

Leave Reply

Your email address will not be published. Required fields are marked *