Posted on 2013-08-26
Medium Priority
Last Modified: 2013-08-31
What is database healthreport.sql

Is that already present?

or we have to create?
Question by:jcob_l
LVL 28

Accepted Solution

Naveen Kumar earned 2000 total points
ID: 39441247
The health check report means the scripts used to run on the database with which one can find out how good or bad the database is. "Health" is very general team which could cater from parameters set in the init.ora, database locks, object size/high water marks, process status, memory parameters, backups, OS level checks on which the database is hosted, invalid objects etc...

But below are few urls you can try for the scripts :


Also Just read thru this for your understanding :


LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39441920
In addition to the above links, I suggest the online docs:
Beginning with Release 11g, Oracle Database includes a framework called Health Monitor for running diagnostic checks on the database.


Since your previous questions involved RAC:
Oracle RAC Configuration Audit tool (RACcheck) is available with Oracle Grid Infrastructure 11g Release 2 ( for assessment of single instance and Oracle RAC database installations for known configuration issues, best practices, regular health checks, and pre- and post upgrade best practices.


Author Closing Comment

ID: 39455621
yes this is good

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question