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

        #######################################################