oracle hidden parameter 조회

col KSPPINM format a50
col KSPPSTVL format a10
col KSPPDESC format a100

SELECT  A.KSPPINM, B.KSPPSTVL, A.KSPPDESC
FROM    X$KSPPI  A
      , X$KSPPSV  B
WHERE   SUBSTR(A.KSPPINM,1,1) = '_'
AND     A.INDX = B.INDX
AND     A.KSPPINM IN
       (
        '_PX_use_large_pool'
      , '_b_tree_bitmap_plans'
      , '_db_file_exec_read_count'
      , '_db_file_optimizer_read_count'
      , '_index_partition_large_extents'
      , '_memory_imm_mode_without_autosga'
      , '_object_statistics'
      , '_optim_peek_user_binds'
      , '_optimizer_adaptive_cursor_sharing'
      , '_optimizer_join_factorization'
      , '_optimizer_use_feedback'
      , '_partition_large_extents'
      , '_query_execution_cache_max_size'
      , '_sqlmon_threshold'
      , '_trace_files_public'
      , '_undo_autotune'
      , '_use_adaptive_log_file_sync'
       )
ORDER BY
        A.KSPPINM
;

select /*+ use_nl(x y) */

       x.indx+1 NUM

     , ksppinm NAME

     , ksppity TYPE

     , ksppstvl VALUE

     , ksppstdf ISDEFAULT

     , decode(bitand(ksppiflg/256, 1), 1, 'TRUE', 'FALSE') ISSES_MODIFIABLE

     , decode(bitand(ksppiflg/65536, 3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', 'FALSE') ISSYS_MODIFIABLE

     , decode(bitand(ksppstvf, 7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE') ISMODIFIED

     , decode(bitand(ksppstvf, 2), 2, 'TRUE', 'FALSE') ISADJUSTED

     , ksppdesc DESCRIPTION

  from x$ksppi x

     , x$ksppcv y

 WHERE x.indx = y.indx

   and x.indx + 1 not in (select distinct num from v$parameter)

   AND ksppinm like '%%' escape '\'

 order by ksppinm;