Feeds

Performing an Oracle database health check? We have a little list

Guidelines for the diligent DBA

  • alert
  • submit to reddit
Workshop

Workshop Everyone needs a checkup from time to time, and your Oracle database is no exception. A periodic medical can keep it running smoothly, and avoid more serious conditions from developing later.

Here is a guide to help ensure optimal performance, with a series of checkpoints that can form the basis for a regular database review.

Tools

You can use the Health Monitor available in release 11g to assess several aspects of your database's health. These include various data integrity checks for file structure, REDO logs and undo segments.

You can also use Toad for Oracle, which is one of the most popular third party administrator tools for the Oracle database. Toad users can launch database health checks either from the database browser, or from the diagnose menu.

Security

One of the areas that Toad for Oracle focuses on is security. DBAs can find the vulnerability assessment under its own category. It includes a variety of vulnerability checks, alongside an 'explainer' column, providing a description of each check as a friendly reminder to the DBA.

The assessment checks in Toad are many and varied, but they include listing listing hidden users and nested roles, and listing GRANTs on SYS tables granted directly to users.

DBAs can check many aspects of their Oracle database's health, and any health check should include a thorough security audit to ensure that there is no light leakage. A review should include the following:

  • Patch management procedures.
  • Backup recovery (test it).
  • User password management and access controls.
  • User roles and responsibilities.
  • Configuration parameters.
  • How your audit trail is configured.
  • Privileges (how are system and object privileges assigned? Who has them?)
  • Access to Oracle packages and privileges, including operating system access.
  • Which PL/SQL and Java is used, and how.

Space Management

Monitor and optimize your use of database space. There are two ways to do this: proactive tablespace management (PTM), and shrinking segments. Under PTM, Oracle warns database administrators when available space is running low. It has two thresholds when alerts are triggered: critical, and warning.

You can conduct this health check incrementally as space frees up in the database server, which helps you make space available to users when needed. Check the critical and warning thresholds of the table spaces to know how much of your table space is being used. By default, the settings are 97% critical and 85% warning.

Segment shrinkage makes unused space available to other segments in the tablespace. You can shrink a segment using the Enterprise Manager.

Next page: Mine the logs

More from The Register

next story
KDE releases ice-cream coloured Plasma 5 just in time for summer
Melty but refreshing - popular rival to Mint's Cinnamon's still a work in progress
Leaked Windows Phone 8.1 Update specs tease details of Nokia's next mobes
New screen sizes, dual SIMs, voice over LTE, and more
PEAK LANDFILL: Why tablet gloom is good news for Windows users
Sinofsky's hybrid strategy looks dafter than ever
Fiendishly complex password app extension ships for iOS 8
Just slip it in, won't hurt a bit, 1Password makers urge devs
Mozilla keeps its Beard, hopes anti-gay marriage troubles are now over
Plenty on new CEO's todo list – starting with Firefox's slipping grasp
Apple: We'll unleash OS X Yosemite beta on the MASSES on 24 July
Starting today, regular fanbois will be guinea pigs, it tells Reg
Another day, another Firefox: Version 31 is upon us ALREADY
Web devs, Mozilla really wants you to like this one
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.