共计 105695 个字符，预计需要花费 265 分钟才能阅读完成。
本篇文章为大家展示了 Oracle12c 版本中未归档隐藏参数有哪些，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。
我将列出 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 usednbsp; Time to wait before allowing an allocation decrease
IN_DECREASE_WAI
T
_LM_COMM_TKTS_M : Time to wait before allowing an allocation increase
IN_INCREASE_WAI
T
_LM_COMM_TKTS_M : Ticket allocation multiplication factor
ULT_FACTOR
_LM_COMM_TKTS_N : Null request frequency threshold (percentage)
ULLREQ_THRESHOL
D
_LM_COMPRESSION : GES compression scheme
_SCHEME
_LM_CONTIGUOUS_ : number of contiguous blocks that will hash to the same
RES_COUNT HV bucket
_LM_DD_IGNORE_N : if TRUE nodeadlockwait/nodeadlockblock options are
ODD ignored
_LM_DD_INTERVAL : dd time interval in seconds
_LM_DD_MAXDUMP : max number of locks to be dumped during dd validation
_LM_DD_MAX_SEAR : max dd search time per token
CH_TIME
_LM_DD_SCAN_INT : dd scan interval in seconds
ERVAL
_LM_DD_SEARCH_C : number of dd search per token get
NT
_LM_DEFERRED_MS : deferred message timeout
G_TIMEOUT
_LM_DRMOPT12 : enable drm scan optimizations in 12
_LM_DRMOPT12_NO : enable drm latching optimizations in 12
LATCH
_LM_DRM_BATCH_T : time in seconds to wait to batch drm requests
IME
_LM_DRM_DISABLE : disable drm in different level
_LM_DRM_HILOAD_ : drm high load threshold percentage
PERCENTAGE
_LM_DRM_LOWLOAD : drm low load threshold percentage
_PERCENTAGE
_LM_DRM_MAX_REQ : dynamic remastering maximum affinity requests processed
UESTS together
_LM_DRM_MIN_INT : minimum interval in secs between two consecutive drms
ERVAL
_LM_DRM_OBJECT_ : enable/disable object scan to force full table scan
SCAN always
_LM_DRM_WINDOW : dynamic remastering bucket window size
_LM_DRM_XLATCH : dynamic remastering forced exclusive latches
_LM_DUMP_NULL_L : dump null lock in state dump
OCK
_LM_DYNAMIC_LMS : dynamic lms invocation
_LM_DYNAMIC_LOA : dynamic load adjustment
D
_LM_ENABLE_AFF_ : enables affinity benefit computations if TRUE
BENEFIT_STATS
_LM_ENQUEUE_BLO : enqueue blocker dump timeout
CKER_DUMP_TIMEO
UT
_LM_ENQUEUE_BLO : enqueue blocker dump timeout count
CKER_DUMP_TIMEO
UT_CNT
_LM_ENQUEUE_BLO : enqueue blocker kill timeout
CKER_KILL_TIMEO
UT
_LM_ENQUEUE_FRE : Number of enqueue freelist
ELIST
_LM_ENQUEUE_TIM : enqueue suggested min timeout in seconds
EOUT
_LM_ENQ_LOCK_FR : Number of ges enqueue element freelist
EELIST
_LM_ENQ_RCFG : if TRUE enables enqueue reconfiguration
_LM_FDRM_STATS : gather full drm statistics
_LM_FILE_AFFINI : mapping between file id and master instance number
TY
_LM_FILE_READ_M : mapping between read-mostly file id and master instance
OSTLY number
_LM_FREEZE_KILL : timeout for killing unfrozen processes in rcfg/drm
_TIME freeze step
_LM_FREE_QUEUE_ : GES free queue threshold
THRESHOLD
_LM_GLOBAL_POST : if TRUE deliver global posts to remote nodes
S
_LM_HASHTABLE_B : High element threshold in hash table bucket
KT_HIGH
_LM_HASHTABLE_B : Low element threshold in hash table bucket
KT_LOW
_LM_HASHTABLE_B : Threshold for hash table resizing
KT_THR
_LM_HB_ACCEPTAB : list of acceptable hang conditions in heartbeat check
LE_HANG_CONDITI
ON
_LM_HB_CALLSTAC : hb diagnostic call stack collection time in seconds
K_COLLECT_TIME
_LM_HB_DISABLE_ : list of process names to be disabled in heartbeat check
CHECK_LIST
_LM_HB_ENABLE_A : to enable the wait analysis with acceptable condition
CL_CHECK lists
_LM_HB_EXPONENT : heartbeat exponential hang time multiplier
IAL_HANG_TIME_F
ACTOR
_LM_HB_MAXIMUM_ : maximum heartbeat hang report count
HANG_REPORT_COU
NT
_LM_HIGH_LOAD_S : high watermark system load percentage
YSLOAD_PERCENTA
GE
_LM_HIGH_LOAD_T : high load threshold parameter
HRESHOLD
_LM_IDLE_CONNEC : GES idle connection check
TION_CHECK
_LM_IDLE_CONNEC : GES idle connection check interval time
TION_CHECK_INTE
RVAL
_LM_IDLE_CONNEC : GES idle connection instance check callout
TION_INSTANCE_C
HECK_CALLOUT
_LM_IDLE_CONNEC : GES idle connection kill
TION_KILL
_LM_IDLE_CONNEC : GES idle connection max skip kill request
TION_KILL_MAX_S
KIPS
_LM_IDLE_CONNEC : GES maximum idle connection kill request ignore count
TION_MAX_IGNORE
_KILL_COUNT
_LM_IDLE_CONNEC : GES idle connection health quorum threshold
TION_QUORUM_THR
ESHOLD
_LM_KILL_FG_ON_ : GES kill fg on IPC timeout
TIMEOUT
_LM_LHUPD_INTER : load and health update interval
VAL
_LM_LMD_WAITTIM : default wait time for lmd in centiseconds
E
_LM_LMON_NOWAIT : if TRUE makes lmon get nowait latches with timeout loop
_LATCH
_LM_LMS : number of background gcs server processes to start
_LM_LMS_OPT_PRI : enable freeslot lms priority optimization
ORITY
_LM_LMS_PRIORIT : frequency of LMS priority decisions in milliseconds
Y_CHECK_FREQUEN
CY
_LM_LMS_PRIORIT : enable lms priority modification
Y_DYNAMIC
_LM_LMS_RT_THRE : maximum number of real time lms processes on machine
SHOLD
_LM_LMS_SPIN : make lms not sleep
_LM_LMS_WAITTIM : default wait time for lms in centiseconds
E
_LM_LOCAL_HP_EN : use static file affinity for HP enqueue mastership
Q
_LM_LOCKS : number of enqueues configured for cluster database
_LM_LOW_LOAD_PE : low watermark percentage for load threshold
RCENTAGE
_LM_MASTER_WEIG : master resource weight for this instance
HT
_LM_MAX_LMS : max. number of background global cache server processes
_LM_MSG_BATCH_S : GES batch message size
IZE
_LM_MSG_CLEANUP : GES message buffer cleanup interval time
_INTERVAL
_LM_MSG_POOL_DU : GES message pool dump threshold in terms of buffer
MP_THRESHOLD count
_LM_NODE_JOIN_O : cluster database node join optimization in reconfig
PT
_LM_NON_FAULT_T : disable cluster database fault-tolerance mode
OLERANT
_LM_NO_LH_CHECK : skip load and health check at decision points
_LM_NO_SYNC : skip reconfiguration/drm syncr/synca messaging
_LM_NUM_BNFT_ST : number of buckets in the benefit stats hash table
ATS_BUCKETS
_LM_NUM_PT_BUCK : number of buckets in the object affinity hash table
ETS
_LM_NUM_PT_LATC : number of latches in the object affinity hash table
HES
_LM_POSTEVENT_B : postevent buffer size
UFFER_SIZE
_LM_PREREGISTER : enqueue type that requires pre-registration to css
_CSS_RESTYPE
_LM_PROCESS_BAT : GES implicit process batching for IPC messages
CHING
_LM_PROCESS_LOC : limit on scanning process lock queue instead of
K_Q_SCAN_LIMIT resource convert lock queue
_LM_PROCS : number of client processes configured for cluster
database
_LM_PROC_FREEZE : reconfiguration: process freeze timeout
_TIMEOUT
_LM_PSRCFG : enable pseudo reconfiguration
_LM_RAC_SPARE_D : rac parameter dp1
P1
_LM_RAC_SPARE_D : rac parameter dp10
P10
_LM_RAC_SPARE_D : rac parameter dp2
P2
_LM_RAC_SPARE_D : rac parameter dp3
P3
_LM_RAC_SPARE_D : rac parameter dp4
P4
_LM_RAC_SPARE_D : rac parameter dp5
P5
_LM_RAC_SPARE_D : rac parameter dp6
P6
_LM_RAC_SPARE_D : rac parameter dp7
P7
_LM_RAC_SPARE_D : rac parameter dp8
P8
_LM_RAC_SPARE_D : rac parameter dp9
P9
_LM_RAC_SPARE_P : rac parameter p1
1
_LM_RAC_SPARE_P : rac parameter p10
10
_LM_RAC_SPARE_P : rac parameter p2
2
_LM_RAC_SPARE_P : rac parameter p3
3
_LM_RAC_SPARE_P : rac parameter p4
4
_LM_RAC_SPARE_P : rac parameter p5
5
_LM_RAC_SPARE_P : rac parameter p6
6
_LM_RAC_SPARE_P : rac parameter p7
7
_LM_RAC_SPARE_P : rac parameter p8
8
_LM_RAC_SPARE_P : rac parameter p9
9
_LM_RCFG_TIMEOU : dlm reconfiguration timeout
T
_LM_RCVINST : designated instance to do instance recovery
_LM_RCVR_HANG_A : receiver hang allow time in seconds
LLOW_TIME
_LM_RCVR_HANG_C : to kill receiver hang at control file IO
FIO_KILL
_LM_RCVR_HANG_C : receiver hang check frequency in seconds
HECK_FREQUENCY
_LM_RCVR_HANG_C : examine system load when check receiver health
HECK_SYSTEM_LOA
D
_LM_RCVR_HANG_K : to kill receiver hang
ILL
_LM_RCVR_HANG_S : systemstate dump level upon receiver hang
YSTEMSTATE_DUMP
_LEVEL
_LM_RESEND_OPEN : timeout in secs before resubmitting the open-convert
_CONVERT_TIMEOU
T
_LM_RESS : number of resources configured for cluster database
_LM_RES_HASH_BU : number of resource hash buckets
CKET
_LM_RES_PART : number of resource partition configured for gcs
_LM_RES_TM_HASH : number of extra TM resource hash buckets
_BUCKET
_LM_RM_SLAVES : if non zero, it enables remastering slaves
_LM_SENDPROXY_R : GES percentage of send proxy reserve of send tickets
ESERVE
_LM_SEND_MODE : GES send mode
_LM_SEND_QUEUE_ : GES send queue message batching
BATCHING
_LM_SEND_QUEUE_ : GES send queue maximum length
LENGTH
_LM_SHARE_LOCK_ : if TRUE enables share lock optimization
OPT
_LM_SINGLE_INST : enable single instance affinity lock optimization
_AFFINITY_LOCK
_LM_SPARE_THREA : number of spare threads to be created by the GPnP
DS master
_LM_SPARE_UNDO : number of spare undo tablespaces to be created by GPnP
master
_LM_SQ_BATCH_FA : GES send queue minimum batching factor
CTOR
_LM_SQ_BATCH_TY : GES send queue batching mechanism
PE
_LM_SQ_BATCH_WA : GES send queue batching waittime in tick
ITTICK
_LM_SYNC_TIMEOU : Synchronization timeout for DLM reconfiguration steps
T
_LM_TICKETS : GES messaging tickets
_LM_TICKET_ACTI : Flow control ticket active sendback threshold
VE_SENDBACK
_LM_TX_DELTA : TX lock localization delta
_LM_USE_GCR : use GCR module if TRUE
_LM_USE_NEW_DEF : use new defered msg queue timeout action
MSGTMO_ACTION
_LM_USE_TX_TSN : use undo tsn affinity master as TX enqueue master
_LM_VALIDATE_PB : GES process batch validation
ATCH
_LM_WAIT_PENDIN : GES wait on pending send queue
G_SEND_QUEUE
_LM_WATCHPOINT_ : GES number of watchpoints
MAXIMUM
_LM_WATCHPOINT_ : GES maximum time in seconds to keep watchpoint
TIMEOUT
_LM_XIDS : number of transaction IDs configured for cluster
database
_LOAD_WITHOUT_C : Load PL/SQL or Database objects without compilation
OMPILE
_LOCAL_ARC_ASSE : Assert whenever local ORL arch waits for space
RT_ON_WAIT
_LOCAL_COMMUNIC : enable local communication costing when TRUE
ATION_COSTING_E
NABLED
_LOCAL_COMMUNIC : set the ratio between global and local communication
ATION_RATIO (0..100)
_LOCAL_HANG_ANA : the interval at which local hang analysis is run
LYSIS_INTERVAL_
SECS
_LOCK_REF_CONST : number of nowait attempts to lock referential
RAINT_COUNT constraint
_LOCK_SGA_AREAS : Lock specified areas of the SGA in physical memory
_LOGOUT_STORM_R : number of processes that can logout in a second
ATE
_LOGOUT_STORM_R : maximum retry count for logouts
ETRYCNT
_LOGOUT_STORM_T : timeout in centi-seconds for time to wait between
IMEOUT retries
_LOG_ARCHIVE_AV : log archive avoid memcpy
OID_MEMCPY
_LOG_ARCHIVE_BU : Number of buffers to allocate for archiving
FFERS
_LOG_ARCHIVE_CA : archival callout
LLOUT
_LOG_ARCHIVE_NE : Log archive network redo buffer size used by ARCH
TWORK_REDO_SIZE
_LOG_ARCHIVE_PR : log archive protection auto demotion
OT_AUTO_DEMOTE
_LOG_ARCHIVE_ST : log archive security strong auth
RONG_AUTH
_LOG_ARCHIVE_TR : log archive trace pids parameter
ACE_PIDS
_LOG_BLOCKS_DUR : log block images when changed during backup
ING_BACKUP
_LOG_BUFFERS_CO : corrupt redo buffers before write
RRUPT
_LOG_BUFFERS_DE : debug redo buffers (slows things down)
BUG
_LOG_BUFFER_COA : Coalescing log buffers for log writes
LESCE
_LOG_CHECKPOINT : # redo blocks to verify after checkpoint
_RECOVERY_CHECK
_LOG_COMMITTIME : Log commit-time block cleanout
_BLOCK_CLEANOUT
_LOG_DELETION_P : archivelog deletion policy for mandatory/all
OLICY destination
_LOG_EVENT_QUEU : number of the log writer event queues
ES
_LOG_FILE_SYNC_ : Log file sync timeout (centiseconds)
TIMEOUT
_LOG_MAX_OPTIMI : maximum number of threads to which log scan
ZE_THREADS optimization is applied
_LOG_PARALLELIS : Enable dynamic strands
M_DYNAMIC
_LOG_PARALLELIS : Maximum number of log buffer strands
M_MAX
_LOG_PRIVATE_MU : Private strand multiplier for log space preallocation
L
_LOG_PRIVATE_PA : Active sessions multiplier to deduce number of private
RALLELISM_MUL strands
_LOG_READ_BUFFE : Number of log read buffers for media recovery
RS
_LOG_READ_BUFFE : buffer size for reading log files
R_SIZE
_LOG_SIMULTANEO : number of simultaneous copies into redo buffer(# of
US_COPIES copy latches)
_LOG_SPACE_ERRO : should we report space errors to alert log
RS
_LOG_SWITCH_TIM : Maximum number of seconds redos in the current log
EOUT could span
_LOG_UNDO_DF_IN : generate marker to log file# that belong to undo
FO tablespace
_LOG_WRITER_WOR : LGWR worker DLM health-monitoring heartbeat update
KER_DLM_HEARBEA frequency (ms)
T_UPDATE_FREQ
_LOG_WRITE_INFO : Size of log write info array
_SIZE
_LONGOPS_ENABLE : longops stats enabled
D
_LONG_BCAST_ACK : threshold for long bcast ack warning messages in ms
_WARNING_THRESH
OLD
_LONG_LOG_WRITE : threshold for long log write warning messages in ms
_WARNING_THRESH
OLD
_LOWRES_DRIFT_A : allowed lowres timer drift for VKTM
LLOWED_SEC
_LOW_SERVER_THR : low server thresholds
ESHOLD
_LTC_TRACE : tracing level for load table conventional
_LTHREAD_CLEANU : interval for cleaning lightweight threads in secs
P_INTV_SECS
_LTHREAD_CLNUP_ : timeout after hard killing operation for lthread to
HK_WAIT_SECS exit
_LTHREAD_CLNUP_ : wait timeout for PMON between soft kill and hard kill
PMON_SOFTKILL_W of lthreads
AIT_SECS
_LTHREAD_CLNUP_ : timeout for spawner between soft kill and hard kill of
SPAWNER_SK_WAIT lthreads
_SECS
_LTHREAD_DEBUG : Enable Debugging mode for lightweight threads
_LTHREAD_ENABLE : Enable lightweight threads
D
_LTHREAD_MAX_SP : maximum time interval a spawner will wait for a lthread
AWN_TIME_CSECS to get ready
_LTHREAD_SPAWN_ : time interval for a spawner to check for spawnee to get
CHECK_INTV_MS ready
_LTHREAD_STEP_D : Enable Step wise Debugging mode for lightweight threads
EBUGGING
_MAIN_DEAD_PROC : PMON main dead process scan interval (in seconds)
ESS_SCAN_INTERV
AL
_MASTER_DIRECT_ : direct sends for messages from master (DFS)
SENDS
_MAV_REFRESH_CO : refresh materialized views using consistent read
NSISTENT_READ snapshot
_MAV_REFRESH_DO : materialized view MAV refreshes avoid double counting
UBLE_COUNT_PREV
ENTED
_MAV_REFRESH_OP : optimizations during refresh of materialized views
T
_MAV_REFRESH_UN : # tables for union all expansion during materialized
IONALL_TABLES view refresh
_MAX_AQ_PERSIST : max aq persistent queue memory
ENT_QUEUE_MEMOR
Y
_MAX_ASYNC_WAIT : Switchover wait time for async LNS to catch up in
_FOR_CATCH_UP seconds
_MAX_CLIENTS_PE : maximum number of clients per emon
R_EMON
_MAX_CR_ROLLBAC : Maximum number of CR rollbacks per block (LMS)
KS
_MAX_DATA_TRANS : Maximum size of data transfer cache
FER_CACHE_SIZE
_MAX_DEFER_GRAN : Maximum deferred granules transferred by MMAN atonce
_XFER_ATONCE
_MAX_EXPONENTIA : max sleep during exponential backoff
L_SLEEP
_MAX_FILESTAT_T : maximum number of file stat tries
RIES
_MAX_FSU_SEGMEN : Maximum segments to track for fast space usage
TS
_MAX_FSU_STALE_ : Allowed space usage staleness in seconds
TIME
_MAX_INCIDENT_F : Maximum size (in KB, MB, GB, Blocks) of incident dump
ILE_SIZE file
_MAX_IO_SIZE : Maximum I/O size in bytes for sequential file accesses
_MAX_KCNIBR_RAN : Max number of nonlogged data block ranges
GES
_MAX_LARGEPAGE_ : Maximum number of seconds to spend on largepage
ALLOC_TIME_SECS allocation
_MAX_LARGE_IO : IORM:max number of large I/O’s to issue
_MAX_LNS_SHUTDO : Maximum time spent by LNS to archive last log during
WN_ARCHIVAL_TIM shutdown
E
_MAX_LOG_WRITE_ : Maximum I/O parallelism within a log write (auto=0)
IO_PARALLELISM
_MAX_LOG_WRITE_ : Maximum parallelism within a log write (auto=0)
PARALLELISM
_MAX_OUTSTANDIN : Maximum number of outstanding redo log writes
G_LOG_WRITES
_MAX_PENDING_SC : maximum number of pending SCN broadcasts
N_BCASTS
_MAX_PROTOCOL_S : Max occurrence protocols supported in a process
UPPORT
_MAX_QUEUED_REP : Maximum number of report requests that can be queued in
ORT_REQUESTS a list
_MAX_REASONABLE : Max reasonable SCN rate
_SCN_RATE
_MAX_REPORT_FLU : Max no of report requests that can be flushed per cycle
SHES_PERCYCLE
_MAX_RWGS_GROUP : maximum no of groupings on materialized views
INGS
_MAX_SERVICES : maximum number of database services
_MAX_SHRINK_OBJ : number of segments for which shrink stats will be
_STATS maintained
_MAX_SLEEP_HOLD : max time to sleep while holding a latch
ING_LATCH
_MAX_SMALL_IO : IORM:max number of small I/O’s to issue
_MAX_SPACEBG_MS : maximum space management interrupt message throttling
GS_PERCENTAGE
_MAX_SPACEBG_SL : maximum space management background slaves
AVES
_MAX_SPACEBG_TA : maximum space management background tasks
SKS
_MAX_STRING_SIZ : controls error checking for the max_string_size
E_BYPASS parameter
_MAX_SYS_NEXT_E : Dictionary managed SYSTEM tablespace maximum next
XTENT extent size in MB (allowed range [16-4095], 0 if
unlimited)
_MEDIA_RECOVERY : media recovery block read batch
_READ_BATCH
_MEMORY_BROKER_ : memory broker num stat entries
LOG_STAT_ENTRIE
S
_MEMORY_BROKER_ : Marginal Utility threshold pct for bc
MARGINAL_UTILIT
Y_BC
_MEMORY_BROKER_ : Marginal Utility threshold pct for sp
MARGINAL_UTILIT
Y_SP
_MEMORY_BROKER_ : memory broker allow policy to shrink shared pool
SHRINK_HEAPS
_MEMORY_BROKER_ : memory broker allow policy to shrink java pool
SHRINK_JAVA_HEA
PS
_MEMORY_BROKER_ : memory broker allow policy to shrink streams pool
SHRINK_STREAMS_
POOL
_MEMORY_BROKER_ : memory broker policy to timeout shrink shared/java pool
SHRINK_TIMEOUT
_MEMORY_BROKER_ : memory broker statistics gathering interval for auto
STAT_INTERVAL sga
_MEMORY_CHECKIN : check inuse time interval
USE_TIMEINTV
_MEMORY_IMM_MOD : Allow immediate mode without sga/memory target
E_WITHOUT_AUTOS
GA
_MEMORY_INITIAL : Initial default sga target percentage with memory
_SGA_SPLIT_PERC target
_MEMORY_MANAGEM : trace memory management activity
ENT_TRACING
_MEMORY_MAX_TGT : counts the times checker increments memory target
_INC_CNT
_MEMORY_MGMT_FA : always fail immediate mode request
IL_IMMREQ
_MEMORY_MGMT_IM : time in seconds to time out immediate mode request
MREQ_TIMEOUT
_MEMORY_NOCANCE : do not cancel deferred sga reqs with auto-memory
L_DEFSGAREQ
_MEMORY_SANITY_ : partial granule sanity check
CHECK
_MEM_ANNOTATION : private memory annotation collection level
_PR_LEV
_MEM_ANNOTATION : memory annotation pre-allocation scaling
_SCALE
_MEM_ANNOTATION : shared memory annotation collection level
_SH_LEV
_MEM_ANNOTATION : memory annotation in-memory store
_STORE
_MEM_STD_EXTENT : standard extent size for fixed-size-extent heaps
_SIZE
_MESSAGES : message queue resources – dependent on # processes #
buffers
_MGD_RCV_HANDLE : Managed recovery handle orphan datafile situation
_ORPHAN_DATAFIL
ES
_MIDTIER_AFFINI : cluster wait precentage threshold to enter affinity
TY_CLUSWAIT_PRC
_THRESHOLD
_MIDTIER_AFFINI : goodness gradient threshold to dissolve affinity
TY_GOODNESS_THR
ESHOLD
_MINFREE_PLUS : max percentage of block space + minfree before we mark
block full
_MINIMAL_STATS_ : prohibit stats aggregation at compile/partition
AGGREGATION maintenance time
_MINIMUM_BLOCKS : minimum number freeable blocks for shrink to be present
_TO_SHRINK
_MINIMUM_DB_FLA : Minimum flashback retention
SHBACK_RETENTIO
N
_MINIMUM_EXTENT : minimum number freeable extents for shrink to be
S_TO_SHRINK present
_MIN_TIME_BETWE : minimum time between PSP0 diagnostic used for flow
EN_PSP0_DIAG_SE control
CS
_MIRROR_REDO_BU : Save buffers for debugging redo corruptions
FFERS
_MMV_QUERY_REWR : allow rewrites with multiple MVs and/or base tables
ITE_ENABLED
_MODIFY_COLUMN_ : allow ALTER TABLE MODIFY(column) to violate index key
INDEX_UNUSABLE length limit
_MODULE_ACTION_ : Use module and action old length parameter
OLD_LENGTH
_MPMT_ENABLED : MPMT mode enabled
_MPMT_ENABLED_B : mpmt enabled backgrounds
ACKGROUNDS
_MPMT_FG_ENABLE : MPMT mode foreground enabled
D
_MPMT_PROCS_PER : max procs per osp
_OSP
_MULTIPLE_INSTA : use multiple instances for media recovery
NCE_RECOVERY
_MULTI_INSTANCE : force multi instance parallel recovery
_PMR
_MULTI_JOIN_KEY : TRUE iff multi-join-key table lookup prefetch is
_TABLE_LOOKUP enabled
_MULTI_TRANSACT : reduce SGA memory use during create of a partitioned
ION_OPTIMIZATIO table
N_ENABLED
_MUTEX_SPIN_COU : Mutex spin count
NT
_MUTEX_WAIT_SCH : Mutex wait scheme
EME
_MUTEX_WAIT_TIM : Mutex wait time
E
_MV_ADD_LOG_PLA : add log placeholder
CEHOLDER
_MV_CLEANUP_ORP : cleanup orphaned materialized view metadata
HANED_METADATA
_MV_COMPLETE_RE : use conventional INSERTs for MV complete refresh
FRESH_CONVENTIO
NAL
_MV_DEFERRED_NO : avoid build deferred MV log age validate
_LOG_AGE_VAL
_MV_EXPRESSION_ : MV expression extend size
EXTEND_SIZE
_MV_GENERALIZED : enable/disable new algorithm for MJV with generalized
_OJ_REFRESH_OPT outer joins
_MV_REFRESH_ANA : what percent to analyze after complete/PCT refresh
_MV_REFRESH_COS : refresh decision based on cost or on rules
TING
_MV_REFRESH_DEL : delta mv as fractional percentage of size of mv
TA_FRACTION
_MV_REFRESH_ENH : enable enhanced detection of DML types from MV log
ANCED_DML_DETEC
TION
_MV_REFRESH_EUT : refresh materialized views using EUT(partition)-based
algorithm
_MV_REFRESH_FOR : force materialized view refreshes to use parallel query
CE_PARALLEL_QUE
RY
_MV_REFRESH_INS : materialized view refresh using insert no append
ERT_NO_APPEND
_MV_REFRESH_NEW : materialized view MV refresh new setup disabling
_SETUP_DISABLED
_MV_REFRESH_NO_ : avoid index rebuild as part of the MV refresh
IDX_REBUILD
_MV_REFRESH_PKF : control MV refresh based on the assumption of PK-FK
K_DATA_UNITS_OP data units
T
_MV_REFRESH_PKF : control MV refresh based on the use of PK-FK
K_RELATIONSHIP_ relationships
OPT
_MV_REFRESH_REB : minimum percentage change required in MV to force an
UILD_PERCENTAGE indexrebuild
_MV_REFRESH_SEL : create materialized views with selections and fast
ECTIONS refresh
_MV_REFRESH_UPD : materialized view refresh using update analysis
ATE_ANALYSIS
_MV_REFRESH_USE : use hash_sj hint in queries
_HASH_SJ
_MV_REFRESH_USE : use no_merge hint in queries
_NO_MERGE
_MV_REFRESH_USE : pass cardinality hints to refresh queries
_STATS
_MV_REFSCHED_TI : proportionality constant for dop vs. time in MV refresh
MEINCR
_MV_ROLLING_INV : create/alter mv uses rolling cursor invalidation
instead of immediate
_MWIN_SCHEDULE : Enable/disable Maintenance Window Schedules
_NAMESERVICE_CO : NameService Consistency check switch
NSISTENCY_CHECK
_NCHAR_IMP_CNV : NLS allow Implicit Conversion between CHAR and NCHAR
_NCHAR_IMP_CONV : should implicit conversion bewteen clob and nclob be
allowed
_NCMB_READAHEAD : enable multi-block readahead for an index scan
_ENABLED
_NCMB_READAHEAD : turn on multi-block readahead tracing
_TRACING
_NCOMP_SHARED_O : native compilation shared objects dir
BJECTS_DIR
_NESTED_LOOP_FU : nested loop fudge
DGE
_NESTED_MV_FAST : nested MV refresh fast on commit allowed
_ONCOMMIT_ENABL
ED
_NET_TIMEOUT_LA : NET_TIMEOUT latency
TENCY
_NEWSORT_ENABLE : controls whether new sorts can be used as system sort
D
_NEWSORT_ORDERE : controls when new sort avoids sorting ordered input
D_PCT
_NEWSORT_TYPE : specifies options for the new sort algorithm
_NEW_INITIAL_JO : enable initial join orders based on new ordering
IN_ORDERS heuristics
_NEW_SORT_COST_ : enables the use of new cost estimate for sort
ESTIMATE
_NINETEENTH_SPA : nineteenth spare parameter – string
RE_PARAMETER
_NINTH_SPARE_PA : ninth spare parameter – integer
RAMETER
_NLJ_BATCHING_A : FAE flag type set after restoring to IO batching buffer
E_FLAG
_NLJ_BATCHING_E : enable batching of the RHS IO in NLJ
NABLED
_NLJ_BATCHING_M : enable exceptions for buffer cache misses
ISSES_ENABLED
_NLS_PARAMETER_ : enables or disables updates to v$parameter whenever an
SYNC_ENABLED alter session statement modifies various nls parameters
_NOLOGGING_KCNB : Number of nologging buffer hash buckets
UF_HASH_BUCKETS
_NOLOGGING_KCNB : Number of nologging buffer hash latches
UF_HASH_LATCHES
_NOLOGGING_LOAD : Nologging standby: direct load buffer size
_SLOTSZ
_NOLOGGING_SDCL : Nologging standby append sdcl wait time
_APPEND_WAIT
_NOLOGGING_SEND : Nologging standby: outstanding send buffer ratio
BUF_RATIO
_NOLOGGING_TXN_ : Nologging standby transaction commit wait time
CMT_WAIT
_NONCDB_TO_PDB : converting a non-cdb to a pdb
_NOSEG_FOR_UNUS : no segments for unusable indexes if set to TRUE
ABLE_INDEX_ENAB
LED
_NOTIFY_CRS : notify cluster ready services of startup and shutdown
_NO_OBJECTS : no object features are used
_NO_OR_EXPANSIO : OR expansion during optimization disabled
N
_NO_RECOVERY_TH : no recovery through this resetlogs operation
ROUGH_RESETLOGS
_NO_SMALL_FILE : Not to apply new extent scheme for small file temp
spaces
_NO_STALE_JOINB : No joinbacks if mv is stale
ACK_REWRITE
_NS_MAX_FLUSH_W : Flush wait time for NetServer to flush oustanding
T writes
_NS_MAX_SEND_DE : Data Loss Time Bound for NetServer
LAY
_NUMA_BUFFER_CA : Configure NUMA buffer cache stats
CHE_STATS
_NUMA_INSTANCE_ : Set of nodes that this instance should run on
MAPPING
_NUMA_POOL_SIZE : aggregate size in bytes of NUMA pool
_NUMA_SHIFT_ENA : Enable NUMA shift
BLED
_NUMA_SHIFT_VAL : user defined value for numa nodes shift
UE
_NUMA_TRACE_LEV : numa trace event
EL
_NUMBER_CACHED_ : maximum number of cached attributes per instance
ATTRIBUTES
_NUMBER_CACHED_ : maximum number of cached group memberships
GROUP_MEMBERSHI
PS
_NUMBER_GROUP_M : maximum number of group memberships per cache line
EMBERSHIPS_PER_
CACHE_LINE
_NUM_LONGOP_CHI : number of child latches for long op array
LD_LATCHES
_OBJECT_NUMBER_ : Object number cache size
CACHE_SIZE
_OBJECT_REUSE_B : if 1 or higher, handle object reuse
AST
_OBJECT_STATIST : enable the object level statistics collection
ICS
_OBJECT_STATS_M : Maximum number of entries to be tracked per stat
AX_ENTRIES
_OBJ_CKPT_TRACI : Enable object checkpoint tracing
NG
_ODCI_AGGREGATE : trade speed for space in user-defined aggregation
_SAVE_SPACE
_OFFLINE_ROLLBA : offline undo segment list
CK_SEGMENTS
_OGMS_HOME : GMS home directory
_OLAPI_HISTORY_ : enable olapi history retention
RETENTION
_OLAPI_IFACE_OB : enable olapi interface object history collection
JECT_HISTORY
_OLAPI_IFACE_OB : enable olapi interface object history retention
JECT_HISTORY_RE
TENTION
_OLAPI_IFACE_OP : enable olapi interface operation history retention
ERATION_HISTORY
_RETENTION
_OLAPI_INTERFAC : enable olapi interface operation history collection
E_OPERATION_HIS
TORY
_OLAPI_MEMORY_O : enable olapi memory alloc/free history collection
PERATION_HISTOR
Y
_OLAPI_MEMORY_O : enable olapi memory alloc/free history collection
PERATION_HISTOR pausing
Y_PAUSE_AT_SEQN
O
_OLAPI_MEMORY_O : enable olapi memory operation history retention
PERATION_HISTOR
Y_RETENTION
_OLAPI_SESSION_ : enable olapi session history collection
HISTORY
_OLAPI_SESSION_ : enable olapi session history retention
HISTORY_RETENTI
ON
_OLAP_ADV_COMP_ : do additional predicate stats analysis for AW rowsource
STATS_CC_PRECOM
P
_OLAP_ADV_COMP_ : do additional predicate stats analysis for AW rowsource
STATS_MAX_ROWS
_OLAP_AGGREGATE : OLAP Aggregate max buffer size
_BUFFER_SIZE
_OLAP_AGGREGATE : OLAP Aggregate debug flags
_FLAGS
_OLAP_AGGREGATE : OLAP Aggregate function cache enabler
_FUNCTION_CACHE
_ENABLED
_OLAP_AGGREGATE : OLAP Aggregate max thread tuples creation
_MAX_THREAD_TUP
LES
_OLAP_AGGREGATE : OLAP Aggregate min buffer size
_MIN_BUFFER_SIZ
E
_OLAP_AGGREGATE : OLAP Aggregate minimum cardinality of dimensions for
_MIN_THREAD_STA thread
TUS
_OLAP_AGGREGATE : OLAP Aggregate Multi-path Hierarhies enabled
_MULTIPATH_HIER
_OLAP_AGGREGATE : OLAP Aggregate status array usage threshold
_STATLEN_THRESH
_OLAP_AGGREGATE : OLAP Aggregate max worklists generated at once
_WORKLIST_MAX
_OLAP_AGGREGATE : OLAP Aggregate max work parents
_WORK_PER_THREA
D
_OLAP_ALLOCATE_ : OLAP Allocate Errorlog Format
ERRORLOG_FORMAT
_OLAP_ALLOCATE_ : OLAP Allocate Errorlog Header format
ERRORLOG_HEADER
_OLAP_ANALYZE_M : OLAP DML ANALYZE command max cells to analyze
AX
_OLAP_CONTINUOU : OLAP logging definition
S_TRACE_FILE
_OLAP_DBGOUTFIL : OLAP DbgOutfile copy output to event log (tracefile)
E_ECHO_TO_EVENT
LOG
_OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Force
_COREHASH_FORCE
_OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Large Threshold
_COREHASH_LARGE
_OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Pressure Threshold
_COREHASH_PRESS
URE
_OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Maximum Memory Use
_COREHASH_SIZE
_OLAP_EIF_EXPOR : OLAP EIF Export BLOB size
T_LOB_SIZE
_OLAP_LMGEN_DIM : Limitmap generator dimension column size
_SIZE
_OLAP_LMGEN_MEA : Limitmap generator measure column size
S_SIZE
_OLAP_OBJECT_HA : OLAP Object Hash Table Class
SH_CLASS
_OLAP_PAGE_POOL : OLAP Page Pool Expand Rate
_EXPAND_RATE
_OLAP_PAGE_POOL : OLAP Page Pool High Watermark
_HI
_OLAP_PAGE_POOL : OLAP Page Pool Hit Target
_HIT_TARGET
_OLAP_PAGE_POOL : OLAP Page Pool Low Watermark
_LOW
_OLAP_PAGE_POOL : OLAP Page Pool Pressure Threshold
_PRESSURE
_OLAP_PAGE_POOL : OLAP Page Pool Shrink Rate
_SHRINK_RATE
_OLAP_PARALLEL_ : OLAP parallel update server count
UPDATE_SERVER_N
UM
_OLAP_PARALLEL_ : OLAP parallel update threshold for number of small
UPDATE_SMALL_TH pagespaces
RESHOLD
_OLAP_PARALLEL_ : OLAP parallel update threshold in pages
UPDATE_THRESHOL
D
_OLAP_ROW_LOAD_ : OLAP Row Load Time Precision
TIME_PRECISION
_OLAP_SESSCACHE : OLAP Session Cache knob
_ENABLED
_OLAP_SORT_BUFF : OLAP Sort Buffer Size Percentage
ER_PCT
_OLAP_SORT_BUFF : OLAP Sort Buffer Size
ER_SIZE
_OLAP_STATBOOL_ : OLAP Status Boolean max incore bits
COREBITS
_OLAP_STATBOOL_ : OLAP Status Boolean CBM threshold
THRESHOLD
_OLAP_TABLE_FUN : Specify TRUE to output OLAP table function timed
CTION_STATISTIC statistics trace
S
_OLAP_WRAP_ERRO : Wrap error messages to OLAP outfile
RS
_OLD_CONNECT_BY : enable/disable old connect by
_ENABLED
_OLD_EXTENT_SCH : Revert to old extent allocation
EME
_OLS_CLEANUP_TA : Clean up unnecessary entries in OLS sessinfo table
SK
_OLTP_COMPRESSI : oltp compression enabled
ON
_OLTP_COMPRESSI : oltp compression gain
ON_GAIN
_OLTP_COMP_DBG_ : oltp compression scan debug
SCAN
_OLTP_SPILL : spill rows for oltp compression if loader pga limit is
exceeded
_OMF : enable/disable OMF
_OMNI_ENQUEUE_E : Enable Omni Enqueue feature (0 = disable, 1 = enable on
NABLE ASM (default), 2 = enable)
_ONESIDE_COLSTA : sanity check on default selectivity for like/range
T_FOR_EQUIJOINS predicate
_ONLINE_CTAS_DI : controls dumping diagnostic information for online ctas
AG
_ONLINE_PATCH_D : disable check for function on stack for online patches
ISABLE_STACK_CH
ECK
_OPS_PER_SEMOP : the exact number of operations per semop system call
_OPTIMIZER_ADAP : optimizer adaptive cursor sharing
TIVE_CURSOR_SHA
RING
_OPTIMIZER_ADAP : enable adaptive plans
TIVE_PLANS
_OPTIMIZER_ADAP : internal controls for adaptive plans
TIVE_PLAN_CONTR
OL
_OPTIMIZER_ADJU : adjust selectivity for null values
ST_FOR_NULLS
_OPTIMIZER_ADS_ : maximum number of tables in a join under ADS
MAX_TABLE_COUNT
_OPTIMIZER_ADS_ : maximum time limit (seconds) under ADS
TIME_LIMIT
_OPTIMIZER_ADS_ : use result cache for ADS queries
USE_RESULT_CACH
E
_OPTIMIZER_ANSI : optimization of left/full ansi-joins and lateral views
_JOIN_LATERAL_E
NHANCE
_OPTIMIZER_ANSI : re-architecture of ANSI left, right, and full outer
_REARCHITECTURE joins
_OPTIMIZER_AUTO : enable/disable auto stats collection job
STATS_JOB
_OPTIMIZER_AW_J : Enables AW Join Push optimization
OIN_PUSH_ENABLE
D
_OPTIMIZER_AW_S : Enables statistcs on AW olap_table table function
TATS_ENABLED
_OPTIMIZER_BATC : enable table access by ROWID IO batching
H_TABLE_ACCESS_
BY_ROWID
_OPTIMIZER_BETT : enable improved costing of index access using
ER_INLIST_COSTI in-list(s)
NG
_OPTIMIZER_BLOC : standard block size used by optimizer
K_SIZE
_OPTIMIZER_CACH : cost with cache statistics
E_STATS
_OPTIMIZER_CART : optimizer cartesian join enabled
ESIAN_ENABLED
_OPTIMIZER_CBQT : cost factor for cost-based query transformation
_FACTOR
_OPTIMIZER_CBQT : disable cost based transformation query size
_NO_SIZE_RESTRI restriction
CTION
_OPTIMIZER_CEIL : CEIL cost in CBO
_COST
_OPTIMIZER_CLUS : enable/disable the cluster by rowid feature
TER_BY_ROWID
_OPTIMIZER_CLUS : internal control for cluster by rowid feature mode
TER_BY_ROWID_CO
NTROL
_OPTIMIZER_COAL : consider coalescing of subqueries optimization
ESCE_SUBQUERIES
_OPTIMIZER_COMP : enable selectivity estimation for builtin functions
LEX_PRED_SELECT
IVITY
_OPTIMIZER_COMP : force index stats collection on index creation/rebuild
UTE_INDEX_STATS
_OPTIMIZER_CONN : use cost-based transformation for whr clause in connect
ECT_BY_CB_WHR_O by
NLY
_OPTIMIZER_CONN : combine no filtering connect by and start with
ECT_BY_COMBINE_
SW
_OPTIMIZER_CONN : use cost-based transformation for connect by
ECT_BY_COST_BAS
ED
_OPTIMIZER_CONN : allow connect by to eliminate duplicates from input
ECT_BY_ELIM_DUP
S
_OPTIMIZER_CORR : force correct computation of subquery selectivity
ECT_SQ_SELECTIV
ITY
_OPTIMIZER_COST : enables cost-based query transformation
_BASED_TRANSFOR
MATION
_OPTIMIZER_COST : enables costing of filter predicates in IO cost model
_FILTER_PRED
_OPTIMIZER_COST : add cost of generating result set when #rows per key
_HJSMJ_MULTIMAT 1
CH
_OPTIMIZER_COST : optimizer cost model
_MODEL
_OPTIMIZER_CUBE : enable cube join
_JOIN_ENABLED
_OPTIMIZER_DEGR : force the optimizer to use the same degree of
EE parallelism
_OPTIMIZER_DIM_ : use join selectivity in choosing star transformation
SUBQ_JOIN_SEL dimensions
_OPTIMIZER_DISA : disable star transformation sanity checks
BLE_STRANS_SANI
TY_CHECKS
_OPTIMIZER_DIST : Transforms Distinct Aggregates to non-distinct
INCT_AGG_TRANSF aggregates
ORM
_OPTIMIZER_DIST : Eliminates redundant SELECT DISTNCT’s
INCT_ELIMINATIO
N
_OPTIMIZER_DIST : consider distinct placement optimization
INCT_PLACEMENT
_OPTIMIZER_DSDI : controls optimizer usage of dynamic sampling directives
R_USAGE_CONTROL
_OPTIMIZER_DYN_ : number of blocks for optimizer dynamic sampling
SMP_BLKS
_OPTIMIZER_ELIM : optimizer filtering join elimination enabled
INATE_FILTERING
_JOIN
_OPTIMIZER_ENAB : use improved density computation for selectivity
LE_DENSITY_IMPR estimation
OVEMENTS
_OPTIMIZER_ENAB : use extended statistics for selectivity estimation
LE_EXTENDED_STA
TS
_OPTIMIZER_ENAB : consider table lookup by nl transformation
LE_TABLE_LOOKUP
_BY_NL
_OPTIMIZER_ENHA : push filters before trying cost-based query
NCED_FILTER_PUS transformation
H
_OPTIMIZER_EXTE : optimizer extended cursor sharing
NDED_CURSOR_SHA
RING
_OPTIMIZER_EXTE : optimizer extended cursor sharing for relational
NDED_CURSOR_SHA operators
RING_REL
_OPTIMIZER_EXTE : controls the optimizer usage of extended stats
NDED_STATS_USAG
E_CONTROL
_OPTIMIZER_EXTE : join pred pushdown on group-by, distinct,
ND_JPPD_VIEW_TY semi-/anti-joined view
PES
_OPTIMIZER_FALS : optimizer false predicate pull up transformation
E_FILTER_PRED_P
ULLUP
_OPTIMIZER_FAST : use fast algorithm to traverse predicates for physical
_ACCESS_PRED_AN optimizer
ALYSIS
_OPTIMIZER_FAST : use fast algorithm to generate transitive predicates
_PRED_TRANSITIV
ITY
_OPTIMIZER_FEED : controls the optimizer feedback framework
BACK_CONTROL
_OPTIMIZER_FILT : use cost-based flter predicate pull up transformation
ER_PRED_PULLUP
_OPTIMIZER_FILT : enable/disable filter predicate pushdown
ER_PUSHDOWN
_OPTIMIZER_FKR_ : Optimizer index bias over FTS/IFFS under first K rows
INDEX_COST_BIAS mode
_OPTIMIZER_FORC : force CBQT transformation regardless of cost
E_CBQT
_OPTIMIZER_FREE : free transformation subheap after each transformation
_TRANSFORMATION
_HEAP
_OPTIMIZER_FULL : enable/disable full outer to left outer join conversion
_OUTER_JOIN_TO_
OUTER
_OPTIMIZER_GATH : optimizer gather feedback
ER_FEEDBACK
_OPTIMIZER_GATH : enable/disable online statistics gathering
ER_STATS_ON_LOA
D
_OPTIMIZER_GENE : optimizer generate transitive predicates
RATE_TRANSITIVE
_PRED
_OPTIMIZER_GROU : consider group-by placement optimization
P_BY_PLACEMENT
_OPTIMIZER_HYBR : enable hybrid full partition-wise join when TRUE
ID_FPWJ_ENABLED
_OPTIMIZER_IGNO : enables the embedded hints to be ignored
RE_HINTS
_OPTIMIZER_IMPR : improve table and partial overlap join selectivity
OVE_SELECTIVITY computation
_OPTIMIZER_INST : force the optimizer to use the specified number of
ANCE_COUNT instances
_OPTIMIZER_INTE : interleave join predicate pushdown during CBQT
RLEAVE_JPPD
_OPTIMIZER_INVA : time window for invalidation of cursors of analyzed
LIDATION_PERIOD objects
_OPTIMIZER_JOIN : optimizer join elimination enabled
_ELIMINATION_EN
ABLED
_OPTIMIZER_JOIN : use join factorization transformation
_FACTORIZATION
_OPTIMIZER_JOIN : controls the optimizer join order search algorithm
_ORDER_CONTROL
_OPTIMIZER_JOIN : enable/disable sanity check for multi-column join
_SEL_SANITY_CHE selectivity
CK
_OPTIMIZER_MAX_ : optimizer maximum join permutations per query block
PERMUTATIONS
_OPTIMIZER_MIN_ : set minimum cached blocks
CACHE_BLOCKS
_OPTIMIZER_MJC_ : enable merge join cartesian
ENABLED
_OPTIMIZER_MODE : force setting of optimizer mode for user recursive SQL
_FORCE also
_OPTIMIZER_MULT : generate and run plans using several compilation
IPLE_CENV environments
_OPTIMIZER_MULT : control what to report in trace file when run in
IPLE_CENV_REPOR multi-plan mode
T
_OPTIMIZER_MULT : control the types of statements that are run in
IPLE_CENV_STMT multi-plan mode
_OPTIMIZER_MULT : consider join-predicate pushdown that requires
I_LEVEL_PUSH_PR multi-level pushdown to base table
ED
_OPTIMIZER_MULT : allows multiple tables on the left of outerjoin
I_TABLE_OUTERJO
IN
_OPTIMIZER_NATI : execute full outer join using native implementaion
VE_FULL_OUTER_J
OIN
_OPTIMIZER_NEST : number of groups above which we use nested rollup exec
ED_ROLLUP_FOR_G for gset
SET
_OPTIMIZER_NEW_ : compute join cardinality using non-rounded input values
JOIN_CARD_COMPU
TATION
_OPTIMIZER_NULL : enables null-accepting semijoin
_ACCEPTING_SEMI
JOIN
_OPTIMIZER_NULL : null-aware antijoin parameter
_AWARE_ANTIJOIN
_OPTIMIZER_ORDE : Eliminates order bys from views before query
R_BY_ELIMINATIO transformation
N_ENABLED
_OPTIMIZER_OR_E : control or expansion approach used
XPANSION
_OPTIMIZER_OR_E : Use subheap for optimizer or-expansion
XPANSION_SUBHEA
P
_OPTIMIZER_OUTE : enable/disable outer to inner join conversion
R_JOIN_TO_INNER
_OPTIMIZER_OUTE : Enable transformation of outer-join to anti-join if
R_TO_ANTI_ENABL possible
ED
_OPTIMIZER_PART : partial join evaluation parameter
IAL_JOIN_EVAL
_OPTIMIZER_PERC : optimizer percent parallel
ENT_PARALLEL
_OPTIMIZER_PERF : controls the performance feedback
ORMANCE_FEEDBAC
K
_OPTIMIZER_PROC : control the level of processing rates
_RATE_LEVEL
_OPTIMIZER_PROC : control the source of processing rates
_RATE_SOURCE
_OPTIMIZER_PURG : number of rows to be deleted at each iteration of the
E_STATS_ITERATI stats purging process
ON_ROW_COUNT
_OPTIMIZER_PUSH : push down distinct from query block to table
_DOWN_DISTINCT
_OPTIMIZER_PUSH : use cost-based query transformation for push pred
_PRED_COST_BASE optimization
D
_OPTIMIZER_RAND : optimizer seed value for random plans
OM_PLAN
_OPTIMIZER_REUS : reuse cost annotations during cost-based query
E_COST_ANNOTATI transformation
ONS
_OPTIMIZER_ROWN : Default value to use for rownum bind
UM_BIND_DEFAULT
_OPTIMIZER_ROWN : enable the use of first K rows due to rownum predicate
UM_PRED_BASED_F
KR
_OPTIMIZER_SAVE : enable/disable saving old versions of optimizer stats
_STATS
_OPTIMIZER_SEAR : optimizer search limit
CH_LIMIT
_OPTIMIZER_SELF : account for self-induced caching
_INDUCED_CACHE_
COST
_OPTIMIZER_SKIP : enable/disable index skip scan
_SCAN_ENABLED
_OPTIMIZER_SKIP : consider index skip scan for predicates with guessed
_SCAN_GUESS selectivity
_OPTIMIZER_SORT : enable/disable sort-merge join method
MERGE_JOIN_ENAB
LED
_OPTIMIZER_SORT : enable/disable sort-merge join using inequality
MERGE_JOIN_INEQ predicates
UALITY
_OPTIMIZER_SQU_ : enables unnesting of subquery in a bottom-up manner
BOTTOMUP
_OPTIMIZER_STAR : optimizer star plan enabled
PLAN_ENABLED
_OPTIMIZER_STAR : optimizer star transformation minimum cost
_TRANS_MIN_COST
_OPTIMIZER_STAR : optimizer star transformation minimum ratio
_TRANS_MIN_RATI
O
_OPTIMIZER_STAR : enable/disable star transformation in with clause
_TRAN_IN_WITH_C queries
LAUSE
_OPTIMIZER_STRA : allow adaptive pruning of star transformation bitmap
NS_ADAPTIVE_PRU trees
NING
_OPTIMIZER_SYST : system statistics usage
EM_STATS_USAGE
_OPTIMIZER_TABL : consider table expansion transformation
E_EXPANSION
_OPTIMIZER_TRAC : optimizer trace parameter
E
_OPTIMIZER_TRAN : retain equi-join pred upon transitive equality pred
SITIVITY_RETAIN generation
_OPTIMIZER_TRY_ : try Star Transformation before Join Predicate Push Down
ST_BEFORE_JPPD
_OPTIMIZER_UNDO : undo changes to query optimizer
_CHANGES
_OPTIMIZER_UNDO : optimizer undo cost change
_COST_CHANGE
_OPTIMIZER_UNNE : enables unnesting of every type of subquery
ST_ALL_SUBQUERI
ES
_OPTIMIZER_UNNE : Unnesting of correlated set subqueries (TRUE/FALSE)
ST_CORR_SET_SUB
Q
_OPTIMIZER_UNNE : Unnesting of disjunctive subqueries (TRUE/FALSE)
ST_DISJUNCTIVE_
SUBQ
_OPTIMIZER_UNNE : enables unnesting of of scalar subquery
ST_SCALAR_SQ
_OPTIMIZER_USE_ : use rewritten star transformation using cbqt framework
CBQT_STAR_TRANS
FORMATION
_OPTIMIZER_USE_ : optimizer use feedback
FEEDBACK
_OPTIMIZER_USE_ : use GTT session private statistics
GTT_SESSION_STA
TS
_OPTIMIZER_USE_ : enable/disable the usage of histograms by the optimizer
HISTOGRAMS
_OPTIMIZER_USE_ : Enables physical optimizer subheap
SUBHEAP
_OPTIM_ADJUST_F : adjust stats for skews across partitions
OR_PART_SKEWS
_OPTIM_DICT_STA : enable/disable dictionary stats gathering at db
TS_AT_DB_CR_UPG create/upgrade
_OPTIM_ENHANCE_ : TRUE to enable index [fast] full scan more often
NNULL_DETECTION
_OPTIM_NEW_DEFA : improves the way default equijoin selectivity are
ULT_JOIN_SEL computed
_OPTIM_PEEK_USE : enable peeking of user binds
R_BINDS
_ORACLE_SCRIPT : Running an Oracle-supplied script
_ORADBG_PATHNAM : path of oradbg script
E
_ORADEBUG_CMDS_ : oradebug commands to execute at instance startup
AT_STARTUP
_ORADEBUG_FORCE : force target processes to execute oradebug commands?
_ORDERED_NESTED : enable ordered nested loop costing
_LOOP
_ORDERED_SEMIJO : enable ordered semi-join subquery
IN
_ORPH_CLN_INTER : qmon periodic interval for removed subscriber messages
VAL cleanup
_OR_EXPAND_NVL_ : enable OR expanded plan for NVL/DECODE predicate
PREDICATE
_OSS_SKGXP_UDP_ : OSSLIB enable[!0]/disable[0] dynamic credit mgmt for
DYNAMIC_CREDIT_ SKGXP-UDP
MGMT
_OS_SCHED_HIGH_ : OS high priority level
PRIORITY
_OTHER_WAIT_EVE : exclude event names from _other_wait_threshold
NT_EXCLUSION calculations
_OTHER_WAIT_THR : threshold wait percentage for event wait class Other
ESHOLD
_OUTLINE_BITMAP : BITMAP_TREE hint enabled in outline
_TREE
_PARALLELISM_CO : set the parallelism cost fudge factor
ST_FUDGE_FACTOR
_PARALLEL_ADAPT : maximum number of users running with default DOP
IVE_MAX_USERS
_PARALLEL_BLACK : parallel execution blackbox enabled
BOX_ENABLED
_PARALLEL_BLACK : true if blackbox will be allocated in SGA, false if PGA
BOX_SGA
_PARALLEL_BLACK : parallel execution blackbox bucket size
BOX_SIZE
_PARALLEL_BROAD : enable broadcasting of small inputs to hash and sort
CAST_ENABLED merge joins
_PARALLEL_CLUST : max percentage of the global buffer cache to use for
ER_CACHE_PCT affinity
_PARALLEL_CLUST : policy used for parallel execution on
ER_CACHE_POLICY cluster(ADAPTIVE/CACHED)
_PARALLEL_CONSE : conservative parallel statement queuing
RVATIVE_QUEUING
_PARALLEL_CTAS_ : enable/disable parallel CTAS operation
ENABLED
_PARALLEL_DEFAU : default maximum number of instances for parallel query
LT_MAX_INSTANCE
S
_PARALLEL_EXECU : Alignment of PX buffers to OS page boundary
TION_MESSAGE_AL
IGN
_PARALLEL_FAKE_ : fake db-scheduler percent used for testing
CLASS_PCT
_PARALLEL_FAULT : total number of faults fault-tolerance will handle
_TOLERANCE_THRE
SHOLD
_PARALLEL_FIXWR : Number of buckets for each round of fix write
ITE_BUCKET
_PARALLEL_HEART : interval of snapshot to track px msging between
BEAT_SNAPSHOT_I instances
NTERVAL
_PARALLEL_HEART : maximum number of historical snapshots archived
BEAT_SNAPSHOT_M
AX
_PARALLEL_LOAD_ : parallel execution load balanced slave allocation
BALANCING
_PARALLEL_LOAD_ : number of threads to allocate per instance
BAL_UNIT
_PARALLEL_LOAD_ : diffrence in percentage controlling px load propagation
PUBLISH_THRESHO
LD
_PARALLEL_MIN_M : minimum size of shared pool memory to reserve for pq
ESSAGE_POOL servers
_PARALLEL_OPTIM : parallel optimization phase when all slaves are local
IZATION_PHASE_F
OR_LOCAL
_PARALLEL_QUEUI : parallel statement queuing: max waiting time in queue
NG_MAX_WAITINGT
IME
_PARALLEL_RECOV : stop at -position- to step through SMON
ERY_STOPAT
_PARALLEL_REPLA : Number of messages for each round of parallel replay
Y_MSG_LIMIT
_PARALLEL_SCALA : Parallel scalability criterion for parallel execution
BILITY
_PARALLEL_SERVE : idle time before parallel query server dies (in 1/100
R_IDLE_TIME sec)
_PARALLEL_SERVE : sleep time between dequeue timeouts (in 1/100ths)
R_SLEEP_TIME
_PARALLEL_SLAVE : time(in seconds) to wait before retrying slave
_ACQUISITION_WA acquisition
IT
_PARALLEL_STATE : parallel statement queuing enabled
MENT_QUEUING
_PARALLEL_SYSPL : TRUE to obey force parallel query/dml/ddl under System
S_OBEY_FORCE PL/SQL
_PARALLEL_TIME_ : unit of work used to derive the degree of parallelism
UNIT (in seconds)
_PARALLEL_TXN_G : enable parallel_txn hint with updates and deletes
LOBAL
_PARAMETER_TABL : parameter table block size
E_BLOCK_SIZE
_PARTIAL_PWISE_ : enable partial partition-wise join when TRUE
JOIN_ENABLED
_PARTITION_ADVI : enables sampling based partitioning validation
SOR_SRS_ACTIVE
_PARTITION_CDB_ : partitioned cdb view evaluation enabled
VIEW_ENABLED
_PARTITION_LARG : Enables large extent allocation for partitioned tables
E_EXTENTS
_PARTITION_VIEW : enable/disable partitioned views
_ENABLED
_PART_ACCESS_VE : use version numbers to access versioned objects for
RSION_BY_NUMBER partitioning
_PART_REDEF_GLO : online partition redefinition update global indexes
BAL_INDEX_UPDAT
E
_PASSWORDFILE_E : password file enqueue timeout in seconds
NQUEUE_TIMEOUT
_PCT_REFRESH_DO : materialized view PCT refreshes avoid double counting
UBLE_COUNT_PREV
ENTED
_PDB_USE_SEQUEN : Use sequence cache in PDB mode
CE_CACHE
_PDML_GIM_SAMPL : control separation of global index maintenance for PDML
ING
_PDML_GIM_STAGG : slaves start on different index when doing index maint
ERED
_PDML_SLAVES_DI : slaves start on different partition when doing index
FF_PART maint
_PERCENT_FLASHB : Percent of flashback buffer filled to be considered
ACK_BUF_PARTIAL partial full
_FULL
_PGACTX_CAP_STA : capture stacks for setting pgactx
CKS
_PGA_LARGE_EXTE : PGA large extent size
NT_SIZE
_PGA_LIMIT_CHEC : microseconds to wait for over limit confirmation
K_WAIT_TIME
_PGA_LIMIT_DUMP : dump PGA summary when signalling ORA-4036
_SUMMARY
_PGA_LIMIT_INTE : whether to interrupt smaller eligible processes
RRUPT_SMALLER
_PGA_LIMIT_MIN_ : bytes of PGA usage below which process will not get
REQ_SIZE ORA-4036
_PGA_LIMIT_SIMU : bytes of physical memory to determine
LATED_PHYSMEM_S pga_aggregate_limit with
IZE
_PGA_LIMIT_TARG : default percent of pga_aggregate_target for
ET_PERC pga_aggregate_limit
_PGA_LIMIT_TIME : seconds to wait until direct interrupt
_TO_INTERRUPT
_PGA_LIMIT_TIME : seconds to wait before treating process as idle
_UNTIL_IDLE
_PGA_LIMIT_TIME : seconds to wait before killing session over limit
_UNTIL_KILLED
_PGA_LIMIT_TRAC : trace pga_aggregate_limit activity
ING
_PGA_LIMIT_USE_ : use immediate kill for sessions over limit
IMMEDIATE_KILL
_PGA_LIMIT_WATC : percentage of limit to have processes watch
H_PERC
_PGA_LIMIT_WATC : bytes of PGA usage at which process will begin watching
H_SIZE limit
_PGA_MAX_SIZE : Maximum size of the PGA memory for one process
_PING_WAIT_FOR_ : Wait for log force before block ping
LOG_FORCE
_PIN_TIME_STATI : if TRUE collect statistics for how long a current pin
STICS is held
_PIVOT_IMPLEMEN : pivot implementation method
TATION_METHOD
_PKT_ENABLE : enable progressive kill test
_PKT_PMON_INTER : PMON process clean-up interval (cs)
VAL
_PKT_START : start progressive kill test instrumention
_PLAN_OUTLINE_D : explain plan outline data enabled
ATA
_PLAN_VERIFY_IM : Performance improvement criterion for evolving plan
PROVEMENT_MARGI baselines
N
_PLAN_VERIFY_LO : Local time limit to use for an individual plan
CAL_TIME_LIMIT verification
_PLSQL_ANON_BLO : PL/SQL anonymous block code-type
CK_CODE_TYPE
_PLSQL_CACHE_EN : PL/SQL Function Cache Enabled
ABLE
_PLSQL_DUMP_BUF : conditions upon which the PL/SQL circular buffer is
FER_EVENTS dumped
_PLSQL_MAX_STAC : PL/SQL maximum stack size
K_SIZE
_PLSQL_MINIMUM_ : plsql minimum cache hit percentage required to keep
CACHE_HIT_PERCE caching active
NT
_PLSQL_NATIVE_F : Allocate PL/SQL native frames on the heap if size
RAME_THRESHOLD exceeds this value
_PLSQL_NVL_OPTI : PL/SQL NVL optimize
MIZE
_PLUGGABLE_DATA : Debug flag for pluggable database related operations
BASE_DEBUG
_PMON_DEAD_BLKR : rate to check blockers are alive during cleanup (in
S_ALIVE_CHK_RAT seconds)
E_SECS
_PMON_DEAD_BLKR : max blockers to check during cleanup
S_MAX_BLKRS
_PMON_DEAD_BLKR : max attempts per blocker while checking dead blockers
S_MAX_CLEANUP_A
TTEMPTS
_PMON_DEAD_BLKR : rate to scan for dead blockers during cleanup (in
S_SCAN_RATE_SEC seconds)
S
_PMON_ENABLE_DE : look for dead blockers during PMON cleanup
AD_BLKRS
_PMON_LOAD_CONS : server load balancing constants (S,P,D,I,L,C,M)
TANTS
_PMON_MAX_CONSE : PMON max consecutive posts in main loop
C_POSTS
_POST_WAIT_QUEU : Post Wait Queues – Num Dynamic Queues
ES_DYNAMIC_QUEU
ES
_POST_WAIT_QUEU : Post Wait Queues – Num Per Class
ES_NUM_PER_CLAS
S
_PQQ_DEBUG_TXN_ : pq queuing transaction active
ACT
_PQQ_ENABLED : Enable Resource Manager based Parallel Statement
Queuing
_PRECOMPUTE_GID : precompute gid values and copy them before returning a
_VALUES row
_PREDICATE_ELIM : allow predicate elimination if set to TRUE
INATION_ENABLED
_PRED_MOVE_AROU : enables predicate move-around
ND
_PRED_PUSH_CDB_ : predicate pushdown enabled for CDB views
VIEW_ENABLED
_PREFERED_STAND : standby db_unique_name prefered for krb operations
BY
_PRESCOMM : presume commit of IMU transactions
_PRE_REWRITE_PU : push predicates into views before rewrite
SH_PRED
_PRINT_INMEM_HE : print inmem ilm heatmap
ATMAP
_PRINT_REFRESH_ : enable dbms_output of materialized view refresh
SCHEDULE schedule
_PRINT_STAT_SEG : print ilm statistics segment
MENT
_PRIVATE_MEMORY : Start address of large extent memory segment
_ADDRESS
_PROJECTION_PUS : projection pushdown
HDOWN
_PROJECTION_PUS : level for projection pushdown debugging
HDOWN_DEBUG
_PROJECT_VIEW_C : enable projecting out unreferenced columns of a view
OLUMNS
_PROP_OLD_ENABL : Shift to pre 11g propagation behaviour
ED
_PROTECT_FRAME_ : Protect cursor frame heaps
HEAPS
_PTN_CACHE_THRE : flags and threshold to control partition metadata
SHOLD caching
_PUSH_JOIN_PRED : enable pushing join predicate inside a view
ICATE
_PUSH_JOIN_UNIO : enable pushing join predicate inside a union all view
N_VIEW
_PUSH_JOIN_UNIO : enable pushing join predicate inside a union view
N_VIEW2
_PX_ADAPTIVE_DI : determines the behavior of adaptive distribution
ST_METHOD methods
_PX_ADAPTIVE_DI : Buffering / decision threshold for adaptive
ST_METHOD_THRES distribution methods
HOLD
_PX_ADAPTIVE_OF : percentage for PQ adaptive offloading of granules
FLOAD_PERCENTAG
E
_PX_ADAPTIVE_OF : threshold (GB/s) for PQ adaptive offloading of granules
FLOAD_THRESHOLD
_PX_ASYNC_GETGR : asynchronous get granule in the slave
ANULE
_PX_BACK_TO_PAR : allow going back to parallel after a serial operation
ALLEL
_PX_BIND_PEEK_S : enables sharing of px cursors that were built using
HARING bind peeking
_PX_BROADCAST_F : set the tq broadcasting fudge factor percentage
UDGE_FACTOR
_PX_BUFFER_TTL : ttl for px mesg buffers in seconds
_PX_CDB_VIEW_EN : parallel cdb view evaluation enabled
ABLED
_PX_CHUNKLIST_C : ratio of the number of chunk lists to the default DOP
OUNT_RATIO per instance
_PX_COMPILATION : debug level for parallel compilation
_DEBUG
_PX_COMPILATION : tracing level for parallel compilation
_TRACE
_PX_CONCURRENT : enables pq with concurrent execution of serial inputs
_PX_CPU_AUTODOP : enables or disables auto dop cpu computation
_ENABLED
_PX_CPU_OPERATO : CPU operator bandwidth in MB/sec for DOP computation
R_BANDWIDTH
_PX_CPU_PROCESS : CPU process bandwidth in MB/sec for DOP computation
_BANDWIDTH
_PX_DP_ARRAY_SI : Max number of pq processes supported
ZE
_PX_DUMP_12805_ : enables or disables tracing of 12805 signal source
SOURCE
_PX_DYNAMIC_OPT : turn off/on restartable qerpx dynamic optimization
_PX_DYNAMIC_SAM : num of samples for restartable qerpx dynamic
PLE_SIZE optimization
_PX_EXECUTION_S : enable service-based constraint of px slave allocation
ERVICES_ENABLED
_PX_FILTER_PARA : enables or disables correlated filter parallelization
LLELIZED
_PX_FILTER_SKEW : enable correlated filter parallelization to handle skew
_HANDLING
_PX_FREELIST_LA : Divide the computed number of freelists by this power
TCH_DIVISOR of 2
_PX_GIM_FACTOR : weighted autodop global index maintenance factor
_PX_GRANULE_BAT : maximum size of a batch of granules
CH_SIZE
_PX_GRANULE_RAN : enables or disables randomization of parallel scans
DOMIZE rowid granules
_PX_GRANULE_SIZ : default size of a rowid range granule (in KB)
E
_PX_GROUPBY_PUS : perform group-by pushdown for parallel query
HDOWN
_PX_HOLD_TIME : hold px at execution time (unit: second)
_PX_HYBRID_TSM_ : Enable Hybrid Temp Segment Merge/High Water Mark
HWMB_LOAD Brokered load method
_PX_INDEX_SAMPL : parallel query sampling for index create based on
ING_OBJSIZE object size
_PX_IO_PROCESS_ : IO process bandwidth in MB/sec for computing DOP
BANDWIDTH
_PX_IO_SYSTEM_B : total IO system bandwidth in MB/sec for computing DOP
ANDWIDTH
_PX_JOIN_SKEW_H : enables skew handling for parallel joins
ANDLING
_PX_JOIN_SKEW_M : sets minimum frequency(%) for skewed value for parallel
INFREQ joins
_PX_JOIN_SKEW_R : sets skew ratio for parallel joins
ATIO
_PX_KXIB_TRACIN : turn on kxib tracing
G
_PX_LOAD_BALANC : parallel load balancing policy
ING_POLICY
_PX_LOAD_FACTOR : weighted autodop load factor
_PX_LOAD_MONITO : threshold for pushing information to load slave
R_THRESHOLD workload monitor
_PX_LOAD_PUBLIS : interval at which LMON will check whether to publish PX
H_INTERVAL load
_PX_LOC_MSG_COS : CPU cost to send a PX message via shared memory
T
_PX_MAX_GRANULE : maximum number of rowid range granules to generate per
S_PER_SLAVE slave
_PX_MAX_MAP_VAL : Maximum value of rehash mapping for PX
_PX_MAX_MESSAGE : percentage of shared pool for px msg buffers range
_POOL_PCT [5,90]
_PX_MESSAGE_COM : enable compression of control messages for parallel
PRESSION query
_PX_MINUS_INTER : enables pq for minus/interect operators
SECT
_PX_MIN_GRANULE : minimum number of rowid range granules to generate per
S_PER_SLAVE slave
_PX_MONITOR_LOA : enable consumer load slave workload monitoring
D
_PX_NET_MSG_COS : CPU cost to send a PX message over the internconnect
T
_PX_NO_GRANULE_ : prevent parallel partition granules to be sorted on
SORT size
_PX_NO_STEALING : prevent parallel granule stealing in shared nothing
environment
_PX_NSS_PLANB : enables or disables NSS Plan B reparse with outline
_PX_NUMA_STEALI : enable/disable PQ granule stealing across NUMA nodes
NG_ENABLED
_PX_NUMA_SUPPOR : enable/disable PQ NUMA support
T_ENABLED
_PX_OBJECT_SAMP : parallel query sampling for base objects (100000 =
LING 100%)
_PX_OBJECT_SAMP : use base object sampling when possible for range
LING_ENABLED distribution
_PX_ONEPASS_SLA : enable/disable one pass slave acquisition for parallel
VE_ACQUISITION execution
_PX_PARALLELIZE : enables or disables expression evaluation
_EXPRESSION parallelization
_PX_PARTIAL_ROL : perform partial rollup pushdown for parallel execution
LUP_PUSHDOWN
_PX_PARTITION_S : enables or disables parallel partition-based scan
CAN_ENABLED
_PX_PARTITION_S : least number of partitions per slave to start
CAN_THRESHOLD partition-based scan
_PX_PROACTIVE_S : parallel proactive slave allocation threshold/unit
LAVE_ALLOC_THRE
SHOLD
_PX_PROC_CONSTR : reduce parallel_max_servers if greater than (processes
AIN – fudge)
_PX_PWG_ENABLED : parallel partition wise group by enabled
_PX_PWMR_ENABLE : parallel partition wise match recognize enabled
D
_PX_REPLICATION : enables or disables replication of small table scans
_ENABLED
_PX_ROUND_ROBIN : round robin row count to enq to next slave
_ROWCNT
_PX_ROWNUM_PD : turn off/on parallel rownum pushdown optimization
_PX_SEND_TIMEOU : IPC message send timeout value in seconds
T
_PX_SINGLE_SERV : allow single-slave dfo in parallel query
ER_ENABLED
_PX_SLAVES_SHAR : slaves share cursors with QC
E_CURSORS
_PX_TQ_ROWHVS : turn on intra-row hash valueing sharing in TQ
_PX_TRACE : px trace parameter
_PX_UAL_SERIAL_ : enables new pq for UNION operators
INPUT
_PX_USE_LARGE_P : Use Large Pool as source of PX buffers
OOL
_PX_WIF_DFO_DEC : NDV-aware DFO clumping of multiple window sorts
LUMPING
_PX_WIF_EXTEND_ : extend TQ data redistribution keys for window functions
DISTRIBUTION_KE
YS
_PX_WIF_MIN_NDV : mininum NDV of TQ keys needed per slave for scalable
_PER_SLAVE WiF PX
_PX_XTGRANULE_S : default size of a external table granule (in KB)
IZE
_QA_CONTROL : Oracle internal parameter to control QA
_QA_LRG_TYPE : Oracle internal parameter to specify QA lrg type
_QUERY_COST_REW : perform the cost based rewrite with materialized views
RITE
_QUERY_EXECUTIO : max size of query execution cache
N_CACHE_MAX_SIZ
E
_QUERY_MMVREWRI : query mmv rewrite maximum number of cmaps per dmap in
TE_MAXCMAPS query disjunct
_QUERY_MMVREWRI : query mmv rewrite maximum number of dmaps per query
TE_MAXDMAPS disjunct
_QUERY_MMVREWRI : query mmv rewrite maximum number of in-lists per
TE_MAXINLISTS disjunct
_QUERY_MMVREWRI : query mmv rewrite maximum number of intervals per
TE_MAXINTERVALS disjunct
_QUERY_MMVREWRI : query mmv rewrite maximum number of predicates per
TE_MAXPREDS disjunct
_QUERY_MMVREWRI : query mmv rewrite maximum number of query in-list
TE_MAXQRYINLIST values
VALS
_QUERY_MMVREWRI : query mmv rewrite maximum number of region permutations
TE_MAXREGPERM
_QUERY_ON_PHYSI : query on physical
CAL
_QUERY_REWRITE_ : perform query rewrite before after or only before view
1 merging
_QUERY_REWRITE_ : perform query rewrite before after or only after view
2 merging
_QUERY_REWRITE_ : mv rewrite and drop redundant joins
DRJ
_QUERY_REWRITE_ : rewrite with cannonical form for expressions
EXPRESSION
_QUERY_REWRITE_ : mv rewrite fresh partition containment
FPC
_QUERY_REWRITE_ : cost based query rewrite with MVs fudge factor
FUDGE
_QUERY_REWRITE_ : mv rewrite with jg migration
JGMIGRATE
_QUERY_REWRITE_ : query rewrite max disjuncts
MAXDISJUNCT
_QUERY_REWRITE_ : allow query rewrite, if referenced tables are not
OR_ERROR dataless
_QUERY_REWRITE_ : perform general rewrite using set operator summaries
SETOPGRW_ENABLE
_QUERY_REWRITE_ : prune frocol chain before rewrite after view-merging
VOP_CLEANUP
_QUEUE_BUFFER_M : max number of bytes to dump to trace file for queue
AX_DUMP_LEN buffer dump
_RADM_ENABLED : Data Redaction
_RBR_CKPT_TRACI : Enable reuse block range checkpoint tracing
NG
_RCFG_DISABLE_V : if TRUE disables verify at reconfiguration
ERIFY
_RCFG_PARALLEL_ : if TRUE enables parallel fixwrite at reconfiguration
FIXWRITE
_RCFG_PARALLEL_ : if TRUE enables parallel replay and cleanup at
REPLAY reconfiguration
_RCFG_PARALLEL_ : if TRUE enables parallel verify at reconfiguration
VERIFY
_RDBMS_COMPATIB : default RDBMS compatibility level
ILITY
_RDBMS_INTERNAL : enable CELL FPLIB filtering within rdbms
_FPLIB_ENABLED
_RDBMS_INTERNAL : enable reraising of any exceptions in CELL FPLIB
_FPLIB_RAISE_ER
RORS
_READABLE_STAND : readable standby query scn sync timeout
BY_SYNC_TIMEOUT
_READ_MOSTLY_EN : Read mostly instances enable non-privileged logons
ABLE_LOGON
_READ_MOSTLY_IN : indicates this is a read_mostly instance
STANCE
_READ_MOSTLY_IN : internal parameter to control read mostly instance QA
STANCE_QA_CONTR
OL
_READ_MOSTLY_SL : Time to wait on read mostly node when hub not available
AVE_TIMEOUT
_READ_ONLY_VIOL : read-only violation dump to trace files
ATION_DUMP_TO_T
RACE
_READ_ONLY_VIOL : read-only violation array max count
ATION_MAX_COUNT
_READ_ONLY_VIOL : read-only violation array per module max count
ATION_MAX_COUNT
_PER_MODULE
_REALFREE_HEAP_ : minimum max total heap size, in Kbytes
MAX_SIZE
_REALFREE_HEAP_ : mode flags for real-free heap
MODE
_REALFREE_HEAP_ : hint for real-free page size in bytes
PAGESIZE
_REALFREE_PQ_HE : hint for pq real-free page size in bytes
AP_PAGESIZE
_REAL_TIME_APPL : Simulation value with real time apply
Y_SIM
_RECOVERABLE_RE : Recoverable recovery batch size (percentage of buffer
COVERY_BATCH_PE cache)
RCENT
_RECOVERY_ASSER : if TRUE, enable expensive integrity checks
TS
_RECOVERY_PERCE : recovery buffer cache percentage
NTAGE
_RECOVERY_READ_ : number of recovery reads which can be outstanding
LIMIT
_RECOVERY_SKIP_ : allow media recovery even if controlfile seq check
CFSEQ_CHECK fails
_RECOVERY_VERIF : enable thread recovery write verify
Y_WRITES
_RECURSIVE_IMU_ : recursive transactions may be IMU
TRANSACTIONS
_RECURSIVE_WITH : check for maximum level of recursion instead of
_MAX_RECURSION_ checking for cycles
LEVEL
_REDEF_ON_STATE : Use on-statement refresh in online redefinition
MENT
_REDO_COMPATIBI : general and redo/undo compatibility sanity check
LITY_CHECK
_REDO_LOG_DEBUG : Various configuration flags for debugging redo logs
_CONFIG
_REDO_LOG_RECOR : Life time in hours for redo log table records
D_LIFE
_REDO_READ_FROM : Enable reading redo from in-memory log buffer
_MEMORY
_REDO_TRANSPORT : Is ASYNC LNS compression allowed?
_COMPRESS_ALL
_REDO_TRANSPORT : redo transport sanity check bit mask
_SANITY_CHECK
_REDO_TRANSPORT : I/O stall time before terminating redo transport
_STALL_TIME process
_REDO_TRANSPORT : long I/O stall time before terminating redo transport
_STALL_TIME_LON process
G
_REDO_TRANSPORT : test stream connection?
_STREAM_TEST
_REDO_TRANSPORT : Stream network writes?
_STREAM_WRITES
_REDO_TRANSPORT : VIO size requirement
_VIO_SIZE_REQ
_REDUCE_SBY_LOG : enable standby log scan optimization
_SCAN
_REGION_NAME : gsm region name
_RELEASE_INSERT : maximum number of unusable blocks to unlink from
_THRESHOLD freelist
_RELIABLE_BLOCK : if TRUE, no side channel on reliable interconnect
_SENDS
_RELOCATE_PDB : Relocate PDB to another RAC instance after it is closed
in the current instance
_RELOCATION_COM : ASM relocation commit batch size
MIT_BATCH_SIZE
_REMOTE_ASM : remote ASM configuration
_REMOTE_AWR_ENA : Enable/disable Remote AWR Mode
BLED
_REMOVE_AGGR_SU : enables removal of subsumed aggregated subquery
BQUERY
_REMOVE_EXF_COM : enable/disable removing of components EXF and RUL
PONENT during upgrade
_REPLACE_VIRTUA : replace expressions with virtual columns
L_COLUMNS
_REPORT_CAPTURE : Time (in sec) between two cycles of report capture
_CYCLE_TIME daemon
_REPORT_CAPTURE : 100X Percent of system db time daemon is allowed over
_DBTIME_PERCENT 10 cycles
_CUTOFF
_REPORT_CAPTURE : No of report capture cycles after which db time is
_RECHARGE_WINDO recharged
W
_REPORT_CAPTURE : Length of time band (in hours) in the reports time
_TIMEBAND_LENGT bands table
H
_REPORT_REQUEST : Time (in min) after which a report request is deleted
_AGEOUT_MINUTES from queue
_REP_BASE_PATH : base path for EM reports in database
_RESET_MAXCAP_H : reset maxcap history time
ISTORY
_RESOURCE_INCLU : Whether RESOURCE role includes UNLIMITED TABLESPACE
DES_UNLIMITED_T privilege
ABLESPACE
_RESOURCE_MANAG : disable the resource manager always
ER_ALWAYS_OFF
_RESOURCE_MANAG : resource mgr top plan for internal use
ER_PLAN
_RESTORE_MAXOPE : restore assumption for maxopenfiles
NFILES
_RESTORE_SPFILE : restore spfile to this location
_RESULT_CACHE_A : result cache auto dml monitoring duration
UTO_DML_MONITOR
ING_DURATION
_RESULT_CACHE_A : result cache auto dml monitoring slot
UTO_DML_MONITOR
ING_SLOTS
_RESULT_CACHE_A : result cache auto dml threshold
UTO_DML_THRESHO
LD
_RESULT_CACHE_A : result cache auto dml trend threshold
UTO_DML_TREND_T
HRESHOLD
_RESULT_CACHE_A : result cache auto execution threshold
UTO_EXECUTION_T
HRESHOLD
_RESULT_CACHE_A : result cache auto max size allowed
UTO_SIZE_THRESH
OLD
_RESULT_CACHE_A : result cache auto time distance
UTO_TIME_DISTAN
CE
_RESULT_CACHE_A : result cache auto time threshold
UTO_TIME_THRESH
OLD
_RESULT_CACHE_B : result cache block size
LOCK_SIZE
_RESULT_CACHE_C : blocks to copy instead of pinning the result
OPY_BLOCK_COUNT
_RESULT_CACHE_D : result cache deterministic PLSQL functions
ETERMINISTIC_PL
SQL
_RESULT_CACHE_G : Are results available globally across RAC?
LOBAL
_RESULT_CACHE_T : maximum time (sec) a session waits for a result
IMEOUT
_RESUMABLE_CRIT : raise critical alert for resumable failure
ICAL_ALERT
_REUSE_INDEX_LO : number of blocks being examine for index block reuse
OP
_RE_FAST_SQL_OP : enables fast boxable sql operator
ERATOR
_RE_INDEPENDENT : defines max number of compiled cached expressions for
_EXPRESSION_CAC iee
HE_SIZE
_RE_NUM_COMPLEX : defines max number of compiled complex operator per
_OPERATOR ruleset-iee
_RE_NUM_ROWCACH : defines max number of complex operators loaded with row
E_LOAD cache
_RE_RESULT_CACH : defines max number key for result cache hash table
E_KEYSIZ
_RE_RESULT_CACH : defines max number of cached elements for result cache
E_SIZE
_RIGHT_OUTER_HA : Right Outer/Semi/Anti Hash Enabled
SH_ENABLE
_RMAN_IO_PRIORI : priority at which rman backup i/o’s are done
TY
_RMAN_ROUNDROBI : Numa round robin placement for RMAN procs
N_PLACEMENT
_RM_CLUSTER_INT : interconnects for RAC use (RM)
ERCONNECTS
_RM_NUMA_SCHED_ : Is Resource Manager (RM) related NUMA scheduled policy
ENABLE enabled
_RM_NUMA_SIMULA : number of cpus for each pg for numa simulation in
TION_CPUS resource manager
_RM_NUMA_SIMULA : number of PGs for numa simulation in resource manager
TION_PGS
_ROLLBACK_SEGME : number of undo segments
NT_COUNT
_ROLLBACK_SEGME : starting undo segment number
NT_INITIAL
_ROLLBACK_STOPA : stop at -position to step rollback
T
_ROND_TEST_MODE : rac one node test mode
_ROWLEN_FOR_CHA : maximum rowlen above which rows may be chained across
INING_THRESHOLD blocks
_ROWSETS_CDB_VI : rowsets enabled for CDB views
EW_ENABLED
_ROWSETS_ENABLE : enable/disable rowsets
D
_ROWSETS_MAX_RO : maximum number of rows in a rowset
WS
_ROWSETS_TARGET : target size in bytes for space reserved in the frame
_MAXSIZE for a rowset
_ROWSOURCE_EXEC : if TRUE, Oracle will collect rowsource statistics
UTION_STATISTIC
S
_ROWSOURCE_PROF : if TRUE, Oracle will capture active row sources in
ILING_STATISTIC v$active_session_history
S
_ROWSOURCE_STAT : frequency of rowsource statistic sampling (must be a
ISTICS_SAMPFREQ power of 2)
_ROWSRC_TRACE_L : Row source tree tracing level
EVEL
_ROW_CACHE_CURS : number of cached cursors for row cache management
ORS
_ROW_CR : enable row cr for all sql
_ROW_LOCKING : row-locking
_ROW_SHIPPING_E : enable row shipping explain plan support
XPLAIN
_ROW_SHIPPING_T : row shipping column selection threshold
HRESHOLD
_RTADDM_TRIGGER : comma-separated list of numeric arguments for RT addm
_ARGS trigger
_RTADDM_TRIGGER : To enable or disable Real-Time ADDM automatic trigger
_ENABLED
_RTA_SYNC_WAIT_ : RTA sync wait timeout
TIMEOUT
_RTC_INFEASIBLE : Redo Transport Compression infeasible threshold
_THRESHOLD
_SAMPLE_ROWS_PE : number of rows per block used for sampling IO
R_BLOCK optimization
_SCALAR_TYPE_LO : threshold for VARCHAR2, NVARCHAR2, and RAW storage as
B_STORAGE_THRES BLOB
HOLD
_SCATTER_GCS_RE : if TRUE, gcs resources are scattered uniformly across
SOURCES sub pools
_SCATTER_GCS_SH : if TRUE, gcs shadows are scattered uniformly across sub
ADOWS pools
_SCHED_DELAY_MA : scheduling delay maximum number of samples
X_SAMPLES
_SCHED_DELAY_ME : scheduling delay mesurement sleep us
ASUREMENT_SLEEP
_US
_SCHED_DELAY_OS : os tick granularity used by scheduling delay
_TICK_GRANULARI calculations
TY_US
_SCHED_DELAY_SA : scheduling delay sample collection duration threshold
MPLE_COLLECTION ms
_THRESH_MS
_SCHED_DELAY_SA : scheduling delay sampling interval in ms
MPLE_INTERVAL_M
S
_SCN_WAIT_INTER : max exponential backoff time for scn wait interface in
FACE_MAX_BACKOF kta
F_TIME_SECS
_SCN_WAIT_INTER : max timeout for scn wait interface in kta
FACE_MAX_TIMEOU
T_SECS
_SDIAG_CRASH : sql diag crash
_SECOND_SPARE_P : second spare parameter – integer
ARAMETER
_SECUREFILES_BR : segment retry before dishonoring retention
EAKRETEN_RETRY
_SECUREFILES_BU : securefiles segment insert only optization
LKINSERT
_SECUREFILES_CO : securefiles concurrency estimate
NCURRENCY_ESTIM
ATE
_SECUREFILES_FG : segment retry before foreground waits
_RETRY
_SECUREFILES_FO : securefiles force flush before allocation
RCEFLUSH
_SECUREFILES_ME : securefiles memory as percent of SGA
MORY_PERCENTOFS
GA
_SECUREFILES_SP : securefiles segment utl optimization
CUTL
_SECUREFILE_LOG : Maximum number of open descriptors for securefile log
_NUM_LATCHES
_SECUREFILE_LOG : Size of securefile log buffer pool from SGA
_SHARED_POOL_SI
ZE
_SECUREFILE_TIM : collect kdlu timers and accumulate per layers
ERS
_SEC_ENABLE_TES : Whether to enable the test RPCs
T_RPCS
_SELECTIVITY_FO : enable/disable selectivity for storage reduction factor
R_SRF_ENABLED
_SELECT_ANY_DIC : Exclude USER$, XS$VERIFIERS, ENC$ and DEFAULT_PWD$ from
TIONARY_SECURIT SELECT ANY DICTIONARY system privilege
Y_ENABLED
_SELFJOIN_MV_DU : control rewrite self-join algorithm
PLICATES
_SELFTUNE_CHECK : Self-tune checkpointing lag the tail of the redo log
POINTING_LAG
_SELFTUNE_CHECK : Percentage of total physical i/os for self-tune ckpt
POINT_WRITE_PCT
_SEM_PER_SEMID : the exact number of semaphores per semaphore set to
allocate
_SEND_AST_TO_FO : if TRUE, send ast message to foreground
REGROUND
_SEND_CLOSE_WIT : if TRUE, send close with block even with direct sends
H_BLOCK
_SEND_REQUESTS_ : if TRUE, try to send CR requests to PI buffers
TO_PI
_SERIALIZABLE : serializable
_SERIALIZE_LGWR : Serialize LGWR SYNC local and remote io
_SYNC_IO
_SERIAL_DIRECT_ : enable direct read in serial
READ
_SERIAL_LOG_WRI : Serialize log write slave I/O
TE_WORKER_IO
_SERIAL_RECOVER : force serial recovery or parallel recovery
Y
_SERVICE_CLEANU : timeout to peform service cleanup
P_TIMEOUT
_SESSION_ALLOCA : one latch per group of sessions
TION_LATCHES
_SESSION_CACHED : Number of pl/sql instantiations to cache in a session.
_INSTANTIATIONS
_SESSION_CONTEX : session app context size
T_SIZE
_SESSION_IDLE_B : one latch per session or a latch per group of sessions
IT_LATCHES
_SESSION_PAGE_E : Session Page Extent Size
XTENT
_SESSION_WAIT_H : enable session wait history collection
ISTORY
_SET_CONTAINER_ : set container service
SERVICE
_SET_MGD_RECOVE : set mgd recovery state to new value
RY_STATE
_SEVENTEENTH_SP : seventeenth spare parameter – string
ARE_PARAMETER
_SEVENTH_SPARE_ : seventh spare parameter – integer
PARAMETER
_SF_DEFAULT_ENA : enable 12g securefile default
BLED
_SGA_ALLOC_SLAV : Termination timeout in secs for SA** slaves
ES_TERM_TIMEOUT
_SECS
_SGA_CLEAR_DUMP : Allow dumping encrypted blocks in clear for debugging
_SGA_EARLY_TRAC : sga early trace event
E
_SGA_LOCKING : sga granule locking state
_SHARED_IOP_MAX : maximum shared io pool size
_SIZE
_SHARED_IO_POOL : Shared IO pool buffer size
_BUF_SIZE
_SHARED_IO_POOL : trace kcbi debug info to tracefile
_DEBUG_TRC
_SHARED_IO_POOL : Size of shared IO pool
_SIZE
_SHARED_IO_SET_ : shared io pool size set internal value – overwrite zero
VALUE user size
_SHARED_POOL_MA : shared pool maximum size when auto SGA enabled
X_SIZE
_SHARED_POOL_MI : shared pool minimum size when auto SGA enabled
NSIZE_ON
_SHARED_POOL_RE : minimum allocation size in bytes for reserved area of
SERVED_MIN_ALLO shared pool
C
_SHARED_POOL_RE : percentage memory of the shared pool allocated for the
SERVED_PCT reserved area
_SHARED_SERVER_ : shared server load balance
LOAD_BALANCE
_SHARED_SERVER_ : number of shared server common queues
NUM_QUEUES
_SHMPROTECT : allow mprotect use for shared memory
_SHORT_STACK_TI : short stack timeout in ms
MEOUT_MS
_SHOW_MGD_RECOV : Show internal managed recovery state
ERY_STATE
_SHRD_QUE_TM_PR : number of sharded queue Time Managers to start
OCESSES
_SHRD_QUE_TM_ST : Shaded queue statistics collection window duration
ATISTICS_DURATI
ON
_SHRUNK_AGGS_DI : percentage of exceptions at which to switch to full
SABLE_THRESHOLD length aggs
_SHRUNK_AGGS_EN : enable use of variable sized buffers for non-distinct
ABLED aggregates
_SHUTDOWN_COMPL : minutes for shutdown operation to wait for sessions to
ETION_TIMEOUT_M complete
INS
_SIDE_CHANNEL_B : number of messages to batch in a side channel message
ATCH_SIZE (DFS)
_SIDE_CHANNEL_B : timeout before shipping out the batched side
ATCH_TIMEOUT channelmessages in seconds
_SIDE_CHANNEL_B : timeout before shipping out the batched side
ATCH_TIMEOUT_MS channelmessages in milliseconds
_SIMPLE_VIEW_ME : control simple view merging performed by the optimizer
RGING
_SIMULATED_LOG_ : Simulated latency of log writes (usecs)
WRITE_USECS
_SIMULATE_DISK_ : Enables skgfr to report simulated disk sector size
SECTORSIZE
_SIMULATE_IO_WA : Simulate I/O wait to test segment advisor
IT
_SIMULATE_MEM_T : simulate auto memory sga/pga transfers
RANSFER
_SIMULATOR_BUCK : LRU bucket minimum delta
ET_MINDELTA
_SIMULATOR_INTE : simulator internal bound percent
RNAL_BOUND
_SIMULATOR_LRU_ : LRU list rebalance threshold (size)
REBALANCE_SIZTH
R
_SIMULATOR_LRU_ : LRU list rebalance threshold (count)
REBALANCE_THRES
H
_SIMULATOR_LRU_ : LRU scan count
SCAN_COUNT
_SIMULATOR_PIN_ : maximum count of invalid chunks on pin list
INVAL_MAXCNT
_SIMULATOR_RESE : simulator reserved heap count
RVED_HEAP_COUNT
_SIMULATOR_RESE : simulator reserved object count
RVED_OBJ_COUNT
_SIMULATOR_SAMP : sampling factor for the simulator
LING_FACTOR
_SIMULATOR_UPPE : upper bound multiple of pool size
R_BOUND_MULTIPL
E
_SINGLE_PROCESS : run without detached processes
_SIOP_FLASHBACK : Shared IO pool flashback io completion scan depth
_SCANDEPTH
_SIOP_PERC_OF_B : percentange * 100 of cache to transfer to shared io
C_X100 pool
_SIXTEENTH_SPAR : sixteenth spare parameter – string
E_PARAMETER
_SIXTH_SPARE_PA : sixth spare parameter – integer
RAMETER
_SKGXPG_LAST_PA : last defined skgxpg parameter – oss
RAMETER
_SKGXP_ANT_OPTI : SKGXP ANT options (oss)
ONS
_SKGXP_CTX_FLAG : IPC debug options flags (oss)
S1
_SKGXP_CTX_FLAG : IPC debug options flags mask (oss)
S1MASK
_SKGXP_DYNAMIC_ : IPC protocol override
PROTOCOL (!0/-1=*,2=UDP,3=RDS,0x1000=ipc_X)
_SKGXP_GEN_ANT_ : VRPC request timeout when ANT disabled
OFF_RPC_TIMEOUT
_IN_SEC
_SKGXP_GEN_ANT_ : ANT protocol ping miss count
PING_MISSCOUNT
_SKGXP_GEN_RPC_ : ANT ping protocol miss count
NO_PATH_CHECK_I
N_SEC
_SKGXP_GEN_RPC_ : VRPC request timeout when ANT enabled
TIMEOUT_IN_SEC
_SKGXP_INETS : limit SKGXP networks (oss)
_SKGXP_MIN_RPC_ : IPC threshold for rpc rcv zcpy operation (default = 0 –
RCV_ZCPY_LEN disabled)
_SKGXP_MIN_ZCPY : IPC threshold for zcpy operation (default = 0 –
_LEN disabled)
_SKGXP_REAPING : tune skgxp OSD reaping limit
_SKGXP_RGN_PORT : region socket limits (0xFFFFNNXX): F=flags, N=min,
S X=max
_SKGXP_SPARE_PA : ipc oss spare parameter 1
RAM1
_SKGXP_SPARE_PA : ipc oss spare parameter 2
RAM2
_SKGXP_SPARE_PA : ipc oss spare parameter 3
RAM3
_SKGXP_SPARE_PA : ipc oss spare parameter 4
RAM4
_SKGXP_SPARE_PA : ipc oss spare parameter 5
RAM5
_SKGXP_UDP_ACH_ : time in minutes before idle ach’s are reaped
REAPING_TIME
_SKGXP_UDP_ACK_ : Enables delayed acks
DELAY
_SKGXP_UDP_ENAB : Enables dynamic credit management
LE_DYNAMIC_CRED
IT_MGMT
_SKGXP_UDP_HIWA : ach hiwat mark warning interval
T_WARN
_SKGXP_UDP_INTE : time in seconds between interface detection checks
RFACE_DETECTION
_TIME_SECS
_SKGXP_UDP_KEEP : connection idle time in seconds before keep alive is
_ALIVE_PING_TIM initiated. min: 30 sec max: 1800 sec default: 300 sec
ER_SECS
_SKGXP_UDP_LMP_ : MTU size for UDP LMP testing
MTUSIZE
_SKGXP_UDP_LMP_ : enable UDP long message protection
ON
_SKGXP_UDP_TIME : diagnostic log buffering space (in bytes) for timed
D_WAIT_BUFFERIN wait (0 means unbufferd
G
_SKGXP_UDP_TIME : time in seconds before timed wait is invoked
D_WAIT_SECONDS
_SKGXP_UDP_USE_ : disable use of high speek timer
TCB
_SKGXP_ZCPY_FLA : IPC zcpy options flags
GS
_SKIP_ACFS_CHEC : Override checking if on an ACFS file system
KS
_SKIP_ASSUME_MS : if TRUE, skip assume message for consigns at the master
G
_SKIP_TRSTAMP_C : Skip terminal recovery stamp check
HECK
_SLAVE_MAPPING_ : enable slave mapping when TRUE
ENABLED
_SLAVE_MAPPING_ : force the number of slave group in a slave mapper
GROUP_SIZE
_SLAVE_MAPPING_ : maximum skew before slave mapping is disabled
SKEW_RATIO
_SMALL_TABLE_TH : lower threshold level of table size for direct reads
RESHOLD
_SMM_ADVICE_ENA : if TRUE, enable v$pga_advice
BLED
_SMM_ADVICE_LOG : overwrites default size of the PGA advice workarea
_SIZE history log
_SMM_AUTO_COST_ : if TRUE, use the AUTO size policy cost functions
ENABLED
_SMM_AUTO_MAX_I : Maximum IO size (in KB) used by sort/hash-join in auto
O_SIZE mode
_SMM_AUTO_MIN_I : Minimum IO size (in KB) used by sort/hash-join in auto
O_SIZE mode
_SMM_BOUND : overwrites memory manager automatically computed bound
_SMM_CONTROL : provides controls on the memory manager
_SMM_FREEABLE_R : value in KB of the instance freeable PGA memory to
ETAIN retain
_SMM_ISORT_CAP : maximum work area for insertion sort(v1)
_SMM_MAX_SIZE : maximum work area size in auto mode (serial)
_SMM_MAX_SIZE_S : static maximum work area size in auto mode (serial)
TATIC
_SMM_MIN_SIZE : minimum work area size in auto mode
_SMM_PX_MAX_SIZ : maximum work area size in auto mode (global)
E
_SMM_PX_MAX_SIZ : static maximum work area size in auto mode (global)
E_STATIC
_SMM_RETAIN_SIZ : work area retain size in SGA for shared server sessions
E (0 for AUTO)
_SMM_TRACE : Turn on/off tracing for SQL memory manager
_SMON_INTERNAL_ : limit of SMON internal errors
ERRLIMIT
_SMON_UNDO_SEG_ : limit of SMON continous undo segments re-scan
RESCAN_LIMIT
_SMU_DEBUG_MODE : debug-flag – set debug event for testing SMU
operations
_SMU_ERROR_SIMU : site ID of error simulation in KTU code
LATION_SITE
_SMU_ERROR_SIMU : error type for error simulation in KTU code
LATION_TYPE
_SMU_TIMEOUTS : comma-separated *AND double-quoted* list of AUM
timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl
_SNAPSHOT_RECOV : enable/disable snapshot recovery
ERY_ENABLED
_SORT_ELIMINATI : cost ratio for sort eimination under first_rows mode
ON_COST_RATIO
_SORT_MULTIBLOC : multi-block read count for sort
K_READ_COUNT
_SORT_SPILL_THR : force sort to spill to disk each time this many rows
ESHOLD are received
_SORT_SYNC_MIN_ : controls the size of mininum run size for synchronized
SPILLSIZE spill (in kb)
_SORT_SYNC_MIN_ : controls the mininum spill size for synchronized spill
SPILL_THRESHOLD (in percent)
_SPACE_ALIGN_SI : space align size
ZE
_SPARE_TEST_PAR : Spare test parameter
AMETER
_SPAWN_DIAG_OPT : thread spawn diagnostic options
S
_SPAWN_DIAG_THR : thread spawn diagnostic minimal threshold in seconds
ESH_SECS
_SPIN_COUNT : Amount to spin waiting for a latch
_SPR_MAX_RULES : maximum number of rules in sql spreadsheet
_SPR_PUSH_PRED_ : push predicates through reference spreadsheet
REFSPR
_SPR_USE_AW_AS : enable AW for hash table in spreadsheet
_SPR_USE_HASH_T : use hash table for spreadsheet
ABLE
_SQLEXEC_PROGRE : sql execution progression monitoring cost threshold
SSION_COST
_SQLMON_BINDS_X : format of column binds_xml in [G]V$SQL_MONITOR
ML_FORMAT
_SQLMON_MAX_PLA : Maximum number of plans entry that can be monitored.
N Defaults to 20 per CPU
_SQLMON_MAX_PLA : Number of plan lines beyond which a plan cannot be
NLINES monitored
_SQLMON_RECYCLE : Minimum time (in s) to wait before a plan entry can be
_TIME recycled
_SQLMON_THRESHO : CPU/IO time threshold before a statement is monitored.
LD 0 is disabled
_SQLTUNE_CATEGO : Parsed category qualifier for applying hintsets
RY_PARSED
_SQL_ANALYZE_EN : SQL Analyze Autonomous Transaction control parameter
ABLE_AUTO_TXN
_SQL_ANALYZE_PA : SQL Analyze Parse Model control parameter
RSE_MODEL
_SQL_COMPATIBIL : sql compatability bit vector
ITY
_SQL_CONNECT_CA : SQL Connect Capability Table Override
PABILITY_OVERRI
DE
_SQL_CONNECT_CA : SQL Connect Capability Table (testing only)
PABILITY_TABLE
_SQL_DIAG_REPO_ : duarations where sql diag repository are retained
ORIGIN
_SQL_DIAG_REPO_ : retain sql diag repository to cursor or not
RETAIN
_SQL_HASH_DEBUG : Hash value of the SQL statement to debug
_SQL_HVSHARE_DE : control hash value sharing debug level
BUG
_SQL_HVSHARE_TH : threshold to control hash value sharing across
RESHOLD operators
_SQL_MODEL_UNFO : specifies compile-time unfolding of sql model forloops
LD_FORLOOPS
_SQL_NCG_MODE : Optimization mode for SQL NCG
_SQL_PLAN_DIREC : controls internal SQL Plan Directive management
TIVE_MGMT_CONTR activities
OL
_SQL_PLAN_MANAG : controls various internal SQL Plan Management
EMENT_CONTROL algorithms
_SQL_SHOW_EXPRE : show expression evalution as shared hash producer in
VAL plan
_SRVNTFN_JOBSUB : srvntfn job submit interval
MIT_INTERVAL
_SRVNTFN_JOB_DE : srvntfn job deq timeout
Q_TIMEOUT
_SRVNTFN_MAX_CO : srvntfn max concurrent jobs
NCURRENT_JOBS
_SRVNTFN_Q_MSGC : srvntfn q msg count for job exit
OUNT
_SRVNTFN_Q_MSGC : srvntfn q msg count increase for job submit
OUNT_INC
_SSCR_DIR : Session State Capture and Restore DIRectory object
_SSCR_OSDIR : Session State Capture and Restore OS DIRectory
_STACK_GUARD_LE : stack guard level
VEL
_STANDBY_CAUSAL : readable standby causal heartbeat timeout
_HEARTBEAT_TIME
OUT
_STANDBY_FLUSH_ : standby flush mode
MODE
_STANDBY_IMPLIC : minutes to wait for redo during standby implicit
IT_RCV_TIMEOUT recovery
_STANDBY_SWITCH : Number of secords for standby switchover enqueue
OVER_TIMEOUT timeout
_STATIC_BACKGRO : static backgrounds
UNDS
_STATISTICS_BAS : enable/disable the use of statistics for storage
ED_SRF_ENABLED reduction factor
_STAT_AGGS_ONE_ : enable one pass algorithm for variance-related
PASS_ALGORITHM functions
_STA_CONTROL : SQL Tuning Advisory control parameter
_STEP_DOWN_LIMI : step down limit in percentage
T_IN_PCT
_STREAMS_POOL_M : streams pool maximum size when auto SGA enabled
AX_SIZE
_SUBQUERY_PRUNI : subquery pruning cost factor
NG_COST_FACTOR
_SUBQUERY_PRUNI : enable the use of subquery predicates to perform
NG_ENABLED pruning
_SUBQUERY_PRUNI : enable the use of subquery predicates with MVs to
NG_MV_ENABLED perform pruning
_SUBQUERY_PRUNI : subquery pruning reduction factor
NG_REDUCTION
_SUPPRESS_IDENT : supress owner index name err msg
IFIERS_ON_DUPKE
Y
_SWITCHOVER_TIM : Switchover timeout in minutes
EOUT
_SWITCHOVER_TO_ : option for graceful switchover to standby
STANDBY_OPTION
_SWITCHOVER_TO_ : Switchover to standby switches log for open redo
STANDBY_SWITCH_ threads
LOG
_SWITCH_CURRENT : switch current uses scan scn
_SCAN_SCN
_SWRF_METRIC_FR : Enable/disable SWRF Metric Frequent Mode Collection
EQUENT_MODE
_SWRF_MMON_DBFU : Enable/disable SWRF MMON DB Feature Usage
S
_SWRF_MMON_FLUS : Enable/disable SWRF MMON FLushing
H
_SWRF_MMON_METR : Enable/disable SWRF MMON Metrics Collection
ICS
_SWRF_ON_DISK_E : Parameter to enable/disable SWRF
NABLED
_SWRF_TEST_ACTI : test action parameter for SWRF
ON
_SWRF_TEST_DBFU : Enable/disable DB Feature Usage Testing
S
_SYNC_PRIMARY_W : wait time for alter session sync with primary
AIT_TIME
_SYNONYM_REPOIN : whether to trace metadata comparisons for synonym
T_TRACING repointing
_SYSAUX_TEST_PA : test parameter for SYSAUX
RAM
_SYSTEM_API_INT : enable debug tracing for system api interception
ERCEPTION_DEBUG
_SYSTEM_INDEX_C : optimizer percent system index caching
ACHING
_SYSTEM_TRIG_EN : are system triggers enabled
ABLED
_SYS_LOGON_DELA : failed logon delay for sys
Y
_TABLESPACES_PE : estimated number of tablespaces manipulated by each
R_TRANSACTION transaction
_TABLE_LOOKUP_P : table lookup prefetch vector size
REFETCH_SIZE
_TABLE_LOOKUP_P : table lookup prefetch threshold
REFETCH_THRESH
_TABLE_SCAN_COS : bump estimated full table scan and index ffs cost by
T_PLUS_ONE one
_TARGET_LOG_WRI : Do log write if this many redo blocks in buffer
TE_SIZE (auto=0)
_TARGET_LOG_WRI : How long LGWR will wait for redo to accumulate (csecs)
TE_SIZE_TIMEOUT
_TARGET_RBA_MAX : target rba max log lag percentage
_LAG_PERCENTAGE
_TA_LNS_WAIT_FO : LNS Wait time for arhcived version of online log
R_ARCH_LOG
_TDB_DEBUG_MODE : set debug mode for testing transportable database
_TEMP_TRAN_BLOC : number of blocks for a dimension before we temp
K_THRESHOLD transform
_TEMP_TRAN_CACH : determines if temp table is created with cache option
E
_TEMP_UNDO_DISA : is temp undo disabled on ADG
BLE_ADG
_TENTH_SPARE_PA : tenth spare parameter – integer
RAMETER
_TEST_HM_EXTENT : heatmap related – to be used by oracle dev only
_MAP
_TEST_KSUSIGSKI : test the function ksusigskip
P
_TEST_PARAM_1 : test parmeter 1 – integer
_TEST_PARAM_2 : test parameter 2 – string
_TEST_PARAM_3 : test parameter 3 – string
_TEST_PARAM_4 : test parameter 4 – string list
_TEST_PARAM_5 : test parmeter 5 – deprecated integer
_TEST_PARAM_6 : test parmeter 6 – size (ub8)
_TEST_PARAM_7 : test parameter 7 – big integer list
_TEST_PARAM_8 : test parameter 8 – cdb tests
_THIRD_SPARE_PA : third spare parameter – integer
RAMETER
_THIRTEENTH_SPA : thirteenth spare parameter – integer
RE_PARAMETER
_THREAD_STATE_C : Thread state change timeout for PnP instance (in sec)
HANGE_TIMEOUT_P
NP
_THRESHOLD_ALER : if 1, issue threshold-based alerts
TS_ENABLE
_TIMEMODEL_COLL : enable timemodel collection
ECTION
_TIMEOUT_ACTION : enables or disables KSU timeout actions
S_ENABLED
_TIMER_PRECISIO : VKTM timer precision in milli-sec
N
_TIME_BASED_RCV : time-based incremental recovery checkpoint target in
_CKPT_TARGET sec
_TIME_BASED_RCV : time-based incremental recovery file header update
_HDR_UPDATE_INT interval in sec
ERVAL
_TOTAL_LARGE_EX : Total memory for allocating large extents
TENT_MEMORY
_TQ_DUMP_PERIOD : time period for duping of TQ statistics (s)
_TRACE_BUFFERS : trace buffer sizes per process
_TRACE_BUFFER_W : trace buffer busy wait timeouts
AIT_TIMEOUTS
_TRACE_DUMP_ALL : if TRUE on error buckets of all processes will be
_PROCS dumped to the current trace file
_TRACE_DUMP_CLI : if TRUE dump client (ie. non-kst) buckets
ENT_BUCKETS
_TRACE_DUMP_CUR : if TRUE on error just dump our process bucket
_PROC_ONLY
_TRACE_DUMP_STA : if TRUE filter trace dumps to always loaded dlls
TIC_ONLY
_TRACE_EVENTS : trace events enabled at startup
_TRACE_FILES_PU : Create publicly accessible trace files
BLIC
_TRACE_KQLIDP : trace kqlidp0 operation
_TRACE_KTFS : Trace ILM Stats Tracking
_TRACE_KTFS_MEM : Debug memleak
_TRACE_NAVIGATI : enabling trace navigation linking
ON_SCOPE
_TRACE_PIN_TIME : trace how long a current pin is held
_TRACE_POOL_SIZ : trace pool size in bytes
E
_TRACE_PROCESSE : enable KST tracing in process
S
_TRACE_TEMP : Trace Tempspace Management
_TRACE_VIRTUAL_ : trace virtual columns exprs
COLUMNS
_TRACK_METRICS_ : Enable/disable Metrics Memory Tracking
MEMORY
_TRANSACTION_AU : transaction auditing records generated in the redo log
DITING
_TRANSACTION_RE : max number of parallel recovery slaves that may be used
COVERY_SERVERS
_TRANSIENT_LOGI : clear KCCDI2HMRP flag during standby recovery
CAL_CLEAR_HOLD_
MRP_BIT
_TRUNCATE_OPTIM : do truncate optimization if set to TRUE
IZATION_ENABLED
_TSENC_OBFUSCAT : Encryption key obfuscation in memory
E_KEY
_TSENC_TRACING : Enable TS encryption tracing
_TSM_CONNECT_ST : TSM test connect string
RING
_TSM_DISABLE_AU : Disable TSM auto cleanup actions
TO_CLEANUP
_TSTZ_LOCALTIME : Should TTC not convert to LocalTime to preserve
_BYPASS Timestamp with Timezone values
_TTS_ALLOW_CHAR : allow plugging in a tablespace with an incompatible
SET_MISMATCH character set
_TWELFTH_SPARE_ : twelfth spare parameter – integer
PARAMETER
_TWENTIETH_SPAR : twentieth spare parameter – string
E_PARAMETER
_TWENTY-EIGHTH_ : twenty-eighth spare parameter – boolean
SPARE_PARAMETER
_TWENTY-FIFTH_S : twenty-fifth spare parameter – string list
PARE_PARAMETER
_TWENTY-FIRST_S : twenty-first spare parameter – string list
PARE_PARAMETER
_TWENTY-FOURTH_ : twenty-fourth spare parameter – string list
SPARE_PARAMETER
_TWENTY-SECOND_ : twenty-second spare parameter – string list
SPARE_PARAMETER
_TWENTY-SEVENTH : twenty-seventh spare parameter – boolean
_SPARE_PARAMETE
R
_TWENTY-SIXTH_S : twenty-sixth spare parameter – boolean
PARE_PARAMETER
_TWENTY-THIRD_S : twenty-third spare parameter – string list
PARE_PARAMETER
_TWO_PASS : enable two-pass thread recovery
_TWO_PASS_REVER : uses two-pass reverse polish alg. to generate canonical
SE_POLISH_ENABL forms
ED
_TXN_CONTROL_TR : size the in-memory buffer size of txn control
ACE_BUF_SIZE
_UGA_CGA_LARGE_ : UGA/CGA large extent size
EXTENT_SIZE
_ULTRAFAST_LATC : maintain fast-path statistics for ultrafast latches
H_STATISTICS
_UNDO_AUTOTUNE : enable auto tuning of undo_retention
_UNDO_BLOCK_COM : enable undo block compression
PRESSION
_UNDO_DEBUG_MOD : debug flag for undo related operations
E
_UNDO_DEBUG_USA : invoke undo usage functions for testing
GE
_UNIFIED_AUDIT_ : Unified Audit SGA Queue Flush Interval
FLUSH_INTERVAL
_UNIFIED_AUDIT_ : Unified Audit SGA Queue Flush Threshold
FLUSH_THRESHOLD
_UNIFIED_AUDIT_ : Disable Default Unified Audit Policies on DB Create
POLICY_DISABLED
_UNION_REWRITE_ : expand queries with GSets into UNIONs for rewrite
FOR_GS
_UNNEST_SUBQUER : enables unnesting of complex subqueries
Y
_UNUSED_BLOCK_C : enable unused block compression
OMPRESSION
_UPDATE_DATAFIL : user requested update of datafile headers of locally
E_HEADERS_WITH_ managed datafiles with space information
SPACE_INFORMATI
ON
_UPDDEL_DBA_HAS : controls masking of lower order bits in DBA
H_MASK_BITS
_USE_ADAPTIVE_L : Adaptively switch between post/wait and polling
OG_FILE_SYNC
_USE_BEST_FIT : use best fit to allocate space
_USE_COLUMN_STA : enable the use of column statistics for DDP functions
TS_FOR_FUNCTION
_USE_FIPS_MODE : Enable use of crypographic libraries in FIPS mode
_USE_HIDDEN_PAR : use hidden partitions
TITIONS
_USE_HYBRID_ENC : Enable platform optimized encryption in hybrid mode
RYPTION_MODE
_USE_ISM : Enable Shared Page Tables – ISM
_USE_ISM_FOR_PG : Use ISM for allocating large extents
A
_USE_NOSEGMENT_ : use nosegment indexes in explain plan
INDEXES
_USE_PLATFORM_C : Enable platform optimized compression implementation
OMPRESSION_LIB
_USE_PLATFORM_E : Enable platform optimized encryption implementation
NCRYPTION_LIB
_USE_REALFREE_H : use real-free based allocator for PGA memory
EAP
_USE_SEQ_PROCES : whether to use process local seq cache
S_CACHE
_USE_SINGLE_LOG : Use a single process for redo log writing
_WRITER
_USE_VECTOR_POS : use vector post
T
_USE_ZERO_COPY_ : Should network vector IO interface be used for data
IO transfer
_UTLMMIG_TABLE_ : enable/disable utlmmig table stats gathering at upgrade
STATS_GATHERING
_UTS_FIRST_SEGM : Should we retain the first trace segment
ENT_RETAIN
_UTS_FIRST_SEGM : Maximum size (in bytes) of first segments
ENT_SIZE
_UTS_TRACE_DISK : Trace disk threshold parameter
_THRESHOLD
_UTS_TRACE_SEGM : Maximum number of trace segments
ENTS
_UTS_TRACE_SEGM : Maximum size (in bytes) of a trace segment
ENT_SIZE
_VALIDATE_FLASH : Scan database to validate result of flashback database
BACK_DATABASE
_VALIDATE_METRI : Enable/disable SGA Metric Structure validation
C_GROUPS
_VALIDATE_READM : validate redo blocks read from in-memory log buffer
EM_REDO
_VENDOR_LIB_LOC : Vendor library search root directory
_VERIFY_FG_LOG_ : LGWR verifies redo checksums generated by foreground
CHECKSUM processes
_VERIFY_FLASHBA : Verify that the redo logs needed for flashback are
CK_REDO available
_VERIFY_UNDO_QU : TRUE – verify consistency of undo quota statistics
OTA
_VERY_LARGE_OBJ : upper threshold level of object size for direct reads
ECT_THRESHOLD
_VERY_LARGE_PAR : very_large_partitioned_table
TITIONED_TABLE
_VIRTUAL_COLUMN : overload virtual columns expression
_OVERLOAD_ALLOW
ED
_VKRM_SCHEDULE_ : VKRM scheduling interval
INTERVAL
_VKTM_ASSERT_TH : soft assert threshold VKTM timer drift
RESH
_WAIT_BREAKUP_T : Wait breakup threshold (in centiseconds)
HRESHOLD_CSECS
_WAIT_BREAKUP_T : Wait breakup time (in centiseconds)
IME_CSECS
_WAIT_FOR_SYNC : wait for sync on commit MUST BE ALWAYS TRUE
_WAIT_SAMPLES_M : Wait Samples maximum sections
AX_SECTIONS
_WAIT_SAMPLES_M : Wait Samples maximum time in seconds
AX_TIME_SECS
_WAIT_TRACKER_I : Wait Tracker number of seconds per interval
NTERVAL_SECS
_WAIT_TRACKER_N : Wait Tracker number of intervals
UM_INTERVALS
_WAIT_YIELD_HP_ : Wait Yield – High Priority Mode
MODE
_WAIT_YIELD_MOD : Wait Yield – Mode
E
_WAIT_YIELD_SLE : Wait Yield – Sleep Frequency
EP_FREQ
_WAIT_YIELD_SLE : Wait Yield – Sleep Time (in milliseconds)
EP_TIME_MSECS
_WAIT_YIELD_YIE : Wait Yield – Yield Frequency
LD_FREQ
_WALK_INSERT_TH : maximum number of unusable blocks to walk across
RESHOLD freelist
_WATCHPOINT_ON : is the watchpointing feature turned on?
_WCR_CONTROL : Oracle internal test WCR parameter used ONLY for
testing!
_WCR_GRV_CACHE_ : Oracle internal: Set the replay cache size for
SIZE WRR$_REPLAY_DATA.
_WCR_SEQ_CACHE_ : Oracle internal: Set the replay cache size for
SIZE WRR$_REPLAY_SEQ_DATA.
_WIDETAB_COMP_E : wide table compression enabled
NABLED
_WINDOWFUNC_OPT : settings for window function optimizations
IMIZATION_SETTI
NGS
_WITH_SUBQUERY : WITH subquery transformation
_WRITE_CLONES : write clones flag
_XA_INTERNAL_RE : number of internal retries for xa transactions
TRIES
_XDS_MAX_CHILD_ : Maximum number of XDS user-specific child cursors
CURSORS
_XENGEM_DEVNAME : override default VM GEM device name used by skgvm
_XENGEM_DIAGMOD : set to OFF to disable VM GEM support and
E functionalities
_XENGEM_ENABLED : Enable OVM GEM support
_XPL_PEEKED_BIN : maximum bytes for logging peeked bind values for
DS_LOG_SIZE V$SQL_PLAN (0 = OFF)
_XPL_TRACE : Explain Plan tracing parameter
_XSOLAPI_AUTO_M : OLAP API lower bound for auto materialization.
ATERIALIZATION_
BOUND
_XSOLAPI_AUTO_M : OLAP API behavior for auto materialization
ATERIALIZATION_
TYPE
_XSOLAPI_BUILD_ : OLAP API output build info to trace file
TRACE
_XSOLAPI_DEBUG_ : OLAP API debug output disposition
OUTPUT
_XSOLAPI_DENSIF : OLAP API cube densification
Y_CUBES
_XSOLAPI_DIMENS : OLAP API symmetric overfetch
ION_GROUP_CREAT
ION
_XSOLAPI_DML_TR : OLAP API output dml commands and expressions to trace
ACE file
_XSOLAPI_FETCH_ : OLAP API fetch type
TYPE
_XSOLAPI_FIX_VP : OLAP API Enable vptr fixing logic in shared server mode
TRS
_XSOLAPI_GENERA : OLAP API generates WITH clause?
TE_WITH_CLAUSE
_XSOLAPI_HIERAR : OLAP API hierarchy value type
CHY_VALUE_TYPE
_XSOLAPI_LOAD_A : When to load OLAP API library at server process start
T_PROCESS_START
_XSOLAPI_MATERI : OLAP API min number of rows required to use rowcache in
ALIZATION_ROWCA query materialization
CHE_MIN_ROWS_FO
R_USE
_XSOLAPI_MATERI : OLAP API Enable source materialization
ALIZE_SOURCES
_XSOLAPI_METADA : OLAP API metadata reader mode
TA_READER_MODE
_XSOLAPI_ODBO_M : OLAP API uses ODBO mode?
ODE
_XSOLAPI_OPTIMI : OLAP API optimizes suppressions?
ZE_SUPPRESSION
_XSOLAPI_OPT_AW : OLAP API enables AW position and count optimization?
_POSITION
_XSOLAPI_PRECOM : OLAP API precomputes subqueries?
PUTE_SUBQUERY
_XSOLAPI_REMOVE : OLAP API removes columns for materialization?
_COLUMNS_FOR_MA
TERIALIZATION
_XSOLAPI_SET_NL : OLAP API sets NLS?
S
_XSOLAPI_SHARE_ : OLAP API share executors?
EXECUTORS
_XSOLAPI_SOURCE : OLAP API output Source definitions to trace file
_TRACE
_XSOLAPI_SQL_AL : OLAP API multi-join non-base hints
L_MULTI_JOIN_NO
N_BASE_HINTS
_XSOLAPI_SQL_AL : OLAP API non-base hints
L_NON_BASE_HINT
S
_XSOLAPI_SQL_AU : OLAP API enable automatic dimension hints
TO_DIMENSION_HI
NTS
_XSOLAPI_SQL_AU : OLAP API enable automatic measure hints
TO_MEASURE_HINT
S
_XSOLAPI_SQL_DI : OLAP API dimension hints
MENSION_HINTS
_XSOLAPI_SQL_EN : OLAP API enables AW join?
ABLE_AW_JOIN
_XSOLAPI_SQL_EN : OLAP API enables AW QDR merge?
ABLE_AW_QDR_MER
GE
_XSOLAPI_SQL_HI : OLAP API generic hints
NTS
_XSOLAPI_SQL_ME : OLAP API measure hints
ASURE_HINTS
_XSOLAPI_SQL_MI : OLAP API SQL MINUS threshold
NUS_THRESHOLD
_XSOLAPI_SQL_OP : OLAP API enable optimization
TIMIZE
_XSOLAPI_SQL_PR : OLAP API prepare statement cache size
EPARE_STMT_CACH
E_SIZE
_XSOLAPI_SQL_RE : OLAP API enable remove unused columns optimizations
MOVE_COLUMNS
_XSOLAPI_SQL_RE : OLAP API result set cache size
SULT_SET_CACHE_
SIZE
_XSOLAPI_SQL_SY : OLAP API enable symmetric predicate for dimension
MMETRIC_PREDICA groups
TE
_XSOLAPI_SQL_TO : OLAP API top dimension hints
P_DIMENSION_HIN
TS
_XSOLAPI_SQL_TO : OLAP API top measure hints
P_MEASURE_HINTS
_XSOLAPI_SQL_US : OLAP API enable bind variables optimization
E_BIND_VARIABLE
S
_XSOLAPI_STRING : OLAP API stringifies order levels?
IFY_ORDER_LEVEL
S
_XSOLAPI_SUPPOR : OLAP API MTM mapping classes supported?
T_MTM
_XSOLAPI_SUPPRE : OLAP API suppression AW mask threshold
SSION_AW_MASK_T
HRESHOLD
_XSOLAPI_SUPPRE : OLAP API suppression chunk size
SSION_CHUNK_SIZ
E
_XSOLAPI_USE_MO : OLAP API uses models?
DELS
_XSOLAPI_USE_OL : OLAP API uses OLAP DML?
AP_DML
_XSOLAPI_USE_OL : OLAP API uses OLAP DML for rank?
AP_DML_FOR_RANK
_XS_CLEANUP_TAS : Triton Session Cleanup
K
_XS_DISPATCHER_ : XS dispatcher only mode
ONLY
_XTBUFFER_SIZE : buffer size in KB needed for populate/query operation
_XTTS_ALLOW_PRE : allow cross platform for pre10 compatible tablespace
10
_XTTS_SET_PLATF : set cross platform info during file header read
ORM_INFO
_XT_COVERAGE : external tables code coverage parameter
_XT_TRACE : external tables trace parameter
_ZONEMAP_CONTRO : control different uses/algorithms related to zonemaps
L
_ZONEMAP_STALEN : control the staleness tracking of zonemaps via trigger
ESS_TRACKING
_ZONEMAP_USE_EN : enable the use of zonemaps for IO pruning
ABLED
__DATA_TRANSFER : Actual size of data transfer cache
_CACHE_SIZE
__DB_CACHE_SIZE : Actual size of DEFAULT buffer pool for standard block
size buffers
__DG_BROKER_SER : service names for broker use
VICE_NAMES
__JAVA_POOL_SIZ : Actual size in bytes of java pool
E
__LARGE_POOL_SI : Actual size in bytes of large pool
ZE
__ORACLE_BASE : ORACLE_BASE
__PGA_AGGREGATE : Current target size for the aggregate PGA memory
_TARGET consumed
__SGA_TARGET : Actual size of SGA
__SHARED_IO_POO : Actual size of shared IO pool
L_SIZE
__SHARED_POOL_S : Actual size in bytes of shared pool
IZE
__STREAMS_POOL_ : Actual size in bytes of streams pool
SIZE
2984 rows selected.
References: Oracle Documentation
上述内容就是 Oracle12c 版本中未归档隐藏参数有哪些，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注丸趣 TV 行业资讯频道。
