GV$SES_OPTIMIZER_ENV

select
INST_ID,                 -- INST_ID NUMBER
SID_QKSCESEROW,          -- SID NUMBER
PNUM_QKSCESEROW,         -- ID NUMBER
PNAME_QKSCESEROW,        -- NAME VARCHAR2(40)
decode                   -- ISDEFAULT VARCHAR2(3)
  (bitand (FLAGS_QKSCESEROW, 2), 0, 'NO', 'YES'),
PVALUE_QKSCESEROW        -- VALUE VARCHAR2(25)
from
X$QKSCESES 
where
bitand (FLAGS_QKSCESEROW, 8) = 0 and (bitand (FLAGS_QKSCESEROW, 4) = 0 or bitand (FLAGS_QKSCESEROW, 2) = 0)
home |  up  |  mailbox