Shulou(Shulou.com)05/31 Report--

This article shows you what are the unarchived hidden parameters in the Oracle12c version, which are concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

I will list all the unrecorded parameters in Oracle 12.1.0.1c. The following is a query to view all parameters (recorded and unrecorded) that contain the string entered when prompted:

-enter the name of the parameter when prompted

SET linesize 235col Parameter FOR a50col SESSION FOR a28col Instance FOR a55col S FOR a1col I FOR a1col D FOR a1col Description FOR a90SELECT a.ksppinm "Parameter", decode (P.issespace modifiers FOR a1col D FOR a1col Description FOR a90SELECT a.ksppinm "Parameter") "Session", c.ksppstvl "Instance", decode (p.isseshell modifiers) "S", decode (p.isseshell modifiers) 'DEFERRED','D') "I", decode (p.isdefaultGrammer) c.indx AND p.name LIKE UPPER ('% & 1%') ORDER BY a.ksppinm) "D", a.ksppdesc "Description" FROM x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter pWHERE a.indx = b.indx AND a.indx = c.indx AND p.name (+) = a.ksppinm AND UPPER (a.ksppinm) LIKE UPPER ('% & 1%') 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_wrappedcol Description for A55 word_wrappedset pagesize 50000set linesize 80select upper (KSPPINM) parameter,':', KSPPDESC Description from x$ksppiwhere substr (ksppinm,1,1) ='_ 'order by 1

PARAMETER DESCRIPTION

--

_ 4030_DUMP_BITV: bitvec to specify dumps prior to 4030 error

EC

_ 4031_DUMP_BITV: bitvec to specify dumps prior to 4031 error

EC

_ 4031_DUMP_INTE: Dump 4031 error once for each n-second interval

RVAL

_ 4031_MAX_DUMPS: Maximum number of 4031 dumps for this process

_ 4031_SGA_DUMP_: Dump 4031 SGA heapdump error once for each n-second

INTERVAL interval

_ 4031_SGA_MAX_D: Maximum number of SGA heapdumps

UMPS

_ ABORT_ON_MRP_C: abort database instance when MRP crashes

RASH

_ ABORT_RECOVERY: if TRUE, abort recovery on join reconfigurations

_ ON_JOIN

_ ACCEPT_VERSION: List of parameters for rolling operation

S

_ ACTIVE_INSTANC: number of active instances in the cluster database

E_COUNT

_ ACTIVE_SESSION: active session idle limit

_ IDLE_LIMIT

_ ACTIVE_SESSION: active session legacy behavior

_ LEGACY_BEHAVIO

R

_ ACTIVE_STANDBY: if TRUE optimize dlm reconfiguration for active/standby

_ FAST_RECONFIGU OPS

RATION

_ AC_ENABLE_DSCN: Enable Dependent Commit SCN tracking

_ IN_RAC

_ ADAPTIVE_DIREC: Adaptive Direct Read

T_READ

_ ADAPTIVE_DIREC: Adaptive Direct Write

T_WRITE

_ ADAPTIVE_FETCH: enable/disable adaptive fetch in parallel group by

_ ENABLED

_ ADAPTIVE_LOG_F: Threshold for frequent log file sync mode switches (per

ILE_SYNC_HIGH_S minute)

WITCH_FREQ_THRE

SHOLD

_ ADAPTIVE_LOG_F: Polling interval selection bias (conservative=0

ILE_SYNC_POLL_A aggressive=100)

GGRESSIVENESS

_ ADAPTIVE_LOG_F: Window (in seconds) for measuring average scheduling

ILE_SYNC_SCHED_ delay

DELAY_WINDOW

_ ADAPTIVE_LOG_F: Ratio of redo synch time to expected poll time as a

ILE_SYNC_USE_PO percentage

LLING_THRESHOLD

_ ADAPTIVE_LOG_F: Percentage of foreground load from when post/wait was

ILE_SYNC_USE_PO last used

STWAIT_THRESHOL

D

_ ADAPTIVE_SCALA: Percentage of overlap across multiple outstanding

BLE_LOG_WRITER_ writes

DISABLE_WORKER_

THRESHOLD

_ ADAPTIVE_SCALA: Increase in redo generation rate as a percentage

BLE_LOG_WRITER_

ENABLE_WORKER_T

HRESHOLD

_ ADAPTIVE_WINDO: enable/disable adaptive window consolidator PX plan

W_CONSOLIDATOR_

ENABLED

_ ADDM_AUTO_ENAB: governs whether ADDM gets run automatically after every

LE AWR snapshot

_ ADDM_SKIPRULES: comma-separated list of ADDM nodes to skip

_ ADDM_VERSION_C: governs whether ADDM checks the input AWR snapshot

HECK version

_ ADD_COL_OPTIM_: Allows new add column optimization

ENABLED

_ ADD_NULLABLE_C: Allows add of a nullable column with default

OLUMN_WITH_DEFA optimization

ULT_OPTIM

_ ADD_STALE_MV_T: add stale mv to dependency list

O_DEPENDENCY_LI

ST

_ ADD_TRIM_FOR_N: add trimming for fixed char semantics

LSSORT

_ ADG_BUFFER_WAI: Active Dataguard buffer wait time in cs

T_TIMEOUT

_ ADG_INSTANCE_R: enable ADG instance recovery

ECOVERY

_ ADJUST_LITERAL: If TRUE, we will adjust the SQL/PLUS output

_ REPLACEMENT

_ ADR_MIGRATE_RU: Enable/disable ADR Migrate Runonce action

NONCE

_ ADVANCED_INDEX: advanced index compression options

_ COMPRESSION_OP

TIONS

_ ADVANCED_INDEX: advanced index compression options2

_ COMPRESSION_OP

TIONS_VALUE

_ ADVANCED_INDEX: advanced index compression trace

_ COMPRESSION_TR

ACE

_ AFFINITY_ON: enable/disable affinity at run time

_ AGED_OUT_CURSO: number of seconds an aged out session cached cursor

R_CACHE_TIME stay in cache

_ AGGREGATION_OP: settings for aggregation optimizations

TIMIZATION_SETT

INGS

_ AIOWAIT_TIMEOU: Number of aiowait timeouts before error is reported

TS

_ ALERT_EXPIRATI: seconds before an alert message is moved to exception

ON queue

_ ALERT_MESSAGE_: Enable Alert Message Cleanup

CLEANUP

_ ALERT_MESSAGE_: Enable Alert Message Purge

PURGE

_ ALERT_POST_BAC: Enable Background Alert Posting

KGROUND

_ ALLOCATE_CREAT: should files be examined in creation order during

ION_ORDER allocation

_ ALLOCATION_UPD: interval at which successful search in L1 should be

ATE_INTERVAL updated

_ ALLOW_CELL_SMA: Allow checking smart_scan_capable Attr

RT_SCAN_ATTR

_ ALLOW_COMMUTAT: allow for commutativity of +, * when comparing

IVITY expressions

_ ALLOW_COMPATIB: allow advancing DB compatibility with guaranteed

ILITY_ADV_W_GRP restore points

_ ALLOW_DROP_SNA: Allow dropping snapshot standby guaranteed restore

PSHOT_STANDBY_G point

RSP

_ ALLOW_DROP_TS_: Allow drop Tablespace with guaranteed restore points

WITH_GRP

_ ALLOW_ERROR_SI: Allow error simulation for testing

MULATION

_ ALLOW_FILE_1_O: don't signal ORA-1245 due to file 1 being offline

FFLINE_ERROR_12

forty-five

_ ALLOW_LEVEL_WI: allow level without connect by

THOUT_CONNECT_B

Y

_ ALLOW_READ_ONL: allow read-only open even if database is corrupt

Y_CORRUPTION

_ ALLOW_RESETLOG: allow resetlogs even if it will cause corruption

S_CORRUPTION

_ ALLOW_TERMINAL: Finish terminal recovery even if it may cause

_ RECOVERY_CORRU corruption

PTION

_ ALL_SHARED_DBL: treat all dblinks as shared

INKS

_ ALTERNATE_IOT_: enable alternate index-organized table leaf-block

LEAF_BLOCK_SPLI split-points

T_POINTS

_ ALTER_COMMON_U: allow local user to create objects in common schema

SER_SCHEMA

_ ALWAYS_ANTI_JO: always use this method for anti-join when possible

IN

_ ALWAYS_SEMI_JO: always use this method for semi-join when possible

IN

_ ALWAYS_STAR_TR: always favor use of star transformation

ANSFORMATION

_ AM_CONTAINER_F: allocation unit size for non-ASM containers

ILESYSTEM_AUSIZ

E

_ AM_MAX_CONTAIN: maximum number of containers

ERS

_ AM_MAX_GROUPS: maximum number of containers

_ AM_MAX_SEG_BYT: maximum number of bytes per array segment

ES

_ AM_TIMEOUTS_EN: enable timeouts

ABLED

_ AM_TRACE_BUFFE: size of per-process I/O trace buffer

R_SIZE

_ AND_PRUNING_EN: allow partition pruning based on multiple mechanisms

ABLED

_ APPQOS_CDB_SET: QoSM CDB Performance Class Setting

TING

_ APPQOS_PO_MULT: Multiplier for PC performance objective value

IPLIER

_ APPQOS_QT: System Queue time retrieval interval

_ AQSHARDED_CACH: Limit for cached enqueue/dequeue operations

E_LIMIT

_ AQ_DISABLE_X: AQ-Disable new cross processes at an instance

_ AQ_DQ_SESSIONS: Deq session count

_ AQ_EQ_SESSIONS: Enq session count

_ AQ_INIT_SHARDS: Minimum enqueue shards per queue at an instance

_ AQ_MAX_SCAN_DE: Maximum allowable scan delay for AQ indexes and IOTs

LAY

_ AQ_PRECRT_PART: Precreate Partitions

ITIONS

_ AQ_PT_PROCESSE: Partition background processes

S

_ AQ_STOP_BACKGR: Stop all AQ background processes

OUNDS

_ AQ_SUBSHARD_SI: Sub Shard Size

ZE

_ AQ_TM_DEQCOUNT: dequeue count interval for Time Managers to cleanup DEQ

INTERVAL IOT BLOCKS

_ AQ_TM_SCANLIMI: scan limit for Time Managers to clean up IOT

T

_ AQ_TM_STATISTI: statistics collection window duration

CS_DURATION

_ ARCH_COMPRESSI: archive compression enabled

ON

_ ARCH_COMPRESS_: enable/disable row checksums for archive compressed

CHECKSUMS blocks

_ ARCH_COMP_DBG_: archive compression scan debug

SCAN

_ ARCH_COMP_DEC_: decompress archive compression blocks for checking and

BLOCK_CHECK_DUM dumping

P

_ ARCH_IO_SLAVES: ARCH I/O slaves

_ ARCH_SIM_MODE: Change behavior of local archiving

_ ARRAY_CDB_VIEW: array mode enabled for CDB views

_ ENABLED

_ ARRAY_UPDATE_V: Enable array update vector read

ECTOR_READ_ENAB

LED

_ ASH_COMPRESSIO: To enable or disable string compression in ASH

N_ENABLE

_ ASH_DISK_FILTE: Ratio of the number of in-memory samples to the number

R_RATIO of samples actually written to disk

_ ASH_DISK_WRITE: To enable or disable Active Session History flushing

_ ENABLE

_ ASH_DUMMY_TEST: Oracle internal dummy ASH parameter used ONLY for

_ PARAM testing!

_ ASH_EFLUSH_TRI: The percentage above which if the in-memory ASH is full

GGER the emergency flusher will be triggered

_ ASH_ENABLE: To enable or disable Active Session sampling and

Flushing

_ ASH_MIN_MMNL_D: Minimum Time interval passed to consider MMNL Dump

UMP

_ ASH_SAMPLE_ALL: To enable or disable sampling every connected session

Including ones waiting for idle waits

_ ASH_SAMPLING_I: Time interval between two successive Active Session

NTERVAL samples in millisecs

_ ASH_SIZE: To set the size of the in-memory Active Session History

Buffers

_ ASMSID: ASM instance id

_ ASM_ACCESS: ASM File access mechanism

_ ASM_ACD_CHUNKS: initial ACD chunks created

_ ASM_ADMIN_WITH: Does the sysdba role have administrative privileges on

_ SYSDBA ASM?

_ ASM_ALLOWDEGEN: Allow force-mounts of DGs w/o proper quorum

ERATEMOUNTS

_ ASM_ALLOW_APPL: Allow DROP DISK/FAILUREGROUP NOFORCE on ASM Appliances

IANCE_DROPDISK_

NOFORCE

_ ASM_ALLOW_LVM_: Enable disk resilvering for external redundancy

RESILVERING

_ ASM_ALLOW_ONLY: Discovery only raw devices

_ RAW_DISKS

_ ASM_ALLOW_SYST: if system alias renaming is allowed

EM_ALIAS_RENAME

_ ASM_ALLOW_UNSA: attempt unsafe reconnect to ASM

FE_RECONNECT

_ ASM_APPLIANCE_: Appliance configuration file name

CONFIG_FILE

_ ASM_AUSIZE: allocation unit size

_ ASM_AUTOMATIC_: automatically rebalance free space across zones

REZONE

_ ASM_AVOID_PST_: Avoid PST Scans

SCANS

_ ASM_BLKSIZE: metadata block size

_ ASM_CHECK_FOR_: check for misbehaving CF-holding clients

MISBEHAVING_CF_

CLIENTS

_ ASM_COMPATIBIL: default ASM compatibility level

ITY

_ ASM_DBA_BATCH: ASM Disk Based Allocation Max Batch Size

_ ASM_DBA_SPCCHK: ASM Disk Based Allocation Space Check Threshold

_ THLD

_ ASM_DBA_THRESH: ASM Disk Based Allocation Threshold

OLD

_ ASM_DBMSDG_NOH: dbms_diskgroup.checkfile does not check block headers

DRCHK

_ ASM_DIAG_DEAD_: diagnostics for dead clients

CLIENTS

_ ASM_DIRECT_CON: Expire time for idle direct connection to ASM instance

_ EXPIRE_TIME

_ ASM_DISABLE_AM: Disable AMDU dump

DU_DUMP

_ ASM_DISABLE_AS: disable async intra-instance messaging

YNC_MSGS

_ ASM_DISABLE_MU: Disable checking for multiple ASM instances on a given

LTIPLE_INSTANCE node

_ CHECK

_ ASM_DISABLE_PR: disable profile query for discovery

OFILEDISCOVERY

_ ASM_DISABLE_SM: Do Not create smr

R_CREATION

_ ASM_DISABLE_UF: disable ufg member kill

GMEMBERKILL

_ ASM_DISABLE_UF: disable terminated umbilicus diagnostic

G_DUMP

_ ASM_DISKERR_TR: Number of read/write errors per disk a process can

ACES trace

_ ASM_DISKGROUPS: disk groups to mount automatically set 2

two

_ ASM_DISKGROUPS: disk groups to mount automatically set 3

three

_ ASM_DISKGROUPS: disk groups to mount automatically set 4

four

_ ASM_DISK_REPAI: seconds to wait before dropping a failing disk

R_TIME

_ ASM_EMULATE_NF: Emulate NFS disk test event

S_DISK

_ ASM_EMULMAX: max number of concurrent disks to emulate I / O errors

_ ASM_EMULTIMEOU: timeout before emulation begins (in 3s ticks)

T

_ ASM_ENABLE_XRO: Enable XROV capability

V

_ ASM_EVENREAD: ASM Even Read level

_ ASM_EVENREAD_A: ASM Even Read Alpha

LPHA

_ ASM_EVENREAD_A: ASM Even Read Second Alpha

LPHA2

_ ASM_EVENREAD_F: ASM Even Read Fast Start Threshold

ASTSTART

_ ASM_FAIL_RANDO: Randomly fail some RX enqueue gets

M_RX

_ ASM_FOB_TAC_FR: Timeout frequency for FOB cleanup

EQUENCY

_ ASM_FORCE_QUIE: Force diskgroup quiescing

SCE

_ ASM_GLOBAL_DUM: System state dump level for ASM asserts

P_LEVEL

_ ASM_HBEATIOWAI: number of secs to wait for PST Async Hbeat IO return

T

_ ASM_HBEATWAITQ: quantum used to compute time-to-wait for a PST Hbeat

UANTUM check

_ ASM_HEALTHCHEC: seconds until health check takes action

K_TIMEOUT

_ ASM_IMBALANCE_: hundredths of a percentage of inter-disk imbalance to

TOLERANCE tolerate

_ ASM_INSTLOCK_Q: ASM Instance Lock Quota

UOTA

_ ASM_IOSTAT_LAT: ASM I/O statistics latch count

CH_COUNT

_ ASM_KFDPEVENT: KFDP event

_ ASM_KILL_UNRES: kill unresponsive ASM clients

PONSIVE_CLIENTS

_ ASM_LIBRARIES: library search order for discovery

_ ASM_LOG_SCALE_: Rebalance power uses logarithmic scale

REBALANCE

_ ASM_LSOD_BUCKE: ASM lsod bucket size

T_SIZE

_ ASM_MAXIO: Maximum size of individual I/O request

_ ASM_MAX_COD_ST: maximum number of COD strides

RIDES

_ ASM_MAX_REDO_B: asm maximum redo buffer size

UFFER_SIZE

_ ASM_NETWORKS: ASM network subnet addresses

_ ASM_NETWORK_TI: Keepalive timeout for ASM network connections

MEOUT

_ ASM_NODEKILL_E: secs until escalating to nodekill if fence incomplete

SCALATE_TIME

_ ASM_NOEVENREAD: List of disk groups having even read disabled

_ DISKGROUPS

_ ASM_PARTNER_TA: target maximum number of disk partners for repartnering

RGET_DISK_PART

_ ASM_PARTNER_TA: target maximum number of failure group relationships

RGET_FG_REL for repartnering

_ ASM_PRIMARY_LO: Number of cycles/extents to load for non-mirrored files

AD

_ ASM_PRIMARY_LO: True if primary load is in cycles, false if extent

AD_CYCLES counts

_ ASM_PROCS_TRAC: Number of processes allowed to trace a disk failure

E_DISKERR

_ ASM_PROXY_STAR: Maximum time to wait for ASM proxy connection

TWAIT

_ ASM_RANDOM_ZON: Random zones for new files

E

_ ASM_REBALANCE_: maximum rebalance work unit

PLAN_SIZE

_ ASM_REBALANCE_: number of out of space errors allowed before aborting

SPACE_ERRORS rebalance

_ ASM_REMOTE_CLI: timeout before killing disconnected remote clients

ENT_TIMEOUT

_ ASM_REPAIRQUAN: quantum (in 3s) used to compute elapsed time for disk

TUM drop

_ ASM_RESERVE_SL: reserve ASM slaves for CF txns

AVES

_ ASM_RESYNCCKPT: number of extents to resync before flushing checkpoint

_ ASM_ROOT_DIREC: ASM default root directory

TORY

_ ASM_RUNTIME_CA: runtime capability for volume support returns supported

PABILITY_VOLUME

_ SUPPORT

_ ASM_SCRUB_LIMI: ASM disk scrubbing power

T

_ ASM_SECONDARY_: Number of cycles/extents to load for mirrored files

LOAD

_ ASM_SECONDARY_: True if secondary load is in cycles, false if extent

LOAD_CYCLES counts

_ ASM_SERIALIZE_: Serialize volume rebalance

VOLUME_REBALANC

E

_ ASM_SHADOW_CYC: Inverse shadow cycle requirement

LE

_ ASM_SKIP_DISKV: skip client side discovery for disk revalidate

AL_CHECK

_ ASM_SKIP_RENAM: skip the checking of the clients for s/w compatibility

E_CHECK for rename

_ ASM_SKIP_RESIZ: skip the checking of the clients for s/w compatibility

E_CHECK for resize

_ ASM_STORAGEMAY: PST Split Possible

SPLIT

_ ASM_STRIPESIZE: ASM file stripe size

_ ASM_STRIPEWIDT: ASM file stripe width

H

_ ASM_SYNC_REBAL: Rebalance uses sync I/O

ANCE

_ ASM_TRACE_LIMI: Time-out in milliseconds to reset the number of traces

T_TIMEOUT per disk and the number of processes allowed to trace

_ ASM_USD_BATCH: ASM USD Update Max Batch Size

_ ASM_WAIT_TIME: Max/imum time to wait before asmb exits

_ ASSM_DEFAULT: ASSM default

_ ASSM_FORCE_FET: enable metadata block fetching in ASSM segment scan

CHMETA

_ ASSM_HIGH_GSP_: Number of blocks rejected before growing segment

THRESHOLD

_ ASSM_LOW_GSP_T: Number of blocks rejected before collecting stats

HRESHOLD

_ ASYNC_RECOVERY: if TRUE, issue recovery claims asynchronously

_ CLAIMS

_ ASYNC_RECOVERY: if TRUE, issue recovery reads asynchronously

_ READS

_ ASYNC_TS_THRES: check tablespace thresholds asynchronously

HOLD

_ AUTOMATIC_MAIN: Enable AUTOTASK Test Mode

TENANCE_TEST

_ AUTOMEMORY_BRO: memory broker statistics gathering interval for auto

KER_INTERVAL memory

_ AUTOTASK_MAX_W: Maximum Logical Maintenance Window Length in minutes

INDOW

_ AUTOTASK_MIN_W: Minimum Maintenance Window Length in minutes

INDOW

_ AUTOTASK_TEST_: Name of current Autotask Test (or test step)

NAME

_ AUTOTUNE_GTX_I: idle time to trigger auto-shutdown a gtx background

DLE_TIME process

_ AUTOTUNE_GTX_I: interval to autotune global transaction background

NTERVAL processes

_ AUTOTUNE_GTX_T: auto-tune threshold for degree of global transaction

HRESHOLD concurrency

_ AUTO_ASSIGN_CG: auto assign CGs for sessions

_ FOR_SESSIONS

_ AUTO_BMR: enable/disable Auto BMR

_ AUTO_BMR_BG_TI: Auto BMR Process Run Time

ME

_ AUTO_BMR_FC_TI: Auto BMR Flood Control Time

ME

_ AUTO_BMR_PUB_T: Auto BMR Publish Timeout

IMEOUT

_ AUTO_BMR_REQ_T: Auto BMR Requester Timeout

IMEOUT

_ AUTO_BMR_SESS_: Auto BMR Request Session Threshold

THRESHOLD

_ AUTO_BMR_SYS_T: Auto BMR Request System Threshold

HRESHOLD

_ AUTO_MANAGE_EN: perodically check for OFFLINE disks and attempt to

ABLE_OFFLINE_CH ONLINE

ECK

_ AUTO_MANAGE_EX: Automate Exadata disk management

ADATA_DISKS

_ AUTO_MANAGE_IN: TEST: Set infrequent timeout action to run at this

FREQ_TOUT interval, unit is seconds

_ AUTO_MANAGE_IO: oss_ioctl buffer size, to read and respond to cell

CTL_BUFSZ notifications

_ AUTO_MANAGE_MA: Max. Attempts to auto ONLINE an ASM disk

X_ONLINE_TRIES

_ AUTO_MANAGE_NU: Max. Number of out-standing msgs in the KXDAM pipe

M_PIPE_MSGS

_ AUTO_MANAGE_NU: Num. Tries before giving up on an automation operation

M_TRIES

_ AUTO_MANAGE_ON: Allow Max. Attempts to auto ONLINE an ASM disk after

LINE_TRIES_EXPI lapsing this time (unit in seconds)

RE_TIME

_ AUX_DFC_KEEP_T: auxiliary datafile copy keep time in minutes

IME

_ AVAILABLE_CORE: number of cores for this instance

_ COUNT

_ AVOID_PREPARE: if TRUE, do not prepare a buffer when the master is

Local

_ AWR_CDBPERF_TH: Setting for AWR CDBPERF Threshold

RESHOLD

_ AWR_CORRUPT_MO: AWR Corrupt Mode

DE

_ AWR_DISABLED_F: Disable flushing of specified AWR tables

LUSH_TABLES

_ AWR_FLUSH_THRE: Enable/Disable Flushing AWR Threshold Metrics

SHOLD_METRICS

_ AWR_FLUSH_WORK: Enable/Disable Flushing AWR Workload Metrics

LOAD_METRICS

_ AWR_MMON_CPUUS: Enable/disable AWR MMON CPU Usage Tracking

AGE

_ AWR_MMON_DEEP_: Allows deep purge to purge AWR data for all expired

PURGE_ALL_EXPIR snapshots

ED

_ AWR_MMON_DEEP_: Set extent of rows to check each deep purge run

PURGE_EXTENT

_ AWR_MMON_DEEP_: Set interval for deep purge of AWR contents

PURGE_INTERVAL

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

PURGE_NUMROWS purge run

_ AWR_PDB_REGIST: Parameter to enable/disable AWR PDB Registration

RATION_ENABLED

_ AWR_REMOTE_TAR: AWR Remote Target DBLink for Flushing

GET_DBLINK

_ AWR_RESTRICT_M: AWR Restrict Mode

ODE

_ AWR_SQL_CHILD_: Setting for AWR SQL Child Limit

LIMIT

_ BACKUP_ALIGN_W: align backup write I/Os

RITE_IO

_ BACKUP_AUTOMAT: automatic retry on backup write errors

IC_RETRY

_ BACKUP_DISK_BU: number of buffers used for DISK channels

FCNT

_ BACKUP_DISK_BU: size of buffers used for DISK channels

FSZ

_ BACKUP_DISK_IO: BACKUP Disk I/O slaves

_ SLAVES

_ BACKUP_DYNAMIC: dynamically compute backup/restore buffer sizes

_ BUFFERS

_ BACKUP_ENCRYPT: specifies encryption block optimization mode

_ OPT_MODE

_ BACKUP_FILE_BU: number of buffers used for file access

FCNT

_ BACKUP_FILE_BU: size of buffers used for file access

FSZ

_ BACKUP_IO_POOL: memory to reserve from the large pool

_ SIZE

_ BACKUP_KGC_BLK: specifies buffer size to be used by HIGH compression

SIZ

_ BACKUP_KGC_BUF: specifies buffer size to be used by BASIC compression

SZ

_ BACKUP_KGC_MEM: specifies memory level for MEDIUM compression

LEVEL

_ BACKUP_KGC_NIT: specifies number of iterations done by BASIC

ERS compression

_ BACKUP_KGC_PER: specifies compression (performance) level for MEDIUM

FLEVEL compression

_ BACKUP_KGC_SCH: specifies compression scheme

EME

_ BACKUP_KGC_TYP: specifies compression type used by kgc BASIC

E compression

_ BACKUP_KGC_WIN: specifies window size for MEDIUM compression

DOWBITS

_ BACKUP_KSFQ_BU: number of buffers used for backup/restore

FCNT

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

FMEM_MAX for backup/restore

_ BACKUP_KSFQ_BU: size of buffers used for backup/restore

FSZ

_ BACKUP_LZO_SIZ: specifies buffer size for LOW compression

E

_ BACKUP_MAX_GAP: largest gap in an incremental/optimized backup buffer

_ SIZE in bytes

_ BACKUP_MIN_CT_: mimimun size in bytes of change tracking to apply

UNUSED_OPTIM unused space optimuzation

_ BACKUP_SEQ_BUF: number of buffers used for non-DISK channels

CNT

_ BACKUP_SEQ_BUF: size of buffers used for non-DISK channels

SZ

_ BCT_BITMAPS_PE: number of bitmaps to store for each datafile

R_FILE

_ BCT_BUFFER_ALL: maximum size of all change tracking buffer allocations

OCATION_MAX in bytes

_ BCT_BUFFER_ALL: mininum number of extents to allocate per buffer

OCATION_MIN_EXT allocation

ENTS

_ BCT_BUFFER_ALL: size of one change tracking buffer allocation, in bytes

OCATION_SIZE

_ BCT_CHUNK_SIZE: change tracking datafile chunk size, in bytes

_ BCT_CRASH_RESE: change tracking reserved crash recovery SGA space, in

RVE_SIZE bytes

_ BCT_FILE_BLOCK: block size of change tracking file, in bytes

_ SIZE

_ BCT_FILE_EXTEN: extent size of change tracking file, in bytes

T_SIZE

_ BCT_FIXTAB_FIL: change tracking file for fixed tables

E

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

CK_INTERVAL

_ BCT_INITIAL_PR: initial number of entries in the private change

IVATE_DBA_BUFFE tracking dba buffers

R_SIZE

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

T

_ BCT_PUBLIC_DBA: allow dynamic resizing of public dba buffers, zero to

_ BUFFER_DYNRESI disable

ZE

_ BCT_PUBLIC_DBA: max buffer size permitted for public dba buffers, in

_ BUFFER_MAXSIZE bytes

_ BCT_PUBLIC_DBA: total size of all public change tracking dba buffers

_ BUFFER_SIZE in bytes

_ BG_SPAWN_DIAG_: background processes spawn diagnostic options

OPTS

_ BITMAP_OR_IMPR: controls extensions to partition pruning for general

OVEMENT_ENABLED predicates

_ BLOCKING_SESS_: blocking session graph cache size in bytes

GRAPH_CACHE_SIZ

E

_ BLOCKS_PER_CAC: number of consecutive blocks per global cache server

HE_SERVER

_ BLOCK_LEVEL_OF: High Latency Threshold for Block Level Offload

FLOAD_HIGH_LAT_ operations

THRESH

_ BLOCK_SAMPLE_R: controls readahead value during block sampling

EADAHEAD_PROB_T

HRESHOLD

_ BLOOM_FILTER_D: debug level for bloom filtering

EBUG

_ BLOOM_FILTER_E: enables or disables bloom filter

NABLED

_ BLOOM_FILTER_S: bloom filter vector size (in KB)

IZE

_ BLOOM_FOLDING_: bloom filter folding density lower bound

DENSITY

_ BLOOM_FOLDING_: Enable folding of bloom filter

ENABLED

_ BLOOM_FOLDING_: bloom filter folding size lower bound (in KB)

MIN

_ BLOOM_MAX_SIZE: maximum bloom filter size (in KB)

_ BLOOM_MINMAX_E: enable or disable bloom min max filtering

NABLED

_ BLOOM_PREDICAT: enables or disables bloom filter predicate pushdown

E_ENABLED

_ BLOOM_PREDICAT: enables or disables bloom filter predicate offload to

E_OFFLOAD cells

_ BLOOM_PRUNING_: Enable partition pruning using bloom filtering

ENABLED

_ BLOOM_PUSHING_: bloom filter pushing size upper bound (in KB)

MAX

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

TOTAL_MAX

_ BLOOM_RM_FILTE: remove bloom predicate in favor of zonemap join pruning

R predicate

_ BLOOM_SM_ENABL: enable bloom filter optimization using slave mapping

ED

_ BRANCH_TAGGING: enable branch tagging for distributed transaction

_ BROADCAST_SCN_: broadcast-on-commit scn mode

MODE

_ BROADCAST_SCN_: broadcast-on-commit scn wait timeout in centiseconds

WAIT_TIMEOUT

_ BSLN_ADAPTIVE_: Adaptive Thresholds Enabled

THRESHOLDS_ENAB

LED

_ BT_MMV_QUERY_R: allow rewrites with multiple MVs and base tables

EWRITE_ENABLED

_ BUFFERED_MESSA: Buffered message spill age

GE_SPILL_AGE

_ BUFFERED_PUBLI: Flow control threshold for buffered publishers except

SHER_FLOW_CONTR capture

OL_THRESHOLD

_ BUFFER_BUSY_WA: buffer busy wait time in centiseconds

IT_TIMEOUT

_ BUFQ_STOP_FLOW: Stop enforcing flow control for buffered queues

_ CONTROL

_ BUILD_DEFERRED: DEFERRED MV creation skipping MV log setup update

_ MV_SKIPPING_MV

LOG_UPDATE

_ BUMP_HIGHWATER: how many blocks should we allocate per free list on

_ MARK_COUNT advancing HWM

_ BWR_FOR_FLUSHE: if TRUE, generate a BWR for a flushed PI

D_PI

_ BYPASS_SRL_FOR: bypass SRL for S/O EOR logs

_ SO_EOR

_ BYPASS_XPLATFO: bypass datafile header cross-platform-compliance errors

RM_ERROR

_ B_TREE_BITMAP_: enable the use of bitmap plans for tables w. Only

PLANS B-tree indexes

_ CACHE_ORL_DURI: cache online logs

NG_OPEN

_ CACHE_STATS_MO: if TRUE, enable cache stats monitoring

NITOR

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

_ SIZE

_ CAPTURE_PUBLIS: Flow control threshold for capture publishers

HER_FLOW_CONTRO

L_THRESHOLD

_ CASE_SENSITIVE: case sensitive logon enabled

_ LOGON

_ CAUSAL_STANDBY: Causal standby wait timeout

_ WAIT_TIMEOUT

_ CDB_COMPATIBLE: CDB Compatible

_ CDB_RAC_AFFINI: rac affinity for parallel cdb operations

TY

_ CDC_SUBSCRIPTI: Change Data Capture subscription_owner

ON_OWNER

_ CDMP_DIAGNOSTI: cdmp directory diagnostic level

C_LEVEL

_ CELL_FAST_FILE: Allow optimized file creation path for Cells

_ CREATE

_ CELL_FAST_FILE: Allow optimized rman restore for Cells

_ RESTORE

_ CELL_FILE_FORM: Cell file format chunk size in MB

AT_CHUNK_SIZE

_ CELL_INDEX_SCA: enable CELL processing of index FFS

N_ENABLED

_ CELL_MATERIALI: Force materialization of all offloadable expressions on

ZE_ALL_EXPRESSI the cells

ONS

_ CELL_MATERIALI: enable offload of expressions underlying virtual

ZE_VIRTUAL_COLU columns to cells

MNS

_ CELL_OBJECT_EX: flashcache object expiration timeout

PIRATION_HOURS

_ CELL_OFFLOAD_C: specifies capability table to load

APABILITIES_ENA

BLED

_ CELL_OFFLOAD_C: enable complex SQL processing offload to cells

OMPLEX_PROCESSI

NG

_ CELL_OFFLOAD_E: enable offload of expressions to cells

XPRESSIONS

_ CELL_OFFLOAD_H: Query offloading of hybrid columnar compressed tables

YBRIDCOLUMNAR to exadata

_ CELL_OFFLOAD_P: enable out-of-order SQL processing offload to cells

REDICATE_REORDE

RING_ENABLED

_ CELL_OFFLOAD_S: enable offload of SYS_CONTEXT evaluation to cells

YS_CONTEXT

_ CELL_OFFLOAD_T: enable timezone related SQL processing offload to cells

IMEZONE

_ CELL_OFFLOAD_V: enable offload of predicates on virtual columns to

IRTUAL_COLUMNS cells

_ CELL_RANGE_SCA: enable CELL processing of index range scans

N_ENABLED

_ CELL_STORIDX_M: Cell Storage Index mode

ODE

_ CGS_ALLGROUP_P: CGS DBALL group polling interval in milli-seconds

OLL_TIME

_ CGS_COMM_READI: CGS communication readiness check

NESS_CHECK

_ CGS_DBALL_GROU: CGS DBALL group registration type

P_REGISTRATION

_ CGS_DBGROUP_PO: CGS DB group polling interval in milli-seconds

LL_TIME

_ CGS_HEALTH_CHE: CGS health check during reconfiguration

CK_IN_RECONFIG

_ CGS_MEMBERKILL: allow a RIM instance to issue a CSS member kill

_ FROM_RIM_INSTA

NCE

_ CGS_MSG_BATCHI: CGS message batching

NG

_ CGS_MSG_BATCH_: CGS message batch size in bytes

SIZE

_ CGS_NODE_KILL_: CGS node kill escalation to CSS

ESCALATION

_ CGS_NODE_KILL_: CGS wait time to escalate node kill to CSS in seconds

ESCALATION_WAIT

_ CGS_RECONFIG_E: CGS reconfiguration extra wait time for CSS in seconds

XTRA_WAIT

_ CGS_RECONFIG_T: CGS reconfiguration timeout interval

IMEOUT

_ CGS_SEND_TIMEO: CGS send timeout value

UT

_ CGS_TICKETS: CGS messaging tickets

_ CGS_TICKET_SEN: CGS ticket active sendback percentage threshold

DBACK

_ CGS_ZOMBIE_MEM: CGS zombie member kill wait time in seconds

BER_KILL_WAIT

_ CHANGE_VECTOR_: Number of change vector buffers for media recovery

BUFFERS

_ CHECK_BLOCK_AF: perform block check after checksum if both are turned

TER_CHECKSUM on

_ CHECK_BLOCK_NE: check block new invariant for flashback

W_INVARIANT_FOR

_ FLASHBACK

_ CHECK_COLUMN_L: check column length

ENGTH

_ CHECK_PDBID_IN: Enable checking of pluggable database ID in redo

_ REDO

_ CHECK_TS_THRES: check tablespace thresholds

HOLD

_ CLEANOUT_SHRCU: if TRUE, cleanout shrcur buffers

R_BUFFERS

_ CLEANUP_ROLLBA: no. Of undo entries to apply per transaction cleanup

CK_ENTRIES

_ CLEANUP_TIMEOU: timeout value for PMON cleanup

T

_ CLEANUP_TIMEOU: flags for PMON cleanup timeout

T_FLAGS

_ CLEAR_BUFFER_B: Always zero-out buffer before reuse for security

EFORE_REUSE

_ CLIENT_ENABLE_: enable automatic unregister after a send fails with

AUTO_UNREGISTER timeout

_ CLIENT_NTFN_CL: interval after which dead client registration cleanup

EANUP_INTERVAL task repeats

_ CLIENT_NTFN_PI: time between pings to unreachable notification clients

NGINTERVAL

_ CLIENT_NTFN_PI: number of times to ping unreachable notification

NGRETRIES clients

_ CLIENT_NTFN_PI: timeout to connect to unreachable notification clients

NGTIMEOUT

_ CLIENT_RESULT_: bypass the client result cache

CACHE_BYPASS

_ CLIENT_TSTZ_ER: Should Client give error for suspect Timestamp with

ROR_CHECK Timezone operations

_ CLI_CACHEBKTAL: Percentage of memory to allocate

LOC

_ CLONE_ONE_PDB_: Recover ROOT and only one PDB in clone database

RECOVERY

_ CLOSE_CACHED_O: close cursors cached by PL/SQL at each commit

PEN_CURSORS

_ CLOSE_DEQ_BY_C: Close Dequeue By Condition Cursors

OND_CURS

_ CLOUD_NAME: gsm cloud name

_ CLUSTERWIDE_GL: enable/disable clusterwide global transactions

OBAL_TRANSACTIO

NS

_ CLUSTER_LIBRAR: cluster library selection

Y

_ COLLAPSE_WAIT_: collapse wait history

HISTORY

_ COLLECT_TEMPUN: Collect Statistics v$tempundostat

DO_STATS

_ COLLECT_UNDO_S: Collect Statistics v$undostat

TATS

_ COLUMN_COMPRES: Column compression ratio

SION_FACTOR

_ COLUMN_ELIMINA: turn off predicate-only column elimination

TION_OFF

_ COLUMN_TRACKIN: column usage tracking

G_LEVEL

_ COMMON_DATA_VI: common objects returned through dictionary views

EW_ENABLED

_ COMMON_USER_PR: Enforce restriction on a prefix of a Common

EFIX User/Role/Profile name

_ COMPILATION_CA: Size of the compilation call heaps extents

LL_HEAP_EXTENT_

SIZE

_ COMPLEX_VIEW_M: enable complex view merging

ERGING

_ COMPRESSION_AB: number of recompression above cache for sanity check

OVE_CACHE

_ COMPRESSION_AD: Compression advisor

VISOR

_ COMPRESSION_CH: percentage of chained rows allowed for Compression

AIN

_ COMPRESSION_CO: Compression compatability

MPATIBILITY

_ CONCURRENCY_CH: what is the chosen value of concurrency

OSEN

_ CONNECTION_BRO: connection broker host for listen address

KER_HOST

_ CONNECT_BY_USE: use union all for connect by

_ UNION_ALL

_ CONTROLFILE_AU: time delay (in seconds) for performing controlfile

TOBACKUP_DELAY autobackups

_ CONTROLFILE_BA: enable check of the copied blocks during controlfile

CKUP_COPY_CHECK backup copy

_ CONTROLFILE_BL: control file block size in bytes

OCK_SIZE

_ CONTROLFILE_CE: Flash cache hint for control file accesses

LL_FLASH_CACHIN

G

_ CONTROLFILE_EN: dump the system states after controlfile enqueue

QUEUE_DUMP timeout

_ CONTROLFILE_EN: control file enqueue max holding time in seconds

QUEUE_HOLDING_T

IME

_ CONTROLFILE_EN: control file enqueue holding time tracking size

QUEUE_HOLDING_T

IME_TRACKING_SI

ZE

_ CONTROLFILE_EN: control file enqueue timeout in seconds

QUEUE_TIMEOUT

_ CONTROLFILE_SE: control file initial section size

CTION_INIT_SIZE

_ CONTROLFILE_SE: control file max expansion rate

CTION_MAX_EXPAN

D

_ CONTROLFILE_UP: controlfile update sanity check

DATE_CHECK

_ CONVERT_SET_TO: enables conversion of set operator to join

_ JOIN

_ COORD_MESSAGE_: parallel recovery coordinator side extra message buffer

BUFFER size

_ CORRUPTED_ROLL: corrupted undo segment list

BACK_SEGMENTS

_ COST_EQUALITY_: enables costing of equality semi-join

SEMI_JOIN

_ CPU_EFF_THREAD: CPU effective thread multiplier

_ MULTIPLIER

_ CPU_TO_IO: divisor for converting CPU cost to I/O cost

_ CP_NUM_HASH_LA: connection pool number of hash latches

TCHES

_ CRASH_DOMAIN_O: allow domain to exit for exceptions in any thread

N_EXCEPTION

_ CREATE_STAT_SE: create ilm statistics segment

GMENT

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

N_ANY_CLUSTER user

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

L_ROLE global role

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

_ ROLE on

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

Block

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

FLUSH

_ CR_TRC_BUF_SIZ: size of cr trace buffer

E

_ CTX_DOC_POLICY: enable ctx_doc.policy_stems api

_ STEMS

_ CURSOR_BIND_CA: maximum size of the cursor bind capture area

PTURE_AREA_SIZE

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

PTURE_INTERVAL cursor

_ CURSOR_CACHE_T: number of seconds a session cached cursor stay in

IME cache.

_ CURSOR_DB_BUFF: additional number of buffers a cursor can pin at once

ERS_PINNED

_ CURSOR_FEATURE: Shared cursor features enabled bits.

S_ENABLED

_ CURSOR_OBSOLET: Number of cursors per parent before obsoletion.

E_THRESHOLD

_ CURSOR_PLAN_EN: enable collection and display of cursor plans

ABLED

_ CURSOR_PLAN_HA: version of cursor plan hash value

SH_VERSION

_ CURSOR_PLAN_UN: enables/disables using unparse to build

PARSE_ENABLED projection/predicates

_ CURSOR_RELOAD_: Number of failed reloads before marking cursor unusable

FAILURE_THRESHO

LD

_ CURSOR_RUNTIME: Shared cursor runtime heap memory limit

HEAP_MEMLIMIT

_ CURSOR_STATS_E: Enable cursor stats

NABLED

_ CU_ROW_LOCKING: CU row level locking

_ CVMAP_BUFFERS: Number of change vector buffers for multi instance

Media recovery

_ CVW_ENABLE_WEA: enable weak view checking

K_CHECKING

_ DATAFILE_COW: Use copy on write snapshot for the renamed file

_ DATAFILE_WRITE: datafile write errors crash instance

_ ERRORS_CRASH_I

NSTANCE

_ DATAPUMP_COMPR: specifies buffer size for BASIC compression algorithm

ESSBAS_BUFFER_S

IZE

_ DATAPUMP_METAD: specifies buffer size for metadata file I/O

ATA_BUFFER_SIZE

_ DATAPUMP_TABLE: specifies buffer size for table data file I/O

DATA_BUFFER_SIZ

E

_ DATA_TRANSFER_: Percentange * 100of buffer cache to transfer to data

CACHE_BC_PERC_X transfer cache

one hundred

_ DATA_TRANSFER_: Size of data transfer cache

CACHE_SIZE

_ DATA_WAREHOUSI: if TRUE, enable data warehousing scan buffers

NG_SCAN_BUFFERS

_ DBFS_MODIFY_IM: DBFS Link allows implicit fetch on modify-only on

PLICIT_FETCH SecureFiles

_ DBG_PROC_START: debug process startup

UP

_ DBG_SCAN: generic scan debug

_ DBMS_SQL_SECUR: Security level in DBMS_SQL

ITY_LEVEL

_ DBOP_ENABLED: Any positive number enables automatic DBOP monitoring.

0 is disabled

_ DBPOOL_NAME: gsm database pool name

_ DBRM_DYNAMIC_T: DBRM dynamic threshold setting

HRESHOLD

_ DBRM_NUM_RUNNA: Resource Manager number of runnable list per NUMA node

BLE_LIST

_ DBRM_QUANTUM: DBRM quantum

_ DBRM_RUNCHK: Resource Manager Diagnostic Running Thread Check

_ DBRM_SHORT_WAI: Resource Manager short wait length

T_US

_ DBWR_ASYNC_IO: Enable dbwriter asynchronous writes

_ DBWR_SCAN_INTE: dbwriter scan interval

RVAL

_ DBWR_TRACING: Enable dbwriter tracing

_ DB_16K_FLASH_C: flash cache file for 16k block size

ACHE_FILE

_ DB_16K_FLASH_C: flash cache size for _ db_16k_flash_cache_file

ACHE_SIZE

_ DB_2K_FLASH_CA: flash cache file for 2k block size

CHE_FILE

_ DB_2K_FLASH_CA: flash cache size for _ db_2k_flash_cache_file

CHE_SIZE

_ DB_32K_FLASH_C: flash cache file for 32k block size

ACHE_FILE

_ DB_32K_FLASH_C: flash cache size for _ db_32k_flash_cache_file

ACHE_SIZE

_ DB_4K_FLASH_CA: flash cache file for 4k block size

CHE_FILE

_ DB_4K_FLASH_CA: flash cache size for _ db_4k_flash_cache_file

CHE_SIZE

_ DB_8K_FLASH_CA: flash cache file for 8k block size

CHE_FILE

_ DB_8K_FLASH_CA: flash cache size for _ db_8k_flash_cache_file

CHE_SIZE

_ DB_AGING_COOL_: Touch count set when buffer cooled

COUNT

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

E_CR

_ DB_AGING_HOT_C: Touch count which sends a buffer to head of replacement

RITERIA list

_ DB_AGING_STAY_: Touch count set when buffer moved to head of

COUNT replacement list

_ DB_AGING_TOUCH: Touch count which sends a buffer to head of replacement

_ TIME list

_ DB_ALWAYS_CHEC: Always perform block check and checksum for System

K_SYSTEM_TS tablespace

_ DB_BLOCKS_PER_: Number of blocks per hash latch

HASH_LATCH

_ DB_BLOCK_ADJCH: adjacent cache buffer checks-low blkchk overwrite

ECK parameter

_ DB_BLOCK_ADJCH: adjacent cache buffer check level

K_LEVEL

_ DB_BLOCK_ALIGN: Align Direct Reads

_ DIRECT_READ

_ DB_BLOCK_BAD_W: enable bad write checks

RITE_CHECK

_ DB_BLOCK_BUFFE: Number of database blocks cached in memory: hidden

RS parameter

_ DB_BLOCK_CACHE: Always clone data blocks on get (for debugging)

_ CLONE

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

_ HISTORY

_ DB_BLOCK_CACHE: buffer header tracing level

_ HISTORY_LEVEL

_ DB_BLOCK_CACHE: buffer header tracing for lru operations

_ HISTORY_LRU

_ DB_BLOCK_CACHE: number of unmapped buffers (for tracking swap calls on

_ NUM_UMAP blocks)

_ DB_BLOCK_CACHE: protect database blocks (true only when debugging)

_ PROTECT

_ DB_BLOCK_CACHE: protect database blocks (for strictly internal use

_ PROTECT_INTERN only)

AL

_ DB_BLOCK_CHECK: Check more and dump block before image for debugging

_ FOR_DEBUG

_ DB_BLOCK_CHECK: check objd and typ on cache disk read

_ OBJTYP

_ DB_BLOCK_CHUNK: chunkify noncontig multi block reads

IFY_NCMBR

_ DB_BLOCK_CORRU: threshold number of block recovery attempts

PTION_RECOVERY_

THRESHOLD

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

LL_MBREADS

_ DB_BLOCK_HASH_: Number of database block hash buckets

BUCKETS

_ DB_BLOCK_HASH_: Number of database block hash latches

LATCHES

_ DB_BLOCK_HEADE: number of extra buffer headers to use as guard pages

R_GUARD_LEVEL

_ DB_BLOCK_HI_PR: Fraction of writes for high priority reasons

IORITY_BATCH_SI

ZE

_ DB_BLOCK_KNOWN: Initial Percentage of buffers to maintain known clean

_ CLEAN_PCT

_ DB_BLOCK_LRU_L: number of lru latches

ATCHES

_ DB_BLOCK_MAX_C: Maximum Allowed Number of CR buffers per dba

R_DBA

_ DB_BLOCK_MAX_S: Percentage of buffers to inspect when looking for free

CAN_PCT

_ DB_BLOCK_MED_P: Fraction of writes for medium priority reasons

RIORITY_BATCH_S

IZE

_ DB_BLOCK_NUMA: Number of NUMA nodes

_ DB_BLOCK_PREFE: Batched IO enable fast longjumps

TCH_FAST_LONGJU

MPS_ENABLED

_ DB_BLOCK_PREFE: Prefetch limit in blocks

TCH_LIMIT

_ DB_BLOCK_PREFE: Prefetch force override in blocks

TCH_OVERRIDE

_ DB_BLOCK_PREFE: Batched IO enable private cache

TCH_PRIVATE_CAC

HE_ENABLED

_ DB_BLOCK_PREFE: Prefetch quota as a percent of cache size

TCH_QUOTA

_ DB_BLOCK_PREFE: Batched IO enable skip reading buffers

TCH_SKIP_READIN

G_ENABLED

_ DB_BLOCK_PREFE: Allowed wasted percent threshold of prefetched size

TCH_WASTED_THRE

SHOLD_PERC

_ DB_BLOCK_TABLE: Size of shared table scan read buffer

_ SCAN_BUFFER_SI

ZE

_ DB_BLOCK_TEMP_: generate redo for temp blocks

REDO

_ DB_BLOCK_TRACE: trace buffer protect calls

_ PROTECT

_ DB_BLOCK_VLM_C: check of rvlm mapping leaks (for debugging)

HECK

_ DB_BLOCK_VLM_L: Threshold for allowable vlm leaks

EAK_THRESHOLD

_ DB_CACHE_ADVIC: cache advisory maximum multiple of current size to

E_MAX_SIZE_FACT similate

OR

_ DB_CACHE_ADVIC: cache advisory sampling factor

E_SAMPLE_FACTOR

_ DB_CACHE_ADVIC: cache simulation sanity check

E_SANITY_CHECK

_ DB_CACHE_BLOCK: dump short call stack for block reads

_ READ_STACK_TRA

CE

_ DB_CACHE_CRX_C: check for costly crx examination functions

HECK

_ DB_CACHE_MISS_: check LEs after cache miss

CHECK_LES

_ DB_CACHE_MMAN_: check for wait latch get under MMAN ops in kcb

LATCH_CHECK

_ DB_CACHE_PRE_W: Buffer Cache Pre-Warm Enabled: hidden parameter

ARM

_ DB_CACHE_PROCE: maximum number of cr pins a process may have

SS_CR_PIN_MAX

_ DB_CACHE_WAIT_: trace new kslwaits

DEBUG

_ DB_CHANGE_NOTI: enable db change notification

FICATION_ENABLE

_ DB_CHECK_CELL_:

HINTS

_ DB_DISABLE_TEM: Disable Temp Encryption for Spills

P_ENCRYPTION

_ DB_DUMP_FROM_D: dump contents from disk and efc

ISK_AND_EFC

_ DB_DW_SCAN_ADA: if TRUE, enable adaptive DW scan cooling

PTIVE_COOLING

_ DB_DW_SCAN_MAX: DW Scan adaptive cooling max shadow count

_ SHADOW_COUNT

_ DB_DW_SCAN_OBJ: DW Scan object cooling factor to cool all temperatures

_ COOLING_FACTOR

_ DB_DW_SCAN_OBJ: DW Scan object cooling interval in number of scans

_ COOLING_INTERV seconds, or pct of cache size

AL

_ DB_DW_SCAN_OBJ: DW scan objtect cooling policy

_ COOLING_POLICY

_ DB_DW_SCAN_OBJ: DW Scan object warming increment when an object is

_ WARMING_INCREM scanned

ENT

_ DB_FAST_OBJ_CH: enable fast object drop sanity check

ECK

_ DB_FAST_OBJ_CK: enable fast object checkpoint

PT

_ DB_FAST_OBJ_TR: enable fast object truncate

UNCATE

_ DB_FILE_DIRECT: Sequential I/O buf size

_ IO_COUNT

_ DB_FILE_EXEC_R: multiblock read count for regular clients

EAD_COUNT

_ DB_FILE_FORMAT: Block formatting I/O buf count

_ IO_BUFFERS

_ DB_FILE_NONCON: number of noncontiguous db blocks to be prefetched

TIG_MBLOCK_READ

_ COUNT

_ DB_FILE_OPTIMI: multiblock read count for regular clients

ZER_READ_COUNT

_ DB_FLASHBACK_I: Flashback IO Buffer Size

OBUF_SIZE

_ DB_FLASHBACK_L: Minimum flashback database log size in bytes

OG_MIN_SIZE

_ DB_FLASHBACK_L: Minimum flashback database log total space in bytes

OG_MIN_TOTAL_SP

ACE

_ DB_FLASHBACK_N: Flashback Number of IO buffers

UM_IOBUF

_ DB_FLASH_CACHE: Flash cache force replenish lower limit in buffers

_ FORCE_REPLENIS

H_LIMIT

_ DB_FLASH_CACHE: Flash cache keep buffer upper limit in percentage

_ KEEP_LIMIT

_ DB_FLASH_CACHE: Flash cache maximum latency allowed in 10 milliseconds

_ MAX_LATENCY

_ DB_FLASH_CACHE: Flash cache maximum outstanding writes allowed

_ MAX_OUTSTANDIN

G_WRITES

_ DB_FLASH_CACHE: Flash cache max read retry

_ MAX_READ_RETRY

_ DB_FLASH_CACHE: Flash cache maximum slow io allowed

_ MAX_SLOW_IO

_ DB_FLASH_CACHE: Flash cache write buffer upper limit in percentage

_ WRITE_LIMIT

_ DB_HANDLES: System-wide simultaneous buffer operations

_ DB_HANDLES_CAC: Buffer handles cached each process

HED

_ DB_HOT_BLOCK_T: track hot blocks for hash latch contention

RACKING

_ DB_INDEX_BLOCK: index block checking override parameter

_ CHECKING

_ DB_INITIAL_CAC: size of cache created at startup

HESIZE_CREATE_M

B

_ DB_L2_TRACING: flash cache debug tracing

_ DB_LARGE_DIRTY: Number of buffers which force dirty queue to be written

_ QUEUE

_ DB_LOST_WRITE_: Enable scn based lost write detection mechanism

CHECKING

_ DB_LOST_WRITE_: Enable _ db_lost_write_checking tracing

TRACING

_ DB_MTTR_ADVICE: MTTR advisory

_ DB_MTTR_PARTIT: number of partitions for MTTR advisory

IONS

_ DB_MTTR_SAMPLE: MTTR simulation sampling factor

_ FACTOR

_ DB_MTTR_SIM_TA: MTTR simulation targets

RGET

_ DB_MTTR_SIM_TR: MTTR simulation trace size

ACE_SIZE

_ DB_MTTR_TRACE_: dump trace entries to alert file

TO_ALERT

_ DB_NOARCH_DISB: Image redo logging (NOARCHIVEMODE)

LE_OPTIM

_ DB_NUM_EVICT_W: number of evict wait events

AITEVENTS

_ DB_NUM_GSM: database number in gsm dbpool

_ DB_OBJ_ENABLE_: enable ksr in object checkpoint/reuse

KSR

_ DB_PERCENT_HOT: Percent of default buffer pool considered hot

_ DEFAULT

_ DB_PERCENT_HOT: Percent of keep buffer pool considered hot

_ KEEP

_ DB_PERCENT_HOT: Percent of recycle buffer pool considered hot

_ RECYCLE

_ DB_PERCPU_CREA: size of cache created per cpu in deferred cache create

TE_CACHESIZE

_ DB_PREFETCH_HI: maintain prefetch histogram statistics in x$kcbprfhs

STOGRAM_STATIST

ICS

_ DB_RECOVERY_TE: default database recovery temporal file location

MPORAL_FILE_DES

T

_ 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

T

_ 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

S

_ 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

CS

_ 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

LL

_ DEFAULT_ENCRYP: default encryption algorithm

T_ALG

_ DEFAULT_NON_EQ: sanity check on default selectivity for like/range

UALITY_SEL_CHEC predicate

K

_ DEFERRED_CONST: Deferred constant folding mode

ANT_FOLDING_MOD

E

_ 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

ME

_ 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

ED

_ 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

D

_ 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

ED

_ 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

CS

_ 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

OL

_ 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

S

_ DIRECT_IO_WSLO: number of write slots for direct path I/O

TS

_ 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

S

_ 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

EN

_ DISABLE_FAST_A: fast aggregation

GGREGATION

_ DISABLE_FAST_V: disable PL/SQL fast validation

ALIDATE

_ DISABLE_FBA_QR: disable flashback archiver query rewrite

W

_ 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

CK

_ 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

TS

_ DISABLE_INCREM: Disable incremental recovery checkpoint mechanism

ENTAL_RECOVERY_

CKPT

_ DISABLE_INDEX_: disable index block prefetching

BLOCK_PREFETCHI

NG

_ 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

G

_ 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

G

_ 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

M

_ 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

S

_ DISABLE_THREAD: Disable thread internal disable feature

_ INTERNAL_DISAB

LE

_ DISABLE_THREAD: Thread snapshot

_ SNAPSHOT

_ DISABLE_TXN_AL: disable txn layer alert

ERT

_ DISABLE_UNDO_T: disable tablespace alerts for UNDO tablespaces

ABLESPACE_ALERT

S

_ 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

E

_ 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

LE

_ 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

ED

_ 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

H

_ 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

E

_ DTREE_BINNING_: Decision Tree Binning Enabled

ENABLED

_ DTREE_BINTEST_: Decision Tree Binning Test ID

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

PE

_ 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

NS

_ 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

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

C

_ ENABLE_IEE_STA: enables IEE stats gathering

TS

_ 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

GE

_ 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

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

PT

_ 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

O

_ 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

PS

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

D

_ GC_FG_MERGE: if TRUE, merge pi buffers in the foreground

_ GC_FG_SPIN_TIM: foreground msgq spin time

E

_ 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

S

_ 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

UT

_ 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

TY

_ GC_TRANSFER_RA: dynamic object read-mostly transfer ratio

TIO

_ GC_UNDO_AFFINI: if TRUE, enable undo affinity

TY

_ 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

DS

_ GES_DESIGNATED: designated master for GES and GCS resources

_ MASTER

_ GES_DIAGNOSTIC: if TRUE enables GES diagnostics

S

_ GES_DIAGNOSTIC: systemstate level on global enqueue diagnostics blocked

S_ASM_DUMP_LEVE by ASM

L

_ GES_DIRECT_FRE: if TRUE, free each resource directly to the freelist

E

_ 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

S

_ GES_HEALTH_CHE: if greater than 0 enables GES system health check

CK

_ GES_LMD_MAPPIN: enqueue to lmd mapping

G

_ 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

ED

_ 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

S

_ GSM_CPU_THRESH: CPU busy threshold

_ GSM_DRV_INTERV: metric derived values interval

AL

_ 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

T

_ GSM_SRLAT_THRE: Single block read latency threshold

SH

_ GSM_THRESH_RES: threshold resource percentage

PCT

_ GSM_THRESH_ZON: threshold zone

E

_ 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

E1

_ 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

two

_ 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

N

_ 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

IT

_ ILM_FILTER_TIM: Upper filter time for ILM block compression

E

_ 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

E

_ 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

E

_ 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

ST

_ 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

RK

_ 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

D

_ 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

E

_ KCFIS_FAST_RES: Fast response-(next IO size = current IO size * this

PONSE_IOSIZEMUL parameter)

T

_ 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

ED

_ 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

T

_ 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

S

_ 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

DE

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

D_THRESHOLD heuristic)

_ KDLI_CACHE_SIZ: maximum # entries in inode cache

E

_ 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

M

_ 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

TH

_ 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

OP

_ 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

ER

_ 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

P

_ 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

PT

_ KDLXP_MINCMP: minimum comp ratio in pct-only on SecureFiles

_ KDLXP_MINCMPLE: minimum loblen to compress-only on SecureFiles

N

_ 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

H

_ 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

L

_ KFFMAP_HASH_SI: size of kffmap_hash table

ZE

_ KFFMLK_HASH_SI: size of kffmlk_hash table

ZE

_ KFFMOP_CHUNKS: number of chunks of kffmop's

_ KFFMOP_HASH_SI: size of kffmop_hash table

ZE

_ 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

CK

_ KGL_CLUSTER_LO: Library cache support for cluster lock read mostly

CK_READ_MOSTLY optimization

_ KGL_CLUSTER_PI: Library cache support for cluster pins

N

_ 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

T

_ 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

Us

_ 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

ZE

_ 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

GS

_ 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

ET

_ 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

N

_ 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

LE

_ 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

H

_ 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 (0x1000mm ipcedX)

_ KSXP_SKGXP_INE: limit SKGXP networks

TS

_ 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

S

_ KTB_DEBUG_FLAG: ktb-layer debug flags

S

_ 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

IP

_ 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

S

_ 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

TE

_ LGWR_IO_OUTLIE: LGWR I/O outlier frequency

R

_ 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

R

_ LGWR_POSTS_FOR: LGWR posts commit waiters for pending broadcasts

_ PENDING_BCASTS

_ LGWR_TA_SIM_ER: Variable to simulate errors lgwr true async

R

_ LIBRARY_CACHE_: whether KGL advice should be turned on

ADVICE

_ LIGHTWEIGHT_HD: Lightweight headers for redo

RS

_ 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

N

_ 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

D

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

ES

_ 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

L

_ 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

TH

_ 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

T

_ LM_COMM_TKTS_M: Time to wait before allowing an allocation increase

IN_INCREASE_WAI

T

_ LM_COMM_TKTS_M: Ticket allocation multiplication factor

ULT_FACTOR

_ LM_COMM_TKTS_N: Null request frequency threshold (percentage)

ULLREQ_THRESHOL

D

_ LM_COMPRESSION: GES compression scheme

_ SCHEME

_ LM_CONTIGUOUS_: number of contiguous blocks that will hash to the same

RES_COUNT HV bucket

_ LM_DD_IGNORE_N: if TRUE nodeadlockwait/nodeadlockblock options are

ODD ignored

_ LM_DD_INTERVAL: dd time interval in seconds

_ LM_DD_MAXDUMP: max number of locks to be dumped during dd validation

_ LM_DD_MAX_SEAR: max dd search time per token

CH_TIME

_ LM_DD_SCAN_INT: dd scan interval in seconds

ERVAL

_ LM_DD_SEARCH_C: number of dd search per token get

NT

_ LM_DEFERRED_MS: deferred message timeout

G_TIMEOUT

_ LM_DRMOPT12: enable drm scan optimizations in 12

_ LM_DRMOPT12_NO: enable drm latching optimizations in 12

LATCH

_ LM_DRM_BATCH_T: time in seconds to wait to batch drm requests

IME

_ LM_DRM_DISABLE: disable drm in different level

_ LM_DRM_HILOAD_: drm high load threshold percentage

PERCENTAGE

_ LM_DRM_LOWLOAD: drm low load threshold percentage

_ PERCENTAGE

_ LM_DRM_MAX_REQ: dynamic remastering maximum affinity requests processed

UESTS together

_ LM_DRM_MIN_INT: minimum interval in secs between two consecutive drms

ERVAL

_ LM_DRM_OBJECT_: enable/disable object scan to force full table scan

SCAN always

_ LM_DRM_WINDOW: dynamic remastering bucket window size

_ LM_DRM_XLATCH: dynamic remastering forced exclusive latches

_ LM_DUMP_NULL_L: dump null lock in state dump

OCK

_ LM_DYNAMIC_LMS: dynamic lms invocation

_ LM_DYNAMIC_LOA: dynamic load adjustment

D

_ LM_ENABLE_AFF_: enables affinity benefit computations if TRUE

BENEFIT_STATS

_ LM_ENQUEUE_BLO: enqueue blocker dump timeout

CKER_DUMP_TIMEO

UT

_ LM_ENQUEUE_BLO: enqueue blocker dump timeout count

CKER_DUMP_TIMEO

UT_CNT

_ LM_ENQUEUE_BLO: enqueue blocker kill timeout

CKER_KILL_TIMEO

UT

_ LM_ENQUEUE_FRE: Number of enqueue freelist

ELIST

_ LM_ENQUEUE_TIM: enqueue suggested min timeout in seconds

EOUT

_ LM_ENQ_LOCK_FR: Number of ges enqueue element freelist

EELIST

_ LM_ENQ_RCFG: if TRUE enables enqueue reconfiguration

_ LM_FDRM_STATS: gather full drm statistics

_ LM_FILE_AFFINI: mapping between file id and master instance number

TY

_ LM_FILE_READ_M: mapping between read-mostly file id and master instance

OSTLY number

_ LM_FREEZE_KILL: timeout for killing unfrozen processes in rcfg/drm

_ TIME freeze step

_ LM_FREE_QUEUE_: GES free queue threshold

THRESHOLD

_ LM_GLOBAL_POST: if TRUE deliver global posts to remote nodes

S

_ LM_HASHTABLE_B: High element threshold in hash table bucket

KT_HIGH

_ LM_HASHTABLE_B: Low element threshold in hash table bucket

KT_LOW

_ LM_HASHTABLE_B: Threshold for hash table resizing

KT_THR

_ LM_HB_ACCEPTAB: list of acceptable hang conditions in heartbeat check

LE_HANG_CONDITI

ON

_ LM_HB_CALLSTAC: hb diagnostic call stack collection time in seconds

K_COLLECT_TIME

_ LM_HB_DISABLE_: list of process names to be disabled in heartbeat check

CHECK_LIST

_ LM_HB_ENABLE_A: to enable the wait analysis with acceptable condition

CL_CHECK lists

_ LM_HB_EXPONENT: heartbeat exponential hang time multiplier

IAL_HANG_TIME_F

ACTOR

_ LM_HB_MAXIMUM_: maximum heartbeat hang report count

HANG_REPORT_COU

NT

_ LM_HIGH_LOAD_S: high watermark system load percentage

YSLOAD_PERCENTA

GE

_ LM_HIGH_LOAD_T: high load threshold parameter

HRESHOLD

_ LM_IDLE_CONNEC: GES idle connection check

TION_CHECK

_ LM_IDLE_CONNEC: GES idle connection check interval time

TION_CHECK_INTE

RVAL

_ LM_IDLE_CONNEC: GES idle connection instance check callout

TION_INSTANCE_C

HECK_CALLOUT

_ LM_IDLE_CONNEC: GES idle connection kill

TION_KILL

_ LM_IDLE_CONNEC: GES idle connection max skip kill request

TION_KILL_MAX_S

KIPS

_ LM_IDLE_CONNEC: GES maximum idle connection kill request ignore count

TION_MAX_IGNORE

_ KILL_COUNT

_ LM_IDLE_CONNEC: GES idle connection health quorum threshold

TION_QUORUM_THR

ESHOLD

_ LM_KILL_FG_ON_: GES kill fg on IPC timeout

TIMEOUT

_ LM_LHUPD_INTER: load and health update interval

VAL

_ LM_LMD_WAITTIM: default wait time for lmd in centiseconds

E

_ LM_LMON_NOWAIT: if TRUE makes lmon get nowait latches with timeout loop

_ LATCH

_ LM_LMS: number of background gcs server processes to start

_ LM_LMS_OPT_PRI: enable freeslot lms priority optimization

ORITY

_ LM_LMS_PRIORIT: frequency of LMS priority decisions in milliseconds

Y_CHECK_FREQUEN

CY

_ LM_LMS_PRIORIT: enable lms priority modification

Y_DYNAMIC

_ LM_LMS_RT_THRE: maximum number of real time lms processes on machine

SHOLD

_ LM_LMS_SPIN: make lms not sleep

_ LM_LMS_WAITTIM: default wait time for lms in centiseconds

E

_ LM_LOCAL_HP_EN: use static file affinity for HP enqueue mastership

Q

_ LM_LOCKS: number of enqueues configured for cluster database

_ LM_LOW_LOAD_PE: low watermark percentage for load threshold

RCENTAGE

_ LM_MASTER_WEIG: master resource weight for this instance

HT

_ LM_MAX_LMS: max. Number of background global cache server processes

_ LM_MSG_BATCH_S: GES batch message size

IZE

_ LM_MSG_CLEANUP: GES message buffer cleanup interval time

_ INTERVAL

_ LM_MSG_POOL_DU: GES message pool dump threshold in terms of buffer

MP_THRESHOLD count

_ LM_NODE_JOIN_O: cluster database node join optimization in reconfig

PT

_ LM_NON_FAULT_T: disable cluster database fault-tolerance mode

OLERANT

_ LM_NO_LH_CHECK: skip load and health check at decision points

_ LM_NO_SYNC: skip reconfiguration/drm syncr/synca messaging

_ LM_NUM_BNFT_ST: number of buckets in the benefit stats hash table

ATS_BUCKETS

_ LM_NUM_PT_BUCK: number of buckets in the object affinity hash table

ETS

_ LM_NUM_PT_LATC: number of latches in the object affinity hash table

HES

_ LM_POSTEVENT_B: postevent buffer size

UFFER_SIZE

_ LM_PREREGISTER: enqueue type that requires pre-registration to css

_ CSS_RESTYPE

_ LM_PROCESS_BAT: GES implicit process batching for IPC messages

CHING

_ LM_PROCESS_LOC: limit on scanning process lock queue instead of

K_Q_SCAN_LIMIT resource convert lock queue

_ LM_PROCS: number of client processes configured for cluster

Database

_ LM_PROC_FREEZE: reconfiguration: process freeze timeout

_ TIMEOUT

_ LM_PSRCFG: enable pseudo reconfiguration

_ LM_RAC_SPARE_D: rac parameter dp1

P1

_ LM_RAC_SPARE_D: rac parameter dp10

P10

_ LM_RAC_SPARE_D: rac parameter dp2

P2

_ LM_RAC_SPARE_D: rac parameter dp3

P3

_ LM_RAC_SPARE_D: rac parameter dp4

P4

_ LM_RAC_SPARE_D: rac parameter dp5

P5

_ LM_RAC_SPARE_D: rac parameter dp6

P6

_ LM_RAC_SPARE_D: rac parameter dp7

P7

_ LM_RAC_SPARE_D: rac parameter dp8

P8

_ LM_RAC_SPARE_D: rac parameter dp9

P9

_ LM_RAC_SPARE_P: rac parameter p1

one

_ LM_RAC_SPARE_P: rac parameter p10

ten

_ LM_RAC_SPARE_P: rac parameter p2

two

_ LM_RAC_SPARE_P: rac parameter p3

three

_ LM_RAC_SPARE_P: rac parameter p4

four

_ LM_RAC_SPARE_P: rac parameter p5

five

_ LM_RAC_SPARE_P: rac parameter p6

six

_ LM_RAC_SPARE_P: rac parameter p7

seven

_ LM_RAC_SPARE_P: rac parameter p8

eight

_ LM_RAC_SPARE_P: rac parameter p9

nine

_ LM_RCFG_TIMEOU: dlm reconfiguration timeout

T

_ LM_RCVINST: designated instance to do instance recovery

_ LM_RCVR_HANG_A: receiver hang allow time in seconds

LLOW_TIME

_ LM_RCVR_HANG_C: to kill receiver hang at control file IO

FIO_KILL

_ LM_RCVR_HANG_C: receiver hang check frequency in seconds

HECK_FREQUENCY

_ LM_RCVR_HANG_C: examine system load when check receiver health

HECK_SYSTEM_LOA

D

_ LM_RCVR_HANG_K: to kill receiver hang

ILL

_ LM_RCVR_HANG_S: systemstate dump level upon receiver hang

YSTEMSTATE_DUMP

_ LEVEL

_ LM_RESEND_OPEN: timeout in secs before resubmitting the open-convert

_ CONVERT_TIMEOU

T

_ LM_RESS: number of resources configured for cluster database

_ LM_RES_HASH_BU: number of resource hash buckets

CKET

_ LM_RES_PART: number of resource partition configured for gcs

_ LM_RES_TM_HASH: number of extra TM resource hash buckets

_ BUCKET

_ LM_RM_SLAVES: if non zero, it enables remastering slaves

_ LM_SENDPROXY_R: GES percentage of send proxy reserve of send tickets

ESERVE

_ LM_SEND_MODE: GES send mode

_ LM_SEND_QUEUE_: GES send queue message batching

BATCHING

_ LM_SEND_QUEUE_: GES send queue maximum length

LENGTH

_ LM_SHARE_LOCK_: if TRUE enables share lock optimization

OPT

_ LM_SINGLE_INST: enable single instance affinity lock optimization

_ AFFINITY_LOCK

_ LM_SPARE_THREA: number of spare threads to be created by the GPnP

DS master

_ LM_SPARE_UNDO: number of spare undo tablespaces to be created by GPnP

Master

_ LM_SQ_BATCH_FA: GES send queue minimum batching factor

CTOR

_ LM_SQ_BATCH_TY: GES send queue batching mechanism

PE

_ LM_SQ_BATCH_WA: GES send queue batching waittime in tick

ITTICK

_ LM_SYNC_TIMEOU: Synchronization timeout for DLM reconfiguration steps

T

_ LM_TICKETS: GES messaging tickets

_ LM_TICKET_ACTI: Flow control ticket active sendback threshold

VE_SENDBACK

_ LM_TX_DELTA: TX lock localization delta

_ LM_USE_GCR: use GCR module if TRUE

_ LM_USE_NEW_DEF: use new defered msg queue timeout action

MSGTMO_ACTION

_ LM_USE_TX_TSN: use undo tsn affinity master as TX enqueue master

_ LM_VALIDATE_PB: GES process batch validation

ATCH

_ LM_WAIT_PENDIN: GES wait on pending send queue

G_SEND_QUEUE

_ LM_WATCHPOINT_: GES number of watchpoints

MAXIMUM

_ LM_WATCHPOINT_: GES maximum time in seconds to keep watchpoint

TIMEOUT

_ LM_XIDS: number of transaction IDs configured for cluster

Database

_ LOAD_WITHOUT_C: Load PL/SQL or Database objects without compilation

OMPILE

_ LOCAL_ARC_ASSE: Assert whenever local ORL arch waits for space

RT_ON_WAIT

_ LOCAL_COMMUNIC: enable local communication costing when TRUE

ATION_COSTING_E

NABLED

_ LOCAL_COMMUNIC: set the ratio between global and local communication

ATION_RATIO (0.100)

_ LOCAL_HANG_ANA: the interval at which local hang analysis is run

LYSIS_INTERVAL_

SECS

_ LOCK_REF_CONST: number of nowait attempts to lock referential

RAINT_COUNT constraint

_ LOCK_SGA_AREAS: Lock specified areas of the SGA in physical memory

_ LOGOUT_STORM_R: number of processes that can logout in a second

ATE

_ LOGOUT_STORM_R: maximum retry count for logouts

ETRYCNT

_ LOGOUT_STORM_T: timeout in centi-seconds for time to wait between

IMEOUT retries

_ LOG_ARCHIVE_AV: log archive avoid memcpy

OID_MEMCPY

_ LOG_ARCHIVE_BU: Number of buffers to allocate for archiving

FFERS

_ LOG_ARCHIVE_CA: archival callout

LLOUT

_ LOG_ARCHIVE_NE: Log archive network redo buffer size used by ARCH

TWORK_REDO_SIZE

_ LOG_ARCHIVE_PR: log archive protection auto demotion

OT_AUTO_DEMOTE

_ LOG_ARCHIVE_ST: log archive security strong auth

RONG_AUTH

_ LOG_ARCHIVE_TR: log archive trace pids parameter

ACE_PIDS

_ LOG_BLOCKS_DUR: log block images when changed during backup

ING_BACKUP

_ LOG_BUFFERS_CO: corrupt redo buffers before write

RRUPT

_ LOG_BUFFERS_DE: debug redo buffers (slows things down)

BUG

_ LOG_BUFFER_COA: Coalescing log buffers for log writes

LESCE

_ LOG_CHECKPOINT: # redo blocks to verify after checkpoint

_ RECOVERY_CHECK

_ LOG_COMMITTIME: Log commit-time block cleanout

_ BLOCK_CLEANOUT

_ LOG_DELETION_P: archivelog deletion policy for mandatory/all

OLICY destination

_ LOG_EVENT_QUEU: number of the log writer event queues

ES

_ LOG_FILE_SYNC_: Log file sync timeout (centiseconds)

TIMEOUT

_ LOG_MAX_OPTIMI: maximum number of threads to which log scan

ZE_THREADS optimization is applied

_ LOG_PARALLELIS: Enable dynamic strands

M_DYNAMIC

_ LOG_PARALLELIS: Maximum number of log buffer strands

M_MAX

_ LOG_PRIVATE_MU: Private strand multiplier for log space preallocation

L

_ LOG_PRIVATE_PA: Active sessions multiplier to deduce number of private

RALLELISM_MUL strands

_ LOG_READ_BUFFE: Number of log read buffers for media recovery

RS

_ LOG_READ_BUFFE: buffer size for reading log files

R_SIZE

_ LOG_SIMULTANEO: number of simultaneous copies into redo buffer (# of

US_COPIES copy latches)

_ LOG_SPACE_ERRO: should we report space errors to alert log

RS

_ LOG_SWITCH_TIM: Maximum number of seconds redos in the current log

EOUT could span

_ LOG_UNDO_DF_IN: generate marker to log file# that belong to undo

FO tablespace

_ LOG_WRITER_WOR: LGWR worker DLM health-monitoring heartbeat update

KER_DLM_HEARBEA frequency (ms)

T_UPDATE_FREQ

_ LOG_WRITE_INFO: Size of log write info array

_ SIZE

_ LONGOPS_ENABLE: longops stats enabled

D

_ LONG_BCAST_ACK: threshold for long bcast ack warning messages in ms

_ WARNING_THRESH

OLD

_ LONG_LOG_WRITE: threshold for long log write warning messages in ms

_ WARNING_THRESH

OLD

_ LOWRES_DRIFT_A: allowed lowres timer drift for VKTM

LLOWED_SEC

_ LOW_SERVER_THR: low server thresholds

ESHOLD

_ LTC_TRACE: tracing level for load table conventional

_ LTHREAD_CLEANU: interval for cleaning lightweight threads in secs

P_INTV_SECS

_ LTHREAD_CLNUP_: timeout after hard killing operation for lthread to

HK_WAIT_SECS exit

_ LTHREAD_CLNUP_: wait timeout for PMON between soft kill and hard kill

PMON_SOFTKILL_W of lthreads

AIT_SECS

_ LTHREAD_CLNUP_: timeout for spawner between soft kill and hard kill of

SPAWNER_SK_WAIT lthreads

_ SECS

_ LTHREAD_DEBUG: Enable Debugging mode for lightweight threads

_ LTHREAD_ENABLE: Enable lightweight threads

D

_ LTHREAD_MAX_SP: maximum time interval a spawner will wait for a lthread

AWN_TIME_CSECS to get ready

_ LTHREAD_SPAWN_: time interval for a spawner to check for spawnee to get

CHECK_INTV_MS ready

_ LTHREAD_STEP_D: Enable Step wise Debugging mode for lightweight threads

EBUGGING

_ MAIN_DEAD_PROC: PMON main dead process scan interval (in seconds)

ESS_SCAN_INTERV

AL

_ MASTER_DIRECT_: direct sends for messages from master (DFS)

SENDS

_ MAV_REFRESH_CO: refresh materialized views using consistent read

NSISTENT_READ snapshot

_ MAV_REFRESH_DO: materialized view MAV refreshes avoid double counting

UBLE_COUNT_PREV

ENTED

_ MAV_REFRESH_OP: optimizations during refresh of materialized views

T

_ MAV_REFRESH_UN: # tables for union all expansion during materialized

IONALL_TABLES view refresh

_ MAX_AQ_PERSIST: max aq persistent queue memory

ENT_QUEUE_MEMOR

Y

_ MAX_ASYNC_WAIT: Switchover wait time for async LNS to catch up in

_ FOR_CATCH_UP seconds

_ MAX_CLIENTS_PE: maximum number of clients per emon

R_EMON

_ MAX_CR_ROLLBAC: Maximum number of CR rollbacks per block (LMS)

KS

_ MAX_DATA_TRANS: Maximum size of data transfer cache

FER_CACHE_SIZE

_ MAX_DEFER_GRAN: Maximum deferred granules transferred by MMAN atonce

_ XFER_ATONCE

_ MAX_EXPONENTIA: max sleep during exponential backoff

L_SLEEP

_ MAX_FILESTAT_T: maximum number of file stat tries

RIES

_ MAX_FSU_SEGMEN: Maximum segments to track for fast space usage

TS

_ MAX_FSU_STALE_: Allowed space usage staleness in seconds

TIME

_ MAX_INCIDENT_F: Maximum size (in KB, MB, GB, Blocks) of incident dump

ILE_SIZE file

_ MAX_IO_SIZE: Maximum I/O size in bytes for sequential file accesses

_ MAX_KCNIBR_RAN: Max number of nonlogged data block ranges

GES

_ MAX_LARGEPAGE_: Maximum number of seconds to spend on largepage

ALLOC_TIME_SECS allocation

_ MAX_LARGE_IO: IORM:max number of large I/O's to issue

_ MAX_LNS_SHUTDO: Maximum time spent by LNS to archive last log during

WN_ARCHIVAL_TIM shutdown

E

_ MAX_LOG_WRITE_: Maximum Imax O parallelism within a log write (auto=0)

IO_PARALLELISM

_ MAX_LOG_WRITE_: Maximum parallelism within a log write (auto=0)

PARALLELISM

_ MAX_OUTSTANDIN: Maximum number of outstanding redo log writes

G_LOG_WRITES

_ MAX_PENDING_SC: maximum number of pending SCN broadcasts

N_BCASTS

_ MAX_PROTOCOL_S: Max occurrence protocols supported in a process

UPPORT

_ MAX_QUEUED_REP: Maximum number of report requests that can be queued in

ORT_REQUESTS a list

_ MAX_REASONABLE: Max reasonable SCN rate

_ SCN_RATE

_ MAX_REPORT_FLU: Max no of report requests that can be flushed per cycle

SHES_PERCYCLE

_ MAX_RWGS_GROUP: maximum no of groupings on materialized views

INGS

_ MAX_SERVICES: maximum number of database services

_ MAX_SHRINK_OBJ: number of segments for which shrink stats will be

_ STATS maintained

_ MAX_SLEEP_HOLD: max time to sleep while holding a latch

ING_LATCH

_ MAX_SMALL_IO: IORM:max number of small I/O's to issue

_ MAX_SPACEBG_MS: maximum space management interrupt message throttling

GS_PERCENTAGE

_ MAX_SPACEBG_SL: maximum space management background slaves

AVES

_ MAX_SPACEBG_TA: maximum space management background tasks

SKS

_ MAX_STRING_SIZ: controls error checking for the max_string_size

E_BYPASS parameter

_ MAX_SYS_NEXT_E: Dictionary managed SYSTEM tablespace maximum next

XTENT extent size in MB (allowed range [16-4095], 0 if

Unlimited)

_ MEDIA_RECOVERY: media recovery block read batch

_ READ_BATCH

_ MEMORY_BROKER_: memory broker num stat entries

LOG_STAT_ENTRIE

S

_ MEMORY_BROKER_: Marginal Utility threshold pct for bc

MARGINAL_UTILIT

Y_BC

_ MEMORY_BROKER_: Marginal Utility threshold pct for sp

MARGINAL_UTILIT

Y_SP

_ MEMORY_BROKER_: memory broker allow policy to shrink shared pool

SHRINK_HEAPS

_ MEMORY_BROKER_: memory broker allow policy to shrink java pool

SHRINK_JAVA_HEA

PS

_ MEMORY_BROKER_: memory broker allow policy to shrink streams pool

SHRINK_STREAMS_

POOL

_ MEMORY_BROKER_: memory broker policy to timeout shrink shared/java pool

SHRINK_TIMEOUT

_ MEMORY_BROKER_: memory broker statistics gathering interval for auto

STAT_INTERVAL sga

_ MEMORY_CHECKIN: check inuse time interval

USE_TIMEINTV

_ MEMORY_IMM_MOD: Allow immediate mode without sga/memory target

E_WITHOUT_AUTOS

GA

_ MEMORY_INITIAL: Initial default sga target percentage with memory

_ SGA_SPLIT_PERC target

_ MEMORY_MANAGEM: trace memory management activity

ENT_TRACING

_ MEMORY_MAX_TGT: counts the times checker increments memory target

_ INC_CNT

_ MEMORY_MGMT_FA: always fail immediate mode request

IL_IMMREQ

_ MEMORY_MGMT_IM: time in seconds to time out immediate mode request

MREQ_TIMEOUT

_ MEMORY_NOCANCE: do not cancel deferred sga reqs with auto-memory

L_DEFSGAREQ

_ MEMORY_SANITY_: partial granule sanity check

CHECK

_ MEM_ANNOTATION: private memory annotation collection level

_ PR_LEV

_ MEM_ANNOTATION: memory annotation pre-allocation scaling

_ SCALE

_ MEM_ANNOTATION: shared memory annotation collection level

_ SH_LEV

_ MEM_ANNOTATION: memory annotation in-memory store

_ STORE

_ MEM_STD_EXTENT: standard extent size for fixed-size-extent heaps

_ SIZE

_ MESSAGES: message queue resources-dependent on # processes & #

Buffers

_ MGD_RCV_HANDLE: Managed recovery handle orphan datafile situation

_ ORPHAN_DATAFIL

ES

_ MIDTIER_AFFINI: cluster wait precentage threshold to enter affinity

TY_CLUSWAIT_PRC

_ THRESHOLD

_ MIDTIER_AFFINI: goodness gradient threshold to dissolve affinity

TY_GOODNESS_THR

ESHOLD

_ MINFREE_PLUS: max percentage of block space + minfree before we mark

Block full

_ MINIMAL_STATS_: prohibit stats aggregation at compile/partition

AGGREGATION maintenance time

_ MINIMUM_BLOCKS: minimum number freeable blocks for shrink to be present

_ TO_SHRINK

_ MINIMUM_DB_FLA: Minimum flashback retention

SHBACK_RETENTIO

N

_ MINIMUM_EXTENT: minimum number freeable extents for shrink to be

S_TO_SHRINK present

_ MIN_TIME_BETWE: minimum time between PSP0 diagnostic used for flow

EN_PSP0_DIAG_SE control

CS

_ MIRROR_REDO_BU: Save buffers for debugging redo corruptions

FFERS

_ MMV_QUERY_REWR: allow rewrites with multiple MVs and/or base tables

ITE_ENABLED

_ MODIFY_COLUMN_: allow ALTER TABLE MODIFY (column) to violate index key

INDEX_UNUSABLE length limit

_ MODULE_ACTION_: Use module and action old length parameter

OLD_LENGTH

_ MPMT_ENABLED: MPMT mode enabled

_ MPMT_ENABLED_B: mpmt enabled backgrounds

ACKGROUNDS

_ MPMT_FG_ENABLE: MPMT mode foreground enabled

D

_ MPMT_PROCS_PER: max procs per osp

_ OSP

_ MULTIPLE_INSTA: use multiple instances for media recovery

NCE_RECOVERY

_ MULTI_INSTANCE: force multi instance parallel recovery

_ PMR

_ MULTI_JOIN_KEY: TRUE iff multi-join-key table lookup prefetch is

_ TABLE_LOOKUP enabled

_ MULTI_TRANSACT: reduce SGA memory use during create of a partitioned

ION_OPTIMIZATIO table

N_ENABLED

_ MUTEX_SPIN_COU: Mutex spin count

NT

_ MUTEX_WAIT_SCH: Mutex wait scheme

EME

_ MUTEX_WAIT_TIM: Mutex wait time

E

_ MV_ADD_LOG_PLA: add log placeholder

CEHOLDER

_ MV_CLEANUP_ORP: cleanup orphaned materialized view metadata

HANED_METADATA

_ MV_COMPLETE_RE: use conventional INSERTs for MV complete refresh

FRESH_CONVENTIO

NAL

_ MV_DEFERRED_NO: avoid build deferred MV log age validate

_ LOG_AGE_VAL

_ MV_EXPRESSION_: MV expression extend size

EXTEND_SIZE

_ MV_GENERALIZED: enable/disable new algorithm for MJV with generalized

_ OJ_REFRESH_OPT outer joins

_ MV_REFRESH_ANA: what percent to analyze after complete/PCT refresh

_ MV_REFRESH_COS: refresh decision based on cost or on rules

TING

_ MV_REFRESH_DEL: delta mv as fractional percentage of size of mv

TA_FRACTION

_ MV_REFRESH_ENH: enable enhanced detection of DML types from MV log

ANCED_DML_DETEC

TION

_ MV_REFRESH_EUT: refresh materialized views using EUT (partition)-based

Algorithm

_ MV_REFRESH_FOR: force materialized view refreshes to use parallel query

CE_PARALLEL_QUE

RY

_ MV_REFRESH_INS: materialized view refresh using insert no append

ERT_NO_APPEND

_ MV_REFRESH_NEW: materialized view MV refresh new setup disabling

_ SETUP_DISABLED

_ MV_REFRESH_NO_: avoid index rebuild as part of the MV refresh

IDX_REBUILD

_ MV_REFRESH_PKF: control MV refresh based on the assumption of PK-FK

K_DATA_UNITS_OP data units

T

_ MV_REFRESH_PKF: control MV refresh based on the use of PK-FK

K_RELATIONSHIP_ relationships

OPT

_ MV_REFRESH_REB: minimum percentage change required in MV to force an

UILD_PERCENTAGE indexrebuild

_ MV_REFRESH_SEL: create materialized views with selections and fast

ECTIONS refresh

_ MV_REFRESH_UPD: materialized view refresh using update analysis

ATE_ANALYSIS

_ MV_REFRESH_USE: use hash_sj hint in queries

_ HASH_SJ

_ MV_REFRESH_USE: use no_merge hint in queries

_ NO_MERGE

_ MV_REFRESH_USE: pass cardinality hints to refresh queries

_ STATS

_ MV_REFSCHED_TI: proportionality constant for dop vs. Time in MV refresh

MEINCR

_ MV_ROLLING_INV: create/alter mv uses rolling cursor invalidation

Instead of immediate

_ MWIN_SCHEDULE: Enable/disable Maintenance Window Schedules

_ NAMESERVICE_CO: NameService Consistency check switch

NSISTENCY_CHECK

_ NCHAR_IMP_CNV: NLS allow Implicit Conversion between CHAR and NCHAR

_ NCHAR_IMP_CONV: should implicit conversion bewteen clob and nclob be

Allowed

_ NCMB_READAHEAD: enable multi-block readahead for an index scan

_ ENABLED

_ NCMB_READAHEAD: turn on multi-block readahead tracing

_ TRACING

_ NCOMP_SHARED_O: native compilation shared objects dir

BJECTS_DIR

_ NESTED_LOOP_FU: nested loop fudge

DGE

_ NESTED_MV_FAST: nested MV refresh fast on commit allowed

_ ONCOMMIT_ENABL

ED

_ NET_TIMEOUT_LA: NET_TIMEOUT latency

TENCY

_ NEWSORT_ENABLE: controls whether new sorts can be used as system sort

D

_ NEWSORT_ORDERE: controls when new sort avoids sorting ordered input

D_PCT

_ NEWSORT_TYPE: specifies options for the new sort algorithm

_ NEW_INITIAL_JO: enable initial join orders based on new ordering

IN_ORDERS heuristics

_ NEW_SORT_COST_: enables the use of new cost estimate for sort

ESTIMATE

_ NINETEENTH_SPA: nineteenth spare parameter-string

RE_PARAMETER

_ NINTH_SPARE_PA: ninth spare parameter-integer

RAMETER

_ NLJ_BATCHING_A: FAE flag type set after restoring to IO batching buffer

E_FLAG

_ NLJ_BATCHING_E: enable batching of the RHS IO in NLJ

NABLED

_ NLJ_BATCHING_M: enable exceptions for buffer cache misses

ISSES_ENABLED

_ NLS_PARAMETER_: enables or disables updates to v$parameter whenever an

SYNC_ENABLED alter session statement modifies various nls parameters

_ NOLOGGING_KCNB: Number of nologging buffer hash buckets

UF_HASH_BUCKETS

_ NOLOGGING_KCNB: Number of nologging buffer hash latches

UF_HASH_LATCHES

_ NOLOGGING_LOAD: Nologging standby: direct load buffer size

_ SLOTSZ

_ NOLOGGING_SDCL: Nologging standby append sdcl wait time

_ APPEND_WAIT

_ NOLOGGING_SEND: Nologging standby: outstanding send buffer ratio

BUF_RATIO

_ NOLOGGING_TXN_: Nologging standby transaction commit wait time

CMT_WAIT

_ NONCDB_TO_PDB: converting a non-cdb to a pdb

_ NOSEG_FOR_UNUS: no segments for unusable indexes if set to TRUE

ABLE_INDEX_ENAB

LED

_ NOTIFY_CRS: notify cluster ready services of startup and shutdown

_ NO_OBJECTS: no object features are used

_ NO_OR_EXPANSIO: OR expansion during optimization disabled

N

_ NO_RECOVERY_TH: no recovery through this resetlogs operation

ROUGH_RESETLOGS

_ NO_SMALL_FILE: Not to apply new extent scheme for small file temp

Spaces

_ NO_STALE_JOINB: No joinbacks if mv is stale

ACK_REWRITE

_ NS_MAX_FLUSH_W: Flush wait time for NetServer to flush oustanding

T writes

_ NS_MAX_SEND_DE: Data Loss Time Bound for NetServer

LAY

_ NUMA_BUFFER_CA: Configure NUMA buffer cache stats

CHE_STATS

_ NUMA_INSTANCE_: Set of nodes that this instance should run on

MAPPING

_ NUMA_POOL_SIZE: aggregate size in bytes of NUMA pool

_ NUMA_SHIFT_ENA: Enable NUMA shift

BLED

_ NUMA_SHIFT_VAL: user defined value for numa nodes shift

UE

_ NUMA_TRACE_LEV: numa trace event

EL

_ NUMBER_CACHED_: maximum number of cached attributes per instance

ATTRIBUTES

_ NUMBER_CACHED_: maximum number of cached group memberships

GROUP_MEMBERSHI

PS

_ NUMBER_GROUP_M: maximum number of group memberships per cache line

EMBERSHIPS_PER_

CACHE_LINE

_ NUM_LONGOP_CHI: number of child latches for long op array

LD_LATCHES

_ OBJECT_NUMBER_: Object number cache size

CACHE_SIZE

_ OBJECT_REUSE_B: if 1 or higher, handle object reuse

AST

_ OBJECT_STATIST: enable the object level statistics collection

ICS

_ OBJECT_STATS_M: Maximum number of entries to be tracked per stat

AX_ENTRIES

_ OBJ_CKPT_TRACI: Enable object checkpoint tracing

NG

_ ODCI_AGGREGATE: trade speed for space in user-defined aggregation

_ SAVE_SPACE

_ OFFLINE_ROLLBA: offline undo segment list

CK_SEGMENTS

_ OGMS_HOME: GMS home directory

_ OLAPI_HISTORY_: enable olapi history retention

RETENTION

_ OLAPI_IFACE_OB: enable olapi interface object history collection

JECT_HISTORY

_ OLAPI_IFACE_OB: enable olapi interface object history retention

JECT_HISTORY_RE

TENTION

_ OLAPI_IFACE_OP: enable olapi interface operation history retention

ERATION_HISTORY

_ RETENTION

_ OLAPI_INTERFAC: enable olapi interface operation history collection

E_OPERATION_HIS

TORY

_ OLAPI_MEMORY_O: enable olapi memory alloc/free history collection

PERATION_HISTOR

Y

_ OLAPI_MEMORY_O: enable olapi memory alloc/free history collection

PERATION_HISTOR pausing

Y_PAUSE_AT_SEQN

O

_ OLAPI_MEMORY_O: enable olapi memory operation history retention

PERATION_HISTOR

Y_RETENTION

_ OLAPI_SESSION_: enable olapi session history collection

HISTORY

_ OLAPI_SESSION_: enable olapi session history retention

HISTORY_RETENTI

ON

_ OLAP_ADV_COMP_: do additional predicate stats analysis for AW rowsource

STATS_CC_PRECOM

P

_ OLAP_ADV_COMP_: do additional predicate stats analysis for AW rowsource

STATS_MAX_ROWS

_ OLAP_AGGREGATE: OLAP Aggregate max buffer size

_ BUFFER_SIZE

_ OLAP_AGGREGATE: OLAP Aggregate debug flags

_ FLAGS

_ OLAP_AGGREGATE: OLAP Aggregate function cache enabler

_ FUNCTION_CACHE

_ ENABLED

_ OLAP_AGGREGATE: OLAP Aggregate max thread tuples creation

_ MAX_THREAD_TUP

LES

_ OLAP_AGGREGATE: OLAP Aggregate min buffer size

_ MIN_BUFFER_SIZ

E

_ OLAP_AGGREGATE: OLAP Aggregate minimum cardinality of dimensions for

_ MIN_THREAD_STA thread

TUS

_ OLAP_AGGREGATE: OLAP Aggregate Multi-path Hierarhies enabled

_ MULTIPATH_HIER

_ OLAP_AGGREGATE: OLAP Aggregate status array usage threshold

_ STATLEN_THRESH

_ OLAP_AGGREGATE: OLAP Aggregate max worklists generated at once

_ WORKLIST_MAX

_ OLAP_AGGREGATE: OLAP Aggregate max work parents

_ WORK_PER_THREA

D

_ OLAP_ALLOCATE_: OLAP Allocate Errorlog Format

ERRORLOG_FORMAT

_ OLAP_ALLOCATE_: OLAP Allocate Errorlog Header format

ERRORLOG_HEADER

_ OLAP_ANALYZE_M: OLAP DML ANALYZE command max cells to analyze

AX

_ OLAP_CONTINUOU: OLAP logging definition

S_TRACE_FILE

_ OLAP_DBGOUTFIL: OLAP DbgOutfile copy output to event log (tracefile)

E_ECHO_TO_EVENT

LOG

_ OLAP_DIMENSION: OLAP Dimension In-Core Hash Table Force

_ COREHASH_FORCE

_ OLAP_DIMENSION: OLAP Dimension In-Core Hash Table Large Threshold

_ COREHASH_LARGE

_ OLAP_DIMENSION: OLAP Dimension In-Core Hash Table Pressure Threshold

_ COREHASH_PRESS

URE

_ OLAP_DIMENSION: OLAP Dimension In-Core Hash Table Maximum Memory Use

_ COREHASH_SIZE

_ OLAP_EIF_EXPOR: OLAP EIF Export BLOB size

T_LOB_SIZE

_ OLAP_LMGEN_DIM: Limitmap generator dimension column size

_ SIZE

_ OLAP_LMGEN_MEA: Limitmap generator measure column size

S_SIZE

_ OLAP_OBJECT_HA: OLAP Object Hash Table Class

SH_CLASS

_ OLAP_PAGE_POOL: OLAP Page Pool Expand Rate

_ EXPAND_RATE

_ OLAP_PAGE_POOL: OLAP Page Pool High Watermark

_ HI

_ OLAP_PAGE_POOL: OLAP Page Pool Hit Target

_ HIT_TARGET

_ OLAP_PAGE_POOL: OLAP Page Pool Low Watermark

_ LOW

_ OLAP_PAGE_POOL: OLAP Page Pool Pressure Threshold

_ PRESSURE

_ OLAP_PAGE_POOL: OLAP Page Pool Shrink Rate

_ SHRINK_RATE

_ OLAP_PARALLEL_: OLAP parallel update server count

UPDATE_SERVER_N

UM

_ OLAP_PARALLEL_: OLAP parallel update threshold for number of small

UPDATE_SMALL_TH pagespaces

RESHOLD

_ OLAP_PARALLEL_: OLAP parallel update threshold in pages

UPDATE_THRESHOL

D

_ OLAP_ROW_LOAD_: OLAP Row Load Time Precision

TIME_PRECISION

_ OLAP_SESSCACHE: OLAP Session Cache knob

_ ENABLED

_ OLAP_SORT_BUFF: OLAP Sort Buffer Size Percentage

ER_PCT

_ OLAP_SORT_BUFF: OLAP Sort Buffer Size

ER_SIZE

_ OLAP_STATBOOL_: OLAP Status Boolean max incore bits

COREBITS

_ OLAP_STATBOOL_: OLAP Status Boolean CBM threshold

THRESHOLD

_ OLAP_TABLE_FUN: Specify TRUE to output OLAP table function timed

CTION_STATISTIC statistics trace

S

_ OLAP_WRAP_ERRO: Wrap error messages to OLAP outfile

RS

_ OLD_CONNECT_BY: enable/disable old connect by

_ ENABLED

_ OLD_EXTENT_SCH: Revert to old extent allocation

EME

_ OLS_CLEANUP_TA: Clean up unnecessary entries in OLS sessinfo table

SK

_ OLTP_COMPRESSI: oltp compression enabled

ON

_ OLTP_COMPRESSI: oltp compression gain

ON_GAIN

_ OLTP_COMP_DBG_: oltp compression scan debug

SCAN

_ OLTP_SPILL: spill rows for oltp compression if loader pga limit is

Exceeded

_ OMF: enable/disable OMF

_ OMNI_ENQUEUE_E: Enable Omni Enqueue feature (0 = disable, 1 = enable on

NABLE ASM (default), 2 = enable)

_ ONESIDE_COLSTA: sanity check on default selectivity for like/range

T_FOR_EQUIJOINS predicate

_ ONLINE_CTAS_DI: controls dumping diagnostic information for online ctas

AG

_ ONLINE_PATCH_D: disable check for function on stack for online patches

ISABLE_STACK_CH

ECK

_ OPS_PER_SEMOP: the exact number of operations per semop system call

_ OPTIMIZER_ADAP: optimizer adaptive cursor sharing

TIVE_CURSOR_SHA

RING

_ OPTIMIZER_ADAP: enable adaptive plans

TIVE_PLANS

_ OPTIMIZER_ADAP: internal controls for adaptive plans

TIVE_PLAN_CONTR

OL

_ OPTIMIZER_ADJU: adjust selectivity for null values

ST_FOR_NULLS

_ OPTIMIZER_ADS_: maximum number of tables in a join under ADS

MAX_TABLE_COUNT

_ OPTIMIZER_ADS_: maximum time limit (seconds) under ADS

TIME_LIMIT

_ OPTIMIZER_ADS_: use result cache for ADS queries

USE_RESULT_CACH

E

_ OPTIMIZER_ANSI: optimization of left/full ansi-joins and lateral views

_ JOIN_LATERAL_E

NHANCE

_ OPTIMIZER_ANSI: re-architecture of ANSI left, right, and full outer

_ REARCHITECTURE joins

_ OPTIMIZER_AUTO: enable/disable auto stats collection job

STATS_JOB

_ OPTIMIZER_AW_J: Enables AW Join Push optimization

OIN_PUSH_ENABLE

D

_ OPTIMIZER_AW_S: Enables statistcs on AW olap_table table function

TATS_ENABLED

_ OPTIMIZER_BATC: enable table access by ROWID IO batching

H_TABLE_ACCESS_

BY_ROWID

_ OPTIMIZER_BETT: enable improved costing of index access using

ER_INLIST_COSTI in-list (s)

NG

_ OPTIMIZER_BLOC: standard block size used by optimizer

K_SIZE

_ OPTIMIZER_CACH: cost with cache statistics

E_STATS

_ OPTIMIZER_CART: optimizer cartesian join enabled

ESIAN_ENABLED

_ OPTIMIZER_CBQT: cost factor for cost-based query transformation

_ FACTOR

_ OPTIMIZER_CBQT: disable cost based transformation query size

_ NO_SIZE_RESTRI restriction

CTION

_ OPTIMIZER_CEIL: CEIL cost in CBO

_ COST

_ OPTIMIZER_CLUS: enable/disable the cluster by rowid feature

TER_BY_ROWID

_ OPTIMIZER_CLUS: internal control for cluster by rowid feature mode

TER_BY_ROWID_CO

NTROL

_ OPTIMIZER_COAL: consider coalescing of subqueries optimization

ESCE_SUBQUERIES

_ OPTIMIZER_COMP: enable selectivity estimation for builtin functions

LEX_PRED_SELECT

IVITY

_ OPTIMIZER_COMP: force index stats collection on index creation/rebuild

UTE_INDEX_STATS

_ OPTIMIZER_CONN: use cost-based transformation for whr clause in connect

ECT_BY_CB_WHR_O by

NLY

_ OPTIMIZER_CONN: combine no filtering connect by and start with

ECT_BY_COMBINE_

SW

_ OPTIMIZER_CONN: use cost-based transformation for connect by

ECT_BY_COST_BAS

ED

_ OPTIMIZER_CONN: allow connect by to eliminate duplicates from input

ECT_BY_ELIM_DUP

S

_ OPTIMIZER_CORR: force correct computation of subquery selectivity

ECT_SQ_SELECTIV

ITY

_ OPTIMIZER_COST: enables cost-based query transformation

_ BASED_TRANSFOR

MATION

_ OPTIMIZER_COST: enables costing of filter predicates in IO cost model

_ FILTER_PRED

_ OPTIMIZER_COST: add cost of generating result set when # rows per key >

_ HJSMJ_MULTIMAT 1

CH

_ OPTIMIZER_COST: optimizer cost model

_ MODEL

_ OPTIMIZER_CUBE: enable cube join

_ JOIN_ENABLED

_ OPTIMIZER_DEGR: force the optimizer to use the same degree of

EE parallelism

_ OPTIMIZER_DIM_: use join selectivity in choosing star transformation

SUBQ_JOIN_SEL dimensions

_ OPTIMIZER_DISA: disable star transformation sanity checks

BLE_STRANS_SANI

TY_CHECKS

_ OPTIMIZER_DIST: Transforms Distinct Aggregates to non-distinct

INCT_AGG_TRANSF aggregates

ORM

_ OPTIMIZER_DIST: Eliminates redundant SELECT DISTNCT's

INCT_ELIMINATIO

N

_ OPTIMIZER_DIST: consider distinct placement optimization

INCT_PLACEMENT

_ OPTIMIZER_DSDI: controls optimizer usage of dynamic sampling directives

R_USAGE_CONTROL

_ OPTIMIZER_DYN_: number of blocks for optimizer dynamic sampling

SMP_BLKS

_ OPTIMIZER_ELIM: optimizer filtering join elimination enabled

INATE_FILTERING

_ JOIN

_ OPTIMIZER_ENAB: use improved density computation for selectivity

LE_DENSITY_IMPR estimation

OVEMENTS

_ OPTIMIZER_ENAB: use extended statistics for selectivity estimation

LE_EXTENDED_STA

TS

_ OPTIMIZER_ENAB: consider table lookup by nl transformation

LE_TABLE_LOOKUP

_ BY_NL

_ OPTIMIZER_ENHA: push filters before trying cost-based query

NCED_FILTER_PUS transformation

H

_ OPTIMIZER_EXTE: optimizer extended cursor sharing

NDED_CURSOR_SHA

RING

_ OPTIMIZER_EXTE: optimizer extended cursor sharing for relational

NDED_CURSOR_SHA operators

RING_REL

_ OPTIMIZER_EXTE: controls the optimizer usage of extended stats

NDED_STATS_USAG

E_CONTROL

_ OPTIMIZER_EXTE: join pred pushdown on group-by, distinct

ND_JPPD_VIEW_TY semi-/anti-joined view

PES

_ OPTIMIZER_FALS: optimizer false predicate pull up transformation

E_FILTER_PRED_P

ULLUP

_ OPTIMIZER_FAST: use fast algorithm to traverse predicates for physical

_ ACCESS_PRED_AN optimizer

ALYSIS

_ OPTIMIZER_FAST: use fast algorithm to generate transitive predicates

_ PRED_TRANSITIV

ITY

_ OPTIMIZER_FEED: controls the optimizer feedback framework

BACK_CONTROL

_ OPTIMIZER_FILT: use cost-based flter predicate pull up transformation

ER_PRED_PULLUP

_ OPTIMIZER_FILT: enable/disable filter predicate pushdown

ER_PUSHDOWN

_ OPTIMIZER_FKR_: Optimizer index bias over FTS/IFFS under first K rows

INDEX_COST_BIAS mode

_ OPTIMIZER_FORC: force CBQT transformation regardless of cost

E_CBQT

_ OPTIMIZER_FREE: free transformation subheap after each transformation

_ TRANSFORMATION

_ HEAP

_ OPTIMIZER_FULL: enable/disable full outer to left outer join conversion

_ OUTER_JOIN_TO_

OUTER

_ OPTIMIZER_GATH: optimizer gather feedback

ER_FEEDBACK

_ OPTIMIZER_GATH: enable/disable online statistics gathering

ER_STATS_ON_LOA

D

_ OPTIMIZER_GENE: optimizer generate transitive predicates

RATE_TRANSITIVE

_ PRED

_ OPTIMIZER_GROU: consider group-by placement optimization

P_BY_PLACEMENT

_ OPTIMIZER_HYBR: enable hybrid full partition-wise join when TRUE

ID_FPWJ_ENABLED

_ OPTIMIZER_IGNO: enables the embedded hints to be ignored

RE_HINTS

_ OPTIMIZER_IMPR: improve table and partial overlap join selectivity

OVE_SELECTIVITY computation

_ OPTIMIZER_INST: force the optimizer to use the specified number of

ANCE_COUNT instances

_ OPTIMIZER_INTE: interleave join predicate pushdown during CBQT

RLEAVE_JPPD

_ OPTIMIZER_INVA: time window for invalidation of cursors of analyzed

LIDATION_PERIOD objects

_ OPTIMIZER_JOIN: optimizer join elimination enabled

_ ELIMINATION_EN

ABLED

_ OPTIMIZER_JOIN: use join factorization transformation

_ FACTORIZATION

_ OPTIMIZER_JOIN: controls the optimizer join order search algorithm

_ ORDER_CONTROL

_ OPTIMIZER_JOIN: enable/disable sanity check for multi-column join

_ SEL_SANITY_CHE selectivity

CK

_ OPTIMIZER_MAX_: optimizer maximum join permutations per query block

PERMUTATIONS

_ OPTIMIZER_MIN_: set minimum cached blocks

CACHE_BLOCKS

_ OPTIMIZER_MJC_: enable merge join cartesian

ENABLED

_ OPTIMIZER_MODE: force setting of optimizer mode for user recursive SQL

_ FORCE also

_ OPTIMIZER_MULT: generate and run plans using several compilation

IPLE_CENV environments

_ OPTIMIZER_MULT: control what to report in trace file when run in

IPLE_CENV_REPOR multi-plan mode

T

_ OPTIMIZER_MULT: control the types of statements that are run in

IPLE_CENV_STMT multi-plan mode

_ OPTIMIZER_MULT: consider join-predicate pushdown that requires

I_LEVEL_PUSH_PR multi-level pushdown to base table

ED

_ OPTIMIZER_MULT: allows multiple tables on the left of outerjoin

I_TABLE_OUTERJO

IN

_ OPTIMIZER_NATI: execute full outer join using native implementaion

VE_FULL_OUTER_J

OIN

_ OPTIMIZER_NEST: number of groups above which we use nested rollup exec

ED_ROLLUP_FOR_G for gset

SET

_ OPTIMIZER_NEW_: compute join cardinality using non-rounded input values

JOIN_CARD_COMPU

TATION

_ OPTIMIZER_NULL: enables null-accepting semijoin

_ ACCEPTING_SEMI

JOIN

_ OPTIMIZER_NULL: null-aware antijoin parameter

_ AWARE_ANTIJOIN

_ OPTIMIZER_ORDE: Eliminates order bys from views before query

R_BY_ELIMINATIO transformation

N_ENABLED

_ OPTIMIZER_OR_E: control or expansion approach used

XPANSION

_ OPTIMIZER_OR_E: Use subheap for optimizer or-expansion

XPANSION_SUBHEA

P

_ OPTIMIZER_OUTE: enable/disable outer to inner join conversion

R_JOIN_TO_INNER

_ OPTIMIZER_OUTE: Enable transformation of outer-join to anti-join if

R_TO_ANTI_ENABL possible

ED

_ OPTIMIZER_PART: partial join evaluation parameter

IAL_JOIN_EVAL

_ OPTIMIZER_PERC: optimizer percent parallel

ENT_PARALLEL

_ OPTIMIZER_PERF: controls the performance feedback

ORMANCE_FEEDBAC

K

_ OPTIMIZER_PROC: control the level of processing rates

_ RATE_LEVEL

_ OPTIMIZER_PROC: control the source of processing rates

_ RATE_SOURCE

_ OPTIMIZER_PURG: number of rows to be deleted at each iteration of the

E_STATS_ITERATI stats purging process

ON_ROW_COUNT

_ OPTIMIZER_PUSH: push down distinct from query block to table

_ DOWN_DISTINCT

_ OPTIMIZER_PUSH: use cost-based query transformation for push pred

_ PRED_COST_BASE optimization

D

_ OPTIMIZER_RAND: optimizer seed value for random plans

OM_PLAN

_ OPTIMIZER_REUS: reuse cost annotations during cost-based query

E_COST_ANNOTATI transformation

ONS

_ OPTIMIZER_ROWN: Default value to use for rownum bind

UM_BIND_DEFAULT

_ OPTIMIZER_ROWN: enable the use of first K rows due to rownum predicate

UM_PRED_BASED_F

KR

_ OPTIMIZER_SAVE: enable/disable saving old versions of optimizer stats

_ STATS

_ OPTIMIZER_SEAR: optimizer search limit

CH_LIMIT

_ OPTIMIZER_SELF: account for self-induced caching

_ INDUCED_CACHE_

COST

_ OPTIMIZER_SKIP: enable/disable index skip scan

_ SCAN_ENABLED

_ OPTIMIZER_SKIP: consider index skip scan for predicates with guessed

_ SCAN_GUESS selectivity

_ OPTIMIZER_SORT: enable/disable sort-merge join method

MERGE_JOIN_ENAB

LED

_ OPTIMIZER_SORT: enable/disable sort-merge join using inequality

MERGE_JOIN_INEQ predicates

UALITY

_ OPTIMIZER_SQU_: enables unnesting of subquery in a bottom-up manner

BOTTOMUP

_ OPTIMIZER_STAR: optimizer star plan enabled

PLAN_ENABLED

_ OPTIMIZER_STAR: optimizer star transformation minimum cost

_ TRANS_MIN_COST

_ OPTIMIZER_STAR: optimizer star transformation minimum ratio

_ TRANS_MIN_RATI

O

_ OPTIMIZER_STAR: enable/disable star transformation in with clause

_ TRAN_IN_WITH_C queries

LAUSE

_ OPTIMIZER_STRA: allow adaptive pruning of star transformation bitmap

NS_ADAPTIVE_PRU trees

NING

_ OPTIMIZER_SYST: system statistics usage

EM_STATS_USAGE

_ OPTIMIZER_TABL: consider table expansion transformation

E_EXPANSION

_ OPTIMIZER_TRAC: optimizer trace parameter

E

_ OPTIMIZER_TRAN: retain equi-join pred upon transitive equality pred

SITIVITY_RETAIN generation

_ OPTIMIZER_TRY_: try Star Transformation before Join Predicate Push Down

ST_BEFORE_JPPD

_ OPTIMIZER_UNDO: undo changes to query optimizer

_ CHANGES

_ OPTIMIZER_UNDO: optimizer undo cost change

_ COST_CHANGE

_ OPTIMIZER_UNNE: enables unnesting of every type of subquery

ST_ALL_SUBQUERI

ES

_ OPTIMIZER_UNNE: Unnesting of correlated set subqueries (TRUE/FALSE)

ST_CORR_SET_SUB

Q

_ OPTIMIZER_UNNE: Unnesting of disjunctive subqueries (TRUE/FALSE)

ST_DISJUNCTIVE_

SUBQ

_ OPTIMIZER_UNNE: enables unnesting of of scalar subquery

ST_SCALAR_SQ

_ OPTIMIZER_USE_: use rewritten star transformation using cbqt framework

CBQT_STAR_TRANS

FORMATION

_ OPTIMIZER_USE_: optimizer use feedback

FEEDBACK

_ OPTIMIZER_USE_: use GTT session private statistics

GTT_SESSION_STA

TS

_ OPTIMIZER_USE_: enable/disable the usage of histograms by the optimizer

HISTOGRAMS

_ OPTIMIZER_USE_: Enables physical optimizer subheap

SUBHEAP

_ OPTIM_ADJUST_F: adjust stats for skews across partitions

OR_PART_SKEWS

_ OPTIM_DICT_STA: enable/disable dictionary stats gathering at db

TS_AT_DB_CR_UPG create/upgrade

_ OPTIM_ENHANCE_: TRUE to enable index [fast] full scan more often

NNULL_DETECTION

_ OPTIM_NEW_DEFA: improves the way default equijoin selectivity are

ULT_JOIN_SEL computed

_ OPTIM_PEEK_USE: enable peeking of user binds

R_BINDS

_ ORACLE_SCRIPT: Running an Oracle-supplied script

_ ORADBG_PATHNAM: path of oradbg script

E

_ ORADEBUG_CMDS_: oradebug commands to execute at instance startup

AT_STARTUP

_ ORADEBUG_FORCE: force target processes to execute oradebug commands?

_ ORDERED_NESTED: enable ordered nested loop costing

_ LOOP

_ ORDERED_SEMIJO: enable ordered semi-join subquery

IN

_ ORPH_CLN_INTER: qmon periodic interval for removed subscriber messages

VAL cleanup

_ OR_EXPAND_NVL_: enable OR expanded plan for NVL/DECODE predicate

PREDICATE

_ OSS_SKGXP_UDP_: OSSLIB enable [! 0] / disable [0] dynamic credit mgmt for

DYNAMIC_CREDIT_ SKGXP-UDP

MGMT

_ OS_SCHED_HIGH_: OS high priority level

PRIORITY

_ OTHER_WAIT_EVE: exclude event names from _ other_wait_threshold

NT_EXCLUSION calculations

_ OTHER_WAIT_THR: threshold wait percentage for event wait class Other

ESHOLD

_ OUTLINE_BITMAP: BITMAP_TREE hint enabled in outline

_ TREE

_ PARALLELISM_CO: set the parallelism cost fudge factor

ST_FUDGE_FACTOR

_ PARALLEL_ADAPT: maximum number of users running with default DOP

IVE_MAX_USERS

_ PARALLEL_BLACK: parallel execution blackbox enabled

BOX_ENABLED

_ PARALLEL_BLACK: true if blackbox will be allocated in SGA, false if PGA

BOX_SGA

_ PARALLEL_BLACK: parallel execution blackbox bucket size

BOX_SIZE

_ PARALLEL_BROAD: enable broadcasting of small inputs to hash and sort

CAST_ENABLED merge joins

_ PARALLEL_CLUST: max percentage of the global buffer cache to use for

ER_CACHE_PCT affinity

_ PARALLEL_CLUST: policy used for parallel execution on

ER_CACHE_POLICY cluster (ADAPTIVE/CACHED)

_ PARALLEL_CONSE: conservative parallel statement queuing

RVATIVE_QUEUING

_ PARALLEL_CTAS_: enable/disable parallel CTAS operation

ENABLED

_ PARALLEL_DEFAU: default maximum number of instances for parallel query

LT_MAX_INSTANCE

S

_ PARALLEL_EXECU: Alignment of PX buffers to OS page boundary

TION_MESSAGE_AL

IGN

_ PARALLEL_FAKE_: fake db-scheduler percent used for testing

CLASS_PCT

_ PARALLEL_FAULT: total number of faults fault-tolerance will handle

_ TOLERANCE_THRE

SHOLD

_ PARALLEL_FIXWR: Number of buckets for each round of fix write

ITE_BUCKET

_ PARALLEL_HEART: interval of snapshot to track px msging between

BEAT_SNAPSHOT_I instances

NTERVAL

_ PARALLEL_HEART: maximum number of historical snapshots archived

BEAT_SNAPSHOT_M

AX

_ PARALLEL_LOAD_: parallel execution load balanced slave allocation

BALANCING

_ PARALLEL_LOAD_: number of threads to allocate per instance

BAL_UNIT

_ PARALLEL_LOAD_: diffrence in percentage controlling px load propagation

PUBLISH_THRESHO

LD

_ PARALLEL_MIN_M: minimum size of shared pool memory to reserve for pq

ESSAGE_POOL servers

_ PARALLEL_OPTIM: parallel optimization phase when all slaves are local

IZATION_PHASE_F

OR_LOCAL

_ PARALLEL_QUEUI: parallel statement queuing: max waiting time in queue

NG_MAX_WAITINGT

IME

_ PARALLEL_RECOV: stop at-position- to step through SMON

ERY_STOPAT

_ PARALLEL_REPLA: Number of messages for each round of parallel replay

Y_MSG_LIMIT

_ PARALLEL_SCALA: Parallel scalability criterion for parallel execution

BILITY

_ PARALLEL_SERVE: idle time before parallel query server dies (in 1Comp100)

R_IDLE_TIME sec)

_ PARALLEL_SERVE: sleep time between dequeue timeouts (in 1/100ths)

R_SLEEP_TIME

_ PARALLEL_SLAVE: time (in seconds) to wait before retrying slave

_ ACQUISITION_WA acquisition

IT

_ PARALLEL_STATE: parallel statement queuing enabled

MENT_QUEUING

_ PARALLEL_SYSPL: TRUE to obey force parallel query/dml/ddl under System

S_OBEY_FORCE PL/SQL

_ PARALLEL_TIME_: unit of work used to derive the degree of parallelism

UNIT (in seconds)

_ PARALLEL_TXN_G: enable parallel_txn hint with updates and deletes

LOBAL

_ PARAMETER_TABL: parameter table block size

E_BLOCK_SIZE

_ PARTIAL_PWISE_: enable partial partition-wise join when TRUE

JOIN_ENABLED

_ PARTITION_ADVI: enables sampling based partitioning validation

SOR_SRS_ACTIVE

_ PARTITION_CDB_: partitioned cdb view evaluation enabled

VIEW_ENABLED

_ PARTITION_LARG: Enables large extent allocation for partitioned tables

E_EXTENTS

_ PARTITION_VIEW: enable/disable partitioned views

_ ENABLED

_ PART_ACCESS_VE: use version numbers to access versioned objects for

RSION_BY_NUMBER partitioning

_ PART_REDEF_GLO: online partition redefinition update global indexes

BAL_INDEX_UPDAT

E

_ PASSWORDFILE_E: password file enqueue timeout in seconds

NQUEUE_TIMEOUT

_ PCT_REFRESH_DO: materialized view PCT refreshes avoid double counting

UBLE_COUNT_PREV

ENTED

_ PDB_USE_SEQUEN: Use sequence cache in PDB mode

CE_CACHE

_ PDML_GIM_SAMPL: control separation of global index maintenance for PDML

ING

_ PDML_GIM_STAGG: slaves start on different index when doing index maint

ERED

_ PDML_SLAVES_DI: slaves start on different partition when doing index

FF_PART maint

_ PERCENT_FLASHB: Percent of flashback buffer filled to be considered

ACK_BUF_PARTIAL partial full

_ FULL

_ PGACTX_CAP_STA: capture stacks for setting pgactx

CKS

_ PGA_LARGE_EXTE: PGA large extent size

NT_SIZE

_ PGA_LIMIT_CHEC: microseconds to wait for over limit confirmation

K_WAIT_TIME

_ PGA_LIMIT_DUMP: dump PGA summary when signalling ORA-4036

_ SUMMARY

_ PGA_LIMIT_INTE: whether to interrupt smaller eligible processes

RRUPT_SMALLER

_ PGA_LIMIT_MIN_: bytes of PGA usage below which process will not get

REQ_SIZE ORA-4036

_ PGA_LIMIT_SIMU: bytes of physical memory to determine

LATED_PHYSMEM_S pga_aggregate_limit with

IZE

_ PGA_LIMIT_TARG: default percent of pga_aggregate_target for

ET_PERC pga_aggregate_limit

_ PGA_LIMIT_TIME: seconds to wait until direct interrupt

_ TO_INTERRUPT

_ PGA_LIMIT_TIME: seconds to wait before treating process as idle

_ UNTIL_IDLE

_ PGA_LIMIT_TIME: seconds to wait before killing session over limit

_ UNTIL_KILLED

_ PGA_LIMIT_TRAC: trace pga_aggregate_limit activity

ING

_ PGA_LIMIT_USE_: use immediate kill for sessions over limit

IMMEDIATE_KILL

_ PGA_LIMIT_WATC: percentage of limit to have processes watch

H_PERC

_ PGA_LIMIT_WATC: bytes of PGA usage at which process will begin watching

H_SIZE limit

_ PGA_MAX_SIZE: Maximum size of the PGA memory for one process

_ PING_WAIT_FOR_: Wait for log force before block ping

LOG_FORCE

_ PIN_TIME_STATI: if TRUE collect statistics for how long a current pin

STICS is held

_ PIVOT_IMPLEMEN: pivot implementation method

TATION_METHOD

_ PKT_ENABLE: enable progressive kill test

_ PKT_PMON_INTER: PMON process clean-up interval (cs)

VAL

_ PKT_START: start progressive kill test instrumention

_ PLAN_OUTLINE_D: explain plan outline data enabled

ATA

_ PLAN_VERIFY_IM: Performance improvement criterion for evolving plan

PROVEMENT_MARGI baselines

N

_ PLAN_VERIFY_LO: Local time limit to use for an individual plan

CAL_TIME_LIMIT verification

_ PLSQL_ANON_BLO: PL/SQL anonymous block code-type

CK_CODE_TYPE

_ PLSQL_CACHE_EN: PL/SQL Function Cache Enabled

ABLE

_ PLSQL_DUMP_BUF: conditions upon which the PL/SQL circular buffer is

FER_EVENTS dumped

_ PLSQL_MAX_STAC: PL/SQL maximum stack size

K_SIZE

_ PLSQL_MINIMUM_: plsql minimum cache hit percentage required to keep

CACHE_HIT_PERCE caching active

NT

_ PLSQL_NATIVE_F: Allocate PL/SQL native frames on the heap if size

RAME_THRESHOLD exceeds this value

_ PLSQL_NVL_OPTI: PL/SQL NVL optimize

MIZE

_ PLUGGABLE_DATA: Debug flag for pluggable database related operations

BASE_DEBUG

_ PMON_DEAD_BLKR: rate to check blockers are alive during cleanup (in

S_ALIVE_CHK_RAT seconds)

E_SECS

_ PMON_DEAD_BLKR: max blockers to check during cleanup

S_MAX_BLKRS

_ PMON_DEAD_BLKR: max attempts per blocker while checking dead blockers

S_MAX_CLEANUP_A

TTEMPTS

_ PMON_DEAD_BLKR: rate to scan for dead blockers during cleanup (in

S_SCAN_RATE_SEC seconds)

S

_ PMON_ENABLE_DE: look for dead blockers during PMON cleanup

AD_BLKRS

_ PMON_LOAD_CONS: server load balancing constants (SMagol Precinct Drecoy I Magi L C Magi M)

TANTS

_ PMON_MAX_CONSE: PMON max consecutive posts in main loop

C_POSTS

_ POST_WAIT_QUEU: Post Wait Queues-Num Dynamic Queues

ES_DYNAMIC_QUEU

ES

_ POST_WAIT_QUEU: Post Wait Queues-Num Per Class

ES_NUM_PER_CLAS

S

_ PQQ_DEBUG_TXN_: pq queuing transaction active

ACT

_ PQQ_ENABLED: Enable Resource Manager based Parallel Statement

Queuing

_ PRECOMPUTE_GID: precompute gid values and copy them before returning a

_ VALUES row

_ PREDICATE_ELIM: allow predicate elimination if set to TRUE

INATION_ENABLED

_ PRED_MOVE_AROU: enables predicate move-around

ND

_ PRED_PUSH_CDB_: predicate pushdown enabled for CDB views

VIEW_ENABLED

_ PREFERED_STAND: standby db_unique_name prefered for krb operations

BY

_ PRESCOMM: presume commit of IMU transactions

_ PRE_REWRITE_PU: push predicates into views before rewrite

SH_PRED

_ PRINT_INMEM_HE: print inmem ilm heatmap

ATMAP

_ PRINT_REFRESH_: enable dbms_output of materialized view refresh

SCHEDULE schedule

_ PRINT_STAT_SEG: print ilm statistics segment

MENT

_ PRIVATE_MEMORY: Start address of large extent memory segment

_ ADDRESS

_ PROJECTION_PUS: projection pushdown

HDOWN

_ PROJECTION_PUS: level for projection pushdown debugging

HDOWN_DEBUG

_ PROJECT_VIEW_C: enable projecting out unreferenced columns of a view

OLUMNS

_ PROP_OLD_ENABL: Shift to pre 11g propagation behaviour

ED

_ PROTECT_FRAME_: Protect cursor frame heaps

HEAPS

_ PTN_CACHE_THRE: flags and threshold to control partition metadata

SHOLD caching

_ PUSH_JOIN_PRED: enable pushing join predicate inside a view

ICATE

_ PUSH_JOIN_UNIO: enable pushing join predicate inside a union all view

N_VIEW

_ PUSH_JOIN_UNIO: enable pushing join predicate inside a union view

N_VIEW2

_ PX_ADAPTIVE_DI: determines the behavior of adaptive distribution

ST_METHOD methods

_ PX_ADAPTIVE_DI: Buffering / decision threshold for adaptive

ST_METHOD_THRES distribution methods

HOLD

_ PX_ADAPTIVE_OF: percentage for PQ adaptive offloading of granules

FLOAD_PERCENTAG

E

_ PX_ADAPTIVE_OF: threshold (GB/s) for PQ adaptive offloading of granules

FLOAD_THRESHOLD

_ PX_ASYNC_GETGR: asynchronous get granule in the slave

ANULE

_ PX_BACK_TO_PAR: allow going back to parallel after a serial operation

ALLEL

_ PX_BIND_PEEK_S: enables sharing of px cursors that were built using

HARING bind peeking

_ PX_BROADCAST_F: set the tq broadcasting fudge factor percentage

UDGE_FACTOR

_ PX_BUFFER_TTL: ttl for px mesg buffers in seconds

_ PX_CDB_VIEW_EN: parallel cdb view evaluation enabled

ABLED

_ PX_CHUNKLIST_C: ratio of the number of chunk lists to the default DOP

OUNT_RATIO per instance

_ PX_COMPILATION: debug level for parallel compilation

_ DEBUG

_ PX_COMPILATION: tracing level for parallel compilation

_ TRACE

_ PX_CONCURRENT: enables pq with concurrent execution of serial inputs

_ PX_CPU_AUTODOP: enables or disables auto dop cpu computation

_ ENABLED

_ PX_CPU_OPERATO: CPU operator bandwidth in MB/sec for DOP computation

R_BANDWIDTH

_ PX_CPU_PROCESS: CPU process bandwidth in MB/sec for DOP computation

_ BANDWIDTH

_ PX_DP_ARRAY_SI: Max number of pq processes supported

ZE

_ PX_DUMP_12805_: enables or disables tracing of 12805 signal source

SOURCE

_ PX_DYNAMIC_OPT: turn off/on restartable qerpx dynamic optimization

_ PX_DYNAMIC_SAM: num of samples for restartable qerpx dynamic

PLE_SIZE optimization

_ PX_EXECUTION_S: enable service-based constraint of px slave allocation

ERVICES_ENABLED

_ PX_FILTER_PARA: enables or disables correlated filter parallelization

LLELIZED

_ PX_FILTER_SKEW: enable correlated filter parallelization to handle skew

_ HANDLING

_ PX_FREELIST_LA: Divide the computed number of freelists by this power

TCH_DIVISOR of 2

_ PX_GIM_FACTOR: weighted autodop global index maintenance factor

_ PX_GRANULE_BAT: maximum size of a batch of granules

CH_SIZE

_ PX_GRANULE_RAN: enables or disables randomization of parallel scans

DOMIZE rowid granules

_ PX_GRANULE_SIZ: default size of a rowid range granule (in KB)

E

_ PX_GROUPBY_PUS: perform group-by pushdown for parallel query

HDOWN

_ PX_HOLD_TIME: hold px at execution time (unit: second)

_ PX_HYBRID_TSM_: Enable Hybrid Temp Segment Merge/High Water Mark

HWMB_LOAD Brokered load method

_ PX_INDEX_SAMPL: parallel query sampling for index create based on

ING_OBJSIZE object size

_ PX_IO_PROCESS_: IO process bandwidth in MB/sec for computing DOP

BANDWIDTH

_ PX_IO_SYSTEM_B: total IO system bandwidth in MB/sec for computing DOP

ANDWIDTH

_ PX_JOIN_SKEW_H: enables skew handling for parallel joins

ANDLING

_ PX_JOIN_SKEW_M: sets minimum frequency (%) for skewed value for parallel

INFREQ joins

_ PX_JOIN_SKEW_R: sets skew ratio for parallel joins

ATIO

_ PX_KXIB_TRACIN: turn on kxib tracing

G

_ PX_LOAD_BALANC: parallel load balancing policy

ING_POLICY

_ PX_LOAD_FACTOR: weighted autodop load factor

_ PX_LOAD_MONITO: threshold for pushing information to load slave

R_THRESHOLD workload monitor

_ PX_LOAD_PUBLIS: interval at which LMON will check whether to publish PX

H_INTERVAL load

_ PX_LOC_MSG_COS: CPU cost to send a PX message via shared memory

T

_ PX_MAX_GRANULE: maximum number of rowid range granules to generate per

S_PER_SLAVE slave

_ PX_MAX_MAP_VAL: Maximum value of rehash mapping for PX

_ PX_MAX_MESSAGE: percentage of shared pool for px msg buffers range

_ POOL_PCT [5,90]

_ PX_MESSAGE_COM: enable compression of control messages for parallel

PRESSION query

_ PX_MINUS_INTER: enables pq for minus/interect operators

SECT

_ PX_MIN_GRANULE: minimum number of rowid range granules to generate per

S_PER_SLAVE slave

_ PX_MONITOR_LOA: enable consumer load slave workload monitoring

D

_ PX_NET_MSG_COS: CPU cost to send a PX message over the internconnect

T

_ PX_NO_GRANULE_: prevent parallel partition granules to be sorted on

SORT size

_ PX_NO_STEALING: prevent parallel granule stealing in shared nothing

Environment

_ PX_NSS_PLANB: enables or disables NSS Plan B reparse with outline

_ PX_NUMA_STEALI: enable/disable PQ granule stealing across NUMA nodes

NG_ENABLED

_ PX_NUMA_SUPPOR: enable/disable PQ NUMA support

T_ENABLED

_ PX_OBJECT_SAMP: parallel query sampling for base objects (100000 =

LING 100%)

_ PX_OBJECT_SAMP: use base object sampling when possible for range

LING_ENABLED distribution

_ PX_ONEPASS_SLA: enable/disable one pass slave acquisition for parallel

VE_ACQUISITION execution

_ PX_PARALLELIZE: enables or disables expression evaluation

_ EXPRESSION parallelization

_ PX_PARTIAL_ROL: perform partial rollup pushdown for parallel execution

LUP_PUSHDOWN

_ PX_PARTITION_S: enables or disables parallel partition-based scan

CAN_ENABLED

_ PX_PARTITION_S: least number of partitions per slave to start

CAN_THRESHOLD partition-based scan

_ PX_PROACTIVE_S: parallel proactive slave allocation threshold/unit

LAVE_ALLOC_THRE

SHOLD

_ PX_PROC_CONSTR: reduce parallel_max_servers if greater than (processes

AIN-fudge)

_ PX_PWG_ENABLED: parallel partition wise group by enabled

_ PX_PWMR_ENABLE: parallel partition wise match recognize enabled

D

_ PX_REPLICATION: enables or disables replication of small table scans

_ ENABLED

_ PX_ROUND_ROBIN: round robin row count to enq to next slave

_ ROWCNT

_ PX_ROWNUM_PD: turn off/on parallel rownum pushdown optimization

_ PX_SEND_TIMEOU: IPC message send timeout value in seconds

T

_ PX_SINGLE_SERV: allow single-slave dfo in parallel query

ER_ENABLED

_ PX_SLAVES_SHAR: slaves share cursors with QC

E_CURSORS

_ PX_TQ_ROWHVS: turn on intra-row hash valueing sharing in TQ

_ PX_TRACE: px trace parameter

_ PX_UAL_SERIAL_: enables new pq for UNION operators

INPUT

_ PX_USE_LARGE_P: Use Large Pool as source of PX buffers

OOL

_ PX_WIF_DFO_DEC: NDV-aware DFO clumping of multiple window sorts

LUMPING

_ PX_WIF_EXTEND_: extend TQ data redistribution keys for window functions

DISTRIBUTION_KE

YS

_ PX_WIF_MIN_NDV: mininum NDV of TQ keys needed per slave for scalable

_ PER_SLAVE WiF PX

_ PX_XTGRANULE_S: default size of an external table granule (in KB)

IZE

_ QA_CONTROL: Oracle internal parameter to control QA

_ QA_LRG_TYPE: Oracle internal parameter to specify QA lrg type

_ QUERY_COST_REW: perform the cost based rewrite with materialized views

RITE

_ QUERY_EXECUTIO: max size of query execution cache

N_CACHE_MAX_SIZ

E

_ QUERY_MMVREWRI: query mmv rewrite maximum number of cmaps per dmap in

TE_MAXCMAPS query disjunct

_ QUERY_MMVREWRI: query mmv rewrite maximum number of dmaps per query

TE_MAXDMAPS disjunct

_ QUERY_MMVREWRI: query mmv rewrite maximum number of in-lists per

TE_MAXINLISTS disjunct

_ QUERY_MMVREWRI: query mmv rewrite maximum number of intervals per

TE_MAXINTERVALS disjunct

_ QUERY_MMVREWRI: query mmv rewrite maximum number of predicates per

TE_MAXPREDS disjunct

_ QUERY_MMVREWRI: query mmv rewrite maximum number of query in-list

TE_MAXQRYINLIST values

VALS

_ QUERY_MMVREWRI: query mmv rewrite maximum number of region permutations

TE_MAXREGPERM

_ QUERY_ON_PHYSI: query on physical

CAL

_ QUERY_REWRITE_: perform query rewrite before&after or only before view

1 merging

_ QUERY_REWRITE_: perform query rewrite before&after or only after view

2 merging

_ QUERY_REWRITE_: mv rewrite and drop redundant joins

DRJ

_ QUERY_REWRITE_: rewrite with cannonical form for expressions

EXPRESSION

_ QUERY_REWRITE_: mv rewrite fresh partition containment

FPC

_ QUERY_REWRITE_: cost based query rewrite with MVs fudge factor

FUDGE

_ QUERY_REWRITE_: mv rewrite with jg migration

JGMIGRATE

_ QUERY_REWRITE_: query rewrite max disjuncts

MAXDISJUNCT

_ QUERY_REWRITE_: allow query rewrite, if referenced tables are not

OR_ERROR dataless

_ QUERY_REWRITE_: perform general rewrite using set operator summaries

SETOPGRW_ENABLE

_ QUERY_REWRITE_: prune frocol chain before rewrite after view-merging

VOP_CLEANUP

_ QUEUE_BUFFER_M: max number of bytes to dump to trace file for queue

AX_DUMP_LEN buffer dump

_ RADM_ENABLED: Data Redaction

_ RBR_CKPT_TRACI: Enable reuse block range checkpoint tracing

NG

_ RCFG_DISABLE_V: if TRUE disables verify at reconfiguration

ERIFY

_ RCFG_PARALLEL_: if TRUE enables parallel fixwrite at reconfiguration

FIXWRITE

_ RCFG_PARALLEL_: if TRUE enables parallel replay and cleanup at

REPLAY reconfiguration

_ RCFG_PARALLEL_: if TRUE enables parallel verify at reconfiguration

VERIFY

_ RDBMS_COMPATIB: default RDBMS compatibility level

ILITY

_ RDBMS_INTERNAL: enable CELL FPLIB filtering within rdbms

_ FPLIB_ENABLED

_ RDBMS_INTERNAL: enable reraising of any exceptions in CELL FPLIB

_ FPLIB_RAISE_ER

RORS

_ READABLE_STAND: readable standby query scn sync timeout

BY_SYNC_TIMEOUT

_ READ_MOSTLY_EN: Read mostly instances enable non-privileged logons

ABLE_LOGON

_ READ_MOSTLY_IN: indicates this is a read_mostly instance

STANCE

_ READ_MOSTLY_IN: internal parameter to control read mostly instance QA

STANCE_QA_CONTR

OL

_ READ_MOSTLY_SL: Time to wait on read mostly node when hub not available

AVE_TIMEOUT

_ READ_ONLY_VIOL: read-only violation dump to trace files

ATION_DUMP_TO_T

RACE

_ READ_ONLY_VIOL: read-only violation array max count

ATION_MAX_COUNT

_ READ_ONLY_VIOL: read-only violation array per module max count

ATION_MAX_COUNT

_ PER_MODULE

_ REALFREE_HEAP_: minimum max total heap size, in Kbytes

MAX_SIZE

_ REALFREE_HEAP_: mode flags for real-free heap

MODE

_ REALFREE_HEAP_: hint for real-free page size in bytes

PAGESIZE

_ REALFREE_PQ_HE: hint for pq real-free page size in bytes

AP_PAGESIZE

_ REAL_TIME_APPL: Simulation value with real time apply

Y_SIM

_ RECOVERABLE_RE: Recoverable recovery batch size (percentage of buffer

COVERY_BATCH_PE cache)

RCENT

_ RECOVERY_ASSER: if TRUE, enable expensive integrity checks

TS

_ RECOVERY_PERCE: recovery buffer cache percentage

NTAGE

_ RECOVERY_READ_: number of recovery reads which can be outstanding

LIMIT

_ RECOVERY_SKIP_: allow media recovery even if controlfile seq check

CFSEQ_CHECK fails

_ RECOVERY_VERIF: enable thread recovery write verify

Y_WRITES

_ RECURSIVE_IMU_: recursive transactions may be IMU

TRANSACTIONS

_ RECURSIVE_WITH: check for maximum level of recursion instead of

_ MAX_RECURSION_ checking for cycles

LEVEL

_ REDEF_ON_STATE: Use on-statement refresh in online redefinition

MENT

_ REDO_COMPATIBI: general and redo/undo compatibility sanity check

LITY_CHECK

_ REDO_LOG_DEBUG: Various configuration flags for debugging redo logs

_ CONFIG

_ REDO_LOG_RECOR: Life time in hours for redo log table records

D_LIFE

_ REDO_READ_FROM: Enable reading redo from in-memory log buffer

_ MEMORY

_ REDO_TRANSPORT: Is ASYNC LNS compression allowed?

_ COMPRESS_ALL

_ REDO_TRANSPORT: redo transport sanity check bit mask

_ SANITY_CHECK

_ REDO_TRANSPORT: I/O stall time before terminating redo transport

_ STALL_TIME process

_ REDO_TRANSPORT: long I/O stall time before terminating redo transport

_ STALL_TIME_LON process

G

_ REDO_TRANSPORT: test stream connection?

_ STREAM_TEST

_ REDO_TRANSPORT: Stream network writes?

_ STREAM_WRITES

_ REDO_TRANSPORT: VIO size requirement

_ VIO_SIZE_REQ

_ REDUCE_SBY_LOG: enable standby log scan optimization

_ SCAN

_ REGION_NAME: gsm region name

_ RELEASE_INSERT: maximum number of unusable blocks to unlink from

_ THRESHOLD freelist

_ RELIABLE_BLOCK: if TRUE, no side channel on reliable interconnect

_ SENDS

_ RELOCATE_PDB: Relocate PDB to another RAC instance after it is closed

In the current instance

_ RELOCATION_COM: ASM relocation commit batch size

MIT_BATCH_SIZE

_ REMOTE_ASM: remote ASM configuration

_ REMOTE_AWR_ENA: Enable/disable Remote AWR Mode

BLED

_ REMOVE_AGGR_SU: enables removal of subsumed aggregated subquery

BQUERY

_ REMOVE_EXF_COM: enable/disable removing of components EXF and RUL

PONENT during upgrade

_ REPLACE_VIRTUA: replace expressions with virtual columns

L_COLUMNS

_ REPORT_CAPTURE: Time (in sec) between two cycles of report capture

_ CYCLE_TIME daemon

_ REPORT_CAPTURE: 100X Percent of system db time daemon is allowed over

_ DBTIME_PERCENT 10 cycles

_ CUTOFF

_ REPORT_CAPTURE: No of report capture cycles after which db time is

_ RECHARGE_WINDO recharged

W

_ REPORT_CAPTURE: Length of time band (in hours) in the reports time

_ TIMEBAND_LENGT bands table

H

_ REPORT_REQUEST: Time (in min) after which a report request is deleted

_ AGEOUT_MINUTES from queue

_ REP_BASE_PATH: base path for EM reports in database

_ RESET_MAXCAP_H: reset maxcap history time

ISTORY

_ RESOURCE_INCLU: Whether RESOURCE role includes UNLIMITED TABLESPACE

DES_UNLIMITED_T privilege

ABLESPACE

_ RESOURCE_MANAG: disable the resource manager always

ER_ALWAYS_OFF

_ RESOURCE_MANAG: resource mgr top plan for internal use

ER_PLAN

_ RESTORE_MAXOPE: restore assumption for maxopenfiles

NFILES

_ RESTORE_SPFILE: restore spfile to this location

_ RESULT_CACHE_A: result cache auto dml monitoring duration

UTO_DML_MONITOR

ING_DURATION

_ RESULT_CACHE_A: result cache auto dml monitoring slot

UTO_DML_MONITOR

ING_SLOTS

_ RESULT_CACHE_A: result cache auto dml threshold

UTO_DML_THRESHO

LD

_ RESULT_CACHE_A: result cache auto dml trend threshold

UTO_DML_TREND_T

HRESHOLD

_ RESULT_CACHE_A: result cache auto execution threshold

UTO_EXECUTION_T

HRESHOLD

_ RESULT_CACHE_A: result cache auto max size allowed

UTO_SIZE_THRESH

OLD

_ RESULT_CACHE_A: result cache auto time distance

UTO_TIME_DISTAN

CE

_ RESULT_CACHE_A: result cache auto time threshold

UTO_TIME_THRESH

OLD

_ RESULT_CACHE_B: result cache block size

LOCK_SIZE

_ RESULT_CACHE_C: blocks to copy instead of pinning the result

OPY_BLOCK_COUNT

_ RESULT_CACHE_D: result cache deterministic PLSQL functions

ETERMINISTIC_PL

SQL

_ RESULT_CACHE_G: Are results available globally across RAC?

LOBAL

_ RESULT_CACHE_T: maximum time (sec) a session waits for a result

IMEOUT

_ RESUMABLE_CRIT: raise critical alert for resumable failure

ICAL_ALERT

_ REUSE_INDEX_LO: number of blocks being examine for index block reuse

OP

_ RE_FAST_SQL_OP: enables fast boxable sql operator

ERATOR

_ RE_INDEPENDENT: defines max number of compiled cached expressions for

_ EXPRESSION_CAC iee

HE_SIZE

_ RE_NUM_COMPLEX: defines max number of compiled complex operator per

_ OPERATOR ruleset-iee

_ RE_NUM_ROWCACH: defines max number of complex operators loaded with row

E_LOAD cache

_ RE_RESULT_CACH: defines max number key for result cache hash table

E_KEYSIZ

_ RE_RESULT_CACH: defines max number of cached elements for result cache

E_SIZE

_ RIGHT_OUTER_HA: Right Outer/Semi/Anti Hash Enabled

SH_ENABLE

_ RMAN_IO_PRIORI: priority at which rman backup i/o's are done

TY

_ RMAN_ROUNDROBI: Numa round robin placement for RMAN procs

N_PLACEMENT

_ RM_CLUSTER_INT: interconnects for RAC use (RM)

ERCONNECTS

_ RM_NUMA_SCHED_: Is Resource Manager (RM) related NUMA scheduled policy

ENABLE enabled

_ RM_NUMA_SIMULA: number of cpus for each pg for numa simulation in

TION_CPUS resource manager

_ RM_NUMA_SIMULA: number of PGs for numa simulation in resource manager

TION_PGS

_ ROLLBACK_SEGME: number of undo segments

NT_COUNT

_ ROLLBACK_SEGME: starting undo segment number

NT_INITIAL

_ ROLLBACK_STOPA: stop at-position to step rollback

T

_ ROND_TEST_MODE: rac one node test mode

_ ROWLEN_FOR_CHA: maximum rowlen above which rows may be chained across

INING_THRESHOLD blocks

_ ROWSETS_CDB_VI: rowsets enabled for CDB views

EW_ENABLED

_ ROWSETS_ENABLE: enable/disable rowsets

D

_ ROWSETS_MAX_RO: maximum number of rows in a rowset

WS

_ ROWSETS_TARGET: target size in bytes for space reserved in the frame

_ MAXSIZE for a rowset

_ ROWSOURCE_EXEC: if TRUE, Oracle will collect rowsource statistics

UTION_STATISTIC

S

_ ROWSOURCE_PROF: if TRUE, Oracle will capture active row sources in

ILING_STATISTIC v$active_session_history

S

_ ROWSOURCE_STAT: frequency of rowsource statistic sampling (must be a

ISTICS_SAMPFREQ power of 2)

_ ROWSRC_TRACE_L: Row source tree tracing level

EVEL

_ ROW_CACHE_CURS: number of cached cursors for row cache management

ORS

_ ROW_CR: enable row cr for all sql

_ ROW_LOCKING: row-locking

_ ROW_SHIPPING_E: enable row shipping explain plan support

XPLAIN

_ ROW_SHIPPING_T: row shipping column selection threshold

HRESHOLD

_ RTADDM_TRIGGER: comma-separated list of numeric arguments for RT addm

_ ARGS trigger

_ RTADDM_TRIGGER: To enable or disable Real-Time ADDM automatic trigger

_ ENABLED

_ RTA_SYNC_WAIT_: RTA sync wait timeout

TIMEOUT

_ RTC_INFEASIBLE: Redo Transport Compression infeasible threshold

_ THRESHOLD

_ SAMPLE_ROWS_PE: number of rows per block used for sampling IO

R_BLOCK optimization

_ SCALAR_TYPE_LO: threshold for VARCHAR2, NVARCHAR2, and RAW storage as

B_STORAGE_THRES BLOB

HOLD

_ SCATTER_GCS_RE: if TRUE, gcs resources are scattered uniformly across

SOURCES sub pools

_ SCATTER_GCS_SH: if TRUE, gcs shadows are scattered uniformly across sub

ADOWS pools

_ SCHED_DELAY_MA: scheduling delay maximum number of samples

X_SAMPLES

_ SCHED_DELAY_ME: scheduling delay mesurement sleep us

ASUREMENT_SLEEP

_ US

_ SCHED_DELAY_OS: os tick granularity used by scheduling delay

_ TICK_GRANULARI calculations

TY_US

_ SCHED_DELAY_SA: scheduling delay sample collection duration threshold

MPLE_COLLECTION ms

_ THRESH_MS

_ SCHED_DELAY_SA: scheduling delay sampling interval in ms

MPLE_INTERVAL_M

S

_ SCN_WAIT_INTER: max exponential backoff time for scn wait interface in

FACE_MAX_BACKOF kta

F_TIME_SECS

_ SCN_WAIT_INTER: max timeout for scn wait interface in kta

FACE_MAX_TIMEOU

T_SECS

_ SDIAG_CRASH: sql diag crash

_ SECOND_SPARE_P: second spare parameter-integer

ARAMETER

_ SECUREFILES_BR: segment retry before dishonoring retention

EAKRETEN_RETRY

_ SECUREFILES_BU: securefiles segment insert only optization

LKINSERT

_ SECUREFILES_CO: securefiles concurrency estimate

NCURRENCY_ESTIM

ATE

_ SECUREFILES_FG: segment retry before foreground waits

_ RETRY

_ SECUREFILES_FO: securefiles force flush before allocation

RCEFLUSH

_ SECUREFILES_ME: securefiles memory as percent of SGA

MORY_PERCENTOFS

GA

_ SECUREFILES_SP: securefiles segment utl optimization

CUTL

_ SECUREFILE_LOG: Maximum number of open descriptors for securefile log

_ NUM_LATCHES

_ SECUREFILE_LOG: Size of securefile log buffer pool from SGA

_ SHARED_POOL_SI

ZE

_ SECUREFILE_TIM: collect kdlu timers and accumulate per layers

ERS

_ SEC_ENABLE_TES: Whether to enable the test RPCs

T_RPCS

_ SELECTIVITY_FO: enable/disable selectivity for storage reduction factor

R_SRF_ENABLED

_ SELECT_ANY_DIC: Exclude USER$, XS$VERIFIERS, ENC$ and DEFAULT_PWD$ from

TIONARY_SECURIT SELECT ANY DICTIONARY system privilege

Y_ENABLED

_ SELFJOIN_MV_DU: control rewrite self-join algorithm

PLICATES

_ SELFTUNE_CHECK: Self-tune checkpointing lag the tail of the redo log

POINTING_LAG

_ SELFTUNE_CHECK: Percentage of total physical i/os for self-tune ckpt

POINT_WRITE_PCT

_ SEM_PER_SEMID: the exact number of semaphores per semaphore set to

Allocate

_ SEND_AST_TO_FO: if TRUE, send ast message to foreground

REGROUND

_ SEND_CLOSE_WIT: if TRUE, send close with block even with direct sends

H_BLOCK

_ SEND_REQUESTS_: if TRUE, try to send CR requests to PI buffers

TO_PI

_ SERIALIZABLE: serializable

_ SERIALIZE_LGWR: Serialize LGWR SYNC local and remote io

_ SYNC_IO

_ SERIAL_DIRECT_: enable direct read in serial

READ

_ SERIAL_LOG_WRI: Serialize log write slave I/O

TE_WORKER_IO

_ SERIAL_RECOVER: force serial recovery or parallel recovery

Y

_ SERVICE_CLEANU: timeout to peform service cleanup

P_TIMEOUT

_ SESSION_ALLOCA: one latch per group of sessions

TION_LATCHES

_ SESSION_CACHED: Number of pl/sql instantiations to cache in a session.

_ INSTANTIATIONS

_ SESSION_CONTEX: session app context size

T_SIZE

_ SESSION_IDLE_B: one latch per session or a latch per group of sessions

IT_LATCHES

_ SESSION_PAGE_E: Session Page Extent Size

XTENT

_ SESSION_WAIT_H: enable session wait history collection

ISTORY

_ SET_CONTAINER_: set container service

SERVICE

_ SET_MGD_RECOVE: set mgd recovery state to new value

RY_STATE

_ SEVENTEENTH_SP: seventeenth spare parameter-string

ARE_PARAMETER

_ SEVENTH_SPARE_: seventh spare parameter-integer

PARAMETER

_ SF_DEFAULT_ENA: enable 12g securefile default

BLED

_ SGA_ALLOC_SLAV: Termination timeout in secs for SA** slaves

ES_TERM_TIMEOUT

_ SECS

_ SGA_CLEAR_DUMP: Allow dumping encrypted blocks in clear for debugging

_ SGA_EARLY_TRAC: sga early trace event

E

_ SGA_LOCKING: sga granule locking state

_ SHARED_IOP_MAX: maximum shared io pool size

_ SIZE

_ SHARED_IO_POOL: Shared IO pool buffer size

_ BUF_SIZE

_ SHARED_IO_POOL: trace kcbi debug info to tracefile

_ DEBUG_TRC

_ SHARED_IO_POOL: Size of shared IO pool

_ SIZE

_ SHARED_IO_SET_: shared io pool size set internal value-overwrite zero

VALUE user size

_ SHARED_POOL_MA: shared pool maximum size when auto SGA enabled

X_SIZE

_ SHARED_POOL_MI: shared pool minimum size when auto SGA enabled

NSIZE_ON

_ SHARED_POOL_RE: minimum allocation size in bytes for reserved area of

SERVED_MIN_ALLO shared pool

C

_ SHARED_POOL_RE: percentage memory of the shared pool allocated for the

SERVED_PCT reserved area

_ SHARED_SERVER_: shared server load balance

LOAD_BALANCE

_ SHARED_SERVER_: number of shared server common queues

NUM_QUEUES

_ SHMPROTECT: allow mprotect use for shared memory

_ SHORT_STACK_TI: short stack timeout in ms

MEOUT_MS

_ SHOW_MGD_RECOV: Show internal managed recovery state

ERY_STATE

_ SHRD_QUE_TM_PR: number of sharded queue Time Managers to start

OCESSES

_ SHRD_QUE_TM_ST: Shaded queue statistics collection window duration

ATISTICS_DURATI

ON

_ SHRUNK_AGGS_DI: percentage of exceptions at which to switch to full

SABLE_THRESHOLD length aggs

_ SHRUNK_AGGS_EN: enable use of variable sized buffers for non-distinct

ABLED aggregates

_ SHUTDOWN_COMPL: minutes for shutdown operation to wait for sessions to

ETION_TIMEOUT_M complete

INS

_ SIDE_CHANNEL_B: number of messages to batch in a side channel message

ATCH_SIZE (DFS)

_ SIDE_CHANNEL_B: timeout before shipping out the batched side

ATCH_TIMEOUT channelmessages in seconds

_ SIDE_CHANNEL_B: timeout before shipping out the batched side

ATCH_TIMEOUT_MS channelmessages in milliseconds

_ SIMPLE_VIEW_ME: control simple view merging performed by the optimizer

RGING

_ SIMULATED_LOG_: Simulated latency of log writes (usecs)

WRITE_USECS

_ SIMULATE_DISK_: Enables skgfr to report simulated disk sector size

SECTORSIZE

_ SIMULATE_IO_WA: Simulate I/O wait to test segment advisor

IT

_ SIMULATE_MEM_T: simulate auto memory sga/pga transfers

RANSFER

_ SIMULATOR_BUCK: LRU bucket minimum delta

ET_MINDELTA

_ SIMULATOR_INTE: simulator internal bound percent

RNAL_BOUND

_ SIMULATOR_LRU_: LRU list rebalance threshold (size)

REBALANCE_SIZTH

R

_ SIMULATOR_LRU_: LRU list rebalance threshold (count)

REBALANCE_THRES

H

_ SIMULATOR_LRU_: LRU scan count

SCAN_COUNT

_ SIMULATOR_PIN_: maximum count of invalid chunks on pin list

INVAL_MAXCNT

_ SIMULATOR_RESE: simulator reserved heap count

RVED_HEAP_COUNT

_ SIMULATOR_RESE: simulator reserved object count

RVED_OBJ_COUNT

_ SIMULATOR_SAMP: sampling factor for the simulator

LING_FACTOR

_ SIMULATOR_UPPE: upper bound multiple of pool size

R_BOUND_MULTIPL

E

_ SINGLE_PROCESS: run without detached processes

_ SIOP_FLASHBACK: Shared IO pool flashback io completion scan depth

_ SCANDEPTH

_ SIOP_PERC_OF_B: percentange * 100of cache to transfer to shared io

C_X100 pool

_ SIXTEENTH_SPAR: sixteenth spare parameter-string

E_PARAMETER

_ SIXTH_SPARE_PA: sixth spare parameter-integer

RAMETER

_ SKGXPG_LAST_PA: last defined skgxpg parameter-oss

RAMETER

_ SKGXP_ANT_OPTI: SKGXP ANT options (oss)

ONS

_ SKGXP_CTX_FLAG: IPC debug options flags (oss)

S1

_ SKGXP_CTX_FLAG: IPC debug options flags mask (oss)

S1MASK

_ SKGXP_DYNAMIC_: IPC protocol override

PROTOCOL (! 0ppp) (! 0ppm)

_ SKGXP_GEN_ANT_: VRPC request timeout when ANT disabled

OFF_RPC_TIMEOUT

_ IN_SEC

_ SKGXP_GEN_ANT_: ANT protocol ping miss count

PING_MISSCOUNT

_ SKGXP_GEN_RPC_: ANT ping protocol miss count

NO_PATH_CHECK_I

N_SEC

_ SKGXP_GEN_RPC_: VRPC request timeout when ANT enabled

TIMEOUT_IN_SEC

_ SKGXP_INETS: limit SKGXP networks (oss)

_ SKGXP_MIN_RPC_: IPC threshold for rpc rcv zcpy operation (default = 0-

RCV_ZCPY_LEN disabled)

_ SKGXP_MIN_ZCPY: IPC threshold for zcpy operation (default = 0-

_ LEN disabled)

_ SKGXP_REAPING: tune skgxp OSD reaping limit

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

S X=max

_ SKGXP_SPARE_PA: ipc oss spare parameter 1

RAM1

_ SKGXP_SPARE_PA: ipc oss spare parameter 2

RAM2

_ SKGXP_SPARE_PA: ipc oss spare parameter 3

RAM3

_ SKGXP_SPARE_PA: ipc oss spare parameter 4

RAM4

_ SKGXP_SPARE_PA: ipc oss spare parameter 5

RAM5

_ SKGXP_UDP_ACH_: time in minutes before idle ach's are reaped

REAPING_TIME

_ SKGXP_UDP_ACK_: Enables delayed acks

DELAY

_ SKGXP_UDP_ENAB: Enables dynamic credit management

LE_DYNAMIC_CRED

IT_MGMT

_ SKGXP_UDP_HIWA: ach hiwat mark warning interval

T_WARN

_ SKGXP_UDP_INTE: time in seconds between interface detection checks

RFACE_DETECTION

_ TIME_SECS

_ SKGXP_UDP_KEEP: connection idle time in seconds before keep alive is

_ ALIVE_PING_TIM initiated. Min: 30 sec max: 1800 sec default: 300 sec

ER_SECS

_ SKGXP_UDP_LMP_: MTU size for UDP LMP testing

MTUSIZE

_ SKGXP_UDP_LMP_: enable UDP long message protection

ON

_ SKGXP_UDP_TIME: diagnostic log buffering space (in bytes) for timed

D_WAIT_BUFFERIN wait (0 means unbufferd

G

_ SKGXP_UDP_TIME: time in seconds before timed wait is invoked

D_WAIT_SECONDS

_ SKGXP_UDP_USE_: disable use of high speek timer

TCB

_ SKGXP_ZCPY_FLA: IPC zcpy options flags

GS

_ SKIP_ACFS_CHEC: Override checking if on an ACFS file system

KS

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

G

_ SKIP_TRSTAMP_C: Skip terminal recovery stamp check

HECK

_ SLAVE_MAPPING_: enable slave mapping when TRUE

ENABLED

_ SLAVE_MAPPING_: force the number of slave group in a slave mapper

GROUP_SIZE

_ SLAVE_MAPPING_: maximum skew before slave mapping is disabled

SKEW_RATIO

_ SMALL_TABLE_TH: lower threshold level of table size for direct reads

RESHOLD

_ SMM_ADVICE_ENA: if TRUE, enable v$pga_advice

BLED

_ SMM_ADVICE_LOG: overwrites default size of the PGA advice workarea

_ SIZE history log

_ SMM_AUTO_COST_: if TRUE, use the AUTO size policy cost functions

ENABLED

_ SMM_AUTO_MAX_I: Maximum IO size (in KB) used by sort/hash-join in auto

O_SIZE mode

_ SMM_AUTO_MIN_I: Minimum IO size (in KB) used by sort/hash-join in auto

O_SIZE mode

_ SMM_BOUND: overwrites memory manager automatically computed bound

_ SMM_CONTROL: provides controls on the memory manager

_ SMM_FREEABLE_R: value in KB of the instance freeable PGA memory to

ETAIN retain

_ SMM_ISORT_CAP: maximum work area for insertion sort (v1)

_ SMM_MAX_SIZE: maximum work area size in auto mode (serial)

_ SMM_MAX_SIZE_S: static maximum work area size in auto mode (serial)

TATIC

_ SMM_MIN_SIZE: minimum work area size in auto mode

_ SMM_PX_MAX_SIZ: maximum work area size in auto mode (global)

E

_ SMM_PX_MAX_SIZ: static maximum work area size in auto mode (global)

E_STATIC

_ SMM_RETAIN_SIZ: work area retain size in SGA for shared server sessions

E (0 for AUTO)

_ SMM_TRACE: Turn on/off tracing for SQL memory manager

_ SMON_INTERNAL_: limit of SMON internal errors

ERRLIMIT

_ SMON_UNDO_SEG_: limit of SMON continous undo segments re-scan

RESCAN_LIMIT

_ SMU_DEBUG_MODE:-set debug event for testing SMU

Operations

_ SMU_ERROR_SIMU: site ID of error simulation in KTU code

LATION_SITE

_ SMU_ERROR_SIMU: error type for error simulation in KTU code

LATION_TYPE

_ SMU_TIMEOUTS: comma-separated * AND double-quoted* list of AUM

Timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl

_ SNAPSHOT_RECOV: enable/disable snapshot recovery

ERY_ENABLED

_ SORT_ELIMINATI: cost ratio for sort eimination under first_rows mode

ON_COST_RATIO

_ SORT_MULTIBLOC: multi-block read count for sort

K_READ_COUNT

_ SORT_SPILL_THR: force sort to spill to disk each time this many rows

ESHOLD are received

_ SORT_SYNC_MIN_: controls the size of mininum run size for synchronized

SPILLSIZE spill (in kb)

_ SORT_SYNC_MIN_: controls the mininum spill size for synchronized spill

SPILL_THRESHOLD (in percent)

_ SPACE_ALIGN_SI: space align size

ZE

_ SPARE_TEST_PAR: Spare test parameter

AMETER

_ SPAWN_DIAG_OPT: thread spawn diagnostic options

S

_ SPAWN_DIAG_THR: thread spawn diagnostic minimal threshold in seconds

ESH_SECS

_ SPIN_COUNT: Amount to spin waiting for a latch

_ SPR_MAX_RULES: maximum number of rules in sql spreadsheet

_ SPR_PUSH_PRED_: push predicates through reference spreadsheet

REFSPR

_ SPR_USE_AW_AS: enable AW for hash table in spreadsheet

_ SPR_USE_HASH_T: use hash table for spreadsheet

ABLE

_ SQLEXEC_PROGRE: sql execution progression monitoring cost threshold

SSION_COST

_ SQLMON_BINDS_X: format of column binds_xml in [G] V$SQL_MONITOR

ML_FORMAT

_ SQLMON_MAX_PLA: Maximum number of plans entry that can be monitored.

N Defaults to 20 per CPU

_ SQLMON_MAX_PLA: Number of plan lines beyond which a plan cannot be

NLINES monitored

_ SQLMON_RECYCLE: Minimum time (in s) to wait before a plan entry can be

_ TIME recycled

_ SQLMON_THRESHO: CPU/IO time threshold before a statement is monitored.

LD 0 is disabled

_ SQLTUNE_CATEGO: Parsed category qualifier for applying hintsets

RY_PARSED

_ SQL_ANALYZE_EN: SQL Analyze Autonomous Transaction control parameter

ABLE_AUTO_TXN

_ SQL_ANALYZE_PA: SQL Analyze Parse Model control parameter

RSE_MODEL

_ SQL_COMPATIBIL: sql compatability bit vector

ITY

_ SQL_CONNECT_CA: SQL Connect Capability Table Override

PABILITY_OVERRI

DE

_ SQL_CONNECT_CA: SQL Connect Capability Table (testing only)

PABILITY_TABLE

_ SQL_DIAG_REPO_: duarations where sql diag repository are retained

ORIGIN

_ SQL_DIAG_REPO_: retain sql diag repository to cursor or not

RETAIN

_ SQL_HASH_DEBUG: Hash value of the SQL statement to debug

_ SQL_HVSHARE_DE: control hash value sharing debug level

BUG

_ SQL_HVSHARE_TH: threshold to control hash value sharing across

RESHOLD operators

_ SQL_MODEL_UNFO: specifies compile-time unfolding of sql model forloops

LD_FORLOOPS

_ SQL_NCG_MODE: Optimization mode for SQL NCG

_ SQL_PLAN_DIREC: controls internal SQL Plan Directive management

TIVE_MGMT_CONTR activities

OL

_ SQL_PLAN_MANAG: controls various internal SQL Plan Management

EMENT_CONTROL algorithms

_ SQL_SHOW_EXPRE: show expression evalution as shared hash producer in

VAL plan

_ SRVNTFN_JOBSUB: srvntfn job submit interval

MIT_INTERVAL

_ SRVNTFN_JOB_DE: srvntfn job deq timeout

Q_TIMEOUT

_ SRVNTFN_MAX_CO: srvntfn max concurrent jobs

NCURRENT_JOBS

_ SRVNTFN_Q_MSGC: srvntfn q msg count for job exit

OUNT

_ SRVNTFN_Q_MSGC: srvntfn q msg count increase for job submit

OUNT_INC

_ SSCR_DIR: Session State Capture and Restore DIRectory object

_ SSCR_OSDIR: Session State Capture and Restore OS DIRectory

_ STACK_GUARD_LE: stack guard level

VEL

_ STANDBY_CAUSAL: readable standby causal heartbeat timeout

_ HEARTBEAT_TIME

OUT

_ STANDBY_FLUSH_: standby flush mode

MODE

_ STANDBY_IMPLIC: minutes to wait for redo during standby implicit

IT_RCV_TIMEOUT recovery

_ STANDBY_SWITCH: Number of secords for standby switchover enqueue

OVER_TIMEOUT timeout

_ STATIC_BACKGRO: static backgrounds

UNDS

_ STATISTICS_BAS: enable/disable the use of statistics for storage

ED_SRF_ENABLED reduction factor

_ STAT_AGGS_ONE_: enable one pass algorithm for variance-related

PASS_ALGORITHM functions

_ STA_CONTROL: SQL Tuning Advisory control parameter

_ STEP_DOWN_LIMI: step down limit in percentage

T_IN_PCT

_ STREAMS_POOL_M: streams pool maximum size when auto SGA enabled

AX_SIZE

_ SUBQUERY_PRUNI: subquery pruning cost factor

NG_COST_FACTOR

_ SUBQUERY_PRUNI: enable the use of subquery predicates to perform

NG_ENABLED pruning

_ SUBQUERY_PRUNI: enable the use of subquery predicates with MVs to

NG_MV_ENABLED perform pruning

_ SUBQUERY_PRUNI: subquery pruning reduction factor

NG_REDUCTION

_ SUPPRESS_IDENT: supress owner index name err msg

IFIERS_ON_DUPKE

Y

_ SWITCHOVER_TIM: Switchover timeout in minutes

EOUT

_ SWITCHOVER_TO_: option for graceful switchover to standby

STANDBY_OPTION

_ SWITCHOVER_TO_: Switchover to standby switches log for open redo

STANDBY_SWITCH_ threads

LOG

_ SWITCH_CURRENT: switch current uses scan scn

_ SCAN_SCN

_ SWRF_METRIC_FR: Enable/disable SWRF Metric Frequent Mode Collection

EQUENT_MODE

_ SWRF_MMON_DBFU: Enable/disable SWRF MMON DB Feature Usage

S

_ SWRF_MMON_FLUS: Enable/disable SWRF MMON FLushing

H

_ SWRF_MMON_METR: Enable/disable SWRF MMON Metrics Collection

ICS

_ SWRF_ON_DISK_E: Parameter to enable/disable SWRF

NABLED

_ SWRF_TEST_ACTI: test action parameter for SWRF

ON

_ SWRF_TEST_DBFU: Enable/disable DB Feature Usage Testing

S

_ SYNC_PRIMARY_W: wait time for alter session sync with primary

AIT_TIME

_ SYNONYM_REPOIN: whether to trace metadata comparisons for synonym

T_TRACING repointing

_ SYSAUX_TEST_PA: test parameter for SYSAUX

RAM

_ SYSTEM_API_INT: enable debug tracing for system api interception

ERCEPTION_DEBUG

_ SYSTEM_INDEX_C: optimizer percent system index caching

ACHING

_ SYSTEM_TRIG_EN: are system triggers enabled

ABLED

_ SYS_LOGON_DELA: failed logon delay for sys

Y

_ TABLESPACES_PE: estimated number of tablespaces manipulated by each

R_TRANSACTION transaction

_ TABLE_LOOKUP_P: table lookup prefetch vector size

REFETCH_SIZE

_ TABLE_LOOKUP_P: table lookup prefetch threshold

REFETCH_THRESH

_ TABLE_SCAN_COS: bump estimated full table scan and index ffs cost by

T_PLUS_ONE one

_ TARGET_LOG_WRI: Do log write if this many redo blocks in buffer

TE_SIZE (auto=0)

_ TARGET_LOG_WRI: How long LGWR will wait for redo to accumulate (csecs)

TE_SIZE_TIMEOUT

_ TARGET_RBA_MAX: target rba max log lag percentage

_ LAG_PERCENTAGE

_ TA_LNS_WAIT_FO: LNS Wait time for arhcived version of online log

R_ARCH_LOG

_ TDB_DEBUG_MODE: set debug mode for testing transportable database

_ TEMP_TRAN_BLOC: number of blocks for a dimension before we temp

K_THRESHOLD transform

_ TEMP_TRAN_CACH: determines if temp table is created with cache option

E

_ TEMP_UNDO_DISA: is temp undo disabled on ADG

BLE_ADG

_ TENTH_SPARE_PA: tenth spare parameter-integer

RAMETER

_ TEST_HM_EXTENT: heatmap related-to be used by oracle dev only

_ MAP

_ TEST_KSUSIGSKI: test the function ksusigskip

P

_ TEST_PARAM_1: test parmeter 1-integer

_ TEST_PARAM_2: test parameter 2-string

_ TEST_PARAM_3: test parameter 3-string

_ TEST_PARAM_4: test parameter 4-string list

_ TEST_PARAM_5: test parmeter 5-deprecated integer

_ TEST_PARAM_6: test parmeter 6-size (ub8)

_ TEST_PARAM_7: test parameter 7-big integer list

_ TEST_PARAM_8: test parameter 8-cdb tests

_ THIRD_SPARE_PA: third spare parameter-integer

RAMETER

_ THIRTEENTH_SPA: thirteenth spare parameter-integer

RE_PARAMETER

_ THREAD_STATE_C: Thread state change timeout for PnP instance (in sec)

HANGE_TIMEOUT_P

NP

_ THRESHOLD_ALER: if 1, issue threshold-based alerts

TS_ENABLE

_ TIMEMODEL_COLL: enable timemodel collection

ECTION

_ TIMEOUT_ACTION: enables or disables KSU timeout actions

S_ENABLED

_ TIMER_PRECISIO: VKTM timer precision in milli-sec

N

_ TIME_BASED_RCV: time-based incremental recovery checkpoint target in

_ CKPT_TARGET sec

_ TIME_BASED_RCV: time-based incremental recovery file header update

_ HDR_UPDATE_INT interval in sec

ERVAL

_ TOTAL_LARGE_EX: Total memory for allocating large extents

TENT_MEMORY

_ TQ_DUMP_PERIOD: time period for duping of TQ statistics (s)

_ TRACE_BUFFERS: trace buffer sizes per process

_ TRACE_BUFFER_W: trace buffer busy wait timeouts

AIT_TIMEOUTS

_ TRACE_DUMP_ALL: if TRUE on error buckets of all processes will be

_ PROCS dumped to the current trace file

_ TRACE_DUMP_CLI: if TRUE dump client (ie. Non-kst) buckets

ENT_BUCKETS

_ TRACE_DUMP_CUR: if TRUE on error just dump our process bucket

_ PROC_ONLY

_ TRACE_DUMP_STA: if TRUE filter trace dumps to always loaded dlls

TIC_ONLY

_ TRACE_EVENTS: trace events enabled at startup

_ TRACE_FILES_PU: Create publicly accessible trace files

BLIC

_ TRACE_KQLIDP: trace kqlidp0 operation

_ TRACE_KTFS: Trace ILM Stats Tracking

_ TRACE_KTFS_MEM: Debug memleak

_ TRACE_NAVIGATI: enabling trace navigation linking

ON_SCOPE

_ TRACE_PIN_TIME: trace how long a current pin is held

_ TRACE_POOL_SIZ: trace pool size in bytes

E

_ TRACE_PROCESSE: enable KST tracing in process

S

_ TRACE_TEMP: Trace Tempspace Management

_ TRACE_VIRTUAL_: trace virtual columns exprs

COLUMNS

_ TRACK_METRICS_: Enable/disable Metrics Memory Tracking

MEMORY

_ TRANSACTION_AU: transaction auditing records generated in the redo log

DITING

_ TRANSACTION_RE: max number of parallel recovery slaves that may be used

COVERY_SERVERS

_ TRANSIENT_LOGI: clear KCCDI2HMRP flag during standby recovery

CAL_CLEAR_HOLD_

MRP_BIT

_ TRUNCATE_OPTIM: do truncate optimization if set to TRUE

IZATION_ENABLED

_ TSENC_OBFUSCAT: Encryption key obfuscation in memory

E_KEY

_ TSENC_TRACING: Enable TS encryption tracing

_ TSM_CONNECT_ST: TSM test connect string

RING

_ TSM_DISABLE_AU: Disable TSM auto cleanup actions

TO_CLEANUP

_ TSTZ_LOCALTIME: Should TTC not convert to LocalTime to preserve

_ BYPASS Timestamp with Timezone values

_ TTS_ALLOW_CHAR: allow plugging in a tablespace with an incompatible

SET_MISMATCH character set

_ TWELFTH_SPARE_: twelfth spare parameter-integer

PARAMETER

_ TWENTIETH_SPAR: twentieth spare parameter-string

E_PARAMETER

_ TWENTY-EIGHTH_: twenty-eighth spare parameter-boolean

SPARE_PARAMETER

_ TWENTY-FIFTH_S: twenty-fifth spare parameter-string list

PARE_PARAMETER

_ TWENTY-FIRST_S: twenty-first spare parameter-string list

PARE_PARAMETER

_ TWENTY-FOURTH_: twenty-fourth spare parameter-string list

SPARE_PARAMETER

_ TWENTY-SECOND_: twenty-second spare parameter-string list

SPARE_PARAMETER

_ TWENTY-SEVENTH: twenty-seventh spare parameter-boolean

_ SPARE_PARAMETE

R

_ TWENTY-SIXTH_S: twenty-sixth spare parameter-boolean

PARE_PARAMETER

_ TWENTY-THIRD_S: twenty-third spare parameter-string list

PARE_PARAMETER

_ TWO_PASS: enable two-pass thread recovery

_ TWO_PASS_REVER: uses two-pass reverse polish alg. To generate canonical

SE_POLISH_ENABL forms

ED

_ TXN_CONTROL_TR: size the in-memory buffer size of txn control

ACE_BUF_SIZE

_ UGA_CGA_LARGE_: UGA/CGA large extent size

EXTENT_SIZE

_ ULTRAFAST_LATC: maintain fast-path statistics for ultrafast latches

H_STATISTICS

_ UNDO_AUTOTUNE: enable auto tuning of undo_retention

_ UNDO_BLOCK_COM: enable undo block compression

PRESSION

_ UNDO_DEBUG_MOD: debug flag for undo related operations

E

_ UNDO_DEBUG_USA: invoke undo usage functions for testing

GE

_ UNIFIED_AUDIT_: Unified Audit SGA Queue Flush Interval

FLUSH_INTERVAL

_ UNIFIED_AUDIT_: Unified Audit SGA Queue Flush Threshold

FLUSH_THRESHOLD

_ UNIFIED_AUDIT_: Disable Default Unified Audit Policies on DB Create

POLICY_DISABLED

_ UNION_REWRITE_: expand queries with GSets into UNIONs for rewrite

FOR_GS

_ UNNEST_SUBQUER: enables unnesting of complex subqueries

Y

_ UNUSED_BLOCK_C: enable unused block compression

OMPRESSION

_ UPDATE_DATAFIL: user requested update of datafile headers of locally

E_HEADERS_WITH_ managed datafiles with space information

SPACE_INFORMATI

ON

_ UPDDEL_DBA_HAS: controls masking of lower order bits in DBA

H_MASK_BITS

_ USE_ADAPTIVE_L: Adaptively switch between post/wait and polling

OG_FILE_SYNC

_ USE_BEST_FIT: use best fit to allocate space

_ USE_COLUMN_STA: enable the use of column statistics for DDP functions

TS_FOR_FUNCTION

_ USE_FIPS_MODE: Enable use of crypographic libraries in FIPS mode

_ USE_HIDDEN_PAR: use hidden partitions

TITIONS

_ USE_HYBRID_ENC: Enable platform optimized encryption in hybrid mode

RYPTION_MODE

_ USE_ISM: Enable Shared Page Tables-ISM

_ USE_ISM_FOR_PG: Use ISM for allocating large extents

A

_ USE_NOSEGMENT_: use nosegment indexes in explain plan

INDEXES

_ USE_PLATFORM_C: Enable platform optimized compression implementation

OMPRESSION_LIB

_ USE_PLATFORM_E: Enable platform optimized encryption implementation

NCRYPTION_LIB

_ USE_REALFREE_H: use real-free based allocator for PGA memory

EAP

_ USE_SEQ_PROCES: whether to use process local seq cache

S_CACHE

_ USE_SINGLE_LOG: Use a single process for redo log writing

_ WRITER

_ USE_VECTOR_POS: use vector post

T

_ USE_ZERO_COPY_: Should network vector IO interface be used for data

IO transfer

_ UTLMMIG_TABLE_: enable/disable utlmmig table stats gathering at upgrade

STATS_GATHERING

_ UTS_FIRST_SEGM: Should we retain the first trace segment

ENT_RETAIN

_ UTS_FIRST_SEGM: Maximum size (in bytes) of first segments

ENT_SIZE

_ UTS_TRACE_DISK: Trace disk threshold parameter

_ THRESHOLD

_ UTS_TRACE_SEGM: Maximum number of trace segments

ENTS

_ UTS_TRACE_SEGM: Maximum size (in bytes) of a trace segment

ENT_SIZE

_ VALIDATE_FLASH: Scan database to validate result of flashback database

BACK_DATABASE

_ VALIDATE_METRI: Enable/disable SGA Metric Structure validation

C_GROUPS

_ VALIDATE_READM: validate redo blocks read from in-memory log buffer

EM_REDO

_ VENDOR_LIB_LOC: Vendor library search root directory

_ VERIFY_FG_LOG_: LGWR verifies redo checksums generated by foreground

CHECKSUM processes

_ VERIFY_FLASHBA: Verify that the redo logs needed for flashback are

CK_REDO available

_ VERIFY_UNDO_QU: TRUE-verify consistency of undo quota statistics

OTA

_ VERY_LARGE_OBJ: upper threshold level of object size for direct reads

ECT_THRESHOLD

_ VERY_LARGE_PAR: very_large_partitioned_table

TITIONED_TABLE

_ VIRTUAL_COLUMN: overload virtual columns expression

_ OVERLOAD_ALLOW

ED

_ VKRM_SCHEDULE_: VKRM scheduling interval

INTERVAL

_ VKTM_ASSERT_TH: soft assert threshold VKTM timer drift

RESH

_ WAIT_BREAKUP_T: Wait breakup threshold (in centiseconds)

HRESHOLD_CSECS

_ WAIT_BREAKUP_T: Wait breakup time (in centiseconds)

IME_CSECS

_ WAIT_FOR_SYNC: wait for sync on commit MUST BE ALWAYS TRUE

_ WAIT_SAMPLES_M: Wait Samples maximum sections

AX_SECTIONS

_ WAIT_SAMPLES_M: Wait Samples maximum time in seconds

AX_TIME_SECS

_ WAIT_TRACKER_I: Wait Tracker number of seconds per interval

NTERVAL_SECS

_ WAIT_TRACKER_N: Wait Tracker number of intervals

UM_INTERVALS

_ WAIT_YIELD_HP_: Wait Yield-High Priority Mode

MODE

_ WAIT_YIELD_MOD: Wait Yield-Mode

E

_ WAIT_YIELD_SLE: Wait Yield-Sleep Frequency

EP_FREQ

_ WAIT_YIELD_SLE: Wait Yield-Sleep Time (in milliseconds)

EP_TIME_MSECS

_ WAIT_YIELD_YIE: Wait Yield-Yield Frequency

LD_FREQ

_ WALK_INSERT_TH: maximum number of unusable blocks to walk across

RESHOLD freelist

_ WATCHPOINT_ON: is the watchpointing feature turned on?

_ WCR_CONTROL: Oracle internal test WCR parameter used ONLY for

Testing!

_ WCR_GRV_CACHE_: Oracle internal: Set the replay cache size for

SIZE WRR$_REPLAY_DATA.

_ WCR_SEQ_CACHE_: Oracle internal: Set the replay cache size for

SIZE WRR$_REPLAY_SEQ_DATA.

_ WIDETAB_COMP_E: wide table compression enabled

NABLED

_ WINDOWFUNC_OPT: settings for window function optimizations

IMIZATION_SETTI

NGS

_ WITH_SUBQUERY: WITH subquery transformation

_ WRITE_CLONES: write clones flag

_ XA_INTERNAL_RE: number of internal retries for xa transactions

TRIES

_ XDS_MAX_CHILD_: Maximum number of XDS user-specific child cursors

CURSORS

_ XENGEM_DEVNAME: override default VM GEM device name used by skgvm

_ XENGEM_DIAGMOD: set to OFF to disable VM GEM support and

E functionalities

_ XENGEM_ENABLED: Enable OVM GEM support

_ XPL_PEEKED_BIN: maximum bytes for logging peeked bind values for

DS_LOG_SIZE V$SQL_PLAN (0 = OFF)

_ XPL_TRACE: Explain Plan tracing parameter

_ XSOLAPI_AUTO_M: OLAP API lower bound for auto materialization.

ATERIALIZATION_

BOUND

_ XSOLAPI_AUTO_M: OLAP API behavior for auto materialization

ATERIALIZATION_

TYPE

_ XSOLAPI_BUILD_: OLAP API output build info to trace file

TRACE

_ XSOLAPI_DEBUG_: OLAP API debug output disposition

OUTPUT

_ XSOLAPI_DENSIF: OLAP API cube densification

Y_CUBES

_ XSOLAPI_DIMENS: OLAP API symmetric overfetch

ION_GROUP_CREAT

ION

_ XSOLAPI_DML_TR: OLAP API output dml commands and expressions to trace

ACE file

_ XSOLAPI_FETCH_: OLAP API fetch type

TYPE

_ XSOLAPI_FIX_VP: OLAP API Enable vptr fixing logic in shared server mode

TRS

_ XSOLAPI_GENERA: OLAP API generates WITH clause?

TE_WITH_CLAUSE

_ XSOLAPI_HIERAR: OLAP API hierarchy value type

CHY_VALUE_TYPE

_ XSOLAPI_LOAD_A: When to load OLAP API library at server process start

T_PROCESS_START

_ XSOLAPI_MATERI: OLAP API min number of rows required to use rowcache in

ALIZATION_ROWCA query materialization

CHE_MIN_ROWS_FO

R_USE

_ XSOLAPI_MATERI: OLAP API Enable source materialization

ALIZE_SOURCES

_ XSOLAPI_METADA: OLAP API metadata reader mode

TA_READER_MODE

_ XSOLAPI_ODBO_M: OLAP API uses ODBO mode?

ODE

_ XSOLAPI_OPTIMI: OLAP API optimizes suppressions?

ZE_SUPPRESSION

_ XSOLAPI_OPT_AW: OLAP API enables AW position and count optimization?

_ POSITION

_ XSOLAPI_PRECOM: OLAP API precomputes subqueries?

PUTE_SUBQUERY

_ XSOLAPI_REMOVE: OLAP API removes columns for materialization?

_ COLUMNS_FOR_MA

TERIALIZATION

_ XSOLAPI_SET_NL: OLAP API sets NLS?

S

_ XSOLAPI_SHARE_: OLAP API share executors?

EXECUTORS

_ XSOLAPI_SOURCE: OLAP API output Source definitions to trace file

_ TRACE

_ XSOLAPI_SQL_AL: OLAP API multi-join non-base hints

L_MULTI_JOIN_NO

N_BASE_HINTS

_ XSOLAPI_SQL_AL: OLAP API non-base hints

L_NON_BASE_HINT

S

_ XSOLAPI_SQL_AU: OLAP API enable automatic dimension hints

TO_DIMENSION_HI

NTS

_ XSOLAPI_SQL_AU: OLAP API enable automatic measure hints

TO_MEASURE_HINT

S

_ XSOLAPI_SQL_DI: OLAP API dimension hints

MENSION_HINTS

_ XSOLAPI_SQL_EN: OLAP API enables AW join?

ABLE_AW_JOIN

_ XSOLAPI_SQL_EN: OLAP API enables AW QDR merge?

ABLE_AW_QDR_MER

GE

_ XSOLAPI_SQL_HI: OLAP API generic hints

NTS

_ XSOLAPI_SQL_ME: OLAP API measure hints

ASURE_HINTS

_ XSOLAPI_SQL_MI: OLAP API SQL MINUS threshold

NUS_THRESHOLD

_ XSOLAPI_SQL_OP: OLAP API enable optimization

TIMIZE

_ XSOLAPI_SQL_PR: OLAP API prepare statement cache size

EPARE_STMT_CACH

E_SIZE

_ XSOLAPI_SQL_RE: OLAP API enable remove unused columns optimizations

MOVE_COLUMNS

_ XSOLAPI_SQL_RE: OLAP API result set cache size

SULT_SET_CACHE_

SIZE

_ XSOLAPI_SQL_SY: OLAP API enable symmetric predicate for dimension

MMETRIC_PREDICA groups

TE

_ XSOLAPI_SQL_TO: OLAP API top dimension hints

P_DIMENSION_HIN

TS

_ XSOLAPI_SQL_TO: OLAP API top measure hints

P_MEASURE_HINTS

_ XSOLAPI_SQL_US: OLAP API enable bind variables optimization

E_BIND_VARIABLE

S

_ XSOLAPI_STRING: OLAP API stringifies order levels?

IFY_ORDER_LEVEL

S

_ XSOLAPI_SUPPOR: OLAP API MTM mapping classes supported?

T_MTM

_ XSOLAPI_SUPPRE: OLAP API suppression AW mask threshold

SSION_AW_MASK_T

HRESHOLD

_ XSOLAPI_SUPPRE: OLAP API suppression chunk size

SSION_CHUNK_SIZ

E

_ XSOLAPI_USE_MO: OLAP API uses models?

DELS

_ XSOLAPI_USE_OL: OLAP API uses OLAP DML?

AP_DML

_ XSOLAPI_USE_OL: OLAP API uses OLAP DML for rank?

AP_DML_FOR_RANK

_ XS_CLEANUP_TAS: Triton Session Cleanup

K

_ XS_DISPATCHER_: XS dispatcher only mode

ONLY

_ XTBUFFER_SIZE: buffer size in KB needed for populate/query operation

_ XTTS_ALLOW_PRE: allow cross platform for pre10 compatible tablespace

ten

_ XTTS_SET_PLATF: set cross platform info during file header read

ORM_INFO

_ XT_COVERAGE: external tables code coverage parameter

_ XT_TRACE: external tables trace parameter

_ ZONEMAP_CONTRO: control different uses/algorithms related to zonemaps

L

_ ZONEMAP_STALEN: control the staleness tracking of zonemaps via trigger

ESS_TRACKING

_ ZONEMAP_USE_EN: enable the use of zonemaps for IO pruning

ABLED

_ _ DATA_TRANSFER: Actual size of data transfer cache

_ CACHE_SIZE

_ _ DB_CACHE_SIZE: Actual size of DEFAULT buffer pool for standard block

Size buffers

_ _ DG_BROKER_SER: service names for broker use

VICE_NAMES

_ _ JAVA_POOL_SIZ: Actual size in bytes of java pool

E

_ _ LARGE_POOL_SI: Actual size in bytes of large pool

ZE

_ _ ORACLE_BASE: ORACLE_BASE

_ _ PGA_AGGREGATE: Current target size for the aggregate PGA memory

_ TARGET consumed

_ _ SGA_TARGET: Actual size of SGA

_ _ SHARED_IO_POO: Actual size of shared IO pool

L_SIZE

_ _ SHARED_POOL_S: Actual size in bytes of shared pool

IZE

_ _ STREAMS_POOL_: Actual size in bytes of streams pool

SIZE

2984 rows selected.

References: Oracle Documentation

What are the hidden parameters that are not archived in the Oracle12c version? have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.