SQL> connect / as sysdba
Connected.
SQL> select ksppinm,ksppstvl,ksppstdf,
decode(bitand(ksppiflg/256,1),1,'TRUE' ,'FALSE'), decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'D
EFERRED',3,'IMMEDIATE','FALSE'),
decode(bitand(ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE'),
decode(bitan 2 3 4 d(ksppstvf,2),2,'TRUE','FALSE'), ksppdesc
from x$ksppi x, x$ksppcv y where (x.indx = y.indx) and KSPPINM ='_small_table_threshold' ;
5
KSPPINM
----------------------------------------------------------------
KSPPSTVL
--------------------------------------------------------------------------------
KSPPSTDF DECOD DECODE(BI DECODE(BIT DECOD
--------- ----- --------- ---------- -----
KSPPDESC
----------------------------------------------------------------
_small_table_threshold
20
TRUE TRUE DEFERRED FALSE FALSE
threshold level of table size for direct reads