Viscosity
logo-black
  • Data
    • Database Services
      • Performance Assessment
      • Proactive Healthcheck
      • Database Migration & Consolidation
      • Performance Tuning
    • Microsoft Services
      • Microsoft Azure Services
      • Microsoft SQL Server Services
      • Microsoft Gold Azure Partner
    • Oracle Services
      • Oracle Database 19c
      • RAC
      • GoldenGate
      • Data Guard
      • Oracle & SQL Database
    • Viscosity Remote Services
  • Apps
    • App Dev Services
    • Oracle APEX
    • Viscosity AMP
    • Viscosity-ai
    • Shane-ai
  • Cloud
    • Cloud Services
    • Hybrid Cloud
    • Viscosity Edge Cloud
    • Virtualization & Cloud Expertise
    • Microsoft Azure Services
  • Infrastructure
    • Infrastructure Services
    • Exadata
      • Exadata Resale & Services
    • Oracle Database Appliance
      • Oracle Database Appliance Resale & Services
      • ODA Health Checks
    • Zero Data Loss Recovery Appliance
    • VMware to KVM Migration
  • Events
    • Upcoming Events
    • Virtual Training
    • 2025 Past Events
    • 2024 Past Events
    • 2023 Past Events
    • 2022 Past Events
  • About
    • About Us
    • News
    • Blogs
    • Publications
    • Contact
Hit enter to search or ESC to close
ENGAGE WITH US

Keeping Your Oracle Database Healthy

By Gary Gordhamer
November 15, 2022

I recently gave a virtual presentation about database patching and managing risk.  During the session one of the key takeaways is keeping your database healthy.  Although patching is part of keeping things healthy, there is a lot more.

One key is being proactive about health checks.  You should always do some basic database health checks during every patch or upgrade. In fact, you may also want to proactively perform some database health checks weekly or monthly, since many things can happen outside of DB patching.

 

I've personally been in many patching exercises where we planned a specific amount of time. Having tested the patch in a non-production, feeling confident things will go well. Only to find out that something else in the database is not healthy. Something only in production. Some code is invalid, or some system issue is going on. The patching window is now two times longer as we are fixing the problem we didn't know about and still trying to patch.

 

Oracle provides many great tools to help, ORAchk, EXAchk, and Autonomous Health Framework (AFH).
 
See note: Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAChk (Doc ID 2550798.1)
 

Running these tools proactively and reviewing the results on a regular basis is critical to a healthy system. Always do some basic database health checks on your database

  • Every patch or upgrade
  • Proactively perform weekly or monthly
  • Before and after a patch (compare)
Notice this is not just during patching, many things can happen outside of DB patching to corrupt your system!
 

Knowing there is an issue will help you plan your work and make sure your outages have the time you need and everyone is clear on the change that is needed.  The fewer surprises there are in the work you do, the more the business and management will trust what you are doing in the future.

 

There are other tools that Oracle provides outside of AHF.  Here is a list of some more Oracle-provided scripts and technical notes on things you can check in your database to show it is healthy.  This does not guarantee that the application that uses the database is healthy, this is more about the technical aspects of the database itself.

  • Database Upgrade Guide

  • Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAChk (Doc ID 2550798.1)

  • Script to Collect DB Upgrade / Migrate Diagnostic Information (dbupgdiag.sql) (Doc ID 556610.1)

  • hcheck.sql Script to Check for Known Problems in Oracle8i, Oracle9i, Oracle10g, Oracle 11g and Oracle 12c (Doc ID 136697.1)

  • Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (DOC ID 2118136.2)

  • Best Practices for running catalog, catproc and utlrp script (Doc ID 863312.1)

  • Debug and Validate Invalid Objects (Doc ID 300056.1)

  • Where Can I Find the Parallel Version of Utlrp.sql? (Doc ID 230136.1)

  • Master Note: Troubleshooting Oracle Data Dictionary (Doc ID 1506140.1)

  • Overview of Refreshing Materialized Views (Doc ID 549874.1)

  • How to Monitor the Progress of a Materialized View Refresh (MVIEW) (Doc ID 258021.1)

  • Script to Check the Status or State of the JVM within the Database (Doc ID 456949.1)

Hopefully, these notes give you a point in the right direction on how to help keep your database healthy during patching activities, even when you are not patching.

 
 
All posts
About Author
Gary Gordhamer

Gary is a Managing Principal Consultant at Viscosity North America. He has spent much of his career focusing on enterprise application landscape and business process digitization. His technical experiences range from Oracle E-Business Suite, middleware, database, and related technologies for the past 29 years. His professional background covers many industries including healthcare, manufacturing, utilities, and government. He is an active member of the Quest IOUG Database & Technology Community, serving on the advisory board. Gary is an Oracle ACE Pro, and a frequent presenter at Oracle OpenWorld and user group conferences.

SUBMIT YOUR COMMENT
logo for footer

Viscosity's core expertise includes:

Data Transformation, Emerging Technology, High Availability & Scalability Solutions, Cloud Migrations, Performance Tuning, Data Integrations, Machine Learning, APEX Development, and Custom Application Development.


Solutions

Resources

Partnerships

Careers

Clients

 

Contact
Email: sales@viscosityna.com

Telephone:
(469) 444-1380

Address:
3016 Communications Pkwy Suite 200, Plano, TX 75093

Copyright 2025. All Rights Reserved by Viscosity North America.