Skip to content

Instantly share code, notes, and snippets.

@dincosman

dincosman/query_underscore.sql

Last active March 6, 2022 20:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dincosman/a9438a5af05dea36aebc367e12cdb0a6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dincosman/a9438a5af05dea36aebc367e12cdb0a6 to your computer and use it in GitHub Desktop.
Download ZIP
The query for Oracle Hidden Parameters
Raw
query_underscore.sql
SQL> SELECT PI.KSPPINM PARAMETER_NAME, PSV.KSPPSTVL INSTANCE_VALUE
FROM X$KSPPI PI, X$KSPPCV PCV, X$KSPPSV PSV
WHERE PI.INDX = PCV.INDX
AND PI.INDX = PSV.INDX
AND ( PI.KSPPINM = '_HIGH_PRIORITY_PROCESSES'
OR PI.KSPPINM = '_HIGHEST_PRIORITY_PROCESSES'); --PARAMETER NAME
PARAMETER_NAME INSTANCE_VALUE
-------------- --------------
_highest_priority_processes VKTM
_high_priority_processes LMS*|LM1*|LM2*|LM3*|LM4*|LM5*|LM6*|LM7*|LM8*|LM9*|LM*|LCK0|CKPT|DBRM|RMS0|LGWR|CR*|RS0*|RS1*|RS2*
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment