Oracle 隱藏引數(9i,10g,11g,12c)

myhuaer發表於2013-07-30
Oracle
Oracle 9i,10g,11g 隱藏引數：

  SELECT a.ksppinm Param,
         b.ksppstvl SessionVal,
         c.ksppstvl InstanceVal,
         a.ksppdesc Descr
    FROM x$ksppi a, x$ksppcv b, x$ksppsv c
   WHERE     a.indx = b.indx
         AND a.indx = c.indx
         AND a.ksppinm LIKE '/_%' ESCAPE '/'
ORDER BY 1
/


12c 隱藏引數檢視：

  SELECT ksppinm, ksppdesc
    FROM x$ksppi
   WHERE subsur (ksppinm, 1, 1) = '_'
ORDER BY 1, 2
/

_4030_dump_bitvec             bitvec to specify dumps prior to 4030 error

_4031_dump_bitvec             bitvec to specify dumps prior to 4031 error

_4031_dump_interval           Dump 4031 error once for each n-second interval

_4031_max_dumps               Maximum number of 4031 dumps for this process

_4031_sga_dump_interval       Dump 4031 SGA heapdump error once for each n-second interval

_4031_sga_max_dumps           Maximum number of SGA heapdumps

_ILM_FILTER_TIME              Upper filter time for ILM block compression

_ILM_FILTER_TIME_LOWER        Lower filter time for ILM block compression

_ILM_POLICY_NAME              User specified ILM policy name

_NUMA_instance_mapping        Set of nodes that this instance should run on

_NUMA_pool_size               aggregate size in bytes of NUMA pool

_PX_use_large_pool            Use Large Pool as source of PX buffers

__data_transfer_cache_size    Actual size of data transfer cache

...........



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/34596/viewspace-767495/，如需轉載，請註明出處，否則將追究法律責任。

相關文章