Loading....

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

        #######################################################
Please follow and like us:

Last Update: September 3, 2009  

September 3, 2009 219 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

,

4 thoughts on “DBA Monitoring Menu

  1. Gavin Soorma

    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

  2. aman

    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

Leave a Comment

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

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?