本篇文章为大家展示了Oracle12c版本中未归档隐藏参数有哪些，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。

创新互联公司是一家集网站设计制作、做网站、网站页面设计、网站优化SEO优化为一体的专业网络公司，已为成都等多地近百家企业提供网站建设服务。追求良好的浏览体验,以探求精品塑造与理念升华,设计最适合用户的网站页面。 合作只是第一步，服务才是根本,我们始终坚持讲诚信，负责任的原则，为您进行细心、贴心、认真的服务,与众多客户在蓬勃发展的市场环境中,互促共生。

我将列出Oracle 12.1.0.1c中所有未记录的参数。下面是一个查询，用于查看所有参数（已记录和未记录），这些参数包含提示时输入的字符串：

–出现提示时输入参数的名称

SET linesize 235
col Parameter FOR a50
col SESSION FOR a28
col Instance FOR a55
col S FOR a1
col I FOR a1
col D FOR a1
col Description FOR a90

SELECT 
  a.ksppinm  "Parameter",
  decode(p.isses_modifiable,'FALSE',NULL,NULL,NULL,b.ksppstvl) "Session",
  c.ksppstvl "Instance",
  decode(p.isses_modifiable,'FALSE','F','TRUE','T') "S",
  decode(p.issys_modifiable,'FALSE','F','TRUE','T','IMMEDIATE','I','DEFERRED','D') "I",
  decode(p.isdefault,'FALSE','F','TRUE','T') "D",
  a.ksppdesc "Description"
FROM x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter p
WHERE a.indx = b.indx AND a.indx = c.indx
  AND p.name(+) = a.ksppinm
  AND UPPER(a.ksppinm) LIKE UPPER('%&1%')
ORDER BY a.ksppinm;

Enter value for 1:

Here is the list of all (2984) undocumented parameters in Oracle 12.1.0.1c  :

SQL>     col parameter for a15 word_wrapped
col Description for a55 word_wrapped
set pagesize 50000
set linesize 80
select upper(KSPPINM) parameter,   ' : ',
KSPPDESC Description from x$ksppi
where substr(ksppinm,1,1) = '_'order by 1,3;

PARAMETER                     DESCRIPTION
—————                        ——————————————————-
_4030_DUMP_BITV  :  bitvec to specify dumps prior to 4030 error
EC

_4031_DUMP_BITV  :  bitvec to specify dumps prior to 4031 error
EC

_4031_DUMP_INTE  :  Dump 4031 error once for each n-second interval
RVAL

_4031_MAX_DUMPS  :  Maximum number of 4031 dumps for this process
_4031_SGA_DUMP_  :  Dump 4031 SGA heapdump error once for each n-second
INTERVAL            interval

_4031_SGA_MAX_D  :  Maximum number of SGA heapdumps
UMPS

_ABORT_ON_MRP_C  :  abort database instance when MRP crashes
RASH

_ABORT_RECOVERY  :  if TRUE, abort recovery on join reconfigurations
_ON_JOIN

_ACCEPT_VERSION  :  List of parameters for rolling operation
S

_ACTIVE_INSTANC  :  number of active instances in the cluster database
E_COUNT

_ACTIVE_SESSION  :  active session idle limit
_IDLE_LIMIT

_ACTIVE_SESSION  :  active session legacy behavior
_LEGACY_BEHAVIO
R

_ACTIVE_STANDBY  :  if TRUE optimize dlm reconfiguration for active/standby
_FAST_RECONFIGU     OPS
RATION

_AC_ENABLE_DSCN  :  Enable Dependent Commit SCN tracking
_IN_RAC

_ADAPTIVE_DIREC  :  Adaptive Direct Read
T_READ

_ADAPTIVE_DIREC  :  Adaptive Direct Write
T_WRITE

_ADAPTIVE_FETCH  :  enable/disable adaptive fetch in parallel group by
_ENABLED

_ADAPTIVE_LOG_F  :  Threshold for frequent log file sync mode switches (per
ILE_SYNC_HIGH_S     minute)
WITCH_FREQ_THRE
SHOLD

_ADAPTIVE_LOG_F  :  Polling interval selection bias (conservative=0,
ILE_SYNC_POLL_A     aggressive=100)
GGRESSIVENESS

_ADAPTIVE_LOG_F  :  Window (in seconds) for measuring average scheduling
ILE_SYNC_SCHED_     delay
DELAY_WINDOW

_ADAPTIVE_LOG_F  :  Ratio of redo synch time to expected poll time as a
ILE_SYNC_USE_PO     percentage
LLING_THRESHOLD

_ADAPTIVE_LOG_F  :  Percentage of foreground load from when post/wait was
ILE_SYNC_USE_PO     last used
STWAIT_THRESHOL
D

_ADAPTIVE_SCALA  :  Percentage of overlap across multiple outstanding
BLE_LOG_WRITER_     writes
DISABLE_WORKER_
THRESHOLD

_ADAPTIVE_SCALA  :  Increase in redo generation rate as a percentage
BLE_LOG_WRITER_
ENABLE_WORKER_T
HRESHOLD

_ADAPTIVE_WINDO  :  enable/disable adaptive window consolidator PX plan
W_CONSOLIDATOR_
ENABLED

_ADDM_AUTO_ENAB  :  governs whether ADDM gets run automatically after every
LE                  AWR snapshot

_ADDM_SKIPRULES  :  comma-separated list of ADDM nodes to skip
_ADDM_VERSION_C  :  governs whether ADDM checks the input AWR snapshot
HECK                version

_ADD_COL_OPTIM_  :  Allows new add column optimization
ENABLED

_ADD_NULLABLE_C  :  Allows add of a nullable column with default
OLUMN_WITH_DEFA     optimization
ULT_OPTIM

_ADD_STALE_MV_T  :  add stale mv to dependency list
O_DEPENDENCY_LI
ST

_ADD_TRIM_FOR_N  :  add trimming for fixed char semantics
LSSORT

_ADG_BUFFER_WAI  :  Active Dataguard buffer wait time in cs
T_TIMEOUT

_ADG_INSTANCE_R  :  enable ADG instance recovery
ECOVERY

_ADJUST_LITERAL  :  If TRUE, we will adjust the SQL/PLUS output
_REPLACEMENT

_ADR_MIGRATE_RU  :  Enable/disable ADR Migrate Runonce action
NONCE

_ADVANCED_INDEX  :  advanced index compression options
_COMPRESSION_OP
TIONS

_ADVANCED_INDEX  :  advanced index compression options2
_COMPRESSION_OP
TIONS_VALUE

_ADVANCED_INDEX  :  advanced index compression trace
_COMPRESSION_TR
ACE

_AFFINITY_ON     :  enable/disable affinity at run time
_AGED_OUT_CURSO  :  number of seconds an aged out session cached cursor
R_CACHE_TIME        stay in cache

_AGGREGATION_OP  :  settings for aggregation optimizations
TIMIZATION_SETT
INGS

_AIOWAIT_TIMEOU  :  Number of aiowait timeouts before error is reported
TS

_ALERT_EXPIRATI  :  seconds before an alert message is moved to exception
ON                  queue

_ALERT_MESSAGE_  :  Enable Alert Message Cleanup
CLEANUP

_ALERT_MESSAGE_  :  Enable Alert Message Purge
PURGE

_ALERT_POST_BAC  :  Enable Background Alert Posting
KGROUND

_ALLOCATE_CREAT  :  should files be examined in creation order during
ION_ORDER           allocation

_ALLOCATION_UPD  :  interval at which successful search in L1 should be
ATE_INTERVAL        updated

_ALLOW_CELL_SMA  :  Allow checking smart_scan_capable Attr
RT_SCAN_ATTR

_ALLOW_COMMUTAT  :  allow for commutativity of +, * when comparing
IVITY               expressions

_ALLOW_COMPATIB  :  allow advancing DB compatibility with guaranteed
ILITY_ADV_W_GRP     restore points

_ALLOW_DROP_SNA  :  Allow dropping snapshot standby guaranteed restore
PSHOT_STANDBY_G     point
RSP

_ALLOW_DROP_TS_  :  Allow drop Tablespace with guaranteed restore points
WITH_GRP

_ALLOW_ERROR_SI  :  Allow error simulation for testing
MULATION

_ALLOW_FILE_1_O  :  don’t signal ORA-1245 due to file 1 being offline
FFLINE_ERROR_12
45

_ALLOW_LEVEL_WI  :  allow level without connect by
THOUT_CONNECT_B
Y

_ALLOW_READ_ONL  :  allow read-only open even if database is corrupt
Y_CORRUPTION

_ALLOW_RESETLOG  :  allow resetlogs even if it will cause corruption
S_CORRUPTION

_ALLOW_TERMINAL  :  Finish terminal recovery even if it may cause
_RECOVERY_CORRU     corruption
PTION

_ALL_SHARED_DBL  :  treat all dblinks as shared
INKS

_ALTERNATE_IOT_  :  enable alternate index-organized table leaf-block
LEAF_BLOCK_SPLI     split-points
T_POINTS

_ALTER_COMMON_U  :  allow local user to create objects in common schema
SER_SCHEMA

_ALWAYS_ANTI_JO  :  always use this method for anti-join when possible
IN

_ALWAYS_SEMI_JO  :  always use this method for semi-join when possible
IN

_ALWAYS_STAR_TR  :  always favor use of star transformation
ANSFORMATION

_AM_CONTAINER_F  :  allocation unit size for non-ASM containers
ILESYSTEM_AUSIZ
E

_AM_MAX_CONTAIN  :  maximum number of containers
ERS

_AM_MAX_GROUPS   :  maximum number of containers
_AM_MAX_SEG_BYT  :  maximum number of bytes per array segment
ES

_AM_TIMEOUTS_EN  :  enable timeouts
ABLED

_AM_TRACE_BUFFE  :  size of per-process I/O trace buffer
R_SIZE

_AND_PRUNING_EN  :  allow partition pruning based on multiple mechanisms
ABLED

_APPQOS_CDB_SET  :  QoSM CDB Performance Class Setting
TING

_APPQOS_PO_MULT  :  Multiplier for PC performance objective value
IPLIER

_APPQOS_QT       :  System Queue time retrieval interval
_AQSHARDED_CACH  :  Limit for cached enqueue/dequeue operations
E_LIMIT

_AQ_DISABLE_X    :  AQ – Disable new cross processes at an instance
_AQ_DQ_SESSIONS  :  Deq session count
_AQ_EQ_SESSIONS  :  Enq session count
_AQ_INIT_SHARDS  :  Minimum enqueue shards per queue at an instance
_AQ_MAX_SCAN_DE  :  Maximum allowable scan delay for AQ indexes and IOTs
LAY

_AQ_PRECRT_PART  :  Precreate Partitions
ITIONS

_AQ_PT_PROCESSE  :  Partition background processes
S

_AQ_STOP_BACKGR  :  Stop all AQ background processes
OUNDS

_AQ_SUBSHARD_SI  :  Sub Shard Size
ZE

_AQ_TM_DEQCOUNT  :  dequeue count interval for Time Managers to cleanup DEQ
INTERVAL            IOT BLOCKS

_AQ_TM_SCANLIMI  :  scan limit for Time Managers to clean up IOT
T

_AQ_TM_STATISTI  :  statistics collection window duration
CS_DURATION

_ARCH_COMPRESSI  :  archive compression enabled
ON

_ARCH_COMPRESS_  :  enable/disable row checksums for archive compressed
CHECKSUMS           blocks

_ARCH_COMP_DBG_  :  archive compression scan debug
SCAN

_ARCH_COMP_DEC_  :  decompress archive compression blocks for checking and
BLOCK_CHECK_DUM     dumping
P

_ARCH_IO_SLAVES  :  ARCH I/O slaves
_ARCH_SIM_MODE   :  Change behavior of local archiving
_ARRAY_CDB_VIEW  :  array mode enabled for CDB views
_ENABLED

_ARRAY_UPDATE_V  :  Enable array update vector read
ECTOR_READ_ENAB
LED

_ASH_COMPRESSIO  :  To enable or disable string compression in ASH
N_ENABLE

_ASH_DISK_FILTE  :  Ratio of the number of in-memory samples to the number
R_RATIO             of samples actually written to disk

_ASH_DISK_WRITE  :  To enable or disable Active Session History flushing
_ENABLE

_ASH_DUMMY_TEST  :  Oracle internal dummy ASH parameter used ONLY for
_PARAM              testing!

_ASH_EFLUSH_TRI  :  The percentage above which if the in-memory ASH is full
GGER                the emergency flusher will be triggered

_ASH_ENABLE      :  To enable or disable Active Session sampling and
flushing

_ASH_MIN_MMNL_D  :  Minimum Time interval passed to consider MMNL Dump
UMP

_ASH_SAMPLE_ALL  :  To enable or disable sampling every connected session
including ones waiting for idle waits

_ASH_SAMPLING_I  :  Time interval between two successive Active Session
NTERVAL             samples in millisecs

_ASH_SIZE        :  To set the size of the in-memory Active Session History
buffers

_ASMSID          :  ASM instance id
_ASM_ACCESS      :  ASM File access mechanism
_ASM_ACD_CHUNKS  :  initial ACD chunks created
_ASM_ADMIN_WITH  :  Does the sysdba role have administrative privileges on
_SYSDBA             ASM?

_ASM_ALLOWDEGEN  :  Allow force-mounts of DGs w/o proper quorum
ERATEMOUNTS

_ASM_ALLOW_APPL  :  Allow DROP DISK/FAILUREGROUP NOFORCE on ASM Appliances
IANCE_DROPDISK_
NOFORCE

_ASM_ALLOW_LVM_  :  Enable disk resilvering for external redundancy
RESILVERING

_ASM_ALLOW_ONLY  :  Discovery only raw devices
_RAW_DISKS

_ASM_ALLOW_SYST  :  if system alias renaming is allowed
EM_ALIAS_RENAME

_ASM_ALLOW_UNSA  :  attempt unsafe reconnect to ASM
FE_RECONNECT

_ASM_APPLIANCE_  :  Appliance configuration file name
CONFIG_FILE

_ASM_AUSIZE      :  allocation unit size
_ASM_AUTOMATIC_  :  automatically rebalance free space across zones
REZONE

_ASM_AVOID_PST_  :  Avoid PST Scans
SCANS

_ASM_BLKSIZE     :  metadata block size
_ASM_CHECK_FOR_  :  check for misbehaving CF-holding clients
MISBEHAVING_CF_
CLIENTS

_ASM_COMPATIBIL  :  default ASM compatibility level
ITY

_ASM_DBA_BATCH   :  ASM Disk Based Allocation Max Batch Size
_ASM_DBA_SPCCHK  :  ASM Disk Based Allocation Space Check Threshold
_THLD

_ASM_DBA_THRESH  :  ASM Disk Based Allocation Threshold
OLD

_ASM_DBMSDG_NOH  :  dbms_diskgroup.checkfile does not check block headers
DRCHK

_ASM_DIAG_DEAD_  :  diagnostics for dead clients
CLIENTS

_ASM_DIRECT_CON  :  Expire time for idle direct connection to ASM instance
_EXPIRE_TIME

_ASM_DISABLE_AM  :  Disable AMDU dump
DU_DUMP

_ASM_DISABLE_AS  :  disable async intra-instance messaging
YNC_MSGS

_ASM_DISABLE_MU  :  Disable checking for multiple ASM instances on a given
LTIPLE_INSTANCE     node
_CHECK

_ASM_DISABLE_PR  :  disable profile query for discovery
OFILEDISCOVERY

_ASM_DISABLE_SM  :  Do Not create smr
R_CREATION

_ASM_DISABLE_UF  :  disable ufg member kill
GMEMBERKILL

_ASM_DISABLE_UF  :  disable terminated umbilicus diagnostic
G_DUMP

_ASM_DISKERR_TR  :  Number of read/write errors per disk a process can
ACES                trace

_ASM_DISKGROUPS  :  disk groups to mount automatically set 2
2

_ASM_DISKGROUPS  :  disk groups to mount automatically set 3
3

_ASM_DISKGROUPS  :  disk groups to mount automatically set 4
4

_ASM_DISK_REPAI  :  seconds to wait before dropping a failing disk
R_TIME

_ASM_EMULATE_NF  :  Emulate NFS disk test event
S_DISK

_ASM_EMULMAX     :  max number of concurrent disks to emulate I  /O errors
_ASM_EMULTIMEOU  :  timeout before emulation begins (in 3s ticks)
T

_ASM_ENABLE_XRO  :  Enable XROV capability
V

_ASM_EVENREAD    :  ASM Even Read level
_ASM_EVENREAD_A  :  ASM Even Read Alpha
LPHA

_ASM_EVENREAD_A  :  ASM Even Read Second Alpha
LPHA2

_ASM_EVENREAD_F  :  ASM Even Read Fast Start Threshold
ASTSTART

_ASM_FAIL_RANDO  :  Randomly fail some RX enqueue gets
M_RX

_ASM_FOB_TAC_FR  :  Timeout frequency for FOB cleanup
EQUENCY

_ASM_FORCE_QUIE  :  Force diskgroup quiescing
SCE

_ASM_GLOBAL_DUM  :  System state dump level for ASM asserts
P_LEVEL

_ASM_HBEATIOWAI  :  number of secs to wait for PST Async Hbeat IO return
T

_ASM_HBEATWAITQ  :  quantum used to compute time-to-wait for a PST Hbeat
UANTUM              check

_ASM_HEALTHCHEC  :  seconds until health check takes action
K_TIMEOUT

_ASM_IMBALANCE_  :  hundredths of a percentage of inter-disk imbalance to
TOLERANCE           tolerate

_ASM_INSTLOCK_Q  :  ASM Instance Lock Quota
UOTA

_ASM_IOSTAT_LAT  :  ASM I/O statistics latch count
CH_COUNT

_ASM_KFDPEVENT   :  KFDP event
_ASM_KILL_UNRES  :  kill unresponsive ASM clients
PONSIVE_CLIENTS

_ASM_LIBRARIES   :  library search order for discovery
_ASM_LOG_SCALE_  :  Rebalance power uses logarithmic scale
REBALANCE

_ASM_LSOD_BUCKE  :  ASM lsod bucket size
T_SIZE

_ASM_MAXIO       :  Maximum size of individual I/O request
_ASM_MAX_COD_ST  :  maximum number of COD strides
RIDES

_ASM_MAX_REDO_B  :  asm maximum redo buffer size
UFFER_SIZE

_ASM_NETWORKS    :  ASM network subnet addresses
_ASM_NETWORK_TI  :  Keepalive timeout for ASM network connections
MEOUT

_ASM_NODEKILL_E  :  secs until escalating to nodekill if fence incomplete
SCALATE_TIME

_ASM_NOEVENREAD  :  List of disk groups having even read disabled
_DISKGROUPS

_ASM_PARTNER_TA  :  target maximum number of disk partners for repartnering
RGET_DISK_PART

_ASM_PARTNER_TA  :  target maximum number of failure group relationships
RGET_FG_REL         for repartnering

_ASM_PRIMARY_LO  :  Number of cycles/extents to load for non-mirrored files
AD

_ASM_PRIMARY_LO  :  True if primary load is in cycles, false if extent
AD_CYCLES           counts

_ASM_PROCS_TRAC  :  Number of processes allowed to trace a disk failure
E_DISKERR

_ASM_PROXY_STAR  :  Maximum time to wait for ASM proxy connection
TWAIT

_ASM_RANDOM_ZON  :  Random zones for new files
E

_ASM_REBALANCE_  :  maximum rebalance work unit
PLAN_SIZE

_ASM_REBALANCE_  :  number of out of space errors allowed before aborting
SPACE_ERRORS        rebalance

_ASM_REMOTE_CLI  :  timeout before killing disconnected remote clients
ENT_TIMEOUT

_ASM_REPAIRQUAN  :  quantum (in 3s) used to compute elapsed time for disk
TUM                 drop

_ASM_RESERVE_SL  :  reserve ASM slaves for CF txns
AVES

_ASM_RESYNCCKPT  :  number of extents to resync before flushing checkpoint
_ASM_ROOT_DIREC  :  ASM default root directory
TORY

_ASM_RUNTIME_CA  :  runtime capability for volume support returns supported
PABILITY_VOLUME
_SUPPORT

_ASM_SCRUB_LIMI  :  ASM disk scrubbing power
T

_ASM_SECONDARY_  :  Number of cycles/extents to load for mirrored files
LOAD

_ASM_SECONDARY_  :  True if secondary load is in cycles, false if extent
LOAD_CYCLES         counts

_ASM_SERIALIZE_  :  Serialize volume rebalance
VOLUME_REBALANC
E

_ASM_SHADOW_CYC  :  Inverse shadow cycle requirement
LE

_ASM_SKIP_DISKV  :  skip client side discovery for disk revalidate
AL_CHECK

_ASM_SKIP_RENAM  :  skip the checking of the clients for s/w compatibility
E_CHECK             for rename

_ASM_SKIP_RESIZ  :  skip the checking of the clients for s/w compatibility
E_CHECK             for resize

_ASM_STORAGEMAY  :  PST Split Possible
SPLIT

_ASM_STRIPESIZE  :  ASM file stripe size
_ASM_STRIPEWIDT  :  ASM file stripe width
H

_ASM_SYNC_REBAL  :  Rebalance uses sync I/O
ANCE

_ASM_TRACE_LIMI  :  Time-out in milliseconds to reset the number of traces
T_TIMEOUT           per disk and the number of processes allowed to trace

_ASM_USD_BATCH   :  ASM USD Update Max Batch Size
_ASM_WAIT_TIME   :  Max/imum time to wait before asmb exits
_ASSM_DEFAULT    :  ASSM default
_ASSM_FORCE_FET  :  enable metadata block fetching in ASSM segment scan
CHMETA

_ASSM_HIGH_GSP_  :  Number of blocks rejected before growing segment
THRESHOLD

_ASSM_LOW_GSP_T  :  Number of blocks rejected before collecting stats
HRESHOLD

_ASYNC_RECOVERY  :  if TRUE, issue recovery claims asynchronously
_CLAIMS

_ASYNC_RECOVERY  :  if TRUE, issue recovery reads asynchronously
_READS

_ASYNC_TS_THRES  :  check tablespace thresholds asynchronously
HOLD

_AUTOMATIC_MAIN  :  Enable AUTOTASK Test Mode
TENANCE_TEST

_AUTOMEMORY_BRO  :  memory broker statistics gathering interval for auto
KER_INTERVAL        memory

_AUTOTASK_MAX_W  :  Maximum Logical Maintenance Window Length in minutes
INDOW

_AUTOTASK_MIN_W  :  Minimum Maintenance Window Length in minutes
INDOW

_AUTOTASK_TEST_  :  Name of current Autotask Test (or test step)
NAME

_AUTOTUNE_GTX_I  :  idle time to trigger auto-shutdown a gtx background
DLE_TIME            process

_AUTOTUNE_GTX_I  :  interval to autotune global transaction background
NTERVAL             processes

_AUTOTUNE_GTX_T  :  auto-tune threshold for degree of global transaction
HRESHOLD            concurrency

_AUTO_ASSIGN_CG  :  auto assign CGs for sessions
_FOR_SESSIONS

_AUTO_BMR        :  enable/disable Auto BMR
_AUTO_BMR_BG_TI  :  Auto BMR Process Run Time
ME

_AUTO_BMR_FC_TI  :  Auto BMR Flood Control Time
ME

_AUTO_BMR_PUB_T  :  Auto BMR Publish Timeout
IMEOUT

_AUTO_BMR_REQ_T  :  Auto BMR Requester Timeout
IMEOUT

_AUTO_BMR_SESS_  :  Auto BMR Request Session Threshold
THRESHOLD

_AUTO_BMR_SYS_T  :  Auto BMR Request System Threshold
HRESHOLD

_AUTO_MANAGE_EN  :  perodically check for OFFLINE disks and attempt to
ABLE_OFFLINE_CH     ONLINE
ECK

_AUTO_MANAGE_EX  :  Automate Exadata disk management
ADATA_DISKS

_AUTO_MANAGE_IN  :  TEST: Set infrequent timeout action to run at this
FREQ_TOUT           interval, unit is seconds

_AUTO_MANAGE_IO  :  oss_ioctl buffer size, to read and respond to cell
CTL_BUFSZ           notifications

_AUTO_MANAGE_MA  :  Max. attempts to auto ONLINE an ASM disk
X_ONLINE_TRIES

_AUTO_MANAGE_NU  :  Max. number of out-standing msgs in the KXDAM pipe
M_PIPE_MSGS

_AUTO_MANAGE_NU  :  Num. tries before giving up on a automation operation
M_TRIES

_AUTO_MANAGE_ON  :  Allow Max. attempts to auto ONLINE an ASM disk after
LINE_TRIES_EXPI     lapsing this time (unit in seconds)
RE_TIME

_AUX_DFC_KEEP_T  :  auxiliary datafile copy keep time in minutes
IME

_AVAILABLE_CORE  :  number of cores for this instance
_COUNT

_AVOID_PREPARE   :  if TRUE, do not prepare a buffer when the master is
local

_AWR_CDBPERF_TH  :  Setting for AWR CDBPERF Threshold
RESHOLD

_AWR_CORRUPT_MO  :  AWR Corrupt Mode
DE

_AWR_DISABLED_F  :  Disable flushing of specified AWR tables
LUSH_TABLES

_AWR_FLUSH_THRE  :  Enable/Disable Flushing AWR Threshold Metrics
SHOLD_METRICS

_AWR_FLUSH_WORK  :  Enable/Disable Flushing AWR Workload Metrics
LOAD_METRICS

_AWR_MMON_CPUUS  :  Enable/disable AWR MMON CPU Usage Tracking
AGE

_AWR_MMON_DEEP_  :  Allows deep purge to purge AWR data for all expired
PURGE_ALL_EXPIR     snapshots
ED

_AWR_MMON_DEEP_  :  Set extent of rows to check each deep purge run
PURGE_EXTENT

_AWR_MMON_DEEP_  :  Set interval for deep purge of AWR contents
PURGE_INTERVAL

_AWR_MMON_DEEP_  :  Set max number of rows per table to delete each deep
PURGE_NUMROWS       purge run

_AWR_PDB_REGIST  :  Parameter to enable/disable AWR PDB Registration
RATION_ENABLED

_AWR_REMOTE_TAR  :  AWR Remote Target DBLink for Flushing
GET_DBLINK

_AWR_RESTRICT_M  :  AWR Restrict Mode
ODE

_AWR_SQL_CHILD_  :  Setting for AWR SQL Child Limit
LIMIT

_BACKUP_ALIGN_W  :  align backup write I/Os
RITE_IO

_BACKUP_AUTOMAT  :  automatic retry on backup write errors
IC_RETRY

_BACKUP_DISK_BU  :  number of buffers used for DISK channels
FCNT

_BACKUP_DISK_BU  :  size of buffers used for DISK channels
FSZ

_BACKUP_DISK_IO  :  BACKUP Disk I/O slaves
_SLAVES

_BACKUP_DYNAMIC  :  dynamically compute backup/restore buffer sizes
_BUFFERS

_BACKUP_ENCRYPT  :  specifies encryption block optimization mode
_OPT_MODE

_BACKUP_FILE_BU  :  number of buffers used for file access
FCNT

_BACKUP_FILE_BU  :  size of buffers used for file access
FSZ

_BACKUP_IO_POOL  :  memory to reserve from the large pool
_SIZE

_BACKUP_KGC_BLK  :  specifies buffer size to be used by HIGH compression
SIZ

_BACKUP_KGC_BUF  :  specifies buffer size to be used by BASIC compression
SZ

_BACKUP_KGC_MEM  :  specifies memory level for MEDIUM compression
LEVEL

_BACKUP_KGC_NIT  :  specifies number of iterations done by BASIC
ERS                 compression

_BACKUP_KGC_PER  :  specifies compression (performance) level for MEDIUM
FLEVEL              compression

_BACKUP_KGC_SCH  :  specifies compression scheme
EME

_BACKUP_KGC_TYP  :  specifies compression type used by kgc BASIC
E                   compression

_BACKUP_KGC_WIN  :  specifies window size for MEDIUM compression
DOWBITS

_BACKUP_KSFQ_BU  :  number of buffers used for backup/restore
FCNT

_BACKUP_KSFQ_BU  :  maximum amount of memory (in bytes) used for buffers
FMEM_MAX            for backup/restore

_BACKUP_KSFQ_BU  :  size of buffers used for backup/restore
FSZ

_BACKUP_LZO_SIZ  :  specifies buffer size for LOW compression
E

_BACKUP_MAX_GAP  :  largest gap in an incremental/optimized backup buffer,
_SIZE               in bytes

_BACKUP_MIN_CT_  :  mimimun size in bytes of change tracking to apply
UNUSED_OPTIM        unused space optimuzation

_BACKUP_SEQ_BUF  :  number of buffers used for non-DISK channels
CNT

_BACKUP_SEQ_BUF  :  size of buffers used for non-DISK channels
SZ

_BCT_BITMAPS_PE  :  number of bitmaps to store for each datafile
R_FILE

_BCT_BUFFER_ALL  :  maximum size of all change tracking buffer allocations,
OCATION_MAX         in bytes

_BCT_BUFFER_ALL  :  mininum number of extents to allocate per buffer
OCATION_MIN_EXT     allocation
ENTS

_BCT_BUFFER_ALL  :  size of one change tracking buffer allocation, in bytes
OCATION_SIZE

_BCT_CHUNK_SIZE  :  change tracking datafile chunk size, in bytes
_BCT_CRASH_RESE  :  change tracking reserved crash recovery SGA space, in
RVE_SIZE            bytes

_BCT_FILE_BLOCK  :  block size of change tracking file, in bytes
_SIZE

_BCT_FILE_EXTEN  :  extent size of change tracking file, in bytes
T_SIZE

_BCT_FIXTAB_FIL  :  change tracking file for fixed tables
E

_BCT_HEALTH_CHE  :  CTWR health check interval (seconds), zero to disable
CK_INTERVAL

_BCT_INITIAL_PR  :  initial number of entries in the private change
IVATE_DBA_BUFFE     tracking dba buffers
R_SIZE

_BCT_MRP_TIMEOU  :  CTWR MRP wait timeout (seconds), zero to wait forever
T

_BCT_PUBLIC_DBA  :  allow dynamic resizing of public dba buffers, zero to
_BUFFER_DYNRESI     disable
ZE

_BCT_PUBLIC_DBA  :  max buffer size permitted for public dba buffers, in
_BUFFER_MAXSIZE     bytes

_BCT_PUBLIC_DBA  :  total size of all public change tracking dba buffers,
_BUFFER_SIZE        in bytes

_BG_SPAWN_DIAG_  :  background processes spawn diagnostic options
OPTS

_BITMAP_OR_IMPR  :  controls extensions to partition pruning for general
OVEMENT_ENABLED     predicates

_BLOCKING_SESS_  :  blocking session graph cache size in bytes
GRAPH_CACHE_SIZ
E

_BLOCKS_PER_CAC  :  number of consecutive blocks per global cache server
HE_SERVER

_BLOCK_LEVEL_OF  :  High Latency Threshold for Block Level Offload
FLOAD_HIGH_LAT_     operations
THRESH

_BLOCK_SAMPLE_R  :  controls readahead value during block sampling
EADAHEAD_PROB_T
HRESHOLD

_BLOOM_FILTER_D  :  debug level for bloom filtering
EBUG

_BLOOM_FILTER_E  :  enables or disables bloom filter
NABLED

_BLOOM_FILTER_S  :  bloom filter vector size (in KB)
IZE

_BLOOM_FOLDING_  :  bloom filter folding density lower bound
DENSITY

_BLOOM_FOLDING_  :  Enable folding of bloom filter
ENABLED

_BLOOM_FOLDING_  :  bloom filter folding size lower bound (in KB)
MIN

_BLOOM_MAX_SIZE  :  maximum bloom filter size (in KB)
_BLOOM_MINMAX_E  :  enable or disable bloom min max filtering
NABLED

_BLOOM_PREDICAT  :  enables or disables bloom filter predicate pushdown
E_ENABLED

_BLOOM_PREDICAT  :  enables or disables bloom filter predicate offload to
E_OFFLOAD           cells

_BLOOM_PRUNING_  :  Enable partition pruning using bloom filtering
ENABLED

_BLOOM_PUSHING_  :  bloom filter pushing size upper bound (in KB)
MAX

_BLOOM_PUSHING_  :  bloom filter combined pushing size upper bound (in KB)
TOTAL_MAX

_BLOOM_RM_FILTE  :  remove bloom predicate in favor of zonemap join pruning
R                   predicate

_BLOOM_SM_ENABL  :  enable bloom filter optimization using slave mapping
ED

_BRANCH_TAGGING  :  enable branch tagging for distributed transaction
_BROADCAST_SCN_  :  broadcast-on-commit scn mode
MODE

_BROADCAST_SCN_  :  broadcast-on-commit scn wait timeout in centiseconds
WAIT_TIMEOUT

_BSLN_ADAPTIVE_  :  Adaptive Thresholds Enabled
THRESHOLDS_ENAB
LED

_BT_MMV_QUERY_R  :  allow rewrites with multiple MVs and base tables
EWRITE_ENABLED

_BUFFERED_MESSA  :  Buffered message spill age
GE_SPILL_AGE

_BUFFERED_PUBLI  :  Flow control threshold for buffered publishers except
SHER_FLOW_CONTR     capture
OL_THRESHOLD

_BUFFER_BUSY_WA  :  buffer busy wait time in centiseconds
IT_TIMEOUT

_BUFQ_STOP_FLOW  :  Stop enforcing flow control for buffered queues
_CONTROL

_BUILD_DEFERRED  :  DEFERRED MV creation skipping MV log setup update
_MV_SKIPPING_MV
LOG_UPDATE

_BUMP_HIGHWATER  :  how many blocks should we allocate per free list on
_MARK_COUNT         advancing HWM

_BWR_FOR_FLUSHE  :  if TRUE, generate a BWR for a flushed PI
D_PI

_BYPASS_SRL_FOR  :  bypass SRL for S/O EOR logs
_SO_EOR

_BYPASS_XPLATFO  :  bypass datafile header cross-platform-compliance errors
RM_ERROR

_B_TREE_BITMAP_  :  enable the use of bitmap plans for tables w. only
PLANS               B-tree indexes

_CACHE_ORL_DURI  :  cache online logs
NG_OPEN

_CACHE_STATS_MO  :  if TRUE, enable cache stats monitoring
NITOR

_CAPTURE_BUFFER  :  To set the size of the PGA I/O recording buffers
_SIZE

_CAPTURE_PUBLIS  :  Flow control threshold for capture publishers
HER_FLOW_CONTRO
L_THRESHOLD

_CASE_SENSITIVE  :  case sensitive logon enabled
_LOGON

_CAUSAL_STANDBY  :  Causal standby wait timeout
_WAIT_TIMEOUT

_CDB_COMPATIBLE  :  CDB Compatible
_CDB_RAC_AFFINI  :  rac affinity for parallel cdb operations
TY

_CDC_SUBSCRIPTI  :  Change Data Capture subscription_owner
ON_OWNER

_CDMP_DIAGNOSTI  :  cdmp directory diagnostic level
C_LEVEL

_CELL_FAST_FILE  :  Allow optimized file creation path for Cells
_CREATE

_CELL_FAST_FILE  :  Allow optimized rman restore for Cells
_RESTORE

_CELL_FILE_FORM  :  Cell file format chunk size in MB
AT_CHUNK_SIZE

_CELL_INDEX_SCA  :  enable CELL processing of index FFS
N_ENABLED

_CELL_MATERIALI  :  Force materialization of all offloadable expressions on
ZE_ALL_EXPRESSI     the cells
ONS

_CELL_MATERIALI  :  enable offload of expressions underlying virtual
ZE_VIRTUAL_COLU     columns to cells
MNS

_CELL_OBJECT_EX  :  flashcache object expiration timeout
PIRATION_HOURS

_CELL_OFFLOAD_C  :  specifies capability table to load
APABILITIES_ENA
BLED

_CELL_OFFLOAD_C  :  enable complex SQL processing offload to cells
OMPLEX_PROCESSI
NG

_CELL_OFFLOAD_E  :  enable offload of expressions to cells
XPRESSIONS

_CELL_OFFLOAD_H  :  Query offloading of hybrid columnar compressed tables
YBRIDCOLUMNAR       to exadata

_CELL_OFFLOAD_P  :  enable out-of-order SQL processing offload to cells
REDICATE_REORDE
RING_ENABLED

_CELL_OFFLOAD_S  :  enable offload of SYS_CONTEXT evaluation to cells
YS_CONTEXT

_CELL_OFFLOAD_T  :  enable timezone related SQL processing offload to cells
IMEZONE

_CELL_OFFLOAD_V  :  enable offload of predicates on virtual columns to
IRTUAL_COLUMNS      cells

_CELL_RANGE_SCA  :  enable CELL processing of index range scans
N_ENABLED

_CELL_STORIDX_M  :  Cell Storage Index mode
ODE

_CGS_ALLGROUP_P  :  CGS DBALL group polling interval in milli-seconds
OLL_TIME

_CGS_COMM_READI  :  CGS communication readiness check
NESS_CHECK

_CGS_DBALL_GROU  :  CGS DBALL group registration type
P_REGISTRATION

_CGS_DBGROUP_PO  :  CGS DB group polling interval in milli-seconds
LL_TIME

_CGS_HEALTH_CHE  :  CGS health check during reconfiguration
CK_IN_RECONFIG

_CGS_MEMBERKILL  :  allow a RIM instance to issue a CSS member kill
_FROM_RIM_INSTA
NCE

_CGS_MSG_BATCHI  :  CGS message batching
NG

_CGS_MSG_BATCH_  :  CGS message batch size in bytes
SIZE

_CGS_NODE_KILL_  :  CGS node kill escalation to CSS
ESCALATION

_CGS_NODE_KILL_  :  CGS wait time to escalate node kill to CSS in seconds
ESCALATION_WAIT

_CGS_RECONFIG_E  :  CGS reconfiguration extra wait time for CSS in seconds
XTRA_WAIT

_CGS_RECONFIG_T  :  CGS reconfiguration timeout interval
IMEOUT

_CGS_SEND_TIMEO  :  CGS send timeout value
UT

_CGS_TICKETS     :  CGS messaging tickets
_CGS_TICKET_SEN  :  CGS ticket active sendback percentage threshold
DBACK

_CGS_ZOMBIE_MEM  :  CGS zombie member kill wait time in seconds
BER_KILL_WAIT

_CHANGE_VECTOR_  :  Number of change vector buffers for media recovery
BUFFERS

_CHECK_BLOCK_AF  :  perform block check after checksum if both are turned
TER_CHECKSUM        on

_CHECK_BLOCK_NE  :  check block new invariant for flashback
W_INVARIANT_FOR
_FLASHBACK

_CHECK_COLUMN_L  :  check column length
ENGTH

_CHECK_PDBID_IN  :  Enable checking of pluggable database ID in redo
_REDO

_CHECK_TS_THRES  :  check tablespace thresholds
HOLD

_CLEANOUT_SHRCU  :  if TRUE, cleanout shrcur buffers
R_BUFFERS

_CLEANUP_ROLLBA  :  no. of undo entries to apply per transaction cleanup
CK_ENTRIES

_CLEANUP_TIMEOU  :  timeout value for PMON cleanup
T

_CLEANUP_TIMEOU  :  flags for PMON cleanup timeout
T_FLAGS

_CLEAR_BUFFER_B  :  Always zero-out buffer before reuse for security
EFORE_REUSE

_CLIENT_ENABLE_  :  enable automatic unregister after a send fails with
AUTO_UNREGISTER     timeout

_CLIENT_NTFN_CL  :  interval after which dead client registration cleanup
EANUP_INTERVAL      task repeats

_CLIENT_NTFN_PI  :  time between pings to unreachable notification clients
NGINTERVAL

_CLIENT_NTFN_PI  :  number of times to ping unreachable notification
NGRETRIES           clients

_CLIENT_NTFN_PI  :  timeout to connect to unreachable notification clients
NGTIMEOUT

_CLIENT_RESULT_  :  bypass the client result cache
CACHE_BYPASS

_CLIENT_TSTZ_ER  :  Should Client give error for suspect Timestamp with
ROR_CHECK           Timezone operations

_CLI_CACHEBKTAL  :  Percentage of memory to allocate
LOC

_CLONE_ONE_PDB_  :  Recover ROOT and only one PDB in clone database
RECOVERY

_CLOSE_CACHED_O  :  close cursors cached by PL/SQL at each commit
PEN_CURSORS

_CLOSE_DEQ_BY_C  :  Close Dequeue By Condition Cursors
OND_CURS

_CLOUD_NAME      :  gsm cloud name
_CLUSTERWIDE_GL  :  enable/disable clusterwide global transactions
OBAL_TRANSACTIO
NS

_CLUSTER_LIBRAR  :  cluster library selection
Y

_COLLAPSE_WAIT_  :  collapse wait history
HISTORY

_COLLECT_TEMPUN  :  Collect Statistics v$tempundostat
DO_STATS

_COLLECT_UNDO_S  :  Collect Statistics v$undostat
TATS

_COLUMN_COMPRES  :  Column compression ratio
SION_FACTOR

_COLUMN_ELIMINA  :  turn off predicate-only column elimination
TION_OFF

_COLUMN_TRACKIN  :  column usage tracking
G_LEVEL

_COMMON_DATA_VI  :  common objects returned through dictionary views
EW_ENABLED

_COMMON_USER_PR  :  Enforce restriction on a prefix of a Common
EFIX                User/Role/Profile name

_COMPILATION_CA  :  Size of the compilation call heaps extents
LL_HEAP_EXTENT_
SIZE

_COMPLEX_VIEW_M  :  enable complex view merging
ERGING

_COMPRESSION_AB  :  number of recompression above cache for sanity check
OVE_CACHE

_COMPRESSION_AD  :  Compression advisor
VISOR

_COMPRESSION_CH  :  percentage of chained rows allowed for Compression
AIN

_COMPRESSION_CO  :  Compression compatability
MPATIBILITY

_CONCURRENCY_CH  :  what is the chosen value of concurrency
OSEN

_CONNECTION_BRO  :  connection broker host for listen address
KER_HOST

_CONNECT_BY_USE  :  use union all for connect by
_UNION_ALL

_CONTROLFILE_AU  :  time delay (in seconds) for performing controlfile
TOBACKUP_DELAY      autobackups

_CONTROLFILE_BA  :  enable check of the copied blocks during controlfile
CKUP_COPY_CHECK     backup copy

_CONTROLFILE_BL  :  control file block size in bytes
OCK_SIZE

_CONTROLFILE_CE  :  Flash cache hint for control file accesses
LL_FLASH_CACHIN
G

_CONTROLFILE_EN  :  dump the system states after controlfile enqueue
QUEUE_DUMP          timeout

_CONTROLFILE_EN  :  control file enqueue max holding time in seconds
QUEUE_HOLDING_T
IME

_CONTROLFILE_EN  :  control file enqueue holding time tracking size
QUEUE_HOLDING_T
IME_TRACKING_SI
ZE

_CONTROLFILE_EN  :  control file enqueue timeout in seconds
QUEUE_TIMEOUT

_CONTROLFILE_SE  :  control file initial section size
CTION_INIT_SIZE

_CONTROLFILE_SE  :  control file max expansion rate
CTION_MAX_EXPAN
D

_CONTROLFILE_UP  :  controlfile update sanity check
DATE_CHECK

_CONVERT_SET_TO  :  enables conversion of set operator to join
_JOIN

_COORD_MESSAGE_  :  parallel recovery coordinator side extra message buffer
BUFFER              size

_CORRUPTED_ROLL  :  corrupted undo segment list
BACK_SEGMENTS

_COST_EQUALITY_  :  enables costing of equality semi-join
SEMI_JOIN

_CPU_EFF_THREAD  :  CPU effective thread multiplier
_MULTIPLIER

_CPU_TO_IO       :  divisor for converting CPU cost to I/O cost
_CP_NUM_HASH_LA  :  connection pool number of hash latches
TCHES

_CRASH_DOMAIN_O  :  allow domain to exit for exceptions in any thread
N_EXCEPTION

_CREATE_STAT_SE  :  create ilm statistics segment
GMENT

_CREATE_TABLE_I  :  allow creation of table in a cluster not owned by the
N_ANY_CLUSTER       user

_CR_GRANT_GLOBA  :  if TRUE, grant lock for CR requests when block is in
L_ROLE              global role

_CR_GRANT_LOCAL  :  turn 3-way CR grants off, make it automatic, or turn it
_ROLE               on

_CR_GRANT_ONLY   :  if TRUE, grant locks when possible and do not send the
block

_CR_SERVER_LOG_  :  if TRUE, flush redo log before serving a CR buffer
FLUSH

_CR_TRC_BUF_SIZ  :  size of cr trace buffer
E

_CTX_DOC_POLICY  :  enable ctx_doc.policy_stems api
_STEMS

_CURSOR_BIND_CA  :  maximum size of the cursor bind capture area
PTURE_AREA_SIZE

_CURSOR_BIND_CA  :  interval (in seconds) between two bind capture for a
PTURE_INTERVAL      cursor

_CURSOR_CACHE_T  :  number of seconds a session cached cursor stay in
IME                 cache.

_CURSOR_DB_BUFF  :  additional number of buffers a cursor can pin at once
ERS_PINNED

_CURSOR_FEATURE  :  Shared cursor features enabled bits.
S_ENABLED

_CURSOR_OBSOLET  :  Number of cursors per parent before obsoletion.
E_THRESHOLD

_CURSOR_PLAN_EN  :  enable collection and display of cursor plans
ABLED

_CURSOR_PLAN_HA  :  version of cursor plan hash value
SH_VERSION

_CURSOR_PLAN_UN  :  enables/disables using unparse to build
PARSE_ENABLED       projection/predicates

_CURSOR_RELOAD_  :  Number of failed reloads before marking cursor unusable
FAILURE_THRESHO
LD

_CURSOR_RUNTIME  :  Shared cursor runtime heap memory limit
HEAP_MEMLIMIT

_CURSOR_STATS_E  :  Enable cursor stats
NABLED

_CU_ROW_LOCKING  :  CU row level locking
_CVMAP_BUFFERS   :  Number of change vector buffers for multi instance
media recovery

_CVW_ENABLE_WEA  :  enable weak view checking
K_CHECKING

_DATAFILE_COW    :  Use copy on write snapshot for the renamed file
_DATAFILE_WRITE  :  datafile write errors crash instance
_ERRORS_CRASH_I
NSTANCE

_DATAPUMP_COMPR  :  specifies buffer size for BASIC compression algorithm
ESSBAS_BUFFER_S
IZE

_DATAPUMP_METAD  :  specifies buffer size for metadata file I/O
ATA_BUFFER_SIZE

_DATAPUMP_TABLE  :  specifies buffer size for table data file I/O
DATA_BUFFER_SIZ
E

_DATA_TRANSFER_  :  Percentange * 100 of buffer cache to transfer to data
CACHE_BC_PERC_X     transfer cache
100

_DATA_TRANSFER_  :  Size of data transfer cache
CACHE_SIZE

_DATA_WAREHOUSI  :  if TRUE, enable data warehousing scan buffers
NG_SCAN_BUFFERS

_DBFS_MODIFY_IM  :  DBFS Link allows implicit fetch on modify – only on
PLICIT_FETCH        SecureFiles

_DBG_PROC_START  :  debug process startup
UP

_DBG_SCAN        :  generic scan debug
_DBMS_SQL_SECUR  :  Security level in DBMS_SQL
ITY_LEVEL

_DBOP_ENABLED    :  Any positive number enables automatic DBOP monitoring.
0 is disabled

_DBPOOL_NAME     :  gsm database pool name
_DBRM_DYNAMIC_T  :  DBRM dynamic threshold setting
HRESHOLD

_DBRM_NUM_RUNNA  :  Resource Manager number of runnable list per NUMA node
BLE_LIST

_DBRM_QUANTUM    :  DBRM quantum
_DBRM_RUNCHK     :  Resource Manager Diagnostic Running Thread Check
_DBRM_SHORT_WAI  :  Resource Manager short wait length
T_US

_DBWR_ASYNC_IO   :  Enable dbwriter asynchronous writes
_DBWR_SCAN_INTE  :  dbwriter scan interval
RVAL

_DBWR_TRACING    :  Enable dbwriter tracing
_DB_16K_FLASH_C  :  flash cache file for 16k block size
ACHE_FILE

_DB_16K_FLASH_C  :  flash cache size for _db_16k_flash_cache_file
ACHE_SIZE

_DB_2K_FLASH_CA  :  flash cache file for 2k block size
CHE_FILE

_DB_2K_FLASH_CA  :  flash cache size for _db_2k_flash_cache_file
CHE_SIZE

_DB_32K_FLASH_C  :  flash cache file for 32k block size
ACHE_FILE

_DB_32K_FLASH_C  :  flash cache size for _db_32k_flash_cache_file
ACHE_SIZE

_DB_4K_FLASH_CA  :  flash cache file for 4k block size
CHE_FILE

_DB_4K_FLASH_CA  :  flash cache size for _db_4k_flash_cache_file
CHE_SIZE

_DB_8K_FLASH_CA  :  flash cache file for 8k block size
CHE_FILE

_DB_8K_FLASH_CA  :  flash cache size for _db_8k_flash_cache_file
CHE_SIZE

_DB_AGING_COOL_  :  Touch count set when buffer cooled
COUNT

_DB_AGING_FREEZ  :  Make CR buffers always be too cold to keep in cache
E_CR

_DB_AGING_HOT_C  :  Touch count which sends a buffer to head of replacement
RITERIA             list

_DB_AGING_STAY_  :  Touch count set when buffer moved to head of
COUNT               replacement list

_DB_AGING_TOUCH  :  Touch count which sends a buffer to head of replacement
_TIME               list

_DB_ALWAYS_CHEC  :  Always perform block check and checksum for System
K_SYSTEM_TS         tablespace

_DB_BLOCKS_PER_  :  Number of blocks per hash latch
HASH_LATCH

_DB_BLOCK_ADJCH  :  adjacent cache buffer checks – low blkchk overwrite
ECK                 parameter

_DB_BLOCK_ADJCH  :  adjacent cache buffer check level
K_LEVEL

_DB_BLOCK_ALIGN  :  Align Direct Reads
_DIRECT_READ

_DB_BLOCK_BAD_W  :  enable bad write checks
RITE_CHECK

_DB_BLOCK_BUFFE  :  Number of database blocks cached in memory: hidden
RS                  parameter

_DB_BLOCK_CACHE  :  Always clone data blocks on get (for debugging)
_CLONE

_DB_BLOCK_CACHE  :  buffer header tracing (non-zero only when debugging)
_HISTORY

_DB_BLOCK_CACHE  :  buffer header tracing level
_HISTORY_LEVEL

_DB_BLOCK_CACHE  :  buffer header tracing for lru operations
_HISTORY_LRU

_DB_BLOCK_CACHE  :  number of unmapped buffers (for tracking swap calls on
_NUM_UMAP           blocks)

_DB_BLOCK_CACHE  :  protect database blocks (true only when debugging)
_PROTECT

_DB_BLOCK_CACHE  :  protect database blocks (for strictly internal use
_PROTECT_INTERN     only)
AL

_DB_BLOCK_CHECK  :  Check more and dump block before image for debugging
_FOR_DEBUG

_DB_BLOCK_CHECK  :  check objd and typ on cache disk read
_OBJTYP

_DB_BLOCK_CHUNK  :  chunkify noncontig multi block reads
IFY_NCMBR

_DB_BLOCK_CORRU  :  threshold number of block recovery attempts
PTION_RECOVERY_
THRESHOLD

_DB_BLOCK_DO_FU  :  do full block read even if some blocks are in cache
LL_MBREADS

_DB_BLOCK_HASH_  :  Number of database block hash buckets
BUCKETS

_DB_BLOCK_HASH_  :  Number of database block hash latches
LATCHES

_DB_BLOCK_HEADE  :  number of extra buffer headers to use as guard pages
R_GUARD_LEVEL

_DB_BLOCK_HI_PR  :  Fraction of writes for high priority reasons
IORITY_BATCH_SI
ZE

_DB_BLOCK_KNOWN  :  Initial Percentage of buffers to maintain known clean
_CLEAN_PCT

_DB_BLOCK_LRU_L  :  number of lru latches
ATCHES

_DB_BLOCK_MAX_C  :  Maximum Allowed Number of CR buffers per dba
R_DBA

_DB_BLOCK_MAX_S  :  Percentage of buffers to inspect when looking for free
CAN_PCT

_DB_BLOCK_MED_P  :  Fraction of writes for medium priority reasons
RIORITY_BATCH_S
IZE

_DB_BLOCK_NUMA   :  Number of NUMA nodes
_DB_BLOCK_PREFE  :  Batched IO enable fast longjumps
TCH_FAST_LONGJU
MPS_ENABLED

_DB_BLOCK_PREFE  :  Prefetch limit in blocks
TCH_LIMIT

_DB_BLOCK_PREFE  :  Prefetch force override in blocks
TCH_OVERRIDE

_DB_BLOCK_PREFE  :  Batched IO enable private cache
TCH_PRIVATE_CAC
HE_ENABLED

_DB_BLOCK_PREFE  :  Prefetch quota as a percent of cache size
TCH_QUOTA

_DB_BLOCK_PREFE  :  Batched IO enable skip reading buffers
TCH_SKIP_READIN
G_ENABLED

_DB_BLOCK_PREFE  :  Allowed wasted percent threshold of prefetched size
TCH_WASTED_THRE
SHOLD_PERC

_DB_BLOCK_TABLE  :  Size of shared table scan read buffer
_SCAN_BUFFER_SI
ZE

_DB_BLOCK_TEMP_  :  generate redo for temp blocks
REDO

_DB_BLOCK_TRACE  :  trace buffer protect calls
_PROTECT

_DB_BLOCK_VLM_C  :  check of rvlm mapping leaks (for debugging)
HECK

_DB_BLOCK_VLM_L  :  Threshold for allowable vlm leaks
EAK_THRESHOLD

_DB_CACHE_ADVIC  :  cache advisory maximum multiple of current size to
E_MAX_SIZE_FACT     similate
OR

_DB_CACHE_ADVIC  :  cache advisory sampling factor
E_SAMPLE_FACTOR

_DB_CACHE_ADVIC  :  cache simulation sanity check
E_SANITY_CHECK

_DB_CACHE_BLOCK  :  dump short call stack for block reads
_READ_STACK_TRA
CE

_DB_CACHE_CRX_C  :  check for costly crx examination functions
HECK

_DB_CACHE_MISS_  :  check LEs after cache miss
CHECK_LES

_DB_CACHE_MMAN_  :  check for wait latch get under MMAN ops in kcb
LATCH_CHECK

_DB_CACHE_PRE_W  :  Buffer Cache Pre-Warm Enabled : hidden parameter
ARM

_DB_CACHE_PROCE  :  maximum number of cr pins a process may have
SS_CR_PIN_MAX

_DB_CACHE_WAIT_  :  trace new kslwaits
DEBUG

_DB_CHANGE_NOTI  :  enable db change notification
FICATION_ENABLE

_DB_CHECK_CELL_  :
HINTS

_DB_DISABLE_TEM  :  Disable Temp Encryption for Spills
P_ENCRYPTION

_DB_DUMP_FROM_D  :  dump contents from disk and efc
ISK_AND_EFC

_DB_DW_SCAN_ADA  :  if TRUE, enable adaptive DW scan cooling
PTIVE_COOLING

_DB_DW_SCAN_MAX  :  DW Scan adaptive cooling max shadow count
_SHADOW_COUNT

_DB_DW_SCAN_OBJ  :  DW Scan object cooling factor to cool all temperatures
_COOLING_FACTOR

_DB_DW_SCAN_OBJ  :  DW Scan object cooling interval in number of scans,
_COOLING_INTERV     seconds, or pct of cache size
AL

_DB_DW_SCAN_OBJ  :  DW scan objtect cooling policy
_COOLING_POLICY

_DB_DW_SCAN_OBJ  :  DW Scan object warming increment when an object is
_WARMING_INCREM     scanned
ENT

_DB_FAST_OBJ_CH  :  enable fast object drop sanity check
ECK

_DB_FAST_OBJ_CK  :  enable fast object checkpoint
PT

_DB_FAST_OBJ_TR  :  enable fast object truncate
UNCATE

_DB_FILE_DIRECT  :  Sequential I/O buf size
_IO_COUNT

_DB_FILE_EXEC_R  :  multiblock read count for regular clients
EAD_COUNT

_DB_FILE_FORMAT  :  Block formatting I/O buf count
_IO_BUFFERS

_DB_FILE_NONCON  :  number of noncontiguous db blocks to be prefetched
TIG_MBLOCK_READ
_COUNT

_DB_FILE_OPTIMI  :  multiblock read count for regular clients
ZER_READ_COUNT

_DB_FLASHBACK_I  :  Flashback IO Buffer Size
OBUF_SIZE

_DB_FLASHBACK_L  :  Minimum flashback database log size in bytes
OG_MIN_SIZE

_DB_FLASHBACK_L  :  Minimum flashback database log total space in bytes
OG_MIN_TOTAL_SP
ACE

_DB_FLASHBACK_N  :  Flashback Number of IO buffers
UM_IOBUF

_DB_FLASH_CACHE  :  Flash cache force replenish lower limit in buffers
_FORCE_REPLENIS
H_LIMIT

_DB_FLASH_CACHE  :  Flash cache keep buffer upper limit in percentage
_KEEP_LIMIT

_DB_FLASH_CACHE  :  Flash cache maximum latency allowed in 10 milliseconds
_MAX_LATENCY

_DB_FLASH_CACHE  :  Flash cache maximum outstanding writes allowed
_MAX_OUTSTANDIN
G_WRITES

_DB_FLASH_CACHE  :  Flash cache max read retry
_MAX_READ_RETRY

_DB_FLASH_CACHE  :  Flash cache maximum slow io allowed
_MAX_SLOW_IO

_DB_FLASH_CACHE  :  Flash cache write buffer upper limit in percentage
_WRITE_LIMIT

_DB_HANDLES      :  System-wide simultaneous buffer operations
_DB_HANDLES_CAC  :  Buffer handles cached each process
HED

_DB_HOT_BLOCK_T  :  track hot blocks for hash latch contention
RACKING

_DB_INDEX_BLOCK  :  index block checking override parameter
_CHECKING

_DB_INITIAL_CAC  :  size of cache created at startup
HESIZE_CREATE_M
B

_DB_L2_TRACING   :  flash cache debug tracing
_DB_LARGE_DIRTY  :  Number of buffers which force dirty queue to be written
_QUEUE

_DB_LOST_WRITE_  :  Enable scn based lost write detection mechanism
CHECKING

_DB_LOST_WRITE_  :  Enable _db_lost_write_checking tracing
TRACING

_DB_MTTR_ADVICE  :  MTTR advisory
_DB_MTTR_PARTIT  :  number of partitions for MTTR advisory
IONS

_DB_MTTR_SAMPLE  :  MTTR simulation sampling factor
_FACTOR

_DB_MTTR_SIM_TA  :  MTTR simulation targets
RGET

_DB_MTTR_SIM_TR  :  MTTR simulation trace size
ACE_SIZE

_DB_MTTR_TRACE_  :  dump trace entries to alert file
TO_ALERT

_DB_NOARCH_DISB  :  Image redo logging (NOARCHIVEMODE)
LE_OPTIM

_DB_NUM_EVICT_W  :  number of evict wait events
AITEVENTS

_DB_NUM_GSM      :  database number in gsm dbpool
_DB_OBJ_ENABLE_  :  enable ksr in object checkpoint/reuse
KSR

_DB_PERCENT_HOT  :  Percent of default buffer pool considered hot
_DEFAULT

_DB_PERCENT_HOT  :  Percent of keep buffer pool considered hot
_KEEP

_DB_PERCENT_HOT  :  Percent of recycle buffer pool considered hot
_RECYCLE

_DB_PERCPU_CREA  :  size of cache created per cpu in deferred cache create
TE_CACHESIZE

_DB_PREFETCH_HI  :  maintain prefetch histogram statistics in x$kcbprfhs
STOGRAM_STATIST
ICS

网页标题：Oracle12c版本中未归档隐藏参数有哪些
当前网址：http://kswjz.com/article/pjdpip.html