Hidden (verborgen) Oracle parameters opvragen
Stel de juiste instance in ({instance}):
oracle@...........> . oraenv
ORACLE_SID = [TESTRAC] ? {instance}
Login als sysdba:
Oracle@...........> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 14 12:35:43 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Formateer de uitvoer:
SQL> set linesize 200
SQL> set pagesize 100
Voer volgende statement uit:
SQL> SELECT
a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
FROM
x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE
a.indx = b.indx AND
a.indx = c.indx AND
a.ksppinm LIKE '/_%' escape '/';