ITPub博客

首页 > 数据库 > 数据库开发技术 > What database aspects should be monitored?

What database aspects should be monitored?

原创 数据库开发技术 作者:tsinglee 时间:2007-12-01 10:30:23 0 删除 编辑

摘自orafaq

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:

  1. Is the database up and responding to requests
  2. Are the listeners up and responding to requests
  3. Are the Oracle Names and LDAP Servers up and responding to requests
  4. Are the Web Listeners up and responding to requests
  5. Etc.

Things that can cause service outages:

  1. Is the archive log destination filling up?
  2. Objects getting close to their max extents
  3. Tablespaces running low on free space/ Objects what would not be able to extend
  4. User and process limits reached
  5. Etc.
[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-987155/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892821