Oracle12c版本中未归档隐藏参数有哪些

网友投稿 98 2023-12-29

Oracle12c版本中未归档隐藏参数有哪些

本篇文章为大家展示了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 BYa.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) = _orderby 1,3;

PARAMETER DESCRIPTION

————— ——————————————————-

_4030_DUMP_BITV : bitvec to specify dumps prior to 4030 error

_4031_DUMP_BITV : bitvec to specify dumps prior to 4031 error

_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

_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

_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

_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

_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

_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

_ALLOW_LEVEL_WI : allow level without connect by

THOUT_CONNECT_B

_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

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

_ALWAYS_STAR_TR : always favor use of star transformation

ANSFORMATION

_AM_CONTAINER_F : allocation unit size for non-ASM containers

ILESYSTEM_AUSIZ

_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

_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

_AQ_STOP_BACKGR : Stop all AQ background processes

OUNDS

_AQ_SUBSHARD_SI : Sub Shard Size

_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

_AQ_TM_STATISTI : statistics collection window duration

CS_DURATION

_ARCH_COMPRESSI : archive compression enabled

_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

_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

_ASM_DISKGROUPS : disk groups to mount automatically set 3

_ASM_DISKGROUPS : disk groups to mount automatically set 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)

_ASM_ENABLE_XRO : Enable XROV capability

_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

_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

_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

_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

_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

_ASM_SHADOW_CYC : Inverse shadow cycle requirement

_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

_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

_AUTO_BMR_FC_TI : Auto BMR Flood Control Time

_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

_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

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

PURGE_EXTENT

_AWR_MMON_DEEP_ : Set interval for deep purge of AWR contents

PURGE_INTERVAL

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

PURGE_NUMROWS purge run

_AWR_PDB_REGIST : Parameter to enable/disable AWR PDB Registration

RATION_ENABLED

_AWR_REMOTE_TAR : AWR Remote Target DBLink for Flushing

GET_DBLINK

_AWR_RESTRICT_M : AWR Restrict Mode

ODE

_AWR_SQL_CHILD_ : Setting for AWR SQL Child Limit

LIMIT

_BACKUP_ALIGN_W : align backup write I/Os

RITE_IO

_BACKUP_AUTOMAT : automatic retry on backup write errors

IC_RETRY

_BACKUP_DISK_BU : number of buffers used for DISK channels

FCNT

_BACKUP_DISK_BU : size of buffers used for DISK channels

FSZ

_BACKUP_DISK_IO : BACKUP Disk I/O slaves

_SLAVES

_BACKUP_DYNAMIC : dynamically compute backup/restore buffer sizes

_BUFFERS

_BACKUP_ENCRYPT : specifies encryption block optimization mode

_OPT_MODE

_BACKUP_FILE_BU : number of buffers used for file access

FCNT

_BACKUP_FILE_BU : size of buffers used for file access

FSZ

_BACKUP_IO_POOL : memory to reserve from the large pool

_SIZE

_BACKUP_KGC_BLK : specifies buffer size to be used by HIGH compression

SIZ

_BACKUP_KGC_BUF : specifies buffer size to be used by BASIC compression

_BACKUP_KGC_MEM : specifies memory level for MEDIUM compression

LEVEL

_BACKUP_KGC_NIT : specifies number of iterations done by BASIC

ERS compression

_BACKUP_KGC_PER : specifies compression (performance) level for MEDIUM

FLEVEL compression

_BACKUP_KGC_SCH : specifies compression scheme

EME

_BACKUP_KGC_TYP : specifies compression type used by kgc BASIC

E compression

_BACKUP_KGC_WIN : specifies window size for MEDIUM compression

DOWBITS

_BACKUP_KSFQ_BU : number of buffers used for backup/restore

FCNT

_BACKUP_KSFQ_BU : maximum amount of memory (in bytes) used for buffers

FMEM_MAX for backup/restore

_BACKUP_KSFQ_BU : size of buffers used for backup/restore

FSZ

_BACKUP_LZO_SIZ : specifies buffer size for LOW compression

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

_SIZE in bytes

_BACKUP_MIN_CT_ : mimimun size in bytes of change tracking to apply

UNUSED_OPTIM unused space optimuzation

_BACKUP_SEQ_BUF : number of buffers used for non-DISK channels

CNT

_BACKUP_SEQ_BUF : size of buffers used for non-DISK channels

_BCT_BITMAPS_PE : number of bitmaps to store for each datafile

R_FILE

_BCT_BUFFER_ALL : maximum size of all change tracking buffer allocations,

OCATION_MAX in bytes

_BCT_BUFFER_ALL : mininum number of extents to allocate per buffer

OCATION_MIN_EXT allocation

ENTS

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

OCATION_SIZE

_BCT_CHUNK_SIZE : change tracking datafile chunk size, in bytes

_BCT_CRASH_RESE : change tracking reserved crash recovery SGA space, in

RVE_SIZE bytes

_BCT_FILE_BLOCK : block size of change tracking file, in bytes

_SIZE

_BCT_FILE_EXTEN : extent size of change tracking file, in bytes

T_SIZE

_BCT_FIXTAB_FIL : change tracking file for fixed tables

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

CK_INTERVAL

_BCT_INITIAL_PR : initial number of entries in the private change

IVATE_DBA_BUFFE tracking dba buffers

R_SIZE

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

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

_BUFFER_DYNRESI disable

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

_BUFFER_MAXSIZE bytes

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

_BUFFER_SIZE in bytes

_BG_SPAWN_DIAG_ : background processes spawn diagnostic options

OPTS

_BITMAP_OR_IMPR : controls extensions to partition pruning for general

OVEMENT_ENABLED predicates

_BLOCKING_SESS_ : blocking session graph cache size in bytes

GRAPH_CACHE_SIZ

_BLOCKS_PER_CAC : number of consecutive blocks per global cache server

HE_SERVER

_BLOCK_LEVEL_OF : High Latency Threshold for Block Level Offload

FLOAD_HIGH_LAT_ operations

THRESH

_BLOCK_SAMPLE_R : controls readahead value during block sampling

EADAHEAD_PROB_T

HRESHOLD

_BLOOM_FILTER_D : debug level for bloom filtering

EBUG

_BLOOM_FILTER_E : enables or disables bloom filter

NABLED

_BLOOM_FILTER_S : bloom filter vector size (in KB)

IZE

_BLOOM_FOLDING_ : bloom filter folding density lower bound

DENSITY

_BLOOM_FOLDING_ : Enable folding of bloom filter

ENABLED

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

MIN

_BLOOM_MAX_SIZE : maximum bloom filter size (in KB)

_BLOOM_MINMAX_E : enable or disable bloom min max filtering

NABLED

_BLOOM_PREDICAT : enables or disables bloom filter predicate pushdown

E_ENABLED

_BLOOM_PREDICAT : enables or disables bloom filter predicate offload to

E_OFFLOAD cells

_BLOOM_PRUNING_ : Enable partition pruning using bloom filtering

ENABLED

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

MAX

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

TOTAL_MAX

_BLOOM_RM_FILTE : remove bloom predicate in favor of zonemap join pruning

R predicate

_BLOOM_SM_ENABL : enable bloom filter optimization using slave mapping

_BRANCH_TAGGING : enable branch tagging for distributed transaction

_BROADCAST_SCN_ : broadcast-on-commit scn mode

MODE

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

WAIT_TIMEOUT

_BSLN_ADAPTIVE_ : Adaptive Thresholds Enabled

THRESHOLDS_ENAB

LED

_BT_MMV_QUERY_R : allow rewrites with multiple MVs and base tables

EWRITE_ENABLED

_BUFFERED_MESSA : Buffered message spill age

GE_SPILL_AGE

_BUFFERED_PUBLI : Flow control threshold for buffered publishers except

SHER_FLOW_CONTR capture

OL_THRESHOLD

_BUFFER_BUSY_WA : buffer busy wait time in centiseconds

IT_TIMEOUT

_BUFQ_STOP_FLOW : Stop enforcing flow control for buffered queues

_CONTROL

_BUILD_DEFERRED : DEFERRED MV creation skipping MV log setup update

_MV_SKIPPING_MV

LOG_UPDATE

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

_MARK_COUNT advancing HWM

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

D_PI

_BYPASS_SRL_FOR : bypass SRL for S/O EOR logs

_SO_EOR

_BYPASS_XPLATFO : bypass datafile header cross-platform-compliance errors

RM_ERROR

_B_TREE_BITMAP_ : enable the use of bitmap plans for tables w. only

PLANS B-tree indexes

_CACHE_ORL_DURI : cache online logs

NG_OPEN

_CACHE_STATS_MO : if TRUE, enable cache stats monitoring

NITOR

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

_SIZE

_CAPTURE_PUBLIS : Flow control threshold for capture publishers

HER_FLOW_CONTRO

L_THRESHOLD

_CASE_SENSITIVE : case sensitive logon enabled

_LOGON

_CAUSAL_STANDBY : Causal standby wait timeout

_WAIT_TIMEOUT

_CDB_COMPATIBLE : CDB Compatible

_CDB_RAC_AFFINI : rac affinity for parallel cdb operations

_CDC_SUBSCRIPTI : Change Data Capture subscription_owner

ON_OWNER

_CDMP_DIAGNOSTI : cdmp directory diagnostic level

C_LEVEL

_CELL_FAST_FILE : Allow optimized file creation path for Cells

_CREATE

_CELL_FAST_FILE : Allow optimized rman restore for Cells

_RESTORE

_CELL_FILE_FORM : Cell file format chunk size in MB

AT_CHUNK_SIZE

_CELL_INDEX_SCA : enable CELL processing of index FFS

N_ENABLED

_CELL_MATERIALI : Force materialization of all offloadable expressions on

ZE_ALL_EXPRESSI the cells

ONS

_CELL_MATERIALI : enable offload of expressions underlying virtual

ZE_VIRTUAL_COLU columns to cells

MNS

_CELL_OBJECT_EX : flashcache object expiration timeout

PIRATION_HOURS

_CELL_OFFLOAD_C : specifies capability table to load

APABILITIES_ENA

BLED

_CELL_OFFLOAD_C : enable complex SQL processing offload to cells

OMPLEX_PROCESSI

_CELL_OFFLOAD_E : enable offload of expressions to cells

XPRESSIONS

_CELL_OFFLOAD_H : Query offloading of hybrid columnar compressed tables

YBRIDCOLUMNAR to exadata

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

REDICATE_REORDE

RING_ENABLED

_CELL_OFFLOAD_S : enable offload of SYS_CONTEXT evaluation to cells

YS_CONTEXT

_CELL_OFFLOAD_T : enable timezone related SQL processing offload to cells

IMEZONE

_CELL_OFFLOAD_V : enable offload of predicates on virtual columns to

IRTUAL_COLUMNS cells

_CELL_RANGE_SCA : enable CELL processing of index range scans

N_ENABLED

_CELL_STORIDX_M : Cell Storage Index mode

ODE

_CGS_ALLGROUP_P : CGS DBALL group polling interval in milli-seconds

OLL_TIME

_CGS_COMM_READI : CGS communication readiness check

NESS_CHECK

_CGS_DBALL_GROU : CGS DBALL group registration type

P_REGISTRATION

_CGS_DBGROUP_PO : CGS DB group polling interval in milli-seconds

LL_TIME

_CGS_HEALTH_CHE : CGS health check during reconfiguration

CK_IN_RECONFIG

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

_FROM_RIM_INSTA

NCE

_CGS_MSG_BATCHI : CGS message batching

_CGS_MSG_BATCH_ : CGS message batch size in bytes

SIZE

_CGS_NODE_KILL_ : CGS node kill escalation to CSS

ESCALATION

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

ESCALATION_WAIT

_CGS_RECONFIG_E : CGS reconfiguration extra wait time for CSS in seconds

XTRA_WAIT

_CGS_RECONFIG_T : CGS reconfiguration timeout interval

IMEOUT

_CGS_SEND_TIMEO : CGS send timeout value

_CGS_TICKETS : CGS messaging tickets

_CGS_TICKET_SEN : CGS ticket active sendback percentage threshold

DBACK

_CGS_ZOMBIE_MEM : CGS zombie member kill wait time in seconds

BER_KILL_WAIT

_CHANGE_VECTOR_ : Number of change vector buffers for media recovery

BUFFERS

_CHECK_BLOCK_AF : perform block check after checksum if both are turned

TER_CHECKSUM on

_CHECK_BLOCK_NE : check block new invariant for flashback

W_INVARIANT_FOR

_FLASHBACK

_CHECK_COLUMN_L : check column length

ENGTH

_CHECK_PDBID_IN : Enable checking of pluggable database ID in redo

_REDO

_CHECK_TS_THRES : check tablespace thresholds

HOLD

_CLEANOUT_SHRCU : if TRUE, cleanout shrcur buffers

R_BUFFERS

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

CK_ENTRIES

_CLEANUP_TIMEOU : timeout value for PMON cleanup

_CLEANUP_TIMEOU : flags for PMON cleanup timeout

T_FLAGS

_CLEAR_BUFFER_B : Always zero-out buffer before reuse for security

EFORE_REUSE

_CLIENT_ENABLE_ : enable automatic unregister after a send fails with

AUTO_UNREGISTER timeout

_CLIENT_NTFN_CL : interval after which dead client registration cleanup

EANUP_INTERVAL task repeats

_CLIENT_NTFN_PI : time between pings to unreachable notification clients

NGINTERVAL

_CLIENT_NTFN_PI : number of times to ping unreachable notification

NGRETRIES clients

_CLIENT_NTFN_PI : timeout to connect to unreachable notification clients

NGTIMEOUT

_CLIENT_RESULT_ : bypass the client result cache

CACHE_BYPASS

_CLIENT_TSTZ_ER : Should Client give error for suspect Timestamp with

ROR_CHECK Timezone operations

_CLI_CACHEBKTAL : Percentage of memory to allocate

LOC

_CLONE_ONE_PDB_ : Recover ROOT and only one PDB in clone database

RECOVERY

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

PEN_CURSORS

_CLOSE_DEQ_BY_C : Close Dequeue By Condition Cursors

OND_CURS

_CLOUD_NAME : gsm cloud name

_CLUSTERWIDE_GL : enable/disable clusterwide global transactions

OBAL_TRANSACTIO

_CLUSTER_LIBRAR : cluster library selection

_COLLAPSE_WAIT_ : collapse wait history

HISTORY

_COLLECT_TEMPUN : Collect Statistics v$tempundostat

DO_STATS

_COLLECT_UNDO_S : Collect Statistics v$undostat

TATS

_COLUMN_COMPRES : Column compression ratio

SION_FACTOR

_COLUMN_ELIMINA : turn off predicate-only column elimination

TION_OFF

_COLUMN_TRACKIN : column usage tracking

G_LEVEL

_COMMON_DATA_VI : common objects returned through dictionary views

EW_ENABLED

_COMMON_USER_PR : Enforce restriction on a prefix of a Common

EFIX User/Role/Profile name

_COMPILATION_CA : Size of the compilation call heaps extents

LL_HEAP_EXTENT_

SIZE

_COMPLEX_VIEW_M : enable complex view merging

ERGING

_COMPRESSION_AB : number of recompression above cache for sanity check

OVE_CACHE

_COMPRESSION_AD : Compression advisor

VISOR

_COMPRESSION_CH : percentage of chained rows allowed for Compression

AIN

_COMPRESSION_CO : Compression compatability

MPATIBILITY

_CONCURRENCY_CH : what is the chosen value of concurrency

OSEN

_CONNECTION_BRO : connection broker host for listen address

KER_HOST

_CONNECT_BY_USE : use union all for connect by

_UNION_ALL

_CONTROLFILE_AU : time delay (in seconds) for performing controlfile

TOBACKUP_DELAY autobackups

_CONTROLFILE_BA : enable check of the copied blocks during controlfile

CKUP_COPY_CHECK backup copy

_CONTROLFILE_BL : control file block size in bytes

OCK_SIZE

_CONTROLFILE_CE : Flash cache hint for control file accesses

LL_FLASH_CACHIN

_CONTROLFILE_EN : dump the system states after controlfile enqueue

QUEUE_DUMP timeout

_CONTROLFILE_EN : control file enqueue max holding time in seconds

QUEUE_HOLDING_T

IME

_CONTROLFILE_EN : control file enqueue holding time tracking size

QUEUE_HOLDING_T

IME_TRACKING_SI

_CONTROLFILE_EN : control file enqueue timeout in seconds

QUEUE_TIMEOUT

_CONTROLFILE_SE : control file initial section size

CTION_INIT_SIZE

_CONTROLFILE_SE : control file max expansion rate

CTION_MAX_EXPAN

_CONTROLFILE_UP : controlfile update sanity check

DATE_CHECK

_CONVERT_SET_TO : enables conversion of set operator to join

_JOIN

_COORD_MESSAGE_ : parallel recovery coordinator side extra message buffer

BUFFER size

_CORRUPTED_ROLL : corrupted undo segment list

BACK_SEGMENTS

_COST_EQUALITY_ : enables costing of equality semi-join

SEMI_JOIN

_CPU_EFF_THREAD : CPU effective thread multiplier

_MULTIPLIER

_CPU_TO_IO : divisor for converting CPU cost to I/O cost

_CP_NUM_HASH_LA : connection pool number of hash latches

TCHES

_CRASH_DOMAIN_O : allow domain to exit for exceptions in any thread

N_EXCEPTION

_CREATE_STAT_SE : create ilm statistics segment

GMENT

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

N_ANY_CLUSTER user

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

L_ROLE global role

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

_ROLE on

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

block

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

FLUSH

_CR_TRC_BUF_SIZ : size of cr trace buffer

_CTX_DOC_POLICY : enable ctx_doc.policy_stems api

_STEMS

_CURSOR_BIND_CA : maximum size of the cursor bind capture area

PTURE_AREA_SIZE

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

PTURE_INTERVAL cursor

_CURSOR_CACHE_T : number of seconds a session cached cursor stay in

IME cache.

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

ERS_PINNED

_CURSOR_FEATURE : Shared cursor features enabled bits.

S_ENABLED

_CURSOR_OBSOLET : Number of cursors per parent before obsoletion.

E_THRESHOLD

_CURSOR_PLAN_EN : enable collection and display of cursor plans

ABLED

_CURSOR_PLAN_HA : version of cursor plan hash value

SH_VERSION

_CURSOR_PLAN_UN : enables/disables using unparse to build

PARSE_ENABLED projection/predicates

_CURSOR_RELOAD_ : Number of failed reloads before marking cursor unusable

FAILURE_THRESHO

_CURSOR_RUNTIME : Shared cursor runtime heap memory limit

HEAP_MEMLIMIT

_CURSOR_STATS_E : Enable cursor stats

NABLED

_CU_ROW_LOCKING : CU row level locking

_CVMAP_BUFFERS : Number of change vector buffers for multi instance

media recovery

_CVW_ENABLE_WEA : enable weak view checking

K_CHECKING

_DATAFILE_COW : Use copy on write snapshot for the renamed file

_DATAFILE_WRITE : datafile write errors crash instance

_ERRORS_CRASH_I

NSTANCE

_DATAPUMP_COMPR : specifies buffer size for BASIC compression algorithm

ESSBAS_BUFFER_S

IZE

_DATAPUMP_METAD : specifies buffer size for metadata file I/O

ATA_BUFFER_SIZE

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

DATA_BUFFER_SIZ

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

CACHE_BC_PERC_X transfer cache

100

_DATA_TRANSFER_ : Size of data transfer cache

CACHE_SIZE

_DATA_WAREHOUSI : if TRUE, enable data warehousing scan buffers

NG_SCAN_BUFFERS

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

PLICIT_FETCH SecureFiles

_DBG_PROC_START : debug process startup

_DBG_SCAN : generic scan debug

_DBMS_SQL_SECUR : Security level in DBMS_SQL

ITY_LEVEL

_DBOP_ENABLED : Any positive number enables automatic DBOP monitoring.

0 is disabled

_DBPOOL_NAME : gsm database pool name

_DBRM_DYNAMIC_T : DBRM dynamic threshold setting

HRESHOLD

_DBRM_NUM_RUNNA : Resource Manager number of runnable list per NUMA node

BLE_LIST

_DBRM_QUANTUM : DBRM quantum

_DBRM_RUNCHK : Resource Manager Diagnostic Running Thread Check

_DBRM_SHORT_WAI : Resource Manager short wait length

T_US

_DBWR_ASYNC_IO : Enable dbwriter asynchronous writes

_DBWR_SCAN_INTE : dbwriter scan interval

RVAL

_DBWR_TRACING : Enable dbwriter tracing

_DB_16K_FLASH_C : flash cache file for 16k block size

ACHE_FILE

_DB_16K_FLASH_C : flash cache size for _db_16k_flash_cache_file

ACHE_SIZE

_DB_2K_FLASH_CA : flash cache file for 2k block size

CHE_FILE

_DB_2K_FLASH_CA : flash cache size for _db_2k_flash_cache_file

CHE_SIZE

_DB_32K_FLASH_C : flash cache file for 32k block size

ACHE_FILE

_DB_32K_FLASH_C : flash cache size for _db_32k_flash_cache_file

ACHE_SIZE

_DB_4K_FLASH_CA : flash cache file for 4k block size

CHE_FILE

_DB_4K_FLASH_CA : flash cache size for _db_4k_flash_cache_file

CHE_SIZE

_DB_8K_FLASH_CA : flash cache file for 8k block size

CHE_FILE

_DB_8K_FLASH_CA : flash cache size for _db_8k_flash_cache_file

CHE_SIZE

_DB_AGING_COOL_ : Touch count set when buffer cooled

COUNT

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

E_CR

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

RITERIA list

_DB_AGING_STAY_ : Touch count set when buffer moved to head of

COUNT replacement list

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

_TIME list

_DB_ALWAYS_CHEC : Always perform block check and checksum for System

K_SYSTEM_TS tablespace

_DB_BLOCKS_PER_ : Number of blocks per hash latch

HASH_LATCH

_DB_BLOCK_ADJCH : adjacent cache buffer checks – low blkchk overwrite

ECK parameter

_DB_BLOCK_ADJCH : adjacent cache buffer check level

K_LEVEL

_DB_BLOCK_ALIGN : Align Direct Reads

_DIRECT_READ

_DB_BLOCK_BAD_W : enable bad write checks

RITE_CHECK

_DB_BLOCK_BUFFE : Number of database blocks cached in memory: hidden

RS parameter

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

_CLONE

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

_HISTORY

_DB_BLOCK_CACHE : buffer header tracing level

_HISTORY_LEVEL

_DB_BLOCK_CACHE : buffer header tracing for lru operations

_HISTORY_LRU

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

_NUM_UMAP blocks)

_DB_BLOCK_CACHE : protect database blocks (true only when debugging)

_PROTECT

_DB_BLOCK_CACHE : protect database blocks (for strictly internal use

_PROTECT_INTERN only)

_DB_BLOCK_CHECK : Check more and dump block before image for debugging

_FOR_DEBUG

_DB_BLOCK_CHECK : check objd and typ on cache disk read

_OBJTYP

_DB_BLOCK_CHUNK : chunkify noncontig multi block reads

IFY_NCMBR

_DB_BLOCK_CORRU : threshold number of block recovery attempts

PTION_RECOVERY_

THRESHOLD

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

LL_MBREADS

_DB_BLOCK_HASH_ : Number of database block hash buckets

BUCKETS

_DB_BLOCK_HASH_ : Number of database block hash latches

LATCHES

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

R_GUARD_LEVEL

_DB_BLOCK_HI_PR : Fraction of writes for high priority reasons

IORITY_BATCH_SI

_DB_BLOCK_KNOWN : Initial Percentage of buffers to maintain known clean

_CLEAN_PCT

_DB_BLOCK_LRU_L : number of lru latches

ATCHES

_DB_BLOCK_MAX_C : Maximum Allowed Number of CR buffers per dba

R_DBA

_DB_BLOCK_MAX_S : Percentage of buffers to inspect when looking for free

CAN_PCT

_DB_BLOCK_MED_P : Fraction of writes for medium priority reasons

RIORITY_BATCH_S

IZE

_DB_BLOCK_NUMA : Number of NUMA nodes

_DB_BLOCK_PREFE : Batched IO enable fast longjumps

TCH_FAST_LONGJU

MPS_ENABLED

_DB_BLOCK_PREFE : Prefetch limit in blocks

TCH_LIMIT

_DB_BLOCK_PREFE : Prefetch force override in blocks

TCH_OVERRIDE

_DB_BLOCK_PREFE : Batched IO enable private cache

TCH_PRIVATE_CAC

HE_ENABLED

_DB_BLOCK_PREFE : Prefetch quota as a percent of cache size

TCH_QUOTA

_DB_BLOCK_PREFE : Batched IO enable skip reading buffers

TCH_SKIP_READIN

G_ENABLED

_DB_BLOCK_PREFE : Allowed wasted percent threshold of prefetched size

TCH_WASTED_THRE

SHOLD_PERC

_DB_BLOCK_TABLE : Size of shared table scan read buffer

_SCAN_BUFFER_SI

_DB_BLOCK_TEMP_ : generate redo for temp blocks

REDO

_DB_BLOCK_TRACE : trace buffer protect calls

_PROTECT

_DB_BLOCK_VLM_C : check of rvlm mapping leaks (for debugging)

HECK

_DB_BLOCK_VLM_L : Threshold for allowable vlm leaks

EAK_THRESHOLD

_DB_CACHE_ADVIC : cache advisory maximum multiple of current size to

E_MAX_SIZE_FACT similate

_DB_CACHE_ADVIC : cache advisory sampling factor

E_SAMPLE_FACTOR

_DB_CACHE_ADVIC : cache simulation sanity check

E_SANITY_CHECK

_DB_CACHE_BLOCK : dump short call stack for block reads

_READ_STACK_TRA

_DB_CACHE_CRX_C : check for costly crx examination functions

HECK

_DB_CACHE_MISS_ : check LEs after cache miss

CHECK_LES

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

LATCH_CHECK

_DB_CACHE_PRE_W : Buffer Cache Pre-Warm Enabled : hidden parameter

ARM

_DB_CACHE_PROCE : maximum number of cr pins a process may have

SS_CR_PIN_MAX

_DB_CACHE_WAIT_ : trace new kslwaits

DEBUG

_DB_CHANGE_NOTI : enable db change notification

FICATION_ENABLE

_DB_CHECK_CELL_ :

HINTS

_DB_DISABLE_TEM : Disable Temp Encryption for Spills

P_ENCRYPTION

_DB_DUMP_FROM_D : dump contents from disk and efc

ISK_AND_EFC

_DB_DW_SCAN_ADA : if TRUE, enable adaptive DW scan cooling

PTIVE_COOLING

_DB_DW_SCAN_MAX : DW Scan adaptive cooling max shadow count

_SHADOW_COUNT

_DB_DW_SCAN_OBJ : DW Scan object cooling factor to cool all temperatures

_COOLING_FACTOR

_DB_DW_SCAN_OBJ : DW Scan object cooling interval in number of scans,

_COOLING_INTERV seconds, or pct of cache size

_DB_DW_SCAN_OBJ : DW scan objtect cooling policy

_COOLING_POLICY

_DB_DW_SCAN_OBJ : DW Scan object warming increment when an object is

_WARMING_INCREM scanned

ENT

_DB_FAST_OBJ_CH : enable fast object drop sanity check

ECK

_DB_FAST_OBJ_CK : enable fast object checkpoint

_DB_FAST_OBJ_TR : enable fast object truncate

UNCATE

_DB_FILE_DIRECT : Sequential I/O buf size

_IO_COUNT

_DB_FILE_EXEC_R : multiblock read count for regular clients

EAD_COUNT

_DB_FILE_FORMAT : Block formatting I/O buf count

_IO_BUFFERS

_DB_FILE_NONCON : number of noncontiguous db blocks to be prefetched

TIG_MBLOCK_READ

_COUNT

_DB_FILE_OPTIMI : multiblock read count for regular clients

ZER_READ_COUNT

_DB_FLASHBACK_I : Flashback IO Buffer Size

OBUF_SIZE

_DB_FLASHBACK_L : Minimum flashback database log size in bytes

OG_MIN_SIZE

_DB_FLASHBACK_L : Minimum flashback database log total space in bytes

OG_MIN_TOTAL_SP

ACE

_DB_FLASHBACK_N : Flashback Number of IO buffers

UM_IOBUF

_DB_FLASH_CACHE : Flash cache force replenish lower limit in buffers

_FORCE_REPLENIS

H_LIMIT

_DB_FLASH_CACHE : Flash cache keep buffer upper limit in percentage

_KEEP_LIMIT

_DB_FLASH_CACHE : Flash cache maximum latency allowed in 10 milliseconds

_MAX_LATENCY

_DB_FLASH_CACHE : Flash cache maximum outstanding writes allowed

_MAX_OUTSTANDIN

G_WRITES

_DB_FLASH_CACHE : Flash cache max read retry

_MAX_READ_RETRY

_DB_FLASH_CACHE : Flash cache maximum slow io allowed

_MAX_SLOW_IO

_DB_FLASH_CACHE : Flash cache write buffer upper limit in percentage

_WRITE_LIMIT

_DB_HANDLES : System-wide simultaneous buffer operations

_DB_HANDLES_CAC : Buffer handles cached each process

HED

_DB_HOT_BLOCK_T : track hot blocks for hash latch contention

RACKING

_DB_INDEX_BLOCK : index block checking override parameter

_CHECKING

_DB_INITIAL_CAC : size of cache created at startup

HESIZE_CREATE_M

_DB_L2_TRACING : flash cache debug tracing

_DB_LARGE_DIRTY : Number of buffers which force dirty queue to be written

_QUEUE

_DB_LOST_WRITE_ : Enable scn based lost write detection mechanism

CHECKING

_DB_LOST_WRITE_ : Enable _db_lost_write_checking tracing

TRACING

_DB_MTTR_ADVICE : MTTR advisory

_DB_MTTR_PARTIT : number of partitions for MTTR advisory

IONS

_DB_MTTR_SAMPLE : MTTR simulation sampling factor

_FACTOR

_DB_MTTR_SIM_TA : MTTR simulation targets

RGET

_DB_MTTR_SIM_TR : MTTR simulation trace size

ACE_SIZE

_DB_MTTR_TRACE_ : dump trace entries to alert file

TO_ALERT

_DB_NOARCH_DISB : Image redo logging (NOARCHIVEMODE)

LE_OPTIM

_DB_NUM_EVICT_W : number of evict wait events

AITEVENTS

_DB_NUM_GSM : database number in gsm dbpool

_DB_OBJ_ENABLE_ : enable ksr in object checkpoint/reuse

KSR

_DB_PERCENT_HOT : Percent of default buffer pool considered hot

_DEFAULT

_DB_PERCENT_HOT : Percent of keep buffer pool considered hot

_KEEP

_DB_PERCENT_HOT : Percent of recycle buffer pool considered hot

_RECYCLE

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

TE_CACHESIZE

_DB_PREFETCH_HI : maintain prefetch histogram statistics in x$kcbprfhs

STOGRAM_STATIST

ICS

_DB_RECOVERY_TE : default database recovery temporal file location

MPORAL_FILE_DES

_DB_REQUIRED_PE : percent of fairshare a processor group should always

RCENT_FAIRSHARE use

_USAGE

_DB_ROW_OVERLAP : row overlap checking override parameter for data/index

_CHECKING blocks

_DB_TODEFER_CAC : buffer cache deferred create

HE_CREATE

_DB_WRITER_CHUN : Number of writes DBWR should wait for

K_WRITES

_DB_WRITER_COAL : Size of memory allocated to dbwriter for coalescing

ESCE_AREA_SIZE writes

_DB_WRITER_COAL : Limit on size of coalesced write

ESCE_WRITE_LIMI

_DB_WRITER_FLUS : If FALSE, DBWR will not downgrade IMU txns for AGING

H_IMU

_DB_WRITER_HIST : maintain dbwr histogram statistics in x$kcbbhs

OGRAM_STATISTIC

_DB_WRITER_MAX_ : Max number of outstanding DB Writer IOs

WRITES

_DB_WRITER_NOME : Enable DBWR no-memcopy coalescing

MCOPY_COALESCE

_DB_WRITER_VERI : Enable lost write detection mechanism

FY_WRITES

_DDE_FLOOD_CONT : Initialize Flood Control at database open

ROL_INIT

_DD_VALIDATE_RE : GES deadlock detection validate remote locks

MOTE_LOCKS

_DEADLOCK_DIAGN : automatic deadlock resolution diagnostics level

OSTIC_LEVEL

_DEADLOCK_RECOR : record resolved deadlocks to the alert log

D_TO_ALERT_LOG

_DEADLOCK_RESOL : create incidents when resolving any deadlock?

UTION_INCIDENTS

_ALWAYS

_DEADLOCK_RESOL : create incidents during deadlock resolution

UTION_INCIDENTS

_ENABLED

_DEADLOCK_RESOL : automatic deadlock resolution level

UTION_LEVEL

_DEADLOCK_RESOL : the minimum wait timeout required for deadlock

UTION_MIN_WAIT_ resolution

TIMEOUT_SECS

_DEADLOCK_RESOL : the amount of time given to process a deadlock

UTION_SIGNAL_PR resolution signal

OCESS_THRESH_SE

_DEAD_PROCESS_S : PMON dead process scan interval (in seconds)

CAN_INTERVAL

_DEDICATED_SERV : dedicated server poll count

ER_POLL_COUNT

_DEDICATED_SERV : dedicated server post/wait

ER_POST_WAIT

_DEDICATED_SERV : dedicated server post/wait call

ER_POST_WAIT_CA

_DEFAULT_ENCRYP : default encryption algorithm

T_ALG

_DEFAULT_NON_EQ : sanity check on default selectivity for like/range

UALITY_SEL_CHEC predicate

_DEFERRED_CONST : Deferred constant folding mode

ANT_FOLDING_MOD

_DEFERRED_LOG_D : consider deferred log dest as valid for log deletion

EST_IS_VALID (TRUE/FALSE)

_DEFERRED_SEG_I : Enable Deferred Segment Creation in Seed

N_SEED

_DEFER_EOR_ORL_ : defer EOR ORL archival for switchover

ARCH_FOR_SO

_DEFER_LOG_BOUN : defer media recovery checkpoint at log boundary

DARY_CKPT

_DEFER_LOG_COUN : Number of log boundaries media recovery checkpoint lags

T behind

_DEFER_RCV_DURI : Defer recovery during switchover to standby

NG_SW_TO_SBY

_DEFER_SGA_ALLO : Chunk size for defer sga allocation

C_CHUNK_SIZE

_DEFER_SGA_ENAB : Enable deferred shared memory allocation for SGA

LED

_DEFER_SGA_MIN_ : Minimum shared pool size at startup with deferred sga

SPSZ_AT_STARTUP enabled

_DEFER_SGA_MIN_ : Minimum total deferred segs size for defer sga

TOTAL_DEFER_SEG allocation

S_SZ

_DEFER_SGA_TEST : SA** sleeps for N secs before allocating a deferred

_ALLOC_INTV segment

_DELAY_INDEX_MA : delays index maintenance until after MV is refreshed

INTAIN

_DELTA_PUSH_SHA : enable delta push if greater than the # of share

RE_BLOCKERS blockers

_DEQ_EXECUTE_RE : deq execute reset time

SET_TIME

_DEQ_HT_CHILD_L : deq ht child latches

ATCHES

_DEQ_HT_MAX_ELE : deq ht max elements

MENTS

_DEQ_LARGE_TXN_ : deq large txn size

SIZE

_DEQ_LOG_ARRAY_ : deq log array size

SIZE

_DEQ_MAXWAIT_TI : Change wait times between dequeue calls

_DEQ_MAX_FETCH_ : deq max fetch count

COUNT

_DESIRED_README : The desired percentage of redo reading from memory

M_RATE

_DG_BROKER_TRAC : data guard broker trace level

E_LEVEL

_DG_CF_CHECK_TI : Data Guard controlfile check timer

MER

_DG_CORRUPT_RED : Corrupt redo log validation during archivals

O_LOG

_DIAG_ADR_AUTO_ : Enable/disable ADR MMON Auto Purging

PURGE

_DIAG_ADR_ENABL : Parameter to enable/disable Diag ADR

_DIAG_ADR_TEST_ : Test parameter for Diagnosability

PARAM

_DIAG_ARB_BEFOR : dump diagnostics before killing unresponsive ARBs

E_KILL

_DIAG_BACKWARD_ : Backward Compatibility for Diagnosability

COMPAT

_DIAG_CC_ENABLE : Parameter to enable/disable Diag Call Context

_DIAG_CONF_CAP_ : Parameter to enable/disable Diag Configuration Capture

ENABLED

_DIAG_CRASHDUMP : parameter for systemstate dump level, used by DIAG

_LEVEL during crash

_DIAG_DAEMON : start DIAG daemon

_DIAG_DDE_ASYNC : diag dde async actions: message age limit (in seconds)

_AGE_LIMIT

_DIAG_DDE_ASYNC : diag dde async actions: action cputime limit (in

_CPUTIME_LIMIT seconds)

_DIAG_DDE_ASYNC : diag dde async actions: dispatch mode

_MODE

_DIAG_DDE_ASYNC : diag dde async actions: number of preallocated message

_MSGS buffers

_DIAG_DDE_ASYNC : diag dde async actions: message buffer capacity

_MSG_CAPACITY

_DIAG_DDE_ASYNC : diag dde async actions: message processing rate – per

_PROCESS_RATE loop

_DIAG_DDE_ASYNC : diag dde async actions: action runtime limit (in

_RUNTIME_LIMIT seconds)

_DIAG_DDE_ASYNC : diag dde async actions: max number of concurrent slave

_SLAVES processes

_DIAG_DDE_ENABL : enable DDE handling of critical errors

_DIAG_DDE_FC_EN : Parameter to enable/disable Diag Flood Control

ABLED

_DIAG_DDE_FC_IM : Override Implicit Error Flood Control time parameter

PLICIT_TIME

_DIAG_DDE_FC_MA : Override Macro Error Flood Control time parameter

CRO_TIME

_DIAG_DDE_INC_P : The minimum delay between two MMON incident sweeps

ROC_DELAY (minutes)

_DIAG_DIAGNOSTI : Turn off diag diagnostics

_DIAG_DUMP_REQU : DIAG dump request debug level (0-2)

EST_DEBUG_LEVEL

_DIAG_DUMP_TIME : timeout parameter for SYNC dump

OUT

_DIAG_ENABLE_ST : enable events in instance startup notifiers

ARTUP_EVENTS

_DIAG_HM_RC_ENA : Parameter to enable/disable Diag HM Reactive Checks

BLED

_DIAG_HM_TC_ENA : Parameter to enable/disable Diag HM Test(dummy) Checks

BLED

_DIAG_PROC_ENAB : enable hung process diagnostic API

LED

_DIAG_PROC_MAX_ : hung process diagnostic API max wait time in

TIME_MS milliseconds

_DIAG_PROC_STAC : hung process diagnostic API stack capture type

K_CAPTURE_TYPE

_DIAG_TEST_SEG_ : Sets trace segmentation to be in reincarnation mode

REINC_MODE

_DIAG_UTS_CONTR : UTS control parameter

_DIAG_VERBOSE_E : Allow verbose error tracing on diag init

RROR_ON_INIT

_DIAG_XM_ENABLE : If TRUE, DIAG allows message exchanges across DB/ASM

D boundary

_DIMENSION_SKIP : control dimension skip when null feature

_NULL

_DIRECT_IO_SKIP : Skip current slot on error

_CUR_SLOT_ON_ER

ROR

_DIRECT_IO_SLOT : number of slots for direct path I/O

_DIRECT_IO_WSLO : number of write slots for direct path I/O

_DIRECT_PATH_IN : disable direct path insert features

SERT_FEATURES

_DIRECT_READ_DE : enable direct read decision based on optimizer

CISION_STATISTI statistics

CS_DRIVEN

_DISABLE_12751 : disable policy timeout error (ORA-12751)

_DISABLE_12CBIG : DIsable Storing ILM Statistics in 12cBigFiles

FILE

_DISABLE_ACTIVE : disable active influx move during parallel media

_INFLUX_MOVE recovery

_DISABLE_ADAPTI : adaptive shrunk aggregation

VE_SHRUNK_AGGRE

GATION

_DISABLE_APPLIA : Disable appliance-specific code

NCE_CHECK

_DISABLE_APPLIA : Disable appliance partnering algorithms

NCE_PARTNERING

_DISABLE_AUTOTU : disable autotune global transaction background

NE_GTX processes

_DISABLE_BLOCK_ : disable block checking at the session level

CHECKING

_DISABLE_CELL_O : disable cell optimized backups

PTIMIZED_BACKUP

_DISABLE_CPU_CH : disable cpu_count check

ECK

_DISABLE_CURSOR : disable cursor sharing

_SHARING

_DISABLE_DATALA : disable datalayer sampling

YER_SAMPLING

_DISABLE_DIRECT : Disable directory link checking

ORY_LINK_CHECK

_DISABLE_DUPLEX : Turn off connection duplexing

_LINK

_DISABLE_FASTOP : Do Not Use Fastopen

_DISABLE_FAST_A : fast aggregation

GGREGATION

_DISABLE_FAST_V : disable PL/SQL fast validation

ALIDATE

_DISABLE_FBA_QR : disable flashback archiver query rewrite

_DISABLE_FBA_WP : disable flashback archiver wait for prepared

R transactions

_DISABLE_FILE_L : disable file locks for control, data, redo log files

OCKS

_DISABLE_FLASHB : disable flashback archiver

ACK_ARCHIVER

_DISABLE_FLASHB : Don’t use the Flashback Recyclebin optimization

ACK_RECYCLEBIN_

OPT

_DISABLE_FLASHB : Disable flashback wait callback

ACK_WAIT_CALLBA

_DISABLE_FUNCTI : disable function-based index matching

ON_BASED_INDEX

_DISABLE_GVAQ_C : Disable cache

ACHE

_DISABLE_HEALTH : Disable Health Check

_CHECK

_DISABLE_HIGHRE : disable high-res tick counter

S_TICKS

_DISABLE_IMAGE_ : Disable Oracle executable image checking

CHECK

_DISABLE_IMPLIC : disable implicit row movement

IT_ROW_MOVEMENT

_DISABLE_INCREM : Disable incremental checkpoints for thread recovery

ENTAL_CHECKPOIN

_DISABLE_INCREM : Disable incremental recovery checkpoint mechanism

ENTAL_RECOVERY_

CKPT

_DISABLE_INDEX_ : disable index block prefetching

BLOCK_PREFETCHI

_DISABLE_INITIA : disable initial block compression

L_BLOCK_COMPRES

SION

_DISABLE_INSTAN : disable instance type check for ksp

CE_PARAMS_CHECK

_DISABLE_INTERF : disable interface checking at startup

ACE_CHECKING

_DISABLE_KCBHXO : disable kcbh(c)xor OSD functionality

R_OSD

_DISABLE_KCBL_F : Disable KCBL flashback block new optimization

LASHBACK_BLOCKN

EW_OPT

_DISABLE_KCB_FL : Disable KCB flashback block new optimization

ASHBACK_BLOCKNE

W_OPT

_DISABLE_KGGHSH : disable kgghshcrc32chk OSD functionality

CRC32_OSD

_DISABLE_LATCH_ : disable latch-free SCN writes using 32-bit compare &

FREE_SCN_WRITES swap

_VIA_32CAS

_DISABLE_LATCH_ : disable latch-free SCN writes using 64-bit compare &

FREE_SCN_WRITES swap

_VIA_64CAS

_DISABLE_LOGGIN : Disable logging

_DISABLE_METRIC : Disable Metrics Group (or all Metrics Groups)

S_GROUP

_DISABLE_MULTIP : disable multiple block size support (for debugging)

LE_BLOCK_SIZES

_DISABLE_ODM : disable odm feature

_DISABLE_PARALL : Disable parallel conventional loads

EL_CONVENTIONAL

_LOAD

_DISABLE_PRIMAR : disable primary bitmap switch

Y_BITMAP_SWITCH

_DISABLE_READ_O : Disable read-only open dictionary check

NLY_OPEN_DICT_C

HECK

_DISABLE_REBALA : disable space usage checks for storage reconfiguration

NCE_SPACE_CHECK

_DISABLE_RECOVE : Disable the read optimization during media recovery

RY_READ_SKIP

_DISABLE_ROLLIN : Disable Rolling Patch Feature

G_PATCH

_DISABLE_SAMPLE : disable row sampling IO optimization

_IO_OPTIM

_DISABLE_SAVEPO : disable the fix for bug 1402161

INT_RESET

_DISABLE_SELFTU : Disable self-tune checkpointing

NE_CHECKPOINTIN

_DISABLE_STORAG : Disable storage type checks

E_TYPE

_DISABLE_STREAM : streams diagnostics

S_DIAGNOSTICS

_DISABLE_STREAM : disable streams pool auto tuning

S_POOL_AUTO_TUN

ING

_DISABLE_SUN_RS : Disable IPC OSD support for Sun RSMAPI

_DISABLE_SYSTEM : disable system state dump

_STATE

_DISABLE_SYSTEM : Disable system state dump – wait samples

_STATE_WAIT_SAM

PLES

_DISABLE_TEMP_T : disable tablespace alerts for TEMPORARY tablespaces

ABLESPACE_ALERT

_DISABLE_THREAD : Disable thread internal disable feature

_INTERNAL_DISAB

_DISABLE_THREAD : Thread snapshot

_SNAPSHOT

_DISABLE_TXN_AL : disable txn layer alert

ERT

_DISABLE_UNDO_T : disable tablespace alerts for UNDO tablespaces

ABLESPACE_ALERT

_DISABLE_WAIT_S : Disable wait state

TATE

_DISCRETE_TRANS : enable OLTP mode

ACTIONS_ENABLED

_DISKMON_PIPE_N : DiSKMon skgznp pipe name

AME

_DISK_SECTOR_SI : if TRUE, OSD sector size could be overridden

ZE_OVERRIDE

_DISPATCHER_RAT : scale to display rate statistic (100ths of a second)

E_SCALE

_DISPATCHER_RAT : time-to-live for rate statistic (100ths of a second)

E_TTL

_DISTINCT_VIEW_ : enables unnesting of in subquery into distinct view

UNNESTING

_DISTRIBUTED_RE : number of seconds RECO holds outbound connections open

COVERY_CONNECTI

ON_HOLD_TIME

_DLMTRACE : Trace string of global enqueue type(s)

_DML_BATCH_ERRO : number or error handles allocated for DML in batch mode

R_LIMIT

_DML_FREQUENCY_ : Control DML frequency tracking

TRACKING

_DML_FREQUENCY_ : Control automatic advance and broadcast of DML

TRACKING_ADVANC frequencies

_DML_FREQUENCY_ : Number of slots to use for DML frequency tracking

TRACKING_SLOTS

_DML_FREQUENCY_ : Time length of each slot for DML frequency tracking

TRACKING_SLOT_T

IME

_DML_MONITORING : enable modification monitoring

_ENABLED

_DM_DMF_DETAILS : set dm dmf details compatibility version

_COMPATIBILITY

_DM_ENABLE_LEGA : revert dmf output types to pre-12.1.0.1

CY_DMF_OUTPUT_T

YPES

_DM_MAX_SHARED_ : max percentage of the shared pool to use for a mining

POOL_PCT model

_DNFS_RDMA_ENAB : Enable dNFS RDMA transfers

_DNFS_RDMA_MAX : Maximum size of dNFS RDMA transfer

_DNFS_RDMA_MIN : Minimum size of dNFS RDMA transfer

_DOMAIN_INDEX_B : maximum number of rows from one call to domain index

ATCH_SIZE fetch routine

_DOMAIN_INDEX_D : maximum number of rows for one call to domain index dml

ML_BATCH_SIZE routines

_DRA_BMR_NUMBER : Maximum number of BMRs that can be done to a file

_THRESHOLD

_DRA_BMR_PERCEN : Maximum percentage of blocks in a file that can be

T_THRESHOLD BMR-ed

_DRA_ENABLE_OFF : Enable the periodic creation of the offline dictionary

LINE_DICTIONARY for DRA

_DRM_PARALLEL_F : if TRUE enables parallel drm freeze

REEZE

_DROP_FLASHBACK : Drop logical operations enqueue immediately during

_LOGICAL_OPERAT flashback marker generation

IONS_ENQ

_DROP_STAT_SEGM : drop ilm statistics segment

ENT

_DROP_TABLE_GRA : drop_table_granule

NULE

_DROP_TABLE_OPT : reduce SGA memory use during drop of a partitioned

IMIZATION_ENABL table

_DSC_FEATURE_LE : controls the feature level for deferred segment

VEL creation

_DSKM_HEALTH_CH : DiSKMon health check counter

ECK_CNT

_DSS_CACHE_FLUS : enable full cache flush for parallel execution

_DS_ENABLE_AUTO : Dynamic Sampling Service Autonomous Transaction control

_TXN parameter

_DS_IOCOUNT_IOS : Dynamic Sampling Service defaults: #IOs and IO Size

IZE

_DS_PARSE_MODEL : Dynamic Sampling Service Parse Model control parameter

_DTREE_AREA_SIZ : size of Decision Tree Classification work area

_DTREE_BINNING_ : Decision Tree Binning Enabled

ENABLED

_DTREE_BINTEST_ : Decision Tree Binning Test ID

_DTREE_COMPRESS : Decision Tree Using Compressed Bitmaps Enabled

BMP_ENABLED

_DTREE_MAX_SURR : maximum number of surrogates

OGATES

_DTREE_PRUNING_ : Decision Tree Pruning Enabled

ENABLED

_DUMMY_INSTANCE : dummy instance started by RMAN

_DUMP_10261_LEV : Dump level for event 10261, 1=>minimal dump 2=>top pga

EL dump

_DUMP_COMMON_SU : dump common subexpressions

BEXPRESSIONS

_DUMP_CONNECT_B : dump connect by loop error message into trc file

Y_LOOP_DATA

_DUMP_CURSOR_HE : dump comp/exec heap sizes to tryace file

AP_SIZES

_DUMP_INTERVAL_ : trace dump time interval limit (in seconds)

LIMIT

_DUMP_MAX_LIMIT : max number of dump within dump interval

_DUMP_QBC_TREE : dump top level query parse tree to trace

_DUMP_RCVR_IPC : if TRUE enables IPC dump at instance eviction time

_DUMP_SCN_INCRE : Dumps scn increment stack per session

MENT_STACK

_DUMP_SYSTEM_ST : scope of sysstate dump during instance termination

ATE_SCOPE

_DUMP_TRACE_SCO : scope of trace dump during a process crash

_DYNAMIC_RLS_PO : rls policies are dynamic

LICIES

_DYNAMIC_STATS_ : delay threshold (in seconds) between sending statistics

THRESHOLD messages

_EIGHTEENTH_SPA : eighteenth spare parameter – string

RE_PARAMETER

_EIGHTH_SPARE_P : eighth spare parameter – integer

ARAMETER

_ELEVENTH_SPARE : eleventh spare parameter – integer

_PARAMETER

_ELIMINATE_COMM : enables elimination of common sub-expressions

ON_SUBEXPR

_EMON_MAX_ACTIV : maximum open connections to clients per emon

E_CONNECTIONS

_EMON_OUTBOUND_ : timeout for completing connection set up to clients

CONNECT_TIMEOUT

_EMON_POOL_INC : increment in EMON slaves per pool type

_EMON_POOL_MAX : maximum number of EMON slaves per pool type

_EMON_POOL_MIN : minimum number of EMON slaves per pool type

_EMON_REGULAR_N : number of EMON slaves doing regular database

TFN_SLAVES notifications

_EMON_SEND_TIME : send timeout after which the client is unregistered

OUT

_EMX_CONTROL : EM Express control (internal use only)

_EMX_MAX_SESSIO : Maximum number of sessions in the EM Express cache

_EMX_SESSION_TI : Session timeout (sec) in the EM Express cache

MEOUT

_ENABLE_12G_BFT : enable 12g bigfile tablespace

_ENABLE_ASYNCVI : enable asynch vectored I/O

_ENABLE_AUTOMAT : if 1, Automated Maintenance Is Enabled

IC_MAINTENANCE

_ENABLE_AUTOMAT : Automatic SQL Tuning Advisory enabled parameter

IC_SQLTUNE

_ENABLE_BLOCK_L : enable block level recovery

EVEL_TRANSACTIO

N_RECOVERY

_ENABLE_CHECK_T : enable checking of corruption caused by canceled

RUNCATE truncate

_ENABLE_COLUMNA : Enable Columnar Flash Cache Rewrite

R_CACHE

_ENABLE_CSCN_CA : enable commit SCN caching for all transactions

CHING

_ENABLE_DDL_WAI : use this to turn off ddls with wait semantics

T_LOCK

_ENABLE_DEFAULT : enable default implementation of hard affinity osds

_AFFINITY

_ENABLE_DEFAULT : Enable Default Tablespace Utilization Threshold for

_TEMP_THRESHOLD UNDO Tablespaces

_ENABLE_DEFAULT : Enable Default Tablespace Utilization Threshold for

_UNDO_THRESHOLD TEMPORARY Tablespaces

_ENABLE_DML_LOC : enable dml lock escalation against partitioned tables

K_ESCALATION if TRUE

_ENABLE_EDITION : enable editions for all users

S_FOR_USERS

_ENABLE_EXCHANG : use check constraints on the table for validation

E_VALIDATION_US

ING_CHECK

_ENABLE_FAST_RE : enable fast refresh after move tablespace

F_AFTER_MV_TBS

_ENABLE_FFW : FAL FORWARDING

_ENABLE_FLASH_L : Enable Exadata Smart Flash Logging

OGGING

_ENABLE_FRONT_E : enable front end view optimization

ND_VIEW_OPTIMIZ

ATION

_ENABLE_HASH_OV : TRUE – enable hash cluster overflow based on SIZE

ERFLOW

_ENABLE_HEATMAP : heatmap related – to be used by oracle dev only

_INTERNAL

_ENABLE_HWM_SYN : enable HWM synchronization

_ENABLE_IEE_STA : enables IEE stats gathering

_ENABLE_ILM_FLU : Enable ILM Stats Flush

SH_STATS

_ENABLE_ILM_TES : Enable Test ILM Stats Flush

TFLUSH_STATS

_ENABLE_KQF_PUR : Enable KQF fixed runtime table purge

_ENABLE_LGPG_DE : Enable LGPG debug mode

BUG

_ENABLE_LIST_IO : Enable List I/O

_ENABLE_MIDTIER : enable midtier affinity metrics processing

_AFFINITY

_ENABLE_MINSCN_ : enable/disable minscn optimization for CR

_ENABLE_NATIVEN : Enable skgxp driver usage for native net

ET_TCPIP

_ENABLE_NUMA_IN : Enable NUMA interleave mode

TERLEAVE

_ENABLE_NUMA_OP : Enable NUMA specific optimizations

TIMIZATION

_ENABLE_NUMA_SU : Enable NUMA support and optimizations

PPORT

_ENABLE_OBJ_QUE : enable object queues

UES

_ENABLE_OFFLOAD : Enable offloaded writes for Unit Test

ED_WRITES

_ENABLE_ONLINE_ : Allow online index creation algorithm without S DML

INDEX_WITHOUT_S lock

_LOCKING

_ENABLE_PLUGGAB : Enable Pluggable Database

LE_DATABASE

_ENABLE_QUERY_R : mv rewrite on remote table/view

EWRITE_ON_REMOT

E_OBJS

_ENABLE_REDO_GL : LGWR post globally on write

OBAL_POST

_ENABLE_REFRESH : enable or disable MV refresh scheduling (revert to 9.2

_SCHEDULE behavior)

_ENABLE_RELIABL : Enable reliable latch waits

E_LATCH_WAITS

_ENABLE_RENAME_ : enable RENAME-clause using ALTER USER statement

USER

_ENABLE_RLB : enable RLB metrics processing

_ENABLE_ROW_SHI : use the row shipping optimization for wide table

PPING selects

_ENABLE_SB_DETE : Split Brain Detection

CTION

_ENABLE_SCHEMA_ : enable DDL operations (e.g. creation) involving schema

SYNONYMS synonyms

_ENABLE_SCN_WAI : use this to turn off scn wait interface in kta

T_INTERFACE

_ENABLE_SECUREF : Enable securefile flashback optimization

ILE_FLASHBACK_O

_ENABLE_SEPARAB : enable/disable separable transactions

LE_TRANSACTIONS

_ENABLE_SHARED_ : temporary to disable/enable kgh policy

POOL_DURATIONS

_ENABLE_SHARED_ : Enable shared server vector I/O

SERVER_VECTOR_I

_ENABLE_SPACEBG : enable space management background task

_ENABLE_SPACE_P : enable space pre-allocation

REALLOCATION

_ENABLE_TABLESP : enable tablespace alerts

ACE_ALERTS

_ENABLE_TYPE_DE : enable type dependent selectivity estimates

P_SELECTIVITY

_ENDPROT_CHUNK_ : chunk comment for selective overrun protection

COMMENT

_ENDPROT_HEAP_C : heap comment for selective overrun protection

OMMENT

_ENDPROT_SUBHEA : selective overrun protection for subeheaps

_ENQUEUE_DEADLO : enable deadlock detection on all global enqueues

CK_DETECT_ALL_G

LOBAL_LOCKS

_ENQUEUE_DEADLO : deadlock scan interval

CK_SCAN_SECS

_ENQUEUE_DEADLO : requests with timeout <= this will not have deadlock

CK_TIME_SEC detection

_ENQUEUE_DEBUG_ : debug enqueue multi instance

MULTI_INSTANCE

_ENQUEUE_HASH : enqueue hash table length

_ENQUEUE_HASH_C : enqueue hash chain latches

HAIN_LATCHES

_ENQUEUE_LOCKS : locks for managed enqueues

_ENQUEUE_PARANO : enable enqueue layer advanced debugging checks

IA_MODE_ENABLED

_ENQUEUE_RESOUR : resources for enqueues

CES

_ENQUEUE_SYNC_R : max number of times the bg process to retry synchronous

ETRY_ATTEMPTS enqueue open if it failed because master could not

allocate memory

_ENQUEUE_SYNC_S : simulate master instance running out of memory when

IM_MEM_ERROR synchronously getting a remotely mastered enqueue

_EVOLVE_PLAN_BA : Level of detail to show in plan verification/evolution

SELINE_REPORT_L report

EVEL

_EVT_SYSTEM_EVE : disable system event propagation

NT_PROPAGATION

_EXPAND_AGGREGA : expand aggregates

TES

_EXPLAIN_REWRIT : allow additional messages to be generated during

E_MODE explain rewrite

_EXTENDED_PRUNI : do runtime pruning in iterator if set to TRUE

NG_ENABLED

_EXTERNAL_SCN_L : High delta SCN threshold in seconds

OGGING_THRESHOL

D_SECONDS

_EXTERNAL_SCN_R : external SCN rejection delta threshold in minutes

EJECTION_DELTA_

THRESHOLD_MINUT

_EXTERNAL_SCN_R : Lag in hours between max allowed SCN and an external

EJECTION_THRESH SCN

OLD_HOURS

_FAIRNESS_THRES : number of times to CR serve before downgrading lock

HOLD

_FAIR_REMOTE_CV : if TRUE enables fair remote convert

_FASTPIN_ENABLE : enable reference count based fast pins

_FAST_CURSOR_RE : use more memory in order to get faster execution

EXECUTE

_FAST_DUAL_ENAB : enable/disable fast dual

LED

_FAST_FULL_SCAN : enable/disable index fast full scan

_ENABLED

_FAST_INDEX_MAI : fast global index maintenance during PMOPs

NTENANCE

_FAST_PSBY_CONV : Enable fast physical standby conversion

ERSION

_FBDA_BUSY_PERC : flashback archiver busy percentage

ENTAGE

_FBDA_DEBUG_ASS : flashback archiver debug assert for testing

ERT

_FBDA_DEBUG_MOD : flashback archiver debug event for testing

_FBDA_GLOBAL_BS : flashback archiver global barrier scn lag

CN_LAG

_FBDA_INLINE_PE : flashback archiver inline percentage

RCENTAGE

_FBDA_RAC_INACT : flashback archiver rac inactive limit

IVE_LIMIT

_FG_IORM_SLAVES : ForeGround I/O slaves for IORM

_FG_LOG_CHECKSU : Checksum redo in foreground process

_FG_SYNC_SLEEP_ : Log file sync via usleep

USECS

_FIC_ALGORITHM_ : Set Frequent Itemset Counting Algorithm

SET

_FIC_AREA_SIZE : size of Frequent Itemset Counting work area

_FIC_MAX_LENGTH : Frequent Itemset Counting Maximum Itemset Length

_FIC_MIN_BMSIZE : Frequent Itemset Counting Minimum BITMAP Size

_FIC_OUTOFMEM_C : Frequent Itemset Counting Out Of Memory Candidates

ANDIDATES Generation

_FIFTEENTH_SPAR : fifteenth spare parameter – integer

E_PARAMETER

_FIFTH_SPARE_PA : fifth spare parameter – integer

RAMETER

_FILEMAP_DIR : FILEMAP directory

_FILE_SIZE_INCR : Amount of file size increase increment, in bytes

EASE_INCREMENT

_FIRST_K_ROWS_D : enable the use of dynamic proration of join

YNAMIC_PRORATIO cardinalities

_FIRST_SPARE_PA : first spare parameter – integer

RAMETER

_FIX_CONTROL : bug fix control parameter

_FLASHBACK_11.1 : use 11.1 flashback block new optimization scheme

_BLOCK_NEW_OPT

_FLASHBACK_ALLO : Allow enabling flashback on noarchivelog database

W_NOARCHIVELOG

_FLASHBACK_ARCH : flashback archiver table partition size

IVER_PARTITION_

SIZE

_FLASHBACK_BARR : Flashback barrier interval in seconds

IER_INTERVAL

_FLASHBACK_COPY : Number of flashback copy latches

_LATCHES

_FLASHBACK_DATA : Run Flashback Database in test mode

BASE_TEST_ONLY

_FLASHBACK_DELE : Amount of flashback log (in MB) to delete in one

TE_CHUNK_MB attempt

_FLASHBACK_DYNA : enable flashback enable code path

MIC_ENABLE

_FLASHBACK_DYNA : Simulate failures during dynamic enable

MIC_ENABLE_FAIL

URE

_FLASHBACK_ENAB : Flashback enable read ahead

LE_RA

_FLASHBACK_FORM : Chunk mega-bytes for formatting flashback logs using

AT_CHUNK_MB sync write

_FLASHBACK_FORM : Chunk mega-bytes for formatting flashback logs using

AT_CHUNK_MB_DWR delayed write

ITE

_FLASHBACK_FUZZ : Use flashback fuzzy barrier

Y_BARRIER

_FLASHBACK_GENE : flashback generation buffer size

RATION_BUFFER_S

IZE

_FLASHBACK_HINT : Flashback hint barrier percent

_BARRIER_PERCEN

_FLASHBACK_LOGF : flashback logfile enqueue timeout for opens

ILE_ENQUEUE_TIM

EOUT

_FLASHBACK_LOG_ : Specify Flashback log I/O error behavior

IO_ERROR_BEHAVI

_FLASHBACK_LOG_ : Minimum flashback log size

MIN_SIZE

_FLASHBACK_LOG_ : flashback log rac balance factor

RAC_BALANCE_FAC

TOR

_FLASHBACK_LOG_ : Flashback log size

SIZE

_FLASHBACK_MARK : Enable flashback database marker cache

ER_CACHE_ENABLE

_FLASHBACK_MARK : Size of flashback database marker cache

ER_CACHE_SIZE

_FLASHBACK_MAX_ : Maximum flashback log size in bytes (OS limit)

LOG_SIZE

_FLASHBACK_MAX_ : Maximum number of flashback logs per flashback thread

N_LOG_PER_THREA

_FLASHBACK_MAX_ : Maximum time span between standby recovery sync for

STANDBY_SYNC_SP flashback

_FLASHBACK_N_LO : Desired number of flashback logs per flashback thread

G_PER_THREAD

_FLASHBACK_PREP : Prepare Flashback logs in the background

ARE_LOG

_FLASHBACK_SIZE : Size new flashback logs based on average redo log size

_BASED_ON_REDO

_FLASHBACK_STAN : Flashback standby barrier interval in seconds

DBY_BARRIER_INT

ERVAL

_FLASHBACK_VALI : validate flashback pointers in controlfile for 11.2.0.2

DATE_CONTROLFIL database

_FLASHBACK_VERB : Print verbose information about flashback database

OSE_INFO

_FLASHBACK_WRIT : Flashback writer loop limit before it returns

E_MAX_LOOP_LIMI

_FLUSH_ILM_STAT : flush ilm stats

_FLUSH_PLAN_IN_ : Plan is being flushed from an AWR flush SQL

AWR_SQL

_FLUSH_REDO_TO_ : Flush redo to standby test event parameter

STANDBY

_FLUSH_UNDO_AFT : if TRUE, flush undo buffers after TX recovery

ER_TX_RECOVERY

_FORCE_ARCH_COM : Archive Compress all newly created compressed tables

PRESS

_FORCE_DATEFOLD : force use of trunc for datefolding rewrite

_TRUNC

_FORCE_HASH_JOI : force hash join to spill to disk

N_SPILL

_FORCE_HSC_COMP : compress all newly created tables

RESS

_FORCE_LOGGING_ : force logging during upgrade mode

IN_UPGRADE

_FORCE_OLTP_COM : OLTP Compress all newly created compressed tables

PRESS

_FORCE_OLTP_UPD : OLTP Compressed row optimization on update

ATE_OPT

_FORCE_RCV_INFO : Force recovery info ping to stdby

_PING

_FORCE_REWRITE_ : control new query rewrite features

ENABLE

_FORCE_SLAVE_MA : Force slave mapping for intra partition loads

PPING_INTRA_PAR

T_LOADS

_FORCE_SYS_COMP : Sys compress

RESS

_FORCE_TEMPTABL : executes concatenation of rollups using temp tables

ES_FOR_GSETS

_FORCE_TMP_SEGM : Force tmp segment loads

ENT_LOADS

_FORWARDED_2PC_ : auto-tune threshold for two-phase commit rate across

THRESHOLD RAC instances

_FOURTEENTH_SPA : fourteenth spare parameter – integer

RE_PARAMETER

_FOURTH_SPARE_P : fourth spare parameter – integer

ARAMETER

_FRAME_CACHE_TI : number of seconds a cached frame page stay in cache.

_FULL_DIAG_ON_R : rim nodes have full DIA* function

_FULL_PWISE_JOI : enable full partition-wise join when TRUE

N_ENABLED

_FUSION_SECURIT : Fusion Security

_GBY_HASH_AGGRE : enable group-by and aggregation using hash scheme

GATION_ENABLED

_GBY_ONEKEY_ENA : enable use of one comparison of all group by keys

BLED

_GCR_CPU_MIN_FR : minimum amount of free CPU to flag an anomaly

_GCR_ENABLE_HIG : if TRUE, GCR may kill foregrounds under high load

H_CPU_KILL

_GCR_ENABLE_HIG : if TRUE, GCR may enable a RM plan under high load

H_CPU_RM

_GCR_ENABLE_HIG : if TRUE, GCR may boost bg priority under high load

H_CPU_RT

_GCR_ENABLE_HIG : if TRUE, GCR may kill foregrounds under high memory

H_MEMORY_KILL load

_GCR_ENABLE_NEW : if FALSE, revert to old drm load metric

_DRM_CHECK

_GCR_ENABLE_STA : if FALSE, revert to old cpu load metric

TISTICAL_CPU_CH

ECK

_GCR_HIGH_CPU_T : minimum amount of CPU process must consume to be kill

HRESHOLD target

_GCR_HIGH_MEMOR : minimum amount of Memory process must consume to be

Y_THRESHOLD kill target

_GCR_MAX_RT_PRO : maximum number of RT DLM processes allowed by GCR

_GCR_MEM_MIN_FR : minimum amount of free memory to flag an anomaly

_GCR_USE_CSS : if FALSE, GCR wont register with CSS nor use any CSS

feature

_GCS_DISABLE_RE : disable remote client/shadow handles

MOTE_HANDLES

_GCS_DISABLE_SK : if TRUE, disable skip close optimization in remastering

IP_CLOSE_REMAST

ERING

_GCS_DISABLE_SW : if TRUE, disable switching to local role with a writer

ITCH_ROLE_WITH_

WRITER

_GCS_FAST_RECON : if TRUE, enable fast reconfiguration for gcs locks

FIG

_GCS_LATCHES : number of gcs resource hash latches to be allocated per

LMS process

_GCS_MIN_SLAVES : if non zero, it enables the minimum number of gcs

slaves

_GCS_PKEY_HISTO : number of pkey remastering history

_GCS_PROCESS_IN : if TRUE, process gcs requests during instance recovery

_RECOVERY

_GCS_RESERVED_R : allocate the number of reserved resources in

ESOURCES reconfiguration

_GCS_RESERVED_S : allocate the number of reserved shadows in

HADOWS reconfiguration

_GCS_RESOURCES : number of gcs resources to be allocated

_GCS_RES_HASH_B : number of gcs resource hash buckets to be allocated

UCKETS

_GCS_RES_PER_BU : number of gcs resource per hash bucket

CKET

_GCS_SHADOW_LOC : number of pcm shadow locks to be allocated

_GCS_TESTING : GCS testing parameter

_GC_AFFINITY_AC : if TRUE, save the time we acquired an affinity lock

QUIRE_TIME

_GC_AFFINITY_LO : if TRUE, enable object affinity

CKING

_GC_AFFINITY_LO : if TRUE, get affinity locks

CKS

_GC_AFFINITY_RA : dynamic object affinity ratio

TIO

_GC_ASYNC_SEND : send blocks asynchronously

_GC_BYPASS_READ : if TRUE, modifications bypass readers

ERS

_GC_CHECK_BSCN : if TRUE, check for stale blocks

_GC_COALESCE_RE : if TRUE, coalesce recovery reads

COVERY_READS

_GC_CPU_TIME : if TRUE, record the gc cpu time

_GC_CR_SERVER_R : if TRUE, cr server waits for a read to complete

EAD_WAIT

_GC_DEFER_PING_ : if TRUE, restrict deferred ping to index blocks only

INDEX_ONLY

_GC_DEFER_TIME : how long to defer pings for hot buffers in milliseconds

_GC_DELTA_PUSH_ : if delta >= K bytes, compress before push

COMPRESSION

_GC_DELTA_PUSH_ : max delta level for delta push

MAX_LEVEL

_GC_DELTA_PUSH_ : objects which use delta push

OBJECTS

_GC_DISABLE_S_L : if TRUE, disable S lock BRR ping check for lost write

OCK_BRR_PING_CH protect

ECK

_GC_DOWN_CONVER : if TRUE, down-convert lock after recovery

T_AFTER_KEEP

_GC_ELEMENT_PER : global cache element percent

CENT

_GC_ESCALATE_BI : if TRUE, escalates create a bid

_GC_FG_MERGE : if TRUE, merge pi buffers in the foreground

_GC_FG_SPIN_TIM : foreground msgq spin time

_GC_FLUSH_DURIN : if TRUE, flush during affinity

G_AFFINITY

_GC_FUSION_COMP : compress fusion blocks if there is free space

RESSION

_GC_GLOBAL_CHEC : if TRUE, enable global checkpoint scn

KPOINT_SCN

_GC_GLOBAL_CPU : global cpu checks

_GC_GLOBAL_LRU : turn global lru off, make it automatic, or turn it on

_GC_GLOBAL_LRU_ : global lru touch count

TOUCH_COUNT

_GC_GLOBAL_LRU_ : global lru touch time in seconds

TOUCH_TIME

_GC_INTEGRITY_C : set the integrity check level

HECKS

_GC_KEEP_RECOVE : if TRUE, make single instance crash recovery buffers

RY_BUFFERS current

_GC_LATCHES : number of latches per LMS process

_GC_LOG_FLUSH : if TRUE, flush redo log before a current block transfer

_GC_LONG_QUERY_ : threshold for long running query

THRESHOLD

_GC_MAXIMUM_BID : maximum number of bids which can be prepared

_GC_MAX_DOWNCVT : maximum downconverts to process at one time

_GC_NO_FAIRNESS : if TRUE, no fairness if we serve a clone

_FOR_CLONES

_GC_OBJECT_QUEU : maximum length for an object queue

E_MAX_LENGTH

_GC_OVERRIDE_FO : if TRUE, try to override force-cr requests

RCE_CR

_GC_PERSISTENT_ : if TRUE, enable persistent read-mostly locking

READ_MOSTLY

_GC_POLICY_MINI : dynamic object policy minimum activity per minute

MUM

_GC_POLICY_TIME : how often to make object policy decisions in minutes

_GC_READ_MOSTLY : if TRUE, optimize flushes for read mostly objects

_FLUSH_CHECK

_GC_READ_MOSTLY : if TRUE, enable read-mostly locking

_LOCKING

_GC_SANITY_CHEC : if TRUE, sanity check CR buffers

K_CR_BUFFERS

_GC_SAVE_CLEANO : if TRUE, save cleanout to apply later

_GC_SPLIT_FLUSH : if TRUE, flush index split redo before rejecting bast

_GC_STATISTICS : if TRUE, kcl statistics are maintained

_GC_TEMP_AFFINI : if TRUE, enable global temporary affinity

_GC_TRANSFER_RA : dynamic object read-mostly transfer ratio

TIO

_GC_UNDO_AFFINI : if TRUE, enable undo affinity

_GC_UNDO_BLOCK_ : if TRUE, enable undo block disk reads

DISK_READS

_GC_VECTOR_READ : if TRUE, vector read current buffers

_GENERALIZED_PR : controls extensions to partition pruning for general

UNING_ENABLED predicates

_GES_DD_DEBUG : if 1 or higher enables GES deadlock detection debug

diagnostics

_GES_DEFAULT_LM : default lmds for enqueue hashing

_GES_DESIGNATED : designated master for GES and GCS resources

_MASTER

_GES_DIAGNOSTIC : if TRUE enables GES diagnostics

_GES_DIAGNOSTIC : systemstate level on global enqueue diagnostics blocked

S_ASM_DUMP_LEVE by ASM

_GES_DIRECT_FRE : if TRUE, free each resource directly to the freelist

_GES_DIRECT_FRE : string of resource types(s) to directly free to the

E_RES_TYPE freelist

_GES_DUMP_OPEN_ : if TRUE, dump open locks for the LCK process during

LOCKS shutdown

_GES_FGGL : DLM fg grant lock on/off

_GES_FREEABLE_R : if TRUE, free dynamic resource chunks which are

ES_CHUNK_FREE freeable

_GES_FREEABLE_R : time interval for freeing freeable dynamic resource

ES_CHUNK_FREE_I chunks

NTERVAL

_GES_GATHER_RES : if TRUE, gather resource reuse statistics

_REUSE_STATS

_GES_HASH_GROUP : enqueue hash table groups

_GES_HEALTH_CHE : if greater than 0 enables GES system health check

_GES_LMD_MAPPIN : enqueue to lmd mapping

_GES_NRES_DIVID : how to divide number of enqueue resources among hash

E tables

_GES_NUM_BLOCKE : number of blockers to be killed for hang resolution

RS_TO_KILL

_GES_RESOURCE_M : enable different level of ges res memory optimization

EMORY_OPT

_GES_SERVER_PRO : number of background global enqueue server processes

CESSES

_GLOBALINDEX_PN : enables filter for global index with partition extended

UM_FILTER_ENABL syntax

_GLOBAL_HANG_AN : the interval at which global hang analysis is run

ALYSIS_INTERVAL

_SECS

_GRANT_SECURE_R : Disallow granting of SR to NSR

OLE

_GROUPBY_NOPUSH : groupby nopushdown cut ratio

DOWN_CUT_RATIO

_GROUPBY_ORDERB : groupby/orderby don’t combine threshold

Y_COMBINE

_GSM : GSM descriptions

_GSM_CONFIG_VER : version of gsm config

_GSM_CPU_THRESH : CPU busy threshold

_GSM_DRV_INTERV : metric derived values interval

_GSM_MAX_INSTAN : maximum number of instances per database in gsm cloud

CES_PER_DB

_GSM_MAX_NUM_RE : maximum number of regions in gsm cloud

GIONS

_GSM_REGION_LIS : List of GSM Regions

_GSM_SRLAT_THRE : Single block read latency threshold

_GSM_THRESH_RES : threshold resource percentage

PCT

_GSM_THRESH_ZON : threshold zone

_GS_ANTI_SEMI_J : enable anti/semi join for the GS query

OIN_ALLOWED

_GWM_SPARE1 : gsm spare 1

_GWM_SPARE2 : gsm spare 2

_GWM_SPARE3 : gsm spare 3

_HANG_ANALYSIS_ : hang analysis num call stacks

NUM_CALL_STACKS

_HANG_BASE_FILE : Number of trace files for the normal base trace file

_COUNT

_HANG_BASE_FILE : File space limit for current normal base trace file

_SPACE_LIMIT

_HANG_BOOL_SPAR : Hang Management 1

_HANG_CROSS_BOU : Hang Management Cross Boundary detection

NDARY_HANG_DETE

CTION_ENABLED

_HANG_DELAY_RES : Hang Management delays hang resolution for library

OLUTION_FOR_LIB cache

CACHE

_HANG_DETECTION : Hang Management detection

_ENABLED

_HANG_DETECTION : Hang Management detection interval in seconds

_INTERVAL

_HANG_HANG_ANAL : if TRUE hang manager outputs hang analysis hang chains

YZE_OUTPUT_HANG

_CHAINS

_HANG_HILOAD_PR : Hang Management high load or promoted ignored hang

OMOTED_IGNORED_ count

HANG_COUNT

_HANG_HIPRIOR_S : Hang Management high priority session attribute list

ESSION_ATTRIBUT

E_LIST

_HANG_IGNORED_H : Time in seconds ignored hangs must persist after

ANGS_INTERVAL verification

_HANG_IGNORED_H : Hang Management ignored hang count

ANG_COUNT

_HANG_INT_SPARE : Hang Management 2

_HANG_LOG_VERIF : Hang Management log verified hangs to alert log

IED_HANGS_TO_AL

ERT

_HANG_LONG_WAIT : Long session wait time threshold in seconds

_TIME_THRESHOLD

_HANG_LWS_FILE_ : Number of trace files for long waiting sessions

COUNT

_HANG_LWS_FILE_ : File space limit for current long waiting session trace

SPACE_LIMIT file

_HANG_MONITOR_A : Time in seconds ignored hangs must persist after

RCHIVING_RELATE verification

D_HANG_INTERVAL

_HANG_MSG_CHECK : enable hang graph message checksum

SUM_ENABLED

_HANG_RESOLUTIO : Hang Management hang resolution allow archiving issue

N_ALLOW_ARCHIVI termination

NG_ISSUE_TERMIN

ATION

_HANG_RESOLUTIO : Hang Management hang resolution confidence promotion

N_CONFIDENCE_PR

OMOTION

_HANG_RESOLUTIO : Hang Management hang resolution global hang confidence

N_GLOBAL_HANG_C promotion

ONFIDENCE_PROMO

TION

_HANG_RESOLUTIO : Hang Management hang resolution policy

N_POLICY

_HANG_RESOLUTIO : Hang Management hang resolution promote process

N_PROMOTE_PROCE termination

SS_TERMINATION

_HANG_RESOLUTIO : Hang Management hang resolution scope

N_SCOPE

_HANG_SIGNATURE : Hang Signature List matched output frequency

_LIST_MATCH_OUT

PUT_FREQUENCY

_HANG_STATISTIC : Hang Management statistics collection interval in

S_COLLECTION_IN seconds

TERVAL

_HANG_STATISTIC : Hang Management statistics collection moving average

S_COLLECTION_MA alpha

_ALPHA

_HANG_STATISTIC : Hang Management statistics high IO percentage threshold

S_HIGH_IO_PERCE

NTAGE_THRESHOLD

_HANG_TERMINATE : Hang Management terminates sessions allowing replay

_SESSION_REPLAY

_ENABLED

_HANG_VERIFICAT : Hang Management verification interval in seconds

ION_INTERVAL

_HARD_PROTECTIO : if TRUE enable H.A.R.D specific format changes

_HASHOPS_PREFET : maximum no of rows whose relevant memory locations are

CH_SIZE prefetched

_HASH_JOIN_ENAB : enable/disable hash join

LED

_HASH_MULTIBLOC : number of blocks hash join will read/write at once

K_IO_COUNT

_HB_REDO_MSG_IN : BOC HB redo message interval in ms

TERVAL

_HEATMAP_FORMAT : heatmap related – to be used by oracle dev only

_1BLOCK

_HEATMAP_MIN_MA : Internal testing only

XSIZE

_HEUR_DEADLOCK_ : the heuristic wait time per node for deadlock

RESOLUTION_SECS resolution

_HIGHRES_DRIFT_ : allowed highres timer drift for VKTM

ALLOWED_SEC

_HIGHTHRESHOLD_ : high threshold undo_retention in seconds

UNDORETENTION

_HIGH_PRIORITY_ : High Priority Process Name Mask

PROCESSES

_HIGH_SERVER_TH : high server thresholds

RESHOLD

_HJ_BIT_FILTER_ : hash-join bit filtering threshold (0 always enabled)

THRESHOLD

_HM_ANALYSIS_OR : the oradebug system state level for hang manager hang

ADEBUG_SYS_DUMP analysis

_LEVEL

_HM_XM_ENABLED : If TRUE, DIA0 allows message exchanges across DB/ASM

boundary

_HWM_SYNC_THRES : HWM synchronization threshold in percentage

HOLD

_IDLE_SESSION_K : enables or disables resource manager session idle limit

ILL_ENABLED checks

_IDL_CONVENTION : enable conventional index maintenance for insert direct

AL_INDEX_MAINTE load

NANCE

_IDXRB_ROWINCR : proportionality constant for dop vs. rows in index

rebuild

_IGNORE_DESC_IN : ignore DESC in indexes, sort those columns ascending

_INDEX anyhow

_IGNORE_EDITION : ignore schema’s edition-enabled status during EV

_ENABLED_FOR_EV creation

_CREATION

_IGNORE_FG_DEPS : ignore fine-grain dependencies during invalidation

_ILMFLUSH_STAT_ : ILM flush statistics limit – Internal testing only

LIMIT

_ILMSET_STAT_LI : ILM set statistics limit – Internal testing only

MIT

_ILMSTAT_MEMLIM : Percentage of shared pool for use by ILM Statistics

_ILM_FILTER_TIM : Upper filter time for ILM block compression

_ILM_FILTER_TIM : Lower filter time for ILM block compression

E_LOWER

_ILM_MEM_LIMIT : percentage of the max shared pool heat-map can use –

internal

_ILM_POLICY_NAM : User specified ILM policy name

_IMAGE_REDO_GEN : Image redo generation delay in centi-seconds (direct

_DELAY write mode)

_IMMEDIATE_COMM : if TRUE, propagate commit SCN immediately

IT_PROPAGATION

_IMPROVED_OUTER : improved outer-join cardinality calculation

JOIN_CARD

_IMPROVED_ROW_L : enable the improvements for computing the average row

ENGTH_ENABLED length

_IMR_ACTIVE : Activate Instance Membership Recovery feature

_IMR_AVOID_DOUB : Avoid device voting for CSS reconfig during IMR

LE_VOTING

_IMR_CONTROLFIL : IMR controlfile access wait time in seconds

E_ACCESS_WAIT_T

IME

_IMR_DEVICE_TYP : Type of device to be used by IMR

_IMR_DISKVOTE_I : IMR disk voting implementation method

MPLEMENTATION

_IMR_DISK_VOTIN : Maximum wait for IMR disk voting (seconds)

G_INTERVAL

_IMR_EVICTED_ME : IMR issue evicted member kill after a wait

MBER_KILL

_IMR_EVICTED_ME : IMR evicted member kill wait time in seconds

MBER_KILL_WAIT

_IMR_EXTRA_RECO : Extra reconfiguration wait in seconds

NFIG_WAIT

_IMR_HIGHLOAD_T : IMR system highload threshold

HRESHOLD

_IMR_MAX_RECONF : Maximum Reconfiguration delay (seconds)

IG_DELAY

_IMR_RR_HOLDER_ : IMR max time instance is allowed to hold RR lock in

KILL_TIME seconds

_IMR_SPLITBRAIN : Maximum wait for split-brain resolution (seconds)

_RES_WAIT

_IMR_SYSTEMLOAD : Perform the system load check during IMR

_CHECK

_IMU_POOLS : in memory undo pools

_INCREMENTAL_RE : minimum number of writes for incremental recovery ckpt

COVERY_CKPT_MIN every second

_BATCH

_INDEX_JOIN_ENA : enable the use of index joins

BLED

_INDEX_LOAD_BUF : index load buf oltp sacrifice pct

_OLTP_SACRIFICE

_PCT

_INDEX_LOAD_BUF : index load buf and comp oltp under-estimation pct

_OLTP_UNDER_PCT

_INDEX_MAX_INC_ : max itl expand percentage soft limit during index

TRANS_PCT insert

_INDEX_PARTITIO : Enables large extent allocation for partitioned indices

N_LARGE_EXTENTS

_INDEX_PREFETCH : index prefetching factor

_FACTOR

_INDEX_SCAN_CHE : check and skip corrupt blocks during index scans

CK_SKIP_CORRUPT

_INDEX_SCAN_CHE : check stopkey during index range scans

CK_STOPKEY

_INIT_GRANULE_I : number of granules to process for deferred cache

NTERVAL

_INIT_SQL_FILE : File containing SQL statements to execute upon database

creation

_INJECT_STARTUP : inject fault in the startup code

_FAULT

_INLINE_SQL_IN_ : inline SQL in PL/SQL

PLSQL

_INPLACE_UPDATE : inplace update retry for ora1551

_RETRY

_INQUIRY_RETRY_ : if greater than 0 enables inquiry retry after specified

INTERVAL interval

_INSERT_ENABLE_ : during parallel inserts high water marks are brokered

HWM_BROKERED

_INST_LOCKING_P : period an instance can retain a newly acquired level1

ERIOD bitmap

_INTERCONNECT_C : if TRUE, checksum interconnect blocks

HECKSUM

_INTRAPART_PDML : Enable intra-partition updates/deletes

_ENABLED

_INTRAPART_PDML : Enable intra-partition updates/deletes with random

_RANDOMLOCAL_EN local dist

ABLED

_IN_MEMORY_TBS_ : FALSE – disable fast path for alter tablespace read

SEARCH only

_IN_MEMORY_UNDO : Make in memory undo for top level transactions

_IOCALIBRATE_IN : iocalibrate init I/Os per process

IT_IOS

_IOCALIBRATE_MA : iocalibrate max I/Os per process

X_IOS

_IOQ_FANIN_MULT : IOQ miss count before a miss exception

IPLIER

_IORM_TOUT : IORM scheduler timeout value in msec

_IOR_SERIALIZE_ : inject fault in the ior serialize code

FAULT

_IOSLAVE_BATCH_ : Per attempt IOs picked

COUNT

_IOSLAVE_ISSUE_ : IOs issued before completion check

COUNT

_IO_INTERNAL_TE : I/O internal testing parameter

_IO_OSD_PARAM : OSD specific parameter

_IO_OUTLIER_THR : Latency threshold for io_outlier table

ESHOLD

_IO_RESOURCE_MA : io resource manager always on

NAGER_ALWAYS_ON

_IO_SHARED_POOL : Size of I/O buffer pool from SGA

_SIZE

_IO_SLAVES_DISA : Do not use I/O slaves

BLED

_IO_STATISTICS : if TRUE, ksfd I/O statistics are collected

_IPC_FAIL_NETWO : Simulate cluster network failer

_IPC_TEST_FAILO : Test transparent cluster network failover

VER

_IPC_TEST_MULT_ : simulate multiple cluster networks

NETS

_IPDDB_ENABLE : Enable IPD/DB data collection

_JOB_QUEUE_INTE : Wakeup interval in seconds for job queue co-ordinator

RVAL

_K2Q_LATCHES : number of k2q latches

_KA_ALLOW_REENA : reenability of kernel accelerator service after disable

BLE

_KA_COMPATIBILI : kernel accelerator compatibility operation requirement

TY_REQUIREMENT

_KA_DOORBELL : kernel accelerator doorbell mode

_KA_LOCKS_PER_S : locks per sector in kernel accelerator

ECTOR

_KA_MODE : kernel accelerator mode

_KA_MSG_REAP_CO : maximum number of KA messages to receive and process

UNT per wait

_KA_PBATCH_MESS : kernel accelerator perform pbatch messages

AGES

_KCFIS_AUTOMEM_ : Set auto memory management control for kcfis memory

LEVEL allocation

_KCFIS_BLOCK_DU : Smart IO block dump level

MP_LEVEL

_KCFIS_CACHING_ : enable kcfis intra-scan session caching

ENABLED

_KCFIS_CELLOFLS : Enable offload server usage for passthru operations

RV_PASSTHRU_ENA

BLED

_KCFIS_CELLOFLS : Enable offload server usage for offload operations

RV_USAGE_ENABLE

_KCFIS_CELL_PAS : Allow dataonly passthru for smart scan

STHRU_DATAONLY

_KCFIS_CELL_PAS : Do not perform smart IO filtering on the cell

STHRU_ENABLED

_KCFIS_CELL_PAS : Enable automatic passthru mode when cell CPU util is

STHRU_FROMCPU_E too high

NABLED

_KCFIS_CONTROL1 : Kcfis control1

_KCFIS_CONTROL2 : Kcfis control2

_KCFIS_CONTROL3 : Kcfis control3

_KCFIS_CONTROL4 : Kcfis control4

_KCFIS_CONTROL5 : Kcfis control5

_KCFIS_CONTROL6 : Kcfis control6

_KCFIS_DISABLE_ : Don’t use platform-specific decryption on the storage

PLATFORM_DECRYP cell

TION

_KCFIS_DUMP_COR : Dump any corrupt blocks found during smart IO

RUPT_BLOCK

_KCFIS_FAST_RES : Enable smart scan optimization for fast response (first

PONSE_ENABLED rows)

_KCFIS_FAST_RES : Fast response – The size of the first IO in logical

PONSE_INITIOSIZ blocks

_KCFIS_FAST_RES : Fast response – (next IO size = current IO size * this

PONSE_IOSIZEMUL parameter)

_KCFIS_FAST_RES : Fast response – the number of IOs after which smartIO

PONSE_THRESHOLD is used

_KCFIS_FAULT_CO : Fault Injection Control

NTROL

_KCFIS_IOREQS_T : Enable Smart IO requests throttling

HROTTLE_ENABLED

_KCFIS_IO_PREFE : Smart IO prefetch size for a cell

TCH_SIZE

_KCFIS_KEPT_IN_ : Enable usage of cellsrv flash cache for kept objects

CELLFC_ENABLED

_KCFIS_LARGE_PA : enable large payload to be passed to cellsrv

YLOAD_ENABLED

_KCFIS_MAX_CACH : Sets the maximum number of kcfis sessions cached

ED_SESSIONS

_KCFIS_MAX_OUT_ : Sets the maximum number of outstanding translations in

TRANSLATIONS kcfis

_KCFIS_NONKEPT_ : Enable use of cellsrv flash cache for non-kept objects

IN_CELLFC_ENABL

_KCFIS_OSS_IO_S : KCFIS OSS I/O size

IZE

_KCFIS_QM_PRIOR : Prioritize Quaranitine Manager system plan

ITIZE_SYS_PLAN

_KCFIS_QM_USER_ : Quaranitine Manager user plan name

PLAN_NAME

_KCFIS_RDBMS_BL : Use block IO instead of smart IO in the smart IO module

OCKIO_ENABLED on RDBMS

_KCFIS_READ_BUF : KCFIS Read Buffer (per session) memory limit in bytes

FER_LIMIT

_KCFIS_SPAWN_DE : Decides whether to spawn the debugger at kcfis

BUGGER initialize

_KCFIS_STATS_LE : sets kcfis stats level

VEL

_KCFIS_STORAGEI : Debug mode for storage index on the cell

DX_DIAG_MODE

_KCFIS_STORAGEI : Don’t use storage index optimization on the storage

DX_DISABLED cell

_KCFIS_TEST_CON : kcfis tst control1

TROL1

_KCFIS_TRACE_BU : KCFIS tracing bucket size in bytes

CKET_SIZE

_KCL_COMMIT : if TRUE, call kjbcommit

_KCL_CONSERVATI : if TRUE, conservatively log flush before CR serving

VE_LOG_FLUSH

_KCL_DEBUG : if TRUE, record le history

_KCL_INDEX_SPLI : if TRUE, reject pings on blocks in middle of a split

_KDBL_ENABLE_PO : allocate dbas after populating data buffers

ST_ALLOCATION

_KDIC_SEGARR_SZ : size threshold for segmented arrays for

seg_info_kdicctx

_KDIS_REJECT_LE : b+tree level to enable rejection limit

VEL

_KDIS_REJECT_LI : #block rejections in space reclamation before segment

MIT extension

_KDIS_REJECT_OP : enable rejection heuristic for branch splits

_KDIZOLTP_UNCOM : kdizoltp uncomp sentinal frequency

PSENTINAL_FREQ

_KDI_AVOID_BLOC : avoid index block checking on sensitive opcodes

K_CHECKING

_KDLF_READ_FLAG : kdlf read flag

_KDLI_ALLOW_COR : allow corrupt filesystem_logging data blocks during

RUPT read/write

_KDLI_BUFFER_IN : use buffer injection for CACHE [NO]LOGGING lobs

JECT

_KDLI_CACHEABLE : minimum lob length for inode cacheability

_LENGTH

_KDLI_CACHE_INO : cache inode state across calls

_KDLI_CACHE_REA : minimum lob size for cache->nocache read (0 disables

D_THRESHOLD heuristic)

_KDLI_CACHE_SIZ : maximum #entries in inode cache

_KDLI_CACHE_VER : verify cached inode via deserialization

IFY

_KDLI_CACHE_WRI : minimum lob size for cache->nocache write (0 disables

TE_THRESHOLD heuristic)

_KDLI_CHECKPOIN : do not invalidate cache buffers after write

T_FLUSH

_KDLI_DBC : override db_block_checking setting for securefiles

_KDLI_DELAY_FLU : delay flushing cache writes to direct-write lobs

SHES

_KDLI_DESCN_ADJ : coalesce extents with deallocation scn adjustment

_KDLI_FLUSH_CAC : flush cache-reads data blocks after load

HE_READS

_KDLI_FLUSH_INJ : flush injected buffers of CACHE NOLOGGING lobs before

ECTIONS commit

_KDLI_FORCE_CR : force CR when reading data blocks of direct-write lobs

_KDLI_FORCE_CR_ : force CR when reading metadata blocks of direct-write

META lobs

_KDLI_FORCE_STO : force storage settings for all lobs

RAGE

_KDLI_FULL_READ : maximum lob size for full readahead

AHEAD_THRESHOLD

_KDLI_INJECT_AS : inject asserts into the inode

SERT

_KDLI_INJECT_BA : buffer injection batch size [1, KCBNEWMAX]

TCH

_KDLI_INJECT_CR : inject crashes into the inode

ASH

_KDLI_INLINE_XF : allow inline transformed lobs

_KDLI_INODE_PRE : inline inode evolution preference (data, headless, lhb)

FERENCE

_KDLI_INPLACE_O : maximum inplace overwrite size (> chunksize)

VERWRITE

_KDLI_ITREE_ENT : #entries in lhb/itree blocks (for testing only)

RIES

_KDLI_MEMORY_PR : trace accesses to inode memory outside kdli API

OTECT functions

_KDLI_MTS_SO : use state objects in shared server for asyncIO

pipelines

_KDLI_ONEBLK : allocate chunks as single blocks

_KDLI_PREALLOCA : preallocation mode for lob growth

TION_MODE

_KDLI_PREALLOCA : percentage preallocation [0 .. inf) for lob growth

TION_PCT

_KDLI_RALC_LENG : lob length threshold to trigger rounded allocations

_KDLI_RALC_ROUN : rounding granularity for rounded allocations

DING

_KDLI_RCI_LOBMA : #entries in RCI lobmap before migration to lhb

P_ENTRIES

_KDLI_READAHEAD : shared/cached IO readahead limit

_LIMIT

_KDLI_READAHEAD : shared/cached IO readahead strategy

_STRATEGY

_KDLI_RECENT_SC : use recent (not dependent) scns for block

N format/allocation

_KDLI_RESHAPE : reshape an inode to inline or headless on length

truncation

_KDLI_SAFE_CALL : invoke inode read/write callbacks safely

BACKS

_KDLI_SIO_ASYNC : asynchronous shared IO

_KDLI_SIO_BACKO : use exponential backoff when attempting SIOP

FF allocations

_KDLI_SIO_BPS : maximum blocks per IO slot

_KDLI_SIO_DOP : degree-of-parallelism in the SIO keep pool

_KDLI_SIO_FBWRI : percentage of buffer used for direct writes in

TE_PCT flashback-db

_KDLI_SIO_FGIO : reap asynchronous IO in the foreground

_KDLI_SIO_FILEO : shared IO fileopen mode: datasync vs nodatasync vs

PEN async

_KDLI_SIO_FLUSH : enable shared IO pool operations

_KDLI_SIO_FREE : free IO buffers when not in active use

_KDLI_SIO_MIN_R : shared IO pool read threshold

EAD

_KDLI_SIO_MIN_W : shared IO pool write threshold

RITE

_KDLI_SIO_NBUFS : maximum #IO buffers to allocate per session

_KDLI_SIO_NIODS : maximum #IO descriptors to allocate per session

_KDLI_SIO_ON : enable shared IO pool operations

_KDLI_SIO_PGA : use PGA allocations for direct IO

_KDLI_SIO_PGA_T : PGA allocations come from toplevel PGA heap

_KDLI_SIO_STRAT : shared IO strategy: block vs. extent

EGY

_KDLI_SIO_WRITE : percentage of buffer used for direct writes

_PCT

_KDLI_SMALL_CAC : size limit of small inode cache

HE_LIMIT

_KDLI_SORT_DBAS : sort dbas during chunkification

_KDLI_SPACE_CAC : maximum size of the space cache in #blocks

HE_LIMIT

_KDLI_SQUEEZE : compact lobmap extents with contiguous dbas

_KDLI_STOP_BSZ : undocumented parameter for internal use only

_KDLI_STOP_DBA : undocumented parameter for internal use only

_KDLI_STOP_FSZ : undocumented parameter for internal use only

_KDLI_STOP_NIO : undocumented parameter for internal use only

_KDLI_STOP_TSN : undocumented parameter for internal use only

_KDLI_TIMER_DMP : dump inode timers on session termination

_KDLI_TIMER_TRC : trace inode timers to uts/tracefile

_KDLI_TRACE : inode trace level

_KDLI_VLL_DIREC : use skip-navigation and direct-positioning in

T vll-domain

_KDLU_MAX_BUCKE : UTS kdlu bucket size

T_SIZE

_KDLU_MAX_BUCKE : UTS kdlu bucket size for mts

T_SIZE_MTS

_KDLU_TRACE_LAY : UTS kdlu per-layer trace level

_KDLU_TRACE_SYS : UTS system dump

TEM

_KDLWP_FLUSH_TH : WGC flush threshold in bytes

RESHOLD

_KDLW_ENABLE_KS : enable ksi locking for lobs

I_LOCKING

_KDLW_ENABLE_WR : enable lob write gathering for sql txns

ITE_GATHERING

_KDLXP_CMP_SUBU : size of compression sub-unit in bytes

NIT_SIZE

_KDLXP_DEDUP_FL : deduplication flush threshold in bytes

USH_THRESHOLD

_KDLXP_DEDUP_HA : secure hash algorithm for deduplication – only on

SH_ALGO SecureFiles

_KDLXP_DEDUP_IN : deduplication pct size increase by which inlining

L_PCTFREE avoided

_KDLXP_DEDUP_PR : deduplication prefix hash threshold in bytes

EFIX_THRESHOLD

_KDLXP_DEDUP_WA : deduplication length to allow write-append

PP_LEN

_KDLXP_LOBCMPAD : enable adaptive compression – only on SecureFiles

_KDLXP_LOBCMPLE : Default securefile compression

VEL

_KDLXP_LOBCMPRC : Default securefile compression map version

IVER

_KDLXP_LOBCOMPR : enable lob compression – only on SecureFiles

ESS

_KDLXP_LOBDEDUP : enable lob deduplication – only on SecureFiles

LICATE

_KDLXP_LOBDEDUP : enable deduplicate validate – only on SecureFiles

VALIDATE

_KDLXP_LOBENCRY : enable lob encryption – only on SecureFiles

_KDLXP_MINCMP : minimum comp ratio in pct – only on SecureFiles

_KDLXP_MINCMPLE : minimum loblen to compress – only on SecureFiles

_KDLXP_MINXFM_S : minimum transformation size in bytes

IZE

_KDLXP_SPARE1 : deduplication spare 1

_KDLXP_UNCMP : lob data uncompressed – only on SecureFiles

_KDLXP_XFMCACHE : enable xfm cache – only on SecureFiles

_KDTGSP_RETRIES : max number of retries in kdtgsp if space returns same

block

_KDT_BUFFERING : control kdt buffering for conventional inserts

_KDU_ARRAY_DEPT : array update retry recursion depth limits

_KDZ_HCC_FLAGS : Miscellaneous HCC flags

_KDZ_HCC_TRACK_ : Enable rowid tracking during updates

UPD_RIDS

_KDZ_PRED_NROWS : Number of rows to predicate at a time in kdzt

_KDZ_PROJ_NROWS : Number of rows to project at a time in kdzt

_KD_SYMTAB_CHK : enable or disable symbol table integrity block check

_KEBM_NSTRIKES : kebm # strikes to auto suspend an action

_KEBM_SUSPENSIO : kebm auto suspension time in seconds

N_TIME

_KECAP_CACHE_SI : Workload Replay INTERNAL parameter used to set memory

ZE usage in Application Replay

_KEEP_REMOTE_CO : remote column size does not get modified

LUMN_SIZE

_KERNEL_MESSAGE : kernel message network driver

_NETWORK_DRIVER

_KES_PARSE_MODE : SQL Tune/SPA KES Layer Parse Model control parameter

_KFFMAP_HASH_SI : size of kffmap_hash table

_KFFMLK_HASH_SI : size of kffmlk_hash table

_KFFMOP_CHUNKS : number of chunks of kffmop’s

_KFFMOP_HASH_SI : size of kffmop_hash table

_KFM_DISABLE_SE : disable set fence calls and revert to default (process

T_FENCE fence)

_KGHDSIDX_COUNT : max kghdsidx count

_KGLSIM_MAXMEM_ : max percentage of shared pool size to be used for KGL

PERCENT advice

_KGL_BUCKET_COU : Library cache hash table bucket count

NT (2^_kgl_bucket_count * 256)

_KGL_CAP_HD_ALO : capture stacks for library cache handle allocation

_STACKS

_KGL_CLUSTER_LO : Library cache support for cluster lock

_KGL_CLUSTER_LO : Library cache support for cluster lock read mostly

CK_READ_MOSTLY optimization

_KGL_CLUSTER_PI : Library cache support for cluster pins

_KGL_DEBUG : Library cache debugging

_KGL_FIXED_EXTE : fixed extent size for library cache memory allocations

NTS

_KGL_HASH_COLLI : Library cache name hash collision possible

SION

_KGL_HEAP_SIZE : extent size for library cache heap 0

_KGL_HOT_OBJECT : Number of copies for the hot object

_COPIES

_KGL_KQR_CAP_SO : capture stacks for library and row cache state objects

_STACKS

_KGL_LARGE_HEAP : maximum heap size before KGL writes warnings to the

_WARNING_THRESH alert log

OLD

_KGL_LATCH_COUN : number of library cache latches

_KGL_MESSAGE_LO : RAC message lock count

CKS

_KGL_MIN_CACHED : Minimum cached SO count. If > 1 can help find SO

_SO_COUNT corruptions

_KGL_TIME_TO_WA : time to wait for locks and pins before timing out

IT_FOR_LOCKS

_KGSB_THRESHOLD : threshold size for base allocator

_SIZE

_KGX_LATCHES : # of mutex latches if CAS is not supported.

_KILL_CONTROLFI : enable killing controlfile enqueue blocker on timeout

LE_ENQUEUE_BLOC

KER

_KILL_DIAGNOSTI : timeout delay in seconds before killing enqueue blocker

CS_TIMEOUT

_KILL_ENQUEUE_B : if greater than 0 enables killing enqueue blocker

LOCKER

_KILL_java_THRE : Kill Java threads and do sessionspace migration at end

ADS_ON_EOC of call

_KILL_SESSION_D : Process dump on kill session immediate

UMP

_KJAC_FORCE_OUT : if TRUE, enable to run force outcome on the current

COME_CURRENT_SE session

SSION

_KJDD_CALL_STAC : Enables printing of short call stack with the WFG

K_DUMP_ENABLED

_KJDD_WFG_DUMP_ : To control the way Wait-For_Graph is dumped

CNTRL

_KJLTMAXGT : record latch requests that takes longer than this many

_KJLTMAXHT : record latch reqeust that are held longer than this

many us

_KJLTON : track DLM latch usage on/off

_KKFI_TRACE : trace expression substitution

_KKS_FREE_CURSO : percentage of cursor stats buckets to scan on each

R_STAT_PCT load, in 1/10th of a percent

_KOKLI_CACHE_SI : Size limit of ADT Table Lookup Cache

_KOKLN_CURRENT_ : Make all LOB reads for this session ‘current’ reads

READ

_KOLFUSESLF : allow kolf to use slffopen

_KQDSN_MAX_INST : maximum bits used for instance value in sequence

ANCE_BITS partition

_KQDSN_MIN_INST : minimum bits used for instance value in sequence

ANCE_BITS partition

_KQDSN_PARTITIO : ratio of instance to session bits in sequence partition

N_RATIO

_KQL_SUBHEAP_TR : tracing level for library cache subheap level pins

ACE

_KQR_OPTIMISTIC : optimistic reading of row cache objects

_READS

_KSB_RESTART_CL : process uptime for restarts

EAN_TIME

_KSB_RESTART_PO : process restart policy times in seconds

LICY_TIMES

_KSDXDOCMD_DEFA : default timeout for internal oradebug commands

ULT_TIMEOUT_MS

_KSDXDOCMD_ENAB : if TRUE ksdxdocmd* invocations are enabled

LED

_KSDXW_CINI_FLG : ksdxw context initialization flag

_KSDXW_NBUFS : ksdxw number of buffers in buffered mode

_KSDXW_NUM_PGW : number of watchpoints on a per-process basis

_KSDXW_NUM_SGW : number of watchpoints to be shared by all processes

_KSDXW_STACK_DE : number of PCs to collect in the stack when watchpoint

PTH is hit

_KSDX_CHARSET_R : ratio between the system and oradebug character set

ATIO

_KSD_TEST_PARAM : KSD test parmeter

_KSE_DIE_TIMEOU : amount of time a dying process is spared by PMON (in

T centi-secs)

_KSE_PC_TABLE_S : kse pc table cache size

IZE

_KSE_SIGNATURE_ : number of entries in the kse stack signature cache

ENTRIES

_KSE_SIGNATURE_ : number of stack frames to cache per kse signature

LIMIT

_KSE_SNAP_RING_ : should error snap ring entries show a short stack trace

RECORD_STACK

_KSE_SNAP_RING_ : ring buffer to debug internal error 17090

SIZE

_KSE_TRACE_INT_ : enables soft assert of KGECLEAERERROR is cleares an

MSG_CLEAR interrupt message

_KSFD_VERIFY_WR : verify asynchronous writes issued through ksfd

ITE

_KSIPC_LIBIPC_P : over-ride default location of libipc

ATH

_KSIPC_MODE : ksipc mode

_KSIPC_SPARE_PA : ksipc spare param 1

RAM1

_KSIPC_SPARE_PA : ksipc spare param 2

RAM2

_KSIPC_WAIT_FLA : tune ksipcwait

_KSI_CLIENTLOCK : if TRUE, DLM-clients can provide the lock memory

S_ENABLED

_KSI_TRACE : KSI trace string of lock type(s)

_KSI_TRACE_BUCK : memory tracing: use ksi-private or rdbms-shared bucket

_KSI_TRACE_BUCK : size of the KSI trace bucket

ET_SIZE

_KSMB_DEBUG : ksmb debug flags

_KSMD_PROTECT_M : KSMD protect mode for catching stale access

ODE

_KSMG_GRANULE_L : granule locking status

OCKING_STATUS

_KSMG_GRANULE_S : granule size in bytes

IZE

_KSMG_LOCK_CHEC : timeout action interval in minutes

K_INTERVAL

_KSMG_LOCK_REAC : repeat count for acquisition of locks

QUIRE_COUNT

_KSMLSAF : KSM log alloc and free

_KSM_POST_SGA_I : seconds to delay instance startup at sga initialization

NIT_NOTIF_DELAY (post)

_SECS

_KSM_PRE_SGA_IN : seconds to delay instance startup at sga initialization

IT_NOTIF_DELAY_ (pre)

SECS

_KSPOL_TAC_TIME : timeouts for TAC registerd by kspol

OUT

_KSR_UNIT_TEST_ : number of ksr unit test processes

PROCESSES

_KSS_CALLSTACK_ : state object callstack trace type

TYPE

_KSS_QUIET : if TRUE access violations during kss dumps are not

recorded

_KSUITM_ADDON_T : command to execute when dead processes don’t go away

RCCMD

_KSUITM_DONT_KI : delay inst. termination to allow processes to dump

LL_DUMPER

_KSU_DIAG_KILL_ : number of seconds ksuitm waits before killing diag

TIME

_KSVPPKTMODE : ksv internal pkt test

_KSV_DYNAMIC_FL : ksv dynamic flags 1 – override default behavior

AGS1

_KSV_MAX_SPAWN_ : bg slave spawn failure limit

FAIL_LIMIT

_KSV_POOL_HANG_ : bg slave pool terminate timeout

KILL_TO

_KSV_POOL_WAIT_ : bg slave pool wait limit

TIMEOUT

_KSV_SLAVE_EXIT : slave exit timeout

_TIMEOUT

_KSV_SPAWN_CONT : control all spawning of background slaves

ROL_ALL

_KSV_STATIC_FLA : ksv static flags 1 – override default behavior

GS1

_KSXP_COMPAT_FL : ksxp compat flags

AGS

_KSXP_CONTROL_F : modify ksxp behavior

LAGS

_KSXP_DIAGMODE : set to OFF to disable automatic slowsend diagnostics

_KSXP_DISABLE_C : disable CLSS interconnects

LSS

_KSXP_DISABLE_D : disable dynamic loadin of lib skgxp

YNAMIC_LOADING

_KSXP_DISABLE_I : disable ipc statistics

PC_STATS

_KSXP_DISABLE_R : disable possibility of starting rolling migration

OLLING_MIGRATIO

_KSXP_DUMP_TIME : set timeout for kjzddmp request

OUT

_KSXP_DYNAMIC_S : dynamic skgxp parameters

KGXP_PARAM

_KSXP_IF_CONFIG : ksxp if config flags

_KSXP_INIT_STAT : initial number arrays for ipc statistics

S_BKTS

_KSXP_LWIPC_ENA : enable lwipc for KSXP

BLED

_KSXP_MAX_STATS : max. arrays for ipc statistics

_BKTS

_KSXP_PING_ENAB : disable dynamic loadin of lib skgxp

_KSXP_PING_POLL : max. arrays for ipc statistics

ING_TIME

_KSXP_REAPING : tune ksxp layer reaping limit

_KSXP_REPORTING : reporting process for KSXP

_PROCESS

_KSXP_SEND_TIME : set timeout for sends queued with the inter-instance

OUT IPC

_KSXP_SKGXPG_LA : last defined skgxpg parameter – ksxp

ST_PARAMETER

_KSXP_SKGXP_ANT : SKGXP ANT options

_OPTIONS

_KSXP_SKGXP_COM : over-ride default location of lib skgxp compat

PAT_LIBRARY_PAT

_KSXP_SKGXP_CTX : IPC debug options flags (RAC)

_FLAGS1

_KSXP_SKGXP_CTX : IPC debug options flags mask (RAC)

_FLAGS1MASK

_KSXP_SKGXP_DYN : IPC protocol override (RAC)

AMIC_PROTOCOL (0/-1=*,2=UDP,3=RDS,!0x1000=ipc_X)

_KSXP_SKGXP_INE : limit SKGXP networks

_KSXP_SKGXP_LIB : over-ride default location of lib skgxp

RARY_PATH

_KSXP_SKGXP_RGN : region socket limits (0xFFFFNNXX): F=flags, N=min,

_PORTS X=max

_KSXP_SKGXP_SPA : ipc ksxp spare parameter 1

RE_PARAM1

_KSXP_SKGXP_SPA : ipc ksxp spare parameter 2

RE_PARAM2

_KSXP_SKGXP_SPA : ipc ksxp spare parameter 3

RE_PARAM3

_KSXP_SKGXP_SPA : ipc ksxp spare parameter 4

RE_PARAM4

_KSXP_SKGXP_SPA : ipc ksxp spare parameter 5

RE_PARAM5

_KSXP_STATS_MEM : limit ipc statistics memory. this parameter is a

_LMT percentage value

_KSXP_TESTING : KSXP test parameter

_KSXP_UNIT_TEST : enable byte transformation unit test

_BYTE_TRANSFORM

ATION

_KSXP_WAIT_FLAG : tune ksxpwait

_KTB_DEBUG_FLAG : ktb-layer debug flags

_KTC_DEBUG : for ktc debug

_KTC_LATCHES : number of ktc latches

_KTILMSC_EXP : expiration time of ktilm segment cache (in second)

_KTSLJ_SEGEXT_M : segment pre-extension max size in MB (0: unlimited)

AX_MB

_KTSLJ_SEGEXT_R : segment pre-extension retry

ETRY

_KTSLJ_SEGEXT_W : segment pre-extension warning threshold in percentage

ARNING

_KTSLJ_SEGEXT_W : segment pre-extension warning threshold in MB

ARNING_MB

_KTSPSRCH_MAXSC : maximum segments supported by space search cache

_KTSPSRCH_MAXSK : space search cache rejection skip upper limit

_KTSPSRCH_SCCHK : cleanout check time of space search cache

_KTSPSRCH_SCEXP : expiration time of space search cache

_KTST_RSS_MAX : maximum temp extents to be released across instance

_KTST_RSS_MIN : minimum temp extents to be released across instance

_KTST_RSS_RETRY : maximum retries of sort segment release

_KTTEXT_WARNING : tablespace pre-extension warning threshold in

percentage

_KTU_LATCHES : number of KTU latches

_KU_TRACE : datapump trace parameter

_KXDBIO_CTX_INI : initial count of KXDBIO state object

T_COUNT

_KXDBIO_DISABLE : KXDBIO Disable offload for the set opcodes. Value is a

_OFFLOAD_OPCODE Bitmap of 0x00000001 – disable cell to cell data

copy offload 0x00000002 – disable disk scrubbing

offload to cell 0x00000004 – disable offloaded

writes to cell

_KXDBIO_ENABLE_ : KXDBIO Enable Dumb storage simulation for the set

DS_OPCODE opcodes.

_KXDBIO_HCA_LOA : HCA loadavg threshold at which writes need to get

DAVG_THRESH offloaded

_KXDBIO_UT_CTL : kxdbio unit test controls

_LARGE_POOL_MIN : minimum allocation size in bytes for the large

_ALLOC allocation pool

_LAST_ALLOCATIO : period over which an instance can retain an active

N_PERIOD level1 bitmap

_LATCH_CLASSES : latch classes override

_LATCH_CLASS_0 : latch class 0

_LATCH_CLASS_1 : latch class 1

_LATCH_CLASS_2 : latch class 2

_LATCH_CLASS_3 : latch class 3

_LATCH_CLASS_4 : latch class 4

_LATCH_CLASS_5 : latch class 5

_LATCH_CLASS_6 : latch class 6

_LATCH_CLASS_7 : latch class 7

_LATCH_MISS_STA : Sid of process for which to collect latch stats

T_SID

_LATCH_WAIT_LIS : Time to sleep on latch wait list until getting priority

T_PRI_SLEEP_SEC

_LDR_IO_SIZE : size of write IOs used during a load operation

_LDR_IO_SIZE2 : size of write IOs used during a load operation of EHCC

with HWMB

_LDR_PGA_LIM : pga limit, beyond which new partition loads are delayed

_LDR_TEMPSEG_TH : amount to buffer prior to allocating temp segment

RESHOLD (extent sizing)

_LEFT_NESTED_LO : enable random distribution method for left of

OPS_RANDOM nestedloops

_LGWR_DELAY_WRI : LGWR write delay for debugging

_LGWR_IO_OUTLIE : LGWR I/O outlier frequency

_LGWR_IO_SLAVES : LGWR I/O slaves

_LGWR_MAX_NS_WT : Maximum wait time for lgwr to allow NetServer to

progress

_LGWR_NS_NL_MAX : Variable to simulate network latency or buffer

threshold

_LGWR_NS_NL_MIN : Variable to simulate network latency or buffer

threshold

_LGWR_NS_SIM_ER : Variable to simulate errors lgwrns

_LGWR_POSTS_FOR : LGWR posts commit waiters for pending broadcasts

_PENDING_BCASTS

_LGWR_TA_SIM_ER : Variable to simulate errors lgwr true async

_LIBRARY_CACHE_ : whether KGL advice should be turned on

ADVICE

_LIGHTWEIGHT_HD : Lightweight headers for redo

_LIKE_WITH_BIND : treat LIKE predicate with bind as an equality predicate

_AS_EQUALITY

_LIMIT_ITLS : limit the number of ITLs in OLTP Compressed Tables

_LINUX_PREPAGE_ : prepage large pages during allocation on Linux

LARGE_PAGES

_LMN_COMPRESSIO : suppl logging for compression enabled

_LM_ACTIVATE_LM : threshold value to activate an additional lms

S_THRESHOLD

_LM_ASM_ENQ_HAS : if TRUE makes ASM use enqueue master hashing for fusion

HING locks

_LM_BATCH_COMPR : GES threshold to start compression on batch messages

ESSION_THRESHOL

_LM_BETTER_DDVI : GES better deadlock victim

CTIM

_LM_BIG_CLUSTER : enable certain big cluster optimizations in drm

_OPTIMIZATIONS

_LM_BROADCAST_R : Enable broadcast of highest held mode of resource.

_LM_BROADCAST_R : Trace string of resource type(s)

ESNAME

_LM_CACHE_ALLOC : ratio of cached over allocated resources

ATED_RES_RATIO

_LM_CACHE_LVL0_ : how often to cleanup level 0 cache res (in sec)

CLEANUP

_LM_CACHE_RES_C : percentage of cached resources should be cleanup

LEANUP

_LM_CACHE_RES_C : max number of batches of cached resources to free per

LEANUP_TRIES cleanup

_LM_CACHE_RES_O : ges resource cache options

PTIONS

_LM_CACHE_RES_S : multiple of iniital res cache below which cleanup is

KIP_CLEANUP skipped

_LM_CACHE_RES_T : cache resource: string of lock types(s)

YPE

_LM_CHECKSUM_BA : GES checksum batch messages

TCH_MSG

_LM_COMM_CHANNE : GES communication channel type

_LM_COMM_MSGQ_B : busy wait time in microsecond for msgq

USYWAIT

_LM_COMM_REAP_C : message reap count for receive

OUNT

_LM_COMM_TKTS_A : Ticket allocation addition factor

DD_FACTOR

_LM_COMM_TKTS_C : Weighted average calculation interval length (second)

ALC_PERIOD_LENG

_LM_COMM_TKTS_M : Max number of periods used in weighted avearage

AX_PERIODS calculation

_LM_COMM_TKTS_M : Time to wait before allowing an allocation decrease

IN_DECREASE_WAI

_LM_COMM_TKTS_M : Time to wait before allowing an allocation increase

IN_INCREASE_WAI

_LM_COMM_TKTS_M : Ticket allocation multiplication factor

ULT_FACTOR

_LM_COMM_TKTS_N : Null request frequency threshold (percentage)

ULLREQ_THRESHOL

_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

_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

_LM_ENABLE_AFF_ : enables affinity benefit computations if TRUE

BENEFIT_STATS

_LM_ENQUEUE_BLO : enqueue blocker dump timeout

CKER_DUMP_TIMEO

_LM_ENQUEUE_BLO : enqueue blocker dump timeout count

CKER_DUMP_TIMEO

UT_CNT

_LM_ENQUEUE_BLO : enqueue blocker kill timeout

CKER_KILL_TIMEO

_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

_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

_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

_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

_LM_HIGH_LOAD_S : high watermark system load percentage

YSLOAD_PERCENTA

_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

_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

_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

_LM_LOCAL_HP_EN : use static file affinity for HP enqueue mastership

_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

_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

_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

_LM_RAC_SPARE_D : rac parameter dp10

P10

_LM_RAC_SPARE_D : rac parameter dp2

_LM_RAC_SPARE_D : rac parameter dp3

_LM_RAC_SPARE_D : rac parameter dp4

_LM_RAC_SPARE_D : rac parameter dp5

_LM_RAC_SPARE_D : rac parameter dp6

_LM_RAC_SPARE_D : rac parameter dp7

_LM_RAC_SPARE_D : rac parameter dp8

_LM_RAC_SPARE_D : rac parameter dp9

_LM_RAC_SPARE_P : rac parameter p1

_LM_RAC_SPARE_P : rac parameter p10

_LM_RAC_SPARE_P : rac parameter p2

_LM_RAC_SPARE_P : rac parameter p3

_LM_RAC_SPARE_P : rac parameter p4

_LM_RAC_SPARE_P : rac parameter p5

_LM_RAC_SPARE_P : rac parameter p6

_LM_RAC_SPARE_P : rac parameter p7

_LM_RAC_SPARE_P : rac parameter p8

_LM_RAC_SPARE_P : rac parameter p9

_LM_RCFG_TIMEOU : dlm reconfiguration timeout

_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

_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

_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

_LM_SQ_BATCH_WA : GES send queue batching waittime in tick

ITTICK

_LM_SYNC_TIMEOU : Synchronization timeout for DLM reconfiguration steps

_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

_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

_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

_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

_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

_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

_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

_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

_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

_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)

_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

_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

_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

_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

_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

_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

_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

_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

_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

_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

_MUTEX_WAIT_SCH : Mutex wait scheme

EME

_MUTEX_WAIT_TIM : Mutex wait time

_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

_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

_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

_NET_TIMEOUT_LA : NET_TIMEOUT latency

TENCY

_NEWSORT_ENABLE : controls whether new sorts can be used as system sort

_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

_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

_NUMA_TRACE_LEV : numa trace event

_NUMBER_CACHED_ : maximum number of cached attributes per instance

ATTRIBUTES

_NUMBER_CACHED_ : maximum number of cached group memberships

GROUP_MEMBERSHI

_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

_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

_OLAPI_MEMORY_O : enable olapi memory alloc/free history collection

PERATION_HISTOR pausing

Y_PAUSE_AT_SEQN

_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

_OLAP_ADV_COMP_ : do additional predicate stats analysis for AW rowsource

STATS_CC_PRECOM

_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

_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

_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

_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

_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

_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

_OLAP_WRAP_ERRO : Wrap error messages to OLAP outfile

_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

_OLTP_COMPRESSI : oltp compression enabled

_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

_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

_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

_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

_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)

_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_

_OPTIMIZER_CONN : use cost-based transformation for connect by

ECT_BY_COST_BAS

_OPTIMIZER_CONN : allow connect by to eliminate duplicates from input

ECT_BY_ELIM_DUP

_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

_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

_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

_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

_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

_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

_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

_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

_OPTIMIZER_MULT : allows multiple tables on the left of outerjoin

I_TABLE_OUTERJO

_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

_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

_OPTIMIZER_PART : partial join evaluation parameter

IAL_JOIN_EVAL

_OPTIMIZER_PERC : optimizer percent parallel

ENT_PARALLEL

_OPTIMIZER_PERF : controls the performance feedback

ORMANCE_FEEDBAC

_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

_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

_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

_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

_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

_OPTIMIZER_UNNE : Unnesting of correlated set subqueries (TRUE/FALSE)

ST_CORR_SET_SUB

_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

_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

_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

_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

_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

_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

_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

_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

_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

_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

_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)

_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

_POST_WAIT_QUEU : Post Wait Queues – Num Per Class

ES_NUM_PER_CLAS

_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

_PRED_PUSH_CDB_ : predicate pushdown enabled for CDB views

VIEW_ENABLED

_PREFERED_STAND : standby db_unique_name prefered for krb operations

_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

_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

_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

_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)

_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

_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

_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

_PX_NET_MSG_COS : CPU cost to send a PX message over the internconnect

_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

_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

_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

_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

_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

_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

_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

_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

_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

_REPORT_CAPTURE : Length of time band (in hours) in the reports time

_TIMEBAND_LENGT bands table

_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

_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

_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

_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

_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

_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

_ROWSETS_MAX_RO : maximum number of rows in a rowset

_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

_ROWSOURCE_PROF : if TRUE, Oracle will capture active row sources in

ILING_STATISTIC v$active_session_history

_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

_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

_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

_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

_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

_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

_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

_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

_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

_SIMULATOR_LRU_ : LRU list rebalance threshold (count)

REBALANCE_THRES

_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

_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)

_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

_SKGXP_UDP_TIME : diagnostic log buffering space (in bytes) for timed

D_WAIT_BUFFERIN wait (0 means unbufferd

_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

_SKIP_ACFS_CHEC : Override checking if on an ACFS file system

_SKIP_ASSUME_MS : if TRUE, skip assume message for consigns at the master

_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)

_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 : – 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

_SPARE_TEST_PAR : Spare test parameter

AMETER

_SPAWN_DIAG_OPT : thread spawn diagnostic options

_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

_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

_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

_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

_SWRF_MMON_FLUS : Enable/disable SWRF MMON FLushing

_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

_SWRF_TEST_DBFU : Enable/disable DB Feature Usage Testing

_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

_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

_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

_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

_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

_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

_TRACE_PROCESSE : enable KST tracing in process

_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

_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

_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

_UNDO_DEBUG_USA : invoke undo usage functions for testing

_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

_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

_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

_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

_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

_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

_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?

_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

_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

_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

_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

_XSOLAPI_SQL_TO : OLAP API top dimension hints

P_DIMENSION_HIN

_XSOLAPI_SQL_TO : OLAP API top measure hints

P_MEASURE_HINTS

_XSOLAPI_SQL_US : OLAP API enable bind variables optimization

E_BIND_VARIABLE

_XSOLAPI_STRING : OLAP API stringifies order levels?

IFY_ORDER_LEVEL

_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

_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

_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

_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

_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

__LARGE_POOL_SI : Actual size in bytes of large pool

__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版本中未归档隐藏参数有哪些，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注行业资讯频道。

标签：参数版本字符串 java 字符

暂时没有评论，来抢沙发吧~

Oracle12c版本中未归档隐藏参数有哪些

Oracle12c版本中未归档隐藏参数有哪些

支付宝学微信偷偷送惊喜！支付宝小程序终于出现了直接入口！

拼多多小程序入驻钱包，在微信开辟移动端流量池

拍照识车支付宝小程序上线，4S店实现智慧化升级

最近发表

更多内容

小程序SDK

Finclip技术文档

小程序开发

小程序容器

小程序框架

Finclip小程序平台

Finclip用户投稿

车联网

推荐文章

小程序SDK是什么意思？小程序sdk和插件有什么区别？

小程序支付功能怎么实现？

企业app开发流程是什么？

app运营模式有哪些？

小程序多端引流怎么做？

小程序生态分析的机会和威胁

Flutter入门这一篇效率文章就够了

原生与跨平台解决方案分析,跨平台软件开发技术方案

热更新技术：让软件更新变得更加轻松快速

解决方案

银行解决方案

证券解决方案

互联网解决方案

政企OA解决方案

科技解决方案

loT解决方案

信任解决方案

热评文章

6个用于弹出USB可移动设备的免费工具

商店App排名，十大App各具特色

全向智能移动平台——改变未来交通方式的革命性创新

uni-app做微信小程序的分包处理方法

工业互联网服务平台：全面连接未来工业的智慧引擎

Java解压和压缩带密码的zip文件过程详解