Please refer to an article to describe how to use oracle PL/SQL package to monitor health of database in Oracle 11g.
[url=http://www.oraclepoint.com]RYvb52DKyOraclePointxNdIvJOQf[/url]
You can learn from this article:
- examine which checks can be run while database online or offline
- know what checks needs additional parameter
- how to issue dictionary integrity check manually
- how to create HTML/XML report of checks by using DBMS_HM package
Please find article at attachment.
[url=http://www.oraclepoint.com]ElzKhZqHvOraclePointX9DHPc3qX[/url]