GV$SPPARAMETER

select
INST_ID,                 -- INST_ID NUMBER
KSPSPFFTCTXSPSID,        -- SID VARCHAR2(80)
KSPSPFFTCTXSPNAME,       -- NAME VARCHAR2(80)
KSPSPFFTCTXSPVALUE,      -- VALUE VARCHAR2(255)
KSPSPFFTCTXISSPECIFIED,  -- ISSPECIFIED VARCHAR2(6)
KSPSPFFTCTXORDINAL,      -- ORDINAL NUMBER
KSPSPFFTCTXCOMMENT       -- UPDATE_COMMENT VARCHAR2(255)
from
x$kspspfile 
WHERE
((translate (KSPSPFFTCTXSPNAME,
'_',
'#') not like '#%') OR KSPSPFFTCTXISSPECIFIED = 'TRUE')
home |  up  |  mailbox