what to monitor by DBA ?-Infrastructure availability

Posted on June 8th, 2008 by admin

this is something my DBA friend Anil sent me for a small post.expecting from him more than this post as below.

What database aspects should be monitored?
One should implement a monitoring system to constantly monitor the following
aspects of a database. This can be achieved by writing custom scripts,
implementing Oracle’s Enterprise Manager, or buying a third-party monitoring
product. If an alarm is triggered, the system should automatically notify the
DBA (e-mail, page, etc.) to take appropriate action.

Infrastructure availability:

  • Is the database up and responding to requests ?
  • Are the listeners up and responding to requests?
  • Are the Oracle Names and LDAP Servers up and responding to requests ?
  • Are the Web Listeners up and responding to requests ?
  • Etc.

Things that can cause service outages:

  • Is the archive log destination filling up?
  • Objects getting close to their max extents
  • Tablespaces running low on free space/ Objects what would not be able to extend
  • User and process limits reached
  • Etc.

Add your opinion - this will move the pointer
get dashboard plugin?

Filed under: DBA (DataBase Administrator), ERP, Interview Questions(& answers), SQL

Free Dashboards

Here are some more interesting Articles
  • AIM (Application Implementation Method )
  • SGA data Structures - Shared Pool portion of the SGA
  • Oracle architecture- background processes
  • Agile Software Development
  • Benefits of Dashboards and its purpose
  • Benefits of Dashboards and its purpose

    • Leave a Reply

    You must be logged in to post a comment.

    « Differences Between Oracle Discoverer 4 Desktop Edition and Discoverer 4i Plus who changed my code ?-USER_OBJECTS - »

    • About InfoPurple

      InfoPurple is an Oracle Digest that collects best articles from the best minds from entire blogosphere. We collect them and post an excerpt and point back to the main site. This allows for a consolidated view of Oracle Apps related topics. If you would like to add your website to be included then please email us (infopurple8888 AT gmail DOT com) your web url. If you would like to get your website removed then send us an email and we will remove it. -- infoK purple