Home » RDBMS Server » Server Administration » Database Prod Sever Monitoring (11g, Linux)
Database Prod Sever Monitoring [message #435025] Sun, 13 December 2009 19:55 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All:

We will be migrating one of our database to the prod status very soon. Mostly we monitor for the space usage by using tablespace storage alerts with crontab sending email.

We need all the help about the critical parameters for a prod database to be monitored. Please advise about the parameters, critical setting or any possible script for a 11G database.


Any help, advise, suggestion will be highly appreciated.
Re: Database Prod Sever Monitoring [message #435026 is a reply to message #435025] Sun, 13 December 2009 20:26 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>Mostly we monitor for the space usage by using tablespace storage alerts with crontab sending email.
What is the maximum size you allow tablespace files to be?
For the fastest growing tablespace, how many days or weeks to fill up a new/empty datafile added to this tablespace?

>We need all the help about the critical parameters for a prod database to be monitored.
DB parameters should essentially be static.

>Any help, advise, suggestion will be highly appreciated.
You need real time OS monitoring by NAGIOS or similar s/w
on critical resources of RAM, Disk, CPU & Network.

[Updated on: Sun, 13 December 2009 20:27]

Report message to a moderator

icon6.gif  Re: Database Prod Sever Monitoring [message #435135 is a reply to message #435025] Mon, 14 December 2009 09:18 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member

Install the EM dbconsole and configure "monitoring".
Shocked
Re: Database Prod Sever Monitoring [message #435163 is a reply to message #435025] Mon, 14 December 2009 15:36 Go to previous message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
Grid control (install the agent only) will monitor with default thresholds.

Nets Edge
Previous Topic: Best way to move Oracle Home
Next Topic: Want to change sys password
Goto Forum:
  


Current Time: Wed Sep 28 09:14:35 CDT 2016

Total time taken to generate the page: 0.11178 seconds