Audit Current Global Variable Values Against Defaults

Suresh Ramagiri -

It's useful to compare global variable settings against the default in many cases. The best practice is to check these:

  • Before an upgrade
  • After an Upgrade
  • When encountering issues

We use the following query to check globals against the defaults. This ignores a few globals that are always different than the default, like license and cluster_id:

SQL> SELECT name, 
FROM   system.global_variables 
JOIN   system.global_variable_definitions 
USING  (name) 
WHERE  value != default_value 
AND    name NOT IN ('cluster_ssh_key_private', 
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk