How to check the setting of all hidden parameters

on July 2, 2014 at 12:37 pm
Posted In: Oracle odds and ends (Cat)

Run the following from an SQL*Plus session (connected as SYS):

ttitle – center  ‘All Instance Parameters’  skip 2

col ksppinm   format a28 heading ‘Parameter’ justify c trunc

col ksppstvl  format a40 heading ‘Value’     justify c trunc

col ksppstdf  format a8  heading ‘Default?’  justify c trunc

select

a.ksppinm,

b.ksppstvl,

b.ksppstdf

from

x$ksppi a, x$ksppcv b

where a.indx = b.indx

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

order by a.ksppinm;