Traditionally, the DGMGRL command SHOW CONFIGURATION VERBOSE not only retrieved detailed configuration information but also triggered a health check. The health check operation can be resource-intensive and time-consuming, especially when executed repeatedly across multiple database instances or as part of automated workflows.
Starting with Oracle 23.9 (and planned also for a future 19c Release Update), the behavior of SHOW CONFIGURATION VERBOSE changes with the introduction of the following fix:
Bug 37829413 – ‘SHOW CONFIGURATION VERBOSE’ UNNECESSARILY TRIGGERS A FORCED HEALTH CHECK
You can check it yourself in the Oracle Release Analyzer Diff Utility:
https://oradiff.oraclecorp.com/ords/r/oradiff/oradiff/search-fixes
Previous behavior
Each use of SHOW CONFIGURATION VERBOSE triggered a fresh, full health check before showing configuration details, regardless of whether up-to-date health information was needed.
New behavior
The command now returns comprehensive configuration details and property values without forcing an immediate health check.
Why this change?
This change eliminates unnecessary resource usage and network communication, improving performance especially in automated systems that repeatedly gather configuration info, such as Oracle TFA or custom scripts. The goal is to make monitoring and troubleshooting more efficient.
What’s the impact for me?
When you execute SHOW CONFIGURATION, at the bottom you see when the last health check was executed:
|
1 2 |
Configuration Status: SUCCESS (status updated 32 seconds ago) |
The health check is scheduled automatically every minute.
When there was a warning, it was common to execute “SHOW CONFIGURATION VERBOSE” to force a refresh of the status and get the most recent status. This won’t work anymore, and you’ll have to wait until the next scheduled health check.
In Oracle 23ai, you can still force a health check explicitly with:
|
1 |
SELECT dbms_dg.health_check FROM dual; |
Remember, avoid running it unless you are in an emergency!
—
Ludovico
Latest posts by Ludovico (see all)
- SHOW CONFIGURATION VERBOSE changes in 23.9 - August 14, 2025
- New views in Oracle Data Guard 23c - January 3, 2024
- New in Data Guard 21c and 23c: Automatic preparation of the primary - December 22, 2023