| Database Prod Sever Monitoring [message #435025] |
Sun, 13 December 2009 19:55  |
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  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
