• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 650
  • Last Modified:

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:

  • 3
  • 2
2 Solutions
slightwv (䄆 Netminder) Commented:
Check out Health Monitor:

There are also many alerts/checks in Enterprise manager (or dbConsole) that tell you about things going on in the database.
A start would be on the enterprise manager .
I stole that from oracle forums
"check undo/temp/flashback configurations
- review non-default init parameters
- review shared memory setup
- check backup and recovery status/strategy
- check available space in tablespaces
- check if table/index statistics are currect
- check if tables might benefit from shrinking
- review security – unlocked user/ weak passwords
- check if there are indexes that are redundant / not ever used
- check if there are no missing indexes (ex. for fk)
- The presence of ORA-600/7445 errors in the alert log?
- Are any tablespaces nearly full (without autoextend)?
- A test of I/O throughput against some benchmark?
- A test of SQL response time against some benchmark (ala OEM)?
- ask customer/users about any known issues
- Licencing Audit
- Review of patch or even version status
- Check logs for oddities
- check for invalid objects
- review of performance, look at whole tuning arena
- Security
- suitability of backup strategy"

also you should have a look at this one  assuming you are dealing with an 11g db
hope that helps
slightwv (䄆 Netminder) Commented:
>>I stole that from oracle forums

You need to provide the link.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

pma111Author Commented:
Is there anywhere that details the exact checks that health monitor performs? What kind of issues is it looking for?
slightwv (䄆 Netminder) Commented:
I don't know where everything is spelled out.  The types of check performed is in the doc link I provided:

Oracle Support might be able to provide a detailed list of checks.
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

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now