Link to home
Start Free TrialLog in
Avatar of Pau Lo
Pau Lo

asked on

oracle dbms health checks

Are there any useful health check/best practices analyzer scripts or software for oracle databases, along the lines of the following for MS-SQL:

http://sqlmag.com/blog/microsoft-sql-server-2012-best-practices-analyzer-bpa
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>I stole that from oracle forums

You need to provide the link.
Avatar of Pau Lo

ASKER

Is there anywhere that details the exact checks that health monitor performs? What kind of issues is it looking for?
I don't know where everything is spelled out.  The types of check performed is in the doc link I provided:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag007.htm#CHDDGBJC

Oracle Support might be able to provide a detailed list of checks.