healthreport

What is database healthreport.sql

Is that already present?

or we have to create?
jcob_lAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Naveen KumarProduction Manager / Application Support ManagerCommented:
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 :

http://anuj-singh.blogspot.sg/2011/10/oracle-health-check-report.html
http://appsdbaclass.blogspot.sg/2011/04/oracle-database-health-check-scripts_5816.html
http://rafioracledba.blogspot.sg/search/label/DBA%20Daily%20activities

Also Just read thru this for your understanding :

http://dbwatchs.15.ezp.no/content/download/913/5512/version/1/file/Health+check+report+for+Oracle+10g+database.pdf

Thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
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.

http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#CHDBIIGD

Since your previous questions involved RAC:
Oracle RAC Configuration Audit tool (RACcheck) is available with Oracle Grid Infrastructure 11g Release 2 (11.2.0.4) 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.

http://docs.oracle.com/cd/E11882_01/install.112/e41961/whatsnew.htm#CWLIN2909
0
jcob_lAuthor Commented:
yes this is good
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.