Monitoring oracle database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Monitoring oracle database

  1. #1
    Join Date
    Mar 2010
    Posts
    5

    Monitoring oracle database

    Hi All,

    I have doubt...

    please help me in this...

    In our company... they are creating new tool for monitoring all the oracle databases.... please tell me... what and all have to monitor....

    like tablespace, connectivity, listener dail and monthly...

    Regards,
    Rita

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    it is hard to list here ... If the databases are 10g why don't use Oracle Grid Control to monitor every thing?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Mar 2010
    Posts
    5

    monitoring oracle database

    Hi vijay,

    Thanks for replying me back.

    It's oracle 10g only. how it works. pls can u tell me.

    Regards,
    Rita

  4. #4
    Join Date
    Mar 2010
    Posts
    5

    Monitoring oracle database

    Hi all,

    But i want to list just 10 atleast. Please can anyone help me in this.

    Regards,
    Rita

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    ...is there a DBA involved in the project?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool Re-inventing the wheel

    Quote Originally Posted by Ritasam87 View Post
    Hi All,

    I have doubt...

    please help me in this...

    In our company... they are creating new tool for monitoring all the oracle databases.... please tell me... what and all have to monitor....

    like tablespace, connectivity, listener dail and monthly...

    Regards,
    Rita
    If someone in your company is "creating new tool" to monitor the database, then they are re-inventing the wheel.

    Oracle supplies the Enterprise Manager dbconsole and the Grid Control software which can be configured to monitor the database(s)/listener(s) and server(s).
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  7. #7
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20
    Dude,
    As our friend told you have Oracle Enterprise Manager dbconsole to monitor all stuffs
    But as a growing DBA you can write your own monitoring script by using Perl/sh or any scripting lang for gaining indepth knowledge.

    I can help with few things.

    1) Tablespace growth check, if the space reaches limit automatically increase size
    2) Database instance connectivity check
    3) ORA error message check in alert log file.
    4) Tablespace online and offline check.
    5) Any session holding locks for 30 mins.
    6) Montior trace file ans remove it older than 7 days.
    7) Space availabilty for next backup.
    8) Monitor Temp tablespace usage.
    9) Backup related script.
    10)Database statistics from statspack.
    11) Start and stop all DB servers.
    12) etc,etc ................


    if you want we can disucss on few scripts also.


    Thanks
    VJ
    "Sky is limit"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width