Oracle12c版本中未归档隐藏参数
In this post,I will give a list of all undocumented parameters in Oracle 12.1.0.1c. Here is a query to see all the parameters (documented and undocumented) which contain the string you enter when prompted: – Enter name of the parameter when prompted SET linesize 235 col Parameter FOR a50 col SESSION FOR a28 col Instance FOR a55 col S FOR a1 col I FOR a1 col D FOR a1 col Description FOR a90 SELECT a.ksppinm "Parameter",decode(p.isses_modifiable,'FALSE',NULL,b.ksppstvl) "Session",c.ksppstvl "Instance",'F','TRUE','T') "S",decode(p.issys_modifiable,'T','IMMEDIATE','I','DEFERRED','D') "I",decode(p.isdefault,'T') "D",a.ksppdesc "Description" FROM x$ksppi a,x$ksppcv b,x$ksppsv c,v$parameter p WHERE a.indx = b.indx AND a.indx = c.indx AND p.name(+) = a.ksppinm AND UPPER(a.ksppinm) LIKE UPPER('%&1%') ORDER BY a.ksppinm; Enter value for 1: Here is the list of all (2984) undocumented parameters in Oracle 12.1.0.1c : SQL> col parameter for a15 word_wrapped col Description for a55 word_wrapped set pagesize 50000 set linesize 80 select upper(KSPPINM) parameter,' : ',KSPPDESC Description from x$ksppi where substr(ksppinm,1,1) = '_'order by 1,3; PARAMETER DESCRIPTION _4031_DUMP_BITV : bitvec to specify dumps prior to 4031 error _4031_DUMP_INTE : Dump 4031 error once for each n-second interval _4031_MAX_DUMPS : Maximum number of 4031 dumps for this process _4031_SGA_MAX_D : Maximum number of SGA heapdumps _ABORT_ON_MRP_C : abort database instance when MRP crashes _ABORT_RECOVERY : if TRUE,abort recovery on join reconfigurations _ACCEPT_VERSION : List of parameters for rolling operation _ACTIVE_INSTANC : number of active instances in the cluster database _ACTIVE_SESSION : active session idle limit _ACTIVE_SESSION : active session legacy behavior _ACTIVE_STANDBY : if TRUE optimize dlm reconfiguration for active/standby _AC_ENABLE_DSCN : Enable Dependent Commit SCN tracking _ADAPTIVE_DIREC : Adaptive Direct Read _ADAPTIVE_DIREC : Adaptive Direct Write _ADAPTIVE_FETCH : enable/disable adaptive fetch in parallel group by _ADAPTIVE_LOG_F : Threshold for frequent log file sync mode switches (per _ADAPTIVE_LOG_F : Polling interval selection bias (conservative=0, _ADAPTIVE_LOG_F : Window (in seconds) for measuring average scheduling _ADAPTIVE_LOG_F : Ratio of redo synch time to expected poll time as a _ADAPTIVE_LOG_F : Percentage of foreground load from when post/wait was _ADAPTIVE_SCALA : Percentage of overlap across multiple outstanding _ADAPTIVE_SCALA : Increase in redo generation rate as a percentage _ADAPTIVE_WINDO : enable/disable adaptive window consolidator PX plan _ADDM_AUTO_ENAB : governs whether ADDM gets run automatically after every _ADDM_SKIPRULES : comma-separated list of ADDM nodes to skip _ADD_COL_OPTIM_ : Allows new add column optimization _ADD_NULLABLE_C : Allows add of a nullable column with default _ADD_STALE_MV_T : add stale mv to dependency list _ADD_TRIM_FOR_N : add trimming for fixed char semantics _ADG_BUFFER_WAI : Active Dataguard buffer wait time in cs _ADG_INSTANCE_R : enable ADG instance recovery _ADJUST_LITERAL : If TRUE,we will adjust the SQL/PLUS output _ADR_MIGRATE_RU : Enable/disable ADR Migrate Runonce action _ADVANCED_INDEX : advanced index compression options _ADVANCED_INDEX : advanced index compression options2 _ADVANCED_INDEX : advanced index compression trace _AFFINITY_ON : enable/disable affinity at run time _AGGREGATION_OP : settings for aggregation optimizations _AIOWAIT_TIMEOU : Number of aiowait timeouts before error is reported _ALERT_EXPIRATI : seconds before an alert message is moved to exception _ALERT_MESSAGE_ : Enable Alert Message Cleanup _ALERT_MESSAGE_ : Enable Alert Message Purge _ALERT_POST_BAC : Enable Background Alert Posting _ALLOCATE_CREAT : should files be examined in creation order during _ALLOCATION_UPD : interval at which successful search in L1 should be _ALLOW_CELL_SMA : Allow checking smart_scan_capable Attr _ALLOW_COMMUTAT : allow for commutativity of +,* when comparing _ALLOW_COMPATIB : allow advancing DB compatibility with guaranteed _ALLOW_DROP_SNA : Allow dropping snapshot standby guaranteed restore _ALLOW_DROP_TS_ : Allow drop Tablespace with guaranteed restore points _ALLOW_ERROR_SI : Allow error simulation for testing _ALLOW_FILE_1_O : don’t signal ORA-1245 due to file 1 being offline _ALLOW_LEVEL_WI : allow level without connect by _ALLOW_READ_ONL : allow read-only open even if database is corrupt _ALLOW_RESETLOG : allow resetlogs even if it will cause corruption _ALLOW_TERMINAL : Finish terminal recovery even if it may cause _ALL_SHARED_DBL : treat all dblinks as shared _ALTERNATE_IOT_ : enable alternate index-organized table leaf-block _ALTER_COMMON_U : allow local user to create objects in common schema _ALWAYS_ANTI_JO : always use this method for anti-join when possible _ALWAYS_SEMI_JO : always use this method for semi-join when possible _ALWAYS_STAR_TR : always favor use of star transformation _AM_CONTAINER_F : allocation unit size for non-ASM containers _AM_MAX_CONTAIN : maximum number of containers _AM_MAX_GROUPS : maximum number of containers _AM_TIMEOUTS_EN : enable timeouts _AM_TRACE_BUFFE : size of per-process I/O trace buffer _AND_PRUNING_EN : allow partition pruning based on multiple mechanisms _APPQOS_CDB_SET : QoSM CDB Performance Class Setting _APPQOS_PO_MULT : Multiplier for PC performance objective value _APPQOS_QT : System Queue time retrieval interval _AQ_DISABLE_X : AQ – Disable new cross processes at an instance _AQ_PRECRT_PART : Precreate Partitions _AQ_PT_PROCESSE : Partition background processes _AQ_STOP_BACKGR : Stop all AQ background processes _AQ_SUBSHARD_SI : Sub Shard Size _AQ_TM_DEQCOUNT : dequeue count interval for Time Managers to cleanup DEQ _AQ_TM_SCANLIMI : scan limit for Time Managers to clean up IOT _AQ_TM_STATISTI : statistics collection window duration _ARCH_COMPRESSI : archive compression enabled _ARCH_COMPRESS_ : enable/disable row checksums for archive compressed _ARCH_COMP_DBG_ : archive compression scan debug _ARCH_COMP_DEC_ : decompress archive compression blocks for checking and _ARCH_IO_SLAVES : ARCH I/O slaves _ARRAY_UPDATE_V : Enable array update vector read _ASH_COMPRESSIO : To enable or disable string compression in ASH _ASH_DISK_FILTE : Ratio of the number of in-memory samples to the number _ASH_DISK_WRITE : To enable or disable Active Session History flushing _ASH_DUMMY_TEST : Oracle internal dummy ASH parameter used ONLY for _ASH_EFLUSH_TRI : The percentage above which if the in-memory ASH is full _ASH_ENABLE : To enable or disable Active Session sampling and _ASH_MIN_MMNL_D : Minimum Time interval passed to consider MMNL Dump _ASH_SAMPLE_ALL : To enable or disable sampling every connected session _ASH_SAMPLING_I : Time interval between two successive Active Session _ASH_SIZE : To set the size of the in-memory Active Session History _ASMSID : ASM instance id _ASM_ALLOWDEGEN : Allow force-mounts of DGs w/o proper quorum _ASM_ALLOW_APPL : Allow DROP DISK/FAILUREGROUP NOFORCE on ASM Appliances _ASM_ALLOW_LVM_ : Enable disk resilvering for external redundancy _ASM_ALLOW_ONLY : Discovery only raw devices _ASM_ALLOW_SYST : if system alias renaming is allowed _ASM_ALLOW_UNSA : attempt unsafe reconnect to ASM _ASM_APPLIANCE_ : Appliance configuration file name _ASM_AUSIZE : allocation unit size _ASM_AVOID_PST_ : Avoid PST Scans _ASM_BLKSIZE : metadata block size _ASM_COMPATIBIL : default ASM compatibility level _ASM_DBA_BATCH : ASM Disk Based Allocation Max Batch Size _ASM_DBA_THRESH : ASM Disk Based Allocation Threshold _ASM_DBMSDG_NOH : dbms_diskgroup.checkfile does not check block headers _ASM_DIAG_DEAD_ : diagnostics for dead clients _ASM_DIRECT_CON : Expire time for idle direct connection to ASM instance _ASM_DISABLE_AM : Disable AMDU dump _ASM_DISABLE_AS : disable async intra-instance messaging _ASM_DISABLE_MU : Disable checking for multiple ASM instances on a given _ASM_DISABLE_PR : disable profile query for discovery _ASM_DISABLE_SM : Do Not create smr _ASM_DISABLE_UF : disable ufg member kill _ASM_DISABLE_UF : disable terminated umbilicus diagnostic _ASM_DISKERR_TR : Number of read/write errors per disk a process can _ASM_DISKGROUPS : disk groups to mount automatically set 2 _ASM_DISKGROUPS : disk groups to mount automatically set 3 _ASM_DISKGROUPS : disk groups to mount automatically set 4 _ASM_DISK_REPAI : seconds to wait before dropping a failing disk _ASM_EMULATE_NF : Emulate NFS disk test event _ASM_EMULMAX : max number of concurrent disks to emulate I /O errors _ASM_ENABLE_XRO : Enable XROV capability _ASM_EVENREAD : ASM Even Read level _ASM_EVENREAD_A : ASM Even Read Second Alpha _ASM_EVENREAD_F : ASM Even Read Fast Start Threshold _ASM_FAIL_RANDO : Randomly fail some RX enqueue gets _ASM_FOB_TAC_FR : Timeout frequency for FOB cleanup _ASM_FORCE_QUIE : Force diskgroup quiescing _ASM_GLOBAL_DUM : System state dump level for ASM asserts _ASM_HBEATIOWAI : number of secs to wait for PST Async Hbeat IO return _ASM_HBEATWAITQ : quantum used to compute time-to-wait for a PST Hbeat _ASM_HEALTHCHEC : seconds until health check takes action _ASM_IMBALANCE_ : hundredths of a percentage of inter-disk imbalance to _ASM_INSTLOCK_Q : ASM Instance Lock Quota _ASM_IOSTAT_LAT : ASM I/O statistics latch count _ASM_KFDPEVENT : KFDP event _ASM_LIBRARIES : library search order for discovery _ASM_LSOD_BUCKE : ASM lsod bucket size _ASM_MAXIO : Maximum size of individual I/O request _ASM_MAX_REDO_B : asm maximum redo buffer size _ASM_NETWORKS : ASM network subnet addresses _ASM_NODEKILL_E : secs until escalating to nodekill if fence incomplete _ASM_NOEVENREAD : List of disk groups having even read disabled _ASM_PARTNER_TA : target maximum number of disk partners for repartnering _ASM_PARTNER_TA : target maximum number of failure group relationships _ASM_PRIMARY_LO : Number of cycles/extents to load for non-mirrored files _ASM_PRIMARY_LO : True if primary load is in cycles,false if extent _ASM_PROCS_TRAC : Number of processes allowed to trace a disk failure _ASM_PROXY_STAR : Maximum time to wait for ASM proxy connection _ASM_RANDOM_ZON : Random zones for new files _ASM_REBALANCE_ : maximum rebalance work unit _ASM_REBALANCE_ : number of out of space errors allowed before aborting _ASM_REMOTE_CLI : timeout before killing disconnected remote clients _ASM_REPAIRQUAN : quantum (in 3s) used to compute elapsed time for disk _ASM_RESERVE_SL : reserve ASM slaves for CF txns _ASM_RESYNCCKPT : number of extents to resync before flushing checkpoint _ASM_RUNTIME_CA : runtime capability for volume support returns supported _ASM_SCRUB_LIMI : ASM disk scrubbing power _ASM_SECONDARY_ : Number of cycles/extents to load for mirrored files _ASM_SECONDARY_ : True if secondary load is in cycles,false if extent _ASM_SERIALIZE_ : Serialize volume rebalance _ASM_SHADOW_CYC : Inverse shadow cycle requirement _ASM_SKIP_DISKV : skip client side discovery for disk revalidate _ASM_SKIP_RENAM : skip the checking of the clients for s/w compatibility _ASM_SKIP_RESIZ : skip the checking of the clients for s/w compatibility _ASM_STORAGEMAY : PST Split Possible _ASM_STRIPESIZE : ASM file stripe size _ASM_SYNC_REBAL : Rebalance uses sync I/O _ASM_TRACE_LIMI : Time-out in milliseconds to reset the number of traces _ASM_USD_BATCH : ASM USD Update Max Batch Size _ASSM_HIGH_GSP_ : Number of blocks rejected before growing segment _ASSM_LOW_GSP_T : Number of blocks rejected before collecting stats _ASYNC_RECOVERY : if TRUE,issue recovery claims asynchronously _READS _ASYNC_TS_THRES : check tablespace thresholds asynchronously _AUTOMATIC_MAIN : Enable AUTOTASK Test Mode _AUTOMEMORY_BRO : memory broker statistics gathering interval for auto _AUTOTASK_MAX_W : Maximum Logical Maintenance Window Length in minutes _AUTOTASK_MIN_W : Minimum Maintenance Window Length in minutes _AUTOTASK_TEST_ : Name of current Autotask Test (or test step) _AUTOTUNE_GTX_I : idle time to trigger auto-shutdown a gtx background _AUTOTUNE_GTX_I : interval to autotune global transaction background _AUTOTUNE_GTX_T : auto-tune threshold for degree of global transaction _AUTO_ASSIGN_CG : auto assign CGs for sessions _AUTO_BMR : enable/disable Auto BMR _AUTO_BMR_FC_TI : Auto BMR Flood Control Time _AUTO_BMR_PUB_T : Auto BMR Publish Timeout _AUTO_BMR_REQ_T : Auto BMR Requester Timeout _AUTO_BMR_SESS_ : Auto BMR Request Session Threshold _AUTO_BMR_SYS_T : Auto BMR Request System Threshold _AUTO_MANAGE_EN : perodically check for OFFLINE disks and attempt to _AUTO_MANAGE_EX : Automate Exadata disk management _AUTO_MANAGE_IN : TEST: Set infrequent timeout action to run at this _AUTO_MANAGE_IO : oss_ioctl buffer size,to read and respond to cell _AUTO_MANAGE_MA : Max. attempts to auto ONLINE an ASM disk _AUTO_MANAGE_NU : Max. number of out-standing msgs in the KXDAM pipe _AUTO_MANAGE_NU : Num. tries before giving up on a automation operation _AUTO_MANAGE_ON : Allow Max. attempts to auto ONLINE an ASM disk after _AUX_DFC_KEEP_T : auxiliary datafile copy keep time in minutes _AVAILABLE_CORE : number of cores for this instance _AVOID_PREPARE : if TRUE,do not prepare a buffer when the master is _AWR_CDBPERF_TH : Setting for AWR CDBPERF Threshold _AWR_CORRUPT_MO : AWR Corrupt Mode _AWR_DISABLED_F : Disable flushing of specified AWR tables _AWR_FLUSH_THRE : Enable/Disable Flushing AWR Threshold Metrics _AWR_FLUSH_WORK : Enable/Disable Flushing AWR Workload Metrics _AWR_MMON_CPUUS : Enable/disable AWR MMON CPU Usage Tracking _AWR_MMON_DEEP_ : Allows deep purge to purge AWR data for all expired _AWR_MMON_DEEP_ : Set extent of rows to check each deep purge run _AWR_MMON_DEEP_ : Set interval for deep purge of AWR contents _AWR_MMON_DEEP_ : Set max number of rows per table to delete each deep _AWR_PDB_REGIST : Parameter to enable/disable AWR PDB Registration _AWR_REMOTE_TAR : AWR Remote Target DBLink for Flushing _AWR_RESTRICT_M : AWR Restrict Mode _AWR_SQL_CHILD_ : Setting for AWR SQL Child Limit _BACKUP_ALIGN_W : align backup write I/Os _BACKUP_AUTOMAT : automatic retry on backup write errors _BACKUP_DISK_BU : number of buffers used for DISK channels _BACKUP_DISK_BU : size of buffers used for DISK channels _BACKUP_DISK_IO : BACKUP Disk I/O slaves _BACKUP_DYNAMIC : dynamically compute backup/restore buffer sizes _BACKUP_ENCRYPT : specifies encryption block optimization mode _BACKUP_FILE_BU : number of buffers used for file access _BACKUP_FILE_BU : size of buffers used for file access _BACKUP_IO_POOL : memory to reserve from the large pool _BACKUP_KGC_BLK : specifies buffer size to be used by HIGH compression _BACKUP_KGC_BUF : specifies buffer size to be used by BASIC compression _BACKUP_KGC_MEM : specifies memory level for MEDIUM compression _BACKUP_KGC_NIT : specifies number of iterations done by BASIC _BACKUP_KGC_PER : specifies compression (performance) level for MEDIUM _BACKUP_KGC_SCH : specifies compression scheme _BACKUP_KGC_TYP : specifies compression type used by kgc BASIC _BACKUP_KGC_WIN : specifies window size for MEDIUM compression _BACKUP_KSFQ_BU : number of buffers used for backup/restore _BACKUP_KSFQ_BU : maximum amount of memory (in bytes) used for buffers _BACKUP_KSFQ_BU : size of buffers used for backup/restore _BACKUP_LZO_SIZ : specifies buffer size for LOW compression _BACKUP_MAX_GAP : largest gap in an incremental/optimized backup buffer, _BACKUP_MIN_CT_ : mimimun size in bytes of change tracking to apply _BACKUP_SEQ_BUF : number of buffers used for non-DISK channels _BACKUP_SEQ_BUF : size of buffers used for non-DISK channels _BCT_BITMAPS_PE : number of bitmaps to store for each datafile _BCT_BUFFER_ALL : maximum size of all change tracking buffer allocations, _BCT_BUFFER_ALL : mininum number of extents to allocate per buffer _BCT_BUFFER_ALL : size of one change tracking buffer allocation,in bytes _BCT_CHUNK_SIZE : change tracking datafile chunk size,in bytes _BCT_FILE_BLOCK : block size of change tracking file,in bytes _BCT_FILE_EXTEN : extent size of change tracking file,in bytes _BCT_FIXTAB_FIL : change tracking file for fixed tables _BCT_HEALTH_CHE : CTWR health check interval (seconds),zero to disable _BCT_INITIAL_PR : initial number of entries in the private change _BCT_MRP_TIMEOU : CTWR MRP wait timeout (seconds),zero to wait forever _BCT_PUBLIC_DBA : allow dynamic resizing of public dba buffers,zero to _BCT_PUBLIC_DBA : max buffer size permitted for public dba buffers,in _BCT_PUBLIC_DBA : total size of all public change tracking dba buffers, _BG_SPAWN_DIAG_ : background processes spawn diagnostic options _BITMAP_OR_IMPR : controls extensions to partition pruning for general _BLOCKING_SESS_ : blocking session graph cache size in bytes _BLOCKS_PER_CAC : number of consecutive blocks per global cache server _BLOCK_LEVEL_OF : High Latency Threshold for Block Level Offload _BLOCK_SAMPLE_R : controls readahead value during block sampling _BLOOM_FILTER_D : debug level for bloom filtering _BLOOM_FILTER_E : enables or disables bloom filter _BLOOM_FILTER_S : bloom filter vector size (in KB) _BLOOM_FOLDING_ : bloom filter folding density lower bound _BLOOM_FOLDING_ : Enable folding of bloom filter _BLOOM_FOLDING_ : bloom filter folding size lower bound (in KB) _BLOOM_MAX_SIZE : maximum bloom filter size (in KB) _BLOOM_PREDICAT : enables or disables bloom filter predicate pushdown _BLOOM_PREDICAT : enables or disables bloom filter predicate offload to _BLOOM_PRUNING_ : Enable partition pruning using bloom filtering _BLOOM_PUSHING_ : bloom filter pushing size upper bound (in KB) _BLOOM_PUSHING_ : bloom filter combined pushing size upper bound (in KB) _BLOOM_RM_FILTE : remove bloom predicate in favor of zonemap join pruning _BLOOM_SM_ENABL : enable bloom filter optimization using slave mapping _BRANCH_TAGGING : enable branch tagging for distributed transaction _BROADCAST_SCN_ : broadcast-on-commit scn wait timeout in centiseconds _BSLN_ADAPTIVE_ : Adaptive Thresholds Enabled _BT_MMV_QUERY_R : allow rewrites with multiple MVs and base tables _BUFFERED_MESSA : Buffered message spill age _BUFFERED_PUBLI : Flow control threshold for buffered publishers except _BUFFER_BUSY_WA : buffer busy wait time in centiseconds _BUFQ_STOP_FLOW : Stop enforcing flow control for buffered queues _BUILD_DEFERRED : DEFERRED MV creation skipping MV log setup update _BUMP_HIGHWATER : how many blocks should we allocate per free list on _BWR_FOR_FLUSHE : if TRUE,generate a BWR for a flushed PI _BYPASS_SRL_FOR : bypass SRL for S/O EOR logs _BYPASS_XPLATFO : bypass datafile header cross-platform-compliance errors _B_TREE_BITMAP_ : enable the use of bitmap plans for tables w. only _CACHE_ORL_DURI : cache online logs _CACHE_STATS_MO : if TRUE,enable cache stats monitoring _CAPTURE_BUFFER : To set the size of the PGA I/O recording buffers _CAPTURE_PUBLIS : Flow control threshold for capture publishers _CASE_SENSITIVE : case sensitive logon enabled _CAUSAL_STANDBY : Causal standby wait timeout _CDB_COMPATIBLE : CDB Compatible _CDC_SUBSCRIPTI : Change Data Capture subscription_owner _CDMP_DIAGNOSTI : cdmp directory diagnostic level _CELL_FAST_FILE : Allow optimized file creation path for Cells _CELL_FAST_FILE : Allow optimized rman restore for Cells _CELL_FILE_FORM : Cell file format chunk size in MB _CELL_INDEX_SCA : enable CELL processing of index FFS _CELL_MATERIALI : Force materialization of all offloadable expressions on _CELL_MATERIALI : enable offload of expressions underlying virtual _CELL_OBJECT_EX : flashcache object expiration timeout _CELL_OFFLOAD_C : specifies capability table to load _CELL_OFFLOAD_C : enable complex SQL processing offload to cells _CELL_OFFLOAD_E : enable offload of expressions to cells _CELL_OFFLOAD_H : Query offloading of hybrid columnar compressed tables _CELL_OFFLOAD_P : enable out-of-order SQL processing offload to cells _CELL_OFFLOAD_S : enable offload of SYS_CONTEXT evaluation to cells _CELL_OFFLOAD_T : enable timezone related SQL processing offload to cells _CELL_OFFLOAD_V : enable offload of predicates on virtual columns to _CELL_RANGE_SCA : enable CELL processing of index range scans _CELL_STORIDX_M : Cell Storage Index mode _CGS_ALLGROUP_P : CGS DBALL group polling interval in milli-seconds _CGS_COMM_READI : CGS communication readiness check _CGS_DBALL_GROU : CGS DBALL group registration type _CGS_DBGROUP_PO : CGS DB group polling interval in milli-seconds _CGS_HEALTH_CHE : CGS health check during reconfiguration _CGS_MEMBERKILL : allow a RIM instance to issue a CSS member kill _CGS_MSG_BATCHI : CGS message batching _CGS_MSG_BATCH_ : CGS message batch size in bytes _CGS_NODE_KILL_ : CGS node kill escalation to CSS _CGS_NODE_KILL_ : CGS wait time to escalate node kill to CSS in seconds _CGS_RECONFIG_E : CGS reconfiguration extra wait time for CSS in seconds _CGS_RECONFIG_T : CGS reconfiguration timeout interval _CGS_SEND_TIMEO : CGS send timeout value _CGS_TICKETS : CGS messaging tickets _CGS_ZOMBIE_MEM : CGS zombie member kill wait time in seconds _CHANGE_VECTOR_ : Number of change vector buffers for media recovery _CHECK_BLOCK_AF : perform block check after checksum if both are turned _CHECK_BLOCK_NE : check block new invariant for flashback _CHECK_COLUMN_L : check column length _CHECK_PDBID_IN : Enable checking of pluggable database ID in redo _CHECK_TS_THRES : check tablespace thresholds _CLEANOUT_SHRCU : if TRUE,cleanout shrcur buffers _CLEANUP_ROLLBA : no. of undo entries to apply per transaction cleanup _CLEANUP_TIMEOU : timeout value for PMON cleanup _CLEANUP_TIMEOU : flags for PMON cleanup timeout _CLEAR_BUFFER_B : Always zero-out buffer before reuse for security _CLIENT_ENABLE_ : enable automatic unregister after a send fails with _CLIENT_NTFN_CL : interval after which dead client registration cleanup _CLIENT_NTFN_PI : time between pings to unreachable notification clients _CLIENT_NTFN_PI : number of times to ping unreachable notification _CLIENT_NTFN_PI : timeout to connect to unreachable notification clients _CLIENT_RESULT_ : bypass the client result cache _CLIENT_TSTZ_ER : Should Client give error for suspect Timestamp with _CLI_CACHEBKTAL : Percentage of memory to allocate _CLONE_ONE_PDB_ : Recover ROOT and only one PDB in clone database _CLOSE_CACHED_O : close cursors cached by PL/SQL at each commit _CLOSE_DEQ_BY_C : Close Dequeue By Condition Cursors _CLOUD_NAME : gsm cloud name _CLUSTER_LIBRAR : cluster library selection _COLLAPSE_WAIT_ : collapse wait history _COLLECT_TEMPUN : Collect Statistics v$tempundostat _COLLECT_UNDO_S : Collect Statistics v$undostat _COLUMN_COMPRES : Column compression ratio _COLUMN_ELIMINA : turn off predicate-only column elimination _COLUMN_TRACKIN : column usage tracking _COMMON_DATA_VI : common objects returned through dictionary views _COMMON_USER_PR : Enforce restriction on a prefix of a Common _COMPILATION_CA : Size of the compilation call heaps extents _COMPLEX_VIEW_M : enable complex view merging _COMPRESSION_AB : number of recompression above cache for sanity check _COMPRESSION_AD : Compression advisor _COMPRESSION_CH : percentage of chained rows allowed for Compression _COMPRESSION_CO : Compression compatability _CONCURRENCY_CH : what is the chosen value of concurrency _CONNECTION_BRO : connection broker host for listen address _CONNECT_BY_USE : use union all for connect by _CONTROLFILE_AU : time delay (in seconds) for performing controlfile _CONTROLFILE_BA : enable check of the copied blocks during controlfile _CONTROLFILE_BL : control file block size in bytes _CONTROLFILE_CE : Flash cache hint for control file accesses _CONTROLFILE_EN : dump the system states after controlfile enqueue _CONTROLFILE_EN : control file enqueue max holding time in seconds _CONTROLFILE_EN : control file enqueue holding time tracking size _CONTROLFILE_EN : control file enqueue timeout in seconds _CONTROLFILE_SE : control file initial section size _CONTROLFILE_SE : control file max expansion rate _CONTROLFILE_UP : controlfile update sanity check _CONVERT_SET_TO : enables conversion of set operator to join _COORD_MESSAGE_ : parallel recovery coordinator side extra message buffer _CORRUPTED_ROLL : corrupted undo segment list _COST_EQUALITY_ : enables costing of equality semi-join _CPU_EFF_THREAD : CPU effective thread multiplier _CPU_TO_IO : divisor for converting CPU cost to I/O cost _CRASH_DOMAIN_O : allow domain to exit for exceptions in any thread _CREATE_STAT_SE : create ilm statistics segment _CREATE_TABLE_I : allow creation of table in a cluster not owned by the _CR_GRANT_GLOBA : if TRUE,grant lock for CR requests when block is in _CR_GRANT_LOCAL : turn 3-way CR grants off,make it automatic,or turn it _CR_GRANT_ONLY : if TRUE,grant locks when possible and do not send the _CR_SERVER_LOG_ : if TRUE,flush redo log before serving a CR buffer _CR_TRC_BUF_SIZ : size of cr trace buffer _CTX_DOC_POLICY : enable ctx_doc.policy_stems api _CURSOR_BIND_CA : maximum size of the cursor bind capture area _CURSOR_BIND_CA : interval (in seconds) between two bind capture for a _CURSOR_CACHE_T : number of seconds a session cached cursor stay in _CURSOR_DB_BUFF : additional number of buffers a cursor can pin at once _CURSOR_FEATURE : Shared cursor features enabled bits. _CURSOR_OBSOLET : Number of cursors per parent before obsoletion. _CURSOR_PLAN_EN : enable collection and display of cursor plans _CURSOR_PLAN_HA : version of cursor plan hash value _CURSOR_PLAN_UN : enables/disables using unparse to build _CURSOR_RELOAD_ : Number of failed reloads before marking cursor unusable _CURSOR_RUNTIME : Shared cursor runtime heap memory limit _CURSOR_STATS_E : Enable cursor stats _CU_ROW_LOCKING : CU row level locking _CVW_ENABLE_WEA : enable weak view checking _DATAFILE_COW : Use copy on write snapshot for the renamed file _DATAPUMP_COMPR : specifies buffer size for BASIC compression algorithm _DATAPUMP_METAD : specifies buffer size for metadata file I/O _DATAPUMP_TABLE : specifies buffer size for table data file I/O _DATA_TRANSFER_ : Percentange * 100 of buffer cache to transfer to data _DATA_TRANSFER_ : Size of data transfer cache _DATA_WAREHOUSI : if TRUE,enable data warehousing scan buffers _DBFS_MODIFY_IM : DBFS Link allows implicit fetch on modify – only on _DBG_PROC_START : debug process startup _DBG_SCAN : generic scan debug _DBOP_ENABLED : Any positive number enables automatic DBOP monitoring. _DBPOOL_NAME : gsm database pool name _DBRM_NUM_RUNNA : Resource Manager number of runnable list per NUMA node _DBRM_QUANTUM : DBRM quantum _DBWR_ASYNC_IO : Enable dbwriter asynchronous writes _DBWR_TRACING : Enable dbwriter tracing _DB_16K_FLASH_C : flash cache size for _db_16k_flash_cache_file _DB_2K_FLASH_CA : flash cache file for 2k block size _DB_2K_FLASH_CA : flash cache size for _db_2k_flash_cache_file _DB_32K_FLASH_C : flash cache file for 32k block size _DB_32K_FLASH_C : flash cache size for _db_32k_flash_cache_file _DB_4K_FLASH_CA : flash cache file for 4k block size _DB_4K_FLASH_CA : flash cache size for _db_4k_flash_cache_file _DB_8K_FLASH_CA : flash cache file for 8k block size _DB_8K_FLASH_CA : flash cache size for _db_8k_flash_cache_file _DB_AGING_COOL_ : Touch count set when buffer cooled _DB_AGING_FREEZ : Make CR buffers always be too cold to keep in cache _DB_AGING_HOT_C : Touch count which sends a buffer to head of replacement _DB_AGING_STAY_ : Touch count set when buffer moved to head of _DB_AGING_TOUCH : Touch count which sends a buffer to head of replacement _DB_ALWAYS_CHEC : Always perform block check and checksum for System _DB_BLOCKS_PER_ : Number of blocks per hash latch _DB_BLOCK_ADJCH : adjacent cache buffer checks – low blkchk overwrite _DB_BLOCK_ADJCH : adjacent cache buffer check level _DB_BLOCK_ALIGN : Align Direct Reads _DB_BLOCK_BAD_W : enable bad write checks _DB_BLOCK_BUFFE : Number of database blocks cached in memory: hidden _DB_BLOCK_CACHE : Always clone data blocks on get (for debugging) _DB_BLOCK_CACHE : buffer header tracing (non-zero only when debugging) _DB_BLOCK_CACHE : buffer header tracing level _DB_BLOCK_CACHE : buffer header tracing for lru operations _DB_BLOCK_CACHE : number of unmapped buffers (for tracking swap calls on _DB_BLOCK_CACHE : protect database blocks (true only when debugging) _DB_BLOCK_CACHE : protect database blocks (for strictly internal use _DB_BLOCK_CHECK : Check more and dump block before image for debugging _DB_BLOCK_CHECK : check objd and typ on cache disk read _DB_BLOCK_CHUNK : chunkify noncontig multi block reads _DB_BLOCK_CORRU : threshold number of block recovery attempts _DB_BLOCK_DO_FU : do full block read even if some blocks are in cache _DB_BLOCK_HASH_ : Number of database block hash buckets _DB_BLOCK_HASH_ : Number of database block hash latches _DB_BLOCK_HEADE : number of extra buffer headers to use as guard pages _DB_BLOCK_HI_PR : Fraction of writes for high priority reasons _DB_BLOCK_KNOWN : Initial Percentage of buffers to maintain known clean _DB_BLOCK_LRU_L : number of lru latches _DB_BLOCK_MAX_C : Maximum Allowed Number of CR buffers per dba _DB_BLOCK_MAX_S : Percentage of buffers to inspect when looking for free _DB_BLOCK_MED_P : Fraction of writes for medium priority reasons _DB_BLOCK_NUMA : Number of NUMA nodes _DB_BLOCK_PREFE : Prefetch limit in blocks _DB_BLOCK_PREFE : Prefetch force override in blocks _DB_BLOCK_PREFE : Batched IO enable private cache _DB_BLOCK_PREFE : Prefetch quota as a percent of cache size _DB_BLOCK_PREFE : Batched IO enable skip reading buffers _DB_BLOCK_PREFE : Allowed wasted percent threshold of prefetched size _DB_BLOCK_TABLE : Size of shared table scan read buffer _DB_BLOCK_TEMP_ : generate redo for temp blocks _DB_BLOCK_TRACE : trace buffer protect calls _DB_BLOCK_VLM_C : check of rvlm mapping leaks (for debugging) _DB_BLOCK_VLM_L : Threshold for allowable vlm leaks _DB_CACHE_ADVIC : cache advisory maximum multiple of current size to _DB_CACHE_ADVIC : cache advisory sampling factor _DB_CACHE_ADVIC : cache simulation sanity check _DB_CACHE_BLOCK : dump short call stack for block reads _DB_CACHE_CRX_C : check for costly crx examination functions _DB_CACHE_MISS_ : check LEs after cache miss _DB_CACHE_MMAN_ : check for wait latch get under MMAN ops in kcb _DB_CACHE_PRE_W : Buffer Cache Pre-Warm Enabled : hidden parameter _DB_CACHE_PROCE : maximum number of cr pins a process may have _DB_CACHE_WAIT_ : trace new kslwaits _DB_CHANGE_NOTI : enable db change notification _DB_CHECK_CELL_ : _DB_DISABLE_TEM : Disable Temp Encryption for Spills _DB_DUMP_FROM_D : dump contents from disk and efc _DB_DW_SCAN_ADA : if TRUE,enable adaptive DW scan cooling _DB_DW_SCAN_MAX : DW Scan adaptive cooling max shadow count _DB_DW_SCAN_OBJ : DW Scan object cooling factor to cool all temperatures _DB_DW_SCAN_OBJ : DW Scan object cooling interval in number of scans, _DB_DW_SCAN_OBJ : DW scan objtect cooling policy _DB_DW_SCAN_OBJ : DW Scan object warming increment when an object is _DB_FAST_OBJ_CH : enable fast object drop sanity check _DB_FAST_OBJ_CK : enable fast object checkpoint _DB_FAST_OBJ_TR : enable fast object truncate _DB_FILE_DIRECT : Sequential I/O buf size _DB_FILE_EXEC_R : multiblock read count for regular clients _DB_FILE_FORMAT : Block formatting I/O buf count _DB_FILE_NONCON : number of noncontiguous db blocks to be prefetched _DB_FILE_OPTIMI : multiblock read count for regular clients _DB_FLASHBACK_I : Flashback IO Buffer Size _DB_FLASHBACK_L : Minimum flashback database log size in bytes _DB_FLASHBACK_L : Minimum flashback database log total space in bytes _DB_FLASHBACK_N : Flashback Number of IO buffers _DB_FLASH_CACHE : Flash cache force replenish lower limit in buffers _DB_FLASH_CACHE : Flash cache keep buffer upper limit in percentage _DB_FLASH_CACHE : Flash cache maximum latency allowed in 10 milliseconds _DB_FLASH_CACHE : Flash cache maximum outstanding writes allowed _DB_FLASH_CACHE : Flash cache max read retry _DB_FLASH_CACHE : Flash cache maximum slow io allowed _DB_FLASH_CACHE : Flash cache write buffer upper limit in percentage _DB_HANDLES : System-wide simultaneous buffer operations _DB_HOT_BLOCK_T : track hot blocks for hash latch contention _DB_INDEX_BLOCK : index block checking override parameter _DB_INITIAL_CAC : size of cache created at startup _DB_L2_TRACING : flash cache debug tracing _DB_LOST_WRITE_ : Enable scn based lost write detection mechanism _DB_LOST_WRITE_ : Enable _db_lost_write_checking tracing _DB_MTTR_ADVICE : MTTR advisory _DB_MTTR_SAMPLE : MTTR simulation sampling factor _DB_MTTR_SIM_TA : MTTR simulation targets _DB_MTTR_SIM_TR : MTTR simulation trace size _DB_MTTR_TRACE_ : dump trace entries to alert file _DB_NOARCH_DISB : Image redo logging (NOARCHIVEMODE) _DB_NUM_EVICT_W : number of evict wait events _DB_NUM_GSM : database number in gsm dbpool _DB_PERCENT_HOT : Percent of default buffer pool considered hot _DB_PERCENT_HOT : Percent of keep buffer pool considered hot _DB_PERCENT_HOT : Percent of recycle buffer pool considered hot _DB_PERCPU_CREA : size of cache created per cpu in deferred cache create _DB_PREFETCH_HI : maintain prefetch histogram statistics in x$kcbprfhs _DB_RECOVERY_TE : default database recovery temporal file location _DB_REQUIRED_PE : percent of fairshare a processor group should always _DB_ROW_OVERLAP : row overlap checking override parameter for data/index _DB_TODEFER_CAC : buffer cache deferred create _DB_WRITER_CHUN : Number of writes DBWR should wait for _DB_WRITER_COAL : Size of memory allocated to dbwriter for coalescing _DB_WRITER_COAL : Limit on size of coalesced write _DB_WRITER_FLUS : If FALSE,DBWR will not downgrade IMU txns for AGING _DB_WRITER_HIST : maintain dbwr histogram statistics in x$kcbbhs _DB_WRITER_MAX_ : Max number of outstanding DB Writer IOs _DB_WRITER_NOME : Enable DBWR no-memcopy coalescing _DB_WRITER_VERI : Enable lost write detection mechanism _DDE_FLOOD_CONT : Initialize Flood Control at database open _DD_VALIDATE_RE : GES deadlock detection validate remote locks _DEADLOCK_DIAGN : automatic deadlock resolution diagnostics level _DEADLOCK_RECOR : record resolved deadlocks to the alert log _DEADLOCK_RESOL : create incidents when resolving any deadlock? _DEADLOCK_RESOL : create incidents during deadlock resolution _DEADLOCK_RESOL : automatic deadlock resolution level _DEADLOCK_RESOL : the minimum wait timeout required for deadlock _DEADLOCK_RESOL : the amount of time given to process a deadlock _DEAD_PROCESS_S : PMON dead process scan interval (in seconds) _DEDICATED_SERV : dedicated server poll count _DEDICATED_SERV : dedicated server post/wait _DEDICATED_SERV : dedicated server post/wait call _DEFAULT_ENCRYP : default encryption algorithm _DEFAULT_NON_EQ : sanity check on default selectivity for like/range _DEFERRED_CONST : Deferred constant folding mode _DEFERRED_LOG_D : consider deferred log dest as valid for log deletion _DEFERRED_SEG_I : Enable Deferred Segment Creation in Seed _DEFER_EOR_ORL_ : defer EOR ORL archival for switchover _DEFER_LOG_BOUN : defer media recovery checkpoint at log boundary _DEFER_LOG_COUN : Number of log boundaries media recovery checkpoint lags _DEFER_RCV_DURI : Defer recovery during switchover to standby _DEFER_SGA_ALLO : Chunk size for defer sga allocation _DEFER_SGA_ENAB : Enable deferred shared memory allocation for SGA _DEFER_SGA_MIN_ : Minimum shared pool size at startup with deferred sga _DEFER_SGA_MIN_ : Minimum total deferred segs size for defer sga _DEFER_SGA_TEST : SA** sleeps for N secs before allocating a deferred _DELAY_INDEX_MA : delays index maintenance until after MV is refreshed _DELTA_PUSH_SHA : enable delta push if greater than the # of share _DEQ_EXECUTE_RE : deq execute reset time _DEQ_HT_CHILD_L : deq ht child latches _DEQ_HT_MAX_ELE : deq ht max elements _DEQ_LARGE_TXN_ : deq large txn size _DEQ_LOG_ARRAY_ : deq log array size _DEQ_MAXWAIT_TI : Change wait times between dequeue calls _DEQ_MAX_FETCH_ : deq max fetch count _DESIRED_README : The desired percentage of redo reading from memory _DG_BROKER_TRAC : data guard broker trace level _DG_CF_CHECK_TI : Data Guard controlfile check timer _DG_CORRUPT_RED : Corrupt redo log validation during archivals _DIAG_ADR_AUTO_ : Enable/disable ADR MMON Auto Purging _DIAG_ADR_ENABL : Parameter to enable/disable Diag ADR _DIAG_ADR_TEST_ : Test parameter for Diagnosability _DIAG_ARB_BEFOR : dump diagnostics before killing unresponsive ARBs _DIAG_BACKWARD_ : Backward Compatibility for Diagnosability _DIAG_CC_ENABLE : Parameter to enable/disable Diag Call Context _DIAG_CONF_CAP_ : Parameter to enable/disable Diag Configuration Capture _DIAG_CRASHDUMP : parameter for systemstate dump level,used by DIAG _DIAG_DAEMON : start DIAG daemon _DIAG_DDE_ASYNC : diag dde async actions: action cputime limit (in _DIAG_DDE_ASYNC : diag dde async actions: dispatch mode _DIAG_DDE_ASYNC : diag dde async actions: number of preallocated message _DIAG_DDE_ASYNC : diag dde async actions: message buffer capacity _DIAG_DDE_ASYNC : diag dde async actions: message processing rate – per _DIAG_DDE_ASYNC : diag dde async actions: action runtime limit (in _DIAG_DDE_ASYNC : diag dde async actions: max number of concurrent slave _DIAG_DDE_ENABL : enable DDE handling of critical errors _DIAG_DDE_FC_EN : Parameter to enable/disable Diag Flood Control _DIAG_DDE_FC_IM : Override Implicit Error Flood Control time parameter _DIAG_DDE_FC_MA : Override Macro Error Flood Control time parameter _DIAG_DDE_INC_P : The minimum delay between two MMON incident sweeps _DIAG_DIAGNOSTI : Turn off diag diagnostics _DIAG_DUMP_REQU : DIAG dump request debug level (0-2) _DIAG_DUMP_TIME : timeout parameter for SYNC dump _DIAG_ENABLE_ST : enable events in instance startup notifiers _DIAG_HM_RC_ENA : Parameter to enable/disable Diag HM Reactive Checks _DIAG_HM_TC_ENA : Parameter to enable/disable Diag HM Test(dummy) Checks _DIAG_PROC_ENAB : enable hung process diagnostic API _DIAG_PROC_MAX_ : hung process diagnostic API max wait time in _DIAG_PROC_STAC : hung process diagnostic API stack capture type _DIAG_TEST_SEG_ : Sets trace segmentation to be in reincarnation mode _DIAG_UTS_CONTR : UTS control parameter _DIAG_VERBOSE_E : Allow verbose error tracing on diag init _DIAG_XM_ENABLE : If TRUE,DIAG allows message exchanges across DB/ASM _DIMENSION_SKIP : control dimension skip when null feature _DIRECT_IO_SKIP : Skip current slot on error _DIRECT_IO_SLOT : number of slots for direct path I/O _DIRECT_IO_WSLO : number of write slots for direct path I/O _DIRECT_PATH_IN : disable direct path insert features _DIRECT_READ_DE : enable direct read decision based on optimizer _DISABLE_12751 : disable policy timeout error (ORA-12751) _DISABLE_ACTIVE : disable active influx move during parallel media _DISABLE_ADAPTI : adaptive shrunk aggregation _DISABLE_APPLIA : Disable appliance-specific code _DISABLE_APPLIA : Disable appliance partnering algorithms _DISABLE_AUTOTU : disable autotune global transaction background _DISABLE_BLOCK_ : disable block checking at the session level _DISABLE_CELL_O : disable cell optimized backups _DISABLE_CPU_CH : disable cpu_count check _DISABLE_CURSOR : disable cursor sharing _DISABLE_DATALA : disable datalayer sampling _DISABLE_DIRECT : Disable directory link checking _DISABLE_DUPLEX : Turn off connection duplexing _DISABLE_FASTOP : Do Not Use Fastopen _DISABLE_FAST_A : fast aggregation _DISABLE_FAST_V : disable PL/SQL fast validation _DISABLE_FBA_QR : disable flashback archiver query rewrite _DISABLE_FBA_WP : disable flashback archiver wait for prepared _DISABLE_FILE_L : disable file locks for control,data,redo log files _DISABLE_FLASHB : disable flashback archiver _DISABLE_FLASHB : Don’t use the Flashback Recyclebin optimization _DISABLE_FLASHB : Disable flashback wait callback _DISABLE_FUNCTI : disable function-based index matching _DISABLE_GVAQ_C : Disable cache _DISABLE_HEALTH : Disable Health Check _DISABLE_HIGHRE : disable high-res tick counter _DISABLE_IMAGE_ : Disable Oracle executable image checking _DISABLE_IMPLIC : disable implicit row movement _DISABLE_INCREM : Disable incremental checkpoints for thread recovery _DISABLE_INCREM : Disable incremental recovery checkpoint mechanism _DISABLE_INDEX_ : disable index block prefetching _DISABLE_INITIA : disable initial block compression _DISABLE_INSTAN : disable instance type check for ksp _DISABLE_INTERF : disable interface checking at startup _DISABLE_KCBHXO : disable kcbh(c)xor OSD functionality _DISABLE_KCBL_F : Disable KCBL flashback block new optimization _DISABLE_KCB_FL : Disable KCB flashback block new optimization _DISABLE_KGGHSH : disable kgghshcrc32chk OSD functionality _DISABLE_LATCH_ : disable latch-free SCN writes using 32-bit compare & _DISABLE_LATCH_ : disable latch-free SCN writes using 64-bit compare & _DISABLE_LOGGIN : Disable logging _DISABLE_METRIC : Disable Metrics Group (or all Metrics Groups) _DISABLE_MULTIP : disable multiple block size support (for debugging) _DISABLE_ODM : disable odm feature _DISABLE_PRIMAR : disable primary bitmap switch _DISABLE_READ_O : Disable read-only open dictionary check _DISABLE_REBALA : disable space usage checks for storage reconfiguration _DISABLE_RECOVE : Disable the read optimization during media recovery _DISABLE_ROLLIN : Disable Rolling Patch Feature _DISABLE_SAMPLE : disable row sampling IO optimization _DISABLE_SAVEPO : disable the fix for bug 1402161 _DISABLE_SELFTU : Disable self-tune checkpointing _DISABLE_STORAG : Disable storage type checks _DISABLE_STREAM : streams diagnostics _DISABLE_STREAM : disable streams pool auto tuning _DISABLE_SUN_RS : Disable IPC OSD support for Sun RSMAPI _DISABLE_SYSTEM : disable system state dump _DISABLE_SYSTEM : Disable system state dump – wait samples _DISABLE_TEMP_T : disable tablespace alerts for TEMPORARY tablespaces _DISABLE_THREAD : Disable thread internal disable feature _DISABLE_THREAD : Thread snapshot _DISABLE_TXN_AL : disable txn layer alert _DISABLE_UNDO_T : disable tablespace alerts for UNDO tablespaces _DISABLE_WAIT_S : Disable wait state _DISCRETE_TRANS : enable OLTP mode _DISKMON_PIPE_N : DiSKMon skgznp pipe name _DISK_SECTOR_SI : if TRUE,OSD sector size could be overridden _DISPATCHER_RAT : scale to display rate statistic (100ths of a second) _DISPATCHER_RAT : time-to-live for rate statistic (100ths of a second) _DISTINCT_VIEW_ : enables unnesting of in subquery into distinct view _DISTRIBUTED_RE : number of seconds RECO holds outbound connections open _DLMTRACE : Trace string of global enqueue type(s) _DML_FREQUENCY_ : Control DML frequency tracking _DML_FREQUENCY_ : Control automatic advance and broadcast of DML _DML_FREQUENCY_ : Number of slots to use for DML frequency tracking _DML_FREQUENCY_ : Time length of each slot for DML frequency tracking _DML_MONITORING : enable modification monitoring _DM_DMF_DETAILS : set dm dmf details compatibility version _DM_ENABLE_LEGA : revert dmf output types to pre-12.1.0.1 _DM_MAX_SHARED_ : max percentage of the shared pool to use for a mining _DNFS_RDMA_ENAB : Enable dNFS RDMA transfers _DNFS_RDMA_MAX : Maximum size of dNFS RDMA transfer _DOMAIN_INDEX_D : maximum number of rows for one call to domain index dml _DRA_BMR_NUMBER : Maximum number of BMRs that can be done to a file _DRA_BMR_PERCEN : Maximum percentage of blocks in a file that can be _DRA_ENABLE_OFF : Enable the periodic creation of the offline dictionary _DRM_PARALLEL_F : if TRUE enables parallel drm freeze _DROP_FLASHBACK : Drop logical operations enqueue immediately during _DROP_STAT_SEGM : drop ilm statistics segment _DROP_TABLE_GRA : drop_table_granule _DROP_TABLE_OPT : reduce SGA memory use during drop of a partitioned _DSC_FEATURE_LE : controls the feature level for deferred segment _DSKM_HEALTH_CH : DiSKMon health check counter _DSS_CACHE_FLUS : enable full cache flush for parallel execution _DS_ENABLE_AUTO : Dynamic Sampling Service Autonomous Transaction control _DS_IOCOUNT_IOS : Dynamic Sampling Service defaults: #IOs and IO Size _DS_PARSE_MODEL : Dynamic Sampling Service Parse Model control parameter _DTREE_BINNING_ : Decision Tree Binning Enabled _DTREE_BINTEST_ : Decision Tree Binning Test ID _DTREE_COMPRESS : Decision Tree Using Compressed Bitmaps Enabled _DTREE_MAX_SURR : maximum number of surrogates _DTREE_PRUNING_ : Decision Tree Pruning Enabled _DUMMY_INSTANCE : dummy instance started by RMAN _DUMP_COMMON_SU : dump common subexpressions _DUMP_CONNECT_B : dump connect by loop error message into trc file _DUMP_CURSOR_HE : dump comp/exec heap sizes to tryace file _DUMP_INTERVAL_ : trace dump time interval limit (in seconds) _DUMP_MAX_LIMIT : max number of dump within dump interval _DUMP_SYSTEM_ST : scope of sysstate dump during instance termination _DUMP_TRACE_SCO : scope of trace dump during a process crash _DYNAMIC_RLS_PO : rls policies are dynamic _DYNAMIC_STATS_ : delay threshold (in seconds) between sending statistics _EIGHTEENTH_SPA : eighteenth spare parameter – string _EIGHTH_SPARE_P : eighth spare parameter – integer _ELEVENTH_SPARE : eleventh spare parameter – integer _ELIMINATE_COMM : enables elimination of common sub-expressions _EMON_MAX_ACTIV : maximum open connections to clients per emon _EMON_OUTBOUND_ : timeout for completing connection set up to clients _EMON_POOL_INC : increment in EMON slaves per pool type _EMON_SEND_TIME : send timeout after which the client is unregistered _EMX_CONTROL : EM Express control (internal use only) _EMX_SESSION_TI : Session timeout (sec) in the EM Express cache _ENABLE_12G_BFT : enable 12g bigfile tablespace _ENABLE_AUTOMAT : if 1,Automated Maintenance Is Enabled _ENABLE_AUTOMAT : Automatic SQL Tuning Advisory enabled parameter _ENABLE_BLOCK_L : enable block level recovery _ENABLE_CHECK_T : enable checking of corruption caused by canceled _ENABLE_COLUMNA : Enable Columnar Flash Cache Rewrite _ENABLE_CSCN_CA : enable commit SCN caching for all transactions _ENABLE_DDL_WAI : use this to turn off ddls with wait semantics _ENABLE_DEFAULT : enable default implementation of hard affinity osds _ENABLE_DEFAULT : Enable Default Tablespace Utilization Threshold for _ENABLE_DEFAULT : Enable Default Tablespace Utilization Threshold for _ENABLE_DML_LOC : enable dml lock escalation against partitioned tables _ENABLE_EDITION : enable editions for all users _ENABLE_EXCHANG : use check constraints on the table for validation _ENABLE_FAST_RE : enable fast refresh after move tablespace _ENABLE_FFW : FAL FORWARDING _ENABLE_FRONT_E : enable front end view optimization _ENABLE_HASH_OV : TRUE – enable hash cluster overflow based on SIZE _ENABLE_HEATMAP : heatmap related – to be used by oracle dev only _ENABLE_HWM_SYN : enable HWM synchronization _ENABLE_IEE_STA : enables IEE stats gathering _ENABLE_ILM_FLU : Enable ILM Stats Flush _ENABLE_ILM_TES : Enable Test ILM Stats Flush _ENABLE_KQF_PUR : Enable KQF fixed runtime table purge _ENABLE_LGPG_DE : Enable LGPG debug mode _ENABLE_LIST_IO : Enable List I/O _ENABLE_MINSCN_ : enable/disable minscn optimization for CR _ENABLE_NATIVEN : Enable skgxp driver usage for native net _ENABLE_NUMA_IN : Enable NUMA interleave mode _ENABLE_NUMA_OP : Enable NUMA specific optimizations _ENABLE_NUMA_SU : Enable NUMA support and optimizations _ENABLE_OBJ_QUE : enable object queues _ENABLE_OFFLOAD : Enable offloaded writes for Unit Test _ENABLE_ONLINE_ : Allow online index creation algorithm without S DML _ENABLE_PLUGGAB : Enable Pluggable Database _ENABLE_QUERY_R : mv rewrite on remote table/view _ENABLE_REDO_GL : LGWR post globally on write _ENABLE_REFRESH : enable or disable MV refresh scheduling (revert to 9.2 _ENABLE_RELIABL : Enable reliable latch waits _ENABLE_RENAME_ : enable RENAME-clause using ALTER USER statement _ENABLE_RLB : enable RLB metrics processing _ENABLE_SB_DETE : Split Brain Detection _ENABLE_SCHEMA_ : enable DDL operations (e.g. creation) involving schema _ENABLE_SCN_WAI : use this to turn off scn wait interface in kta _ENABLE_SECUREF : Enable securefile flashback optimization _ENABLE_SEPARAB : enable/disable separable transactions _ENABLE_SHARED_ : temporary to disable/enable kgh policy _ENABLE_SHARED_ : Enable shared server vector I/O _ENABLE_SPACEBG : enable space management background task _ENABLE_TABLESP : enable tablespace alerts _ENABLE_TYPE_DE : enable type dependent selectivity estimates _ENDPROT_CHUNK_ : chunk comment for selective overrun protection _ENDPROT_HEAP_C : heap comment for selective overrun protection _ENDPROT_SUBHEA : selective overrun protection for subeheaps _ENQUEUE_DEADLO : enable deadlock detection on all global enqueues _ENQUEUE_DEADLO : deadlock scan interval _ENQUEUE_DEADLO : requests with timeout <= this will not have deadlock _ENQUEUE_DEBUG_ : debug enqueue multi instance _ENQUEUE_HASH : enqueue hash table length _ENQUEUE_LOCKS : locks for managed enqueues _ENQUEUE_RESOUR : resources for enqueues _ENQUEUE_SYNC_R : max number of times the bg process to retry synchronous _ENQUEUE_SYNC_S : simulate master instance running out of memory when _EVOLVE_PLAN_BA : Level of detail to show in plan verification/evolution _EVT_SYSTEM_EVE : disable system event propagation _EXPAND_AGGREGA : expand aggregates _EXPLAIN_REWRIT : allow additional messages to be generated during _EXTENDED_PRUNI : do runtime pruning in iterator if set to TRUE _EXTERNAL_SCN_L : High delta SCN threshold in seconds _EXTERNAL_SCN_R : external SCN rejection delta threshold in minutes _EXTERNAL_SCN_R : Lag in hours between max allowed SCN and an external _FAIRNESS_THRES : number of times to CR serve before downgrading lock _FAIR_REMOTE_CV : if TRUE enables fair remote convert _FASTPIN_ENABLE : enable reference count based fast pins _FAST_DUAL_ENAB : enable/disable fast dual _FAST_FULL_SCAN : enable/disable index fast full scan _FAST_INDEX_MAI : fast global index maintenance during PMOPs _FAST_PSBY_CONV : Enable fast physical standby conversion _FBDA_BUSY_PERC : flashback archiver busy percentage _FBDA_DEBUG_ASS : flashback archiver debug assert for testing _FBDA_DEBUG_MOD : flashback archiver debug event for testing _FBDA_GLOBAL_BS : flashback archiver global barrier scn lag _FBDA_INLINE_PE : flashback archiver inline percentage _FBDA_RAC_INACT : flashback archiver rac inactive limit _FG_IORM_SLAVES : ForeGround I/O slaves for IORM _FG_SYNC_SLEEP_ : Log file sync via usleep _FIC_ALGORITHM_ : Set Frequent Itemset Counting Algorithm _FIC_AREA_SIZE : size of Frequent Itemset Counting work area _FIFTEENTH_SPAR : fifteenth spare parameter – integer _FIFTH_SPARE_PA : fifth spare parameter – integer _FILEMAP_DIR : FILEMAP directory _FIRST_K_ROWS_D : enable the use of dynamic proration of join _FIRST_SPARE_PA : first spare parameter – integer _FIX_CONTROL : bug fix control parameter _FLASHBACK_ALLO : Allow enabling flashback on noarchivelog database _FLASHBACK_ARCH : flashback archiver table partition size _FLASHBACK_BARR : Flashback barrier interval in seconds _FLASHBACK_COPY : Number of flashback copy latches _FLASHBACK_DATA : Run Flashback Database in test mode _FLASHBACK_DELE : Amount of flashback log (in MB) to delete in one _FLASHBACK_DYNA : enable flashback enable code path _FLASHBACK_DYNA : Simulate failures during dynamic enable _FLASHBACK_ENAB : Flashback enable read ahead _FLASHBACK_FORM : Chunk mega-bytes for formatting flashback logs using _FLASHBACK_FORM : Chunk mega-bytes for formatting flashback logs using _FLASHBACK_FUZZ : Use flashback fuzzy barrier _FLASHBACK_GENE : flashback generation buffer size _FLASHBACK_HINT : Flashback hint barrier percent _FLASHBACK_LOGF : flashback logfile enqueue timeout for opens _FLASHBACK_LOG_ : Specify Flashback log I/O error behavior _FLASHBACK_LOG_ : Minimum flashback log size _FLASHBACK_LOG_ : flashback log rac balance factor _FLASHBACK_LOG_ : Flashback log size _FLASHBACK_MARK : Enable flashback database marker cache _FLASHBACK_MARK : Size of flashback database marker cache _FLASHBACK_MAX_ : Maximum flashback log size in bytes (OS limit) _FLASHBACK_MAX_ : Maximum number of flashback logs per flashback thread _FLASHBACK_MAX_ : Maximum time span between standby recovery sync for _FLASHBACK_N_LO : Desired number of flashback logs per flashback thread _FLASHBACK_PREP : Prepare Flashback logs in the background _FLASHBACK_SIZE : Size new flashback logs based on average redo log size _FLASHBACK_STAN : Flashback standby barrier interval in seconds _FLASHBACK_VALI : validate flashback pointers in controlfile for 11.2.0.2 _FLASHBACK_VERB : Print verbose information about flashback database _FLASHBACK_WRIT : Flashback writer loop limit before it returns _FLUSH_ILM_STAT : flush ilm stats _FLUSH_PLAN_IN_ : Plan is being flushed from an AWR flush SQL _FLUSH_REDO_TO_ : Flush redo to standby test event parameter _FLUSH_UNDO_AFT : if TRUE,flush undo buffers after TX recovery _FORCE_ARCH_COM : Archive Compress all newly created compressed tables _FORCE_DATEFOLD : force use of trunc for datefolding rewrite _FORCE_HASH_JOI : force hash join to spill to disk _FORCE_HSC_COMP : compress all newly created tables _FORCE_LOGGING_ : force logging during upgrade mode _FORCE_OLTP_COM : OLTP Compress all newly created compressed tables _FORCE_OLTP_UPD : OLTP Compressed row optimization on update _FORCE_RCV_INFO : Force recovery info ping to stdby _FORCE_REWRITE_ : control new query rewrite features _FORCE_SLAVE_MA : Force slave mapping for intra partition loads _FORCE_SYS_COMP : Sys compress _FORCE_TEMPTABL : executes concatenation of rollups using temp tables _FORCE_TMP_SEGM : Force tmp segment loads _FORWARDED_2PC_ : auto-tune threshold for two-phase commit rate across _FOURTEENTH_SPA : fourteenth spare parameter – integer _FOURTH_SPARE_P : fourth spare parameter – integer _FRAME_CACHE_TI : number of seconds a cached frame page stay in cache. _FULL_DIAG_ON_R : rim nodes have full DIA* function _FULL_PWISE_JOI : enable full partition-wise join when TRUE _FUSION_SECURIT : Fusion Security _GBY_HASH_AGGRE : enable group-by and aggregation using hash scheme _GBY_ONEKEY_ENA : enable use of one comparison of all group by keys _GCR_CPU_MIN_FR : minimum amount of free CPU to flag an anomaly _GCR_ENABLE_HIG : if TRUE,GCR may kill foregrounds under high load H_CPU_RM H_CPU_RT H_MEMORY_KILL load _GCR_ENABLE_NEW : if FALSE,revert to old drm load metric _GCR_ENABLE_STA : if FALSE,revert to old cpu load metric _GCR_HIGH_CPU_T : minimum amount of CPU process must consume to be kill _GCR_HIGH_MEMOR : minimum amount of Memory process must consume to be _GCR_MAX_RT_PRO : maximum number of RT DLM processes allowed by GCR _GCR_MEM_MIN_FR : minimum amount of free memory to flag an anomaly _GCR_USE_CSS : if FALSE,GCR wont register with CSS nor use any CSS _GCS_DISABLE_RE : disable remote client/shadow handles _GCS_DISABLE_SK : if TRUE,disable skip close optimization in remastering _GCS_DISABLE_SW : if TRUE,disable switching to local role with a writer _GCS_FAST_RECON : if TRUE,enable fast reconfiguration for gcs locks _GCS_LATCHES : number of gcs resource hash latches to be allocated per _GCS_MIN_SLAVES : if non zero,it enables the minimum number of gcs _GCS_PKEY_HISTO : number of pkey remastering history _GCS_PROCESS_IN : if TRUE,process gcs requests during instance recovery _GCS_RESERVED_R : allocate the number of reserved resources in _GCS_RESERVED_S : allocate the number of reserved shadows in _GCS_RESOURCES : number of gcs resources to be allocated _GCS_RES_PER_BU : number of gcs resource per hash bucket _GCS_SHADOW_LOC : number of pcm shadow locks to be allocated _GCS_TESTING : GCS testing parameter _GC_AFFINITY_LO : if TRUE,enable object affinity CKS _GC_AFFINITY_RA : dynamic object affinity ratio _GC_ASYNC_SEND : send blocks asynchronously _GC_CHECK_BSCN : if TRUE,check for stale blocks _GC_CPU_TIME : if TRUE,record the gc cpu time _GC_DEFER_PING_ : if TRUE,restrict deferred ping to index blocks only _GC_DEFER_TIME : how long to defer pings for hot buffers in milliseconds _GC_DELTA_PUSH_ : max delta level for delta push _GC_DELTA_PUSH_ : objects which use delta push _GC_DISABLE_S_L : if TRUE,disable S lock BRR ping check for lost write _GC_DOWN_CONVER : if TRUE,down-convert lock after recovery _GC_ELEMENT_PER : global cache element percent _GC_ESCALATE_BI : if TRUE,escalates create a bid _GC_FG_MERGE : if TRUE,merge pi buffers in the foreground _GC_FLUSH_DURIN : if TRUE,flush during affinity _GC_FUSION_COMP : compress fusion blocks if there is free space _GC_GLOBAL_CHEC : if TRUE,enable global checkpoint scn _GC_GLOBAL_CPU : global cpu checks _GC_GLOBAL_LRU_ : global lru touch time in seconds _GC_INTEGRITY_C : set the integrity check level _GC_KEEP_RECOVE : if TRUE,make single instance crash recovery buffers _GC_LATCHES : number of latches per LMS process _GC_MAXIMUM_BID : maximum number of bids which can be prepared _GC_MAX_DOWNCVT : maximum downconverts to process at one time _GC_OBJECT_QUEU : maximum length for an object queue _GC_OVERRIDE_FO : if TRUE,try to override force-cr requests _GC_PERSISTENT_ : if TRUE,enable persistent read-mostly locking _GC_POLICY_MINI : dynamic object policy minimum activity per minute _GC_POLICY_TIME : how often to make object policy decisions in minutes _GC_READ_MOSTLY : if TRUE,enable read-mostly locking _GC_SANITY_CHEC : if TRUE,sanity check CR buffers _GC_SAVE_CLEANO : if TRUE,save cleanout to apply later _GC_SPLIT_FLUSH : if TRUE,flush index split redo before rejecting bast _GC_TRANSFER_RA : dynamic object read-mostly transfer ratio _GC_UNDO_AFFINI : if TRUE,enable undo affinity _GC_UNDO_BLOCK_ : if TRUE,enable undo block disk reads _GC_VECTOR_READ : if TRUE,vector read current buffers _GES_DD_DEBUG : if 1 or higher enables GES deadlock detection debug _GES_DEFAULT_LM : default lmds for enqueue hashing _GES_DESIGNATED : designated master for GES and GCS resources _GES_DIAGNOSTIC : if TRUE enables GES diagnostics _GES_DIAGNOSTIC : systemstate level on global enqueue diagnostics blocked _GES_DIRECT_FRE : if TRUE,free each resource directly to the freelist _GES_DIRECT_FRE : string of resource types(s) to directly free to the _GES_DUMP_OPEN_ : if TRUE,dump open locks for the LCK process during _GES_FGGL : DLM fg grant lock on/off _GES_FREEABLE_R : time interval for freeing freeable dynamic resource _GES_GATHER_RES : if TRUE,gather resource reuse statistics _GES_HASH_GROUP : enqueue hash table groups _GES_HEALTH_CHE : if greater than 0 enables GES system health check _GES_LMD_MAPPIN : enqueue to lmd mapping _GES_NRES_DIVID : how to divide number of enqueue resources among hash _GES_NUM_BLOCKE : number of blockers to be killed for hang resolution _GES_RESOURCE_M : enable different level of ges res memory optimization _GES_SERVER_PRO : number of background global enqueue server processes _GLOBALINDEX_PN : enables filter for global index with partition extended _GLOBAL_HANG_AN : the interval at which global hang analysis is run _GRANT_SECURE_R : Disallow granting of SR to NSR _GROUPBY_NOPUSH : groupby nopushdown cut ratio _GROUPBY_ORDERB : groupby/orderby don’t combine threshold _GSM : GSM descriptions _GSM_CPU_THRESH : CPU busy threshold _GSM_MAX_INSTAN : maximum number of instances per database in gsm cloud _GSM_MAX_NUM_RE : maximum number of regions in gsm cloud _GSM_REGION_LIS : List of GSM Regions _GSM_SRLAT_THRE : Single block read latency threshold _GSM_THRESH_RES : threshold resource percentage _GSM_THRESH_ZON : threshold zone _GS_ANTI_SEMI_J : enable anti/semi join for the GS query _GWM_SPARE1 : gsm spare 1 _HANG_BASE_FILE : Number of trace files for the normal base trace file _HANG_BASE_FILE : File space limit for current normal base trace file _HANG_BOOL_SPAR : Hang Management 1 _HANG_CROSS_BOU : Hang Management Cross Boundary detection _HANG_DELAY_RES : Hang Management delays hang resolution for library _HANG_DETECTION : Hang Management detection _HANG_DETECTION : Hang Management detection interval in seconds _HANG_HANG_ANAL : if TRUE hang manager outputs hang analysis hang chains _HANG_HILOAD_PR : Hang Management high load or promoted ignored hang _HANG_HIPRIOR_S : Hang Management high priority session attribute list _HANG_IGNORED_H : Time in seconds ignored hangs must persist after _HANG_IGNORED_H : Hang Management ignored hang count _HANG_INT_SPARE : Hang Management 2 _HANG_LOG_VERIF : Hang Management log verified hangs to alert log _HANG_LONG_WAIT : Long session wait time threshold in seconds _HANG_LWS_FILE_ : Number of trace files for long waiting sessions _HANG_LWS_FILE_ : File space limit for current long waiting session trace _HANG_MONITOR_A : Time in seconds ignored hangs must persist after _HANG_MSG_CHECK : enable hang graph message checksum _HANG_RESOLUTIO : Hang Management hang resolution allow archiving issue _HANG_RESOLUTIO : Hang Management hang resolution confidence promotion _HANG_RESOLUTIO : Hang Management hang resolution global hang confidence _HANG_RESOLUTIO : Hang Management hang resolution policy _HANG_RESOLUTIO : Hang Management hang resolution promote process _HANG_RESOLUTIO : Hang Management hang resolution scope _HANG_SIGNATURE : Hang Signature List matched output frequency _HANG_STATISTIC : Hang Management statistics collection interval in _HANG_STATISTIC : Hang Management statistics collection moving average _HANG_STATISTIC : Hang Management statistics high IO percentage threshold _HANG_TERMINATE : Hang Management terminates sessions allowing replay _HANG_VERIFICAT : Hang Management verification interval in seconds _HARD_PROTECTIO : if TRUE enable H.A.R.D specific format changes _HASHOPS_PREFET : maximum no of rows whose relevant memory locations are _HASH_JOIN_ENAB : enable/disable hash join _HASH_MULTIBLOC : number of blocks hash join will read/write at once _HB_REDO_MSG_IN : BOC HB redo message interval in ms _HEATMAP_FORMAT : heatmap related – to be used by oracle dev only _HEATMAP_MIN_MA : Internal testing only _HEUR_DEADLOCK_ : the heuristic wait time per node for deadlock _HIGHRES_DRIFT_ : allowed highres timer drift for VKTM _HIGHTHRESHOLD_ : high threshold undo_retention in seconds _HIGH_PRIORITY_ : High Priority Process Name Mask _HIGH_SERVER_TH : high server thresholds _HJ_BIT_FILTER_ : hash-join bit filtering threshold (0 always enabled) _HM_ANALYSIS_OR : the oradebug system state level for hang manager hang _HM_XM_ENABLED : If TRUE,DIA0 allows message exchanges across DB/ASM _HWM_SYNC_THRES : HWM synchronization threshold in percentage _IDLE_SESSION_K : enables or disables resource manager session idle limit _IDL_CONVENTION : enable conventional index maintenance for insert direct _IDXRB_ROWINCR : proportionality constant for dop vs. rows in index _IGNORE_DESC_IN : ignore DESC in indexes,sort those columns ascending _IGNORE_EDITION : ignore schema’s edition-enabled status during EV _IGNORE_FG_DEPS : ignore fine-grain dependencies during invalidation _ILMSET_STAT_LI : ILM set statistics limit – Internal testing only _ILMSTAT_MEMLIM : Percentage of shared pool for use by ILM Statistics _ILM_FILTER_TIM : Upper filter time for ILM block compression _ILM_FILTER_TIM : Lower filter time for ILM block compression _ILM_MEM_LIMIT : percentage of the max shared pool heat-map can use – _ILM_POLICY_NAM : User specified ILM policy name _IMAGE_REDO_GEN : Image redo generation delay in centi-seconds (direct _IMMEDIATE_COMM : if TRUE,propagate commit SCN immediately _IMPROVED_OUTER : improved outer-join cardinality calculation _IMPROVED_ROW_L : enable the improvements for computing the average row _IMR_ACTIVE : Activate Instance Membership Recovery feature _IMR_CONTROLFIL : IMR controlfile access wait time in seconds _IMR_DEVICE_TYP : Type of device to be used by IMR _IMR_DISKVOTE_I : IMR disk voting implementation method _IMR_DISK_VOTIN : Maximum wait for IMR disk voting (seconds) _IMR_EVICTED_ME : IMR issue evicted member kill after a wait _IMR_EVICTED_ME : IMR evicted member kill wait time in seconds _IMR_EXTRA_RECO : Extra reconfiguration wait in seconds _IMR_HIGHLOAD_T : IMR system highload threshold _IMR_MAX_RECONF : Maximum Reconfiguration delay (seconds) _IMR_RR_HOLDER_ : IMR max time instance is allowed to hold RR lock in _IMR_SPLITBRAIN : Maximum wait for split-brain resolution (seconds) _IMR_SYSTEMLOAD : Perform the system load check during IMR _IMU_POOLS : in memory undo pools _INDEX_JOIN_ENA : enable the use of index joins _INDEX_LOAD_BUF : index load buf oltp sacrifice pct _INDEX_LOAD_BUF : index load buf and comp oltp under-estimation pct _INDEX_MAX_INC_ : max itl expand percentage soft limit during index _INDEX_PARTITIO : Enables large extent allocation for partitioned indices _INDEX_PREFETCH : index prefetching factor _INDEX_SCAN_CHE : check and skip corrupt blocks during index scans _INDEX_SCAN_CHE : check stopkey during index range scans _INIT_GRANULE_I : number of granules to process for deferred cache _INIT_SQL_FILE : File containing SQL statements to execute upon database _INJECT_STARTUP : inject fault in the startup code _INLINE_SQL_IN_ : inline SQL in PL/SQL _INPLACE_UPDATE : inplace update retry for ora1551 _INQUIRY_RETRY_ : if greater than 0 enables inquiry retry after specified _INSERT_ENABLE_ : during parallel inserts high water marks are brokered _INST_LOCKING_P : period an instance can retain a newly acquired level1 _INTERCONNECT_C : if TRUE,checksum interconnect blocks _INTRAPART_PDML : Enable intra-partition updates/deletes _INTRAPART_PDML : Enable intra-partition updates/deletes with random _IN_MEMORY_TBS_ : FALSE – disable fast path for alter tablespace read _IN_MEMORY_UNDO : Make in memory undo for top level transactions _IOCALIBRATE_MA : iocalibrate max I/Os per process _IOQ_FANIN_MULT : IOQ miss count before a miss exception _IORM_TOUT : IORM scheduler timeout value in msec _IOSLAVE_BATCH_ : Per attempt IOs picked _IOSLAVE_ISSUE_ : IOs issued before completion check _IO_INTERNAL_TE : I/O internal testing parameter _IO_OSD_PARAM : OSD specific parameter _IO_RESOURCE_MA : io resource manager always on _IO_SHARED_POOL : Size of I/O buffer pool from SGA _IO_SLAVES_DISA : Do not use I/O slaves _IO_STATISTICS : if TRUE,ksfd I/O statistics are collected _IPC_TEST_FAILO : Test transparent cluster network failover _IPC_TEST_MULT_ : simulate multiple cluster networks _IPDDB_ENABLE : Enable IPD/DB data collection _K2Q_LATCHES : number of k2q latches _KA_COMPATIBILI : kernel accelerator compatibility operation requirement _KA_DOORBELL : kernel accelerator doorbell mode _KA_MODE : kernel accelerator mode _KA_PBATCH_MESS : kernel accelerator perform pbatch messages _KCFIS_AUTOMEM_ : Set auto memory management control for kcfis memory _KCFIS_BLOCK_DU : Smart IO block dump level _KCFIS_CACHING_ : enable kcfis intra-scan session caching _KCFIS_CELLOFLS : Enable offload server usage for passthru operations _KCFIS_CELLOFLS : Enable offload server usage for offload operations _KCFIS_CELL_PAS : Allow dataonly passthru for smart scan _KCFIS_CELL_PAS : Do not perform smart IO filtering on the cell _KCFIS_CELL_PAS : Enable automatic passthru mode when cell CPU util is _KCFIS_CONTROL1 : Kcfis control1 _KCFIS_DUMP_COR : Dump any corrupt blocks found during smart IO _KCFIS_FAST_RES : Enable smart scan optimization for fast response (first _KCFIS_FAST_RES : Fast response – The size of the first IO in logical _KCFIS_FAST_RES : Fast response – (next IO size = current IO size * this _KCFIS_FAST_RES : Fast response – the number of IOs after which smartIO _KCFIS_FAULT_CO : Fault Injection Control _KCFIS_IOREQS_T : Enable Smart IO requests throttling _KCFIS_IO_PREFE : Smart IO prefetch size for a cell _KCFIS_KEPT_IN_ : Enable usage of cellsrv flash cache for kept objects _KCFIS_LARGE_PA : enable large payload to be passed to cellsrv _KCFIS_MAX_CACH : Sets the maximum number of kcfis sessions cached _KCFIS_MAX_OUT_ : Sets the maximum number of outstanding translations in _KCFIS_NONKEPT_ : Enable use of cellsrv flash cache for non-kept objects _KCFIS_OSS_IO_S : KCFIS OSS I/O size _KCFIS_QM_PRIOR : Prioritize Quaranitine Manager system plan _KCFIS_QM_USER_ : Quaranitine Manager user plan name _KCFIS_RDBMS_BL : Use block IO instead of smart IO in the smart IO module _KCFIS_READ_BUF : KCFIS Read Buffer (per session) memory limit in bytes _KCFIS_SPAWN_DE : Decides whether to spawn the debugger at kcfis _KCFIS_STATS_LE : sets kcfis stats level _KCFIS_STORAGEI : Debug mode for storage index on the cell _KCFIS_STORAGEI : Don’t use storage index optimization on the storage _KCFIS_TEST_CON : kcfis tst control1 _KCFIS_TRACE_BU : KCFIS tracing bucket size in bytes _KCL_COMMIT : if TRUE,call kjbcommit _KCL_DEBUG : if TRUE,record le history _KDBL_ENABLE_PO : allocate dbas after populating data buffers _KDIC_SEGARR_SZ : size threshold for segmented arrays for _KDIS_REJECT_LE : b+tree level to enable rejection limit _KDIS_REJECT_LI : #block rejections in space reclamation before segment _KDIS_REJECT_OP : enable rejection heuristic for branch splits _KDIZOLTP_UNCOM : kdizoltp uncomp sentinal frequency _KDI_AVOID_BLOC : avoid index block checking on sensitive opcodes _KDLF_READ_FLAG : kdlf read flag _KDLI_BUFFER_IN : use buffer injection for CACHE [NO]LOGGING lobs _KDLI_CACHEABLE : minimum lob length for inode cacheability _KDLI_CACHE_INO : cache inode state across calls _KDLI_CACHE_REA : minimum lob size for cache->nocache read (0 disables _KDLI_CACHE_SIZ : maximum #entries in inode cache _KDLI_CACHE_VER : verify cached inode via deserialization _KDLI_CACHE_WRI : minimum lob size for cache->nocache write (0 disables _KDLI_CHECKPOIN : do not invalidate cache buffers after write _KDLI_DBC : override db_block_checking setting for securefiles _KDLI_DESCN_ADJ : coalesce extents with deallocation scn adjustment _KDLI_FLUSH_INJ : flush injected buffers of CACHE NOLOGGING lobs before _KDLI_FORCE_CR : force CR when reading data blocks of direct-write lobs _KDLI_FORCE_STO : force storage settings for all lobs _KDLI_FULL_READ : maximum lob size for full readahead _KDLI_INJECT_AS : inject asserts into the inode _KDLI_INJECT_BA : buffer injection batch size [1,KCBNEWMAX] _KDLI_INJECT_CR : inject crashes into the inode _KDLI_INLINE_XF : allow inline transformed lobs _KDLI_INODE_PRE : inline inode evolution preference (data,headless,lhb) _KDLI_INPLACE_O : maximum inplace overwrite size (> chunksize) _KDLI_ITREE_ENT : #entries in lhb/itree blocks (for testing only) _KDLI_MEMORY_PR : trace accesses to inode memory outside kdli API _KDLI_MTS_SO : use state objects in shared server for asyncIO _KDLI_ONEBLK : allocate chunks as single blocks _KDLI_PREALLOCA : percentage preallocation [0 .. inf) for lob growth _KDLI_RALC_LENG : lob length threshold to trigger rounded allocations _KDLI_RALC_ROUN : rounding granularity for rounded allocations _KDLI_RCI_LOBMA : #entries in RCI lobmap before migration to lhb _KDLI_READAHEAD : shared/cached IO readahead limit _KDLI_READAHEAD : shared/cached IO readahead strategy _KDLI_RECENT_SC : use recent (not dependent) scns for block _KDLI_RESHAPE : reshape an inode to inline or headless on length _KDLI_SAFE_CALL : invoke inode read/write callbacks safely _KDLI_SIO_ASYNC : asynchronous shared IO _KDLI_SIO_BPS : maximum blocks per IO slot _KDLI_SIO_FGIO : reap asynchronous IO in the foreground _KDLI_SIO_FLUSH : enable shared IO pool operations _KDLI_SIO_MIN_W : shared IO pool write threshold _KDLI_SIO_NBUFS : maximum #IO buffers to allocate per session _KDLI_SIO_STRAT : shared IO strategy: block vs. extent _KDLI_SIO_WRITE : percentage of buffer used for direct writes _KDLI_SMALL_CAC : size limit of small inode cache _KDLI_SORT_DBAS : sort dbas during chunkification _KDLI_SQUEEZE : compact lobmap extents with contiguous dbas _KDLU_MAX_BUCKE : UTS kdlu bucket size _KDLU_MAX_BUCKE : UTS kdlu bucket size for mts _KDLU_TRACE_LAY : UTS kdlu per-layer trace level _KDLU_TRACE_SYS : UTS system dump _KDLWP_FLUSH_TH : WGC flush threshold in bytes _KDLW_ENABLE_KS : enable ksi locking for lobs _KDLW_ENABLE_WR : enable lob write gathering for sql txns _KDLXP_CMP_SUBU : size of compression sub-unit in bytes _KDLXP_DEDUP_FL : deduplication flush threshold in bytes _KDLXP_DEDUP_HA : secure hash algorithm for deduplication – only on _KDLXP_DEDUP_IN : deduplication pct size increase by which inlining _KDLXP_DEDUP_PR : deduplication prefix hash threshold in bytes _KDLXP_DEDUP_WA : deduplication length to allow write-append _KDLXP_LOBCMPAD : enable adaptive compression – only on SecureFiles _KDLXP_LOBCMPLE : Default securefile compression _KDLXP_LOBCMPRC : Default securefile compression map version _KDLXP_LOBCOMPR : enable lob compression – only on SecureFiles _KDLXP_LOBDEDUP : enable lob deduplication – only on SecureFiles _KDLXP_LOBDEDUP : enable deduplicate validate – only on SecureFiles _KDLXP_LOBENCRY : enable lob encryption – only on SecureFiles _KDLXP_MINCMP : minimum comp ratio in pct – only on SecureFiles _KDLXP_MINXFM_S : minimum transformation size in bytes _KDLXP_SPARE1 : deduplication spare 1 _KDT_BUFFERING : control kdt buffering for conventional inserts _KDZ_HCC_FLAGS : Miscellaneous HCC flags _KDZ_PRED_NROWS : Number of rows to predicate at a time in kdzt _KECAP_CACHE_SI : Workload Replay INTERNAL parameter used to set memory _KEEP_REMOTE_CO : remote column size does not get modified _KERNEL_MESSAGE : kernel message network driver _KES_PARSE_MODE : SQL Tune/SPA KES Layer Parse Model control parameter _KFFMAP_HASH_SI : size of kffmap_hash table _KFFMLK_HASH_SI : size of kffmlk_hash table _KFFMOP_CHUNKS : number of chunks of kffmop’s _KFM_DISABLE_SE : disable set fence calls and revert to default (process _KGHDSIDX_COUNT : max kghdsidx count _KGL_BUCKET_COU : Library cache hash table bucket count _KGL_CAP_HD_ALO : capture stacks for library cache handle allocation _KGL_CLUSTER_LO : Library cache support for cluster lock _KGL_CLUSTER_LO : Library cache support for cluster lock read mostly _KGL_CLUSTER_PI : Library cache support for cluster pins _KGL_DEBUG : Library cache debugging _KGL_HASH_COLLI : Library cache name hash collision possible _KGL_HEAP_SIZE : extent size for library cache heap 0 _KGL_KQR_CAP_SO : capture stacks for library and row cache state objects _KGL_LARGE_HEAP : maximum heap size before KGL writes warnings to the _KGL_LATCH_COUN : number of library cache latches _KGL_MESSAGE_LO : RAC message lock count _KGL_MIN_CACHED : Minimum cached SO count. If > 1 can help find SO _KGL_TIME_TO_WA : time to wait for locks and pins before timing out _KGSB_THRESHOLD : threshold size for base allocator _KGX_LATCHES : # of mutex latches if CAS is not supported. _KILL_DIAGNOSTI : timeout delay in seconds before killing enqueue blocker _KILL_ENQUEUE_B : if greater than 0 enables killing enqueue blocker _KILL_JAVA_THRE : Kill Java threads and do sessionspace migration at end _KILL_SESSION_D : Process dump on kill session immediate _KJAC_FORCE_OUT : if TRUE,enable to run force outcome on the current _KJDD_CALL_STAC : Enables printing of short call stack with the WFG _KJDD_WFG_DUMP_ : To control the way Wait-For_Graph is dumped _KJLTMAXGT : record latch requests that takes longer than this many _KJLTMAXHT : record latch reqeust that are held longer than this _KJLTON : track DLM latch usage on/off _KOKLI_CACHE_SI : Size limit of ADT Table Lookup Cache _KOKLN_CURRENT_ : Make all LOB reads for this session ‘current’ reads _KOLFUSESLF : allow kolf to use slffopen _KQDSN_MIN_INST : minimum bits used for instance value in sequence _KQDSN_PARTITIO : ratio of instance to session bits in sequence partition _KQL_SUBHEAP_TR : tracing level for library cache subheap level pins _KQR_OPTIMISTIC : optimistic reading of row cache objects _KSB_RESTART_CL : process uptime for restarts _KSB_RESTART_PO : process restart policy times in seconds _KSDXDOCMD_DEFA : default timeout for internal oradebug commands _KSDXDOCMD_ENAB : if TRUE ksdxdocmd* invocations are enabled _KSDXW_CINI_FLG : ksdxw context initialization flag _KSDX_CHARSET_R : ratio between the system and oradebug character set _KSD_TEST_PARAM : KSD test parmeter _KSE_PC_TABLE_S : kse pc table cache size _KSE_SIGNATURE_ : number of entries in the kse stack signature cache _KSE_SIGNATURE_ : number of stack frames to cache per kse signature _KSE_SNAP_RING_ : should error snap ring entries show a short stack trace _KSE_SNAP_RING_ : ring buffer to debug internal error 17090 _KSE_TRACE_INT_ : enables soft assert of KGECLEAERERROR is cleares an _KSFD_VERIFY_WR : verify asynchronous writes issued through ksfd _KSIPC_LIBIPC_P : over-ride default location of libipc _KSIPC_MODE : ksipc mode _KSIPC_SPARE_PA : ksipc spare param 2 _KSIPC_WAIT_FLA : tune ksipcwait _KSI_CLIENTLOCK : if TRUE,DLM-clients can provide the lock memory _KSI_TRACE : KSI trace string of lock type(s) _KSI_TRACE_BUCK : size of the KSI trace bucket _KSMB_DEBUG : ksmb debug flags _KSMG_GRANULE_L : granule locking status _KSMG_GRANULE_S : granule size in bytes _KSMG_LOCK_CHEC : timeout action interval in minutes _KSMG_LOCK_REAC : repeat count for acquisition of locks _KSMLSAF : KSM log alloc and free _KSM_PRE_SGA_IN : seconds to delay instance startup at sga initialization _KSPOL_TAC_TIME : timeouts for TAC registerd by kspol _KSR_UNIT_TEST_ : number of ksr unit test processes _KSS_CALLSTACK_ : state object callstack trace type _KSS_QUIET : if TRUE access violations during kss dumps are not _KSUITM_ADDON_T : command to execute when dead processes don’t go away _KSUITM_DONT_KI : delay inst. termination to allow processes to dump _KSU_DIAG_KILL_ : number of seconds ksuitm waits before killing diag _KSVPPKTMODE : ksv internal pkt test _KSV_MAX_SPAWN_ : bg slave spawn failure limit _KSV_POOL_HANG_ : bg slave pool terminate timeout _KSV_POOL_WAIT_ : bg slave pool wait limit _KSV_SLAVE_EXIT : slave exit timeout _KSV_SPAWN_CONT : control all spawning of background slaves _KSV_STATIC_FLA : ksv static flags 1 – override default behavior _KSXP_COMPAT_FL : ksxp compat flags _KSXP_CONTROL_F : modify ksxp behavior _KSXP_DIAGMODE : set to OFF to disable automatic slowsend diagnostics _KSXP_DISABLE_D : disable dynamic loadin of lib skgxp _KSXP_DISABLE_I : disable ipc statistics _KSXP_DISABLE_R : disable possibility of starting rolling migration _KSXP_DUMP_TIME : set timeout for kjzddmp request _KSXP_DYNAMIC_S : dynamic skgxp parameters _KSXP_IF_CONFIG : ksxp if config flags _KSXP_LWIPC_ENA : enable lwipc for KSXP _KSXP_MAX_STATS : max. arrays for ipc statistics _KSXP_PING_ENAB : disable dynamic loadin of lib skgxp _KSXP_PING_POLL : max. arrays for ipc statistics _KSXP_REAPING : tune ksxp layer reaping limit _KSXP_SEND_TIME : set timeout for sends queued with the inter-instance _KSXP_SKGXPG_LA : last defined skgxpg parameter – ksxp _KSXP_SKGXP_ANT : SKGXP ANT options _KSXP_SKGXP_COM : over-ride default location of lib skgxp compat _KSXP_SKGXP_CTX : IPC debug options flags (RAC) _KSXP_SKGXP_CTX : IPC debug options flags mask (RAC) _KSXP_SKGXP_DYN : IPC protocol override (RAC) _KSXP_SKGXP_INE : limit SKGXP networks _KSXP_SKGXP_LIB : over-ride default location of lib skgxp _KSXP_SKGXP_RGN : region socket limits (0xFFFFNNXX): F=flags,N=min, _KSXP_SKGXP_SPA : ipc ksxp spare parameter 1 _KSXP_SKGXP_SPA : ipc ksxp spare parameter 2 _KSXP_SKGXP_SPA : ipc ksxp spare parameter 3 _KSXP_SKGXP_SPA : ipc ksxp spare parameter 4 _KSXP_SKGXP_SPA : ipc ksxp spare parameter 5 _KSXP_STATS_MEM : limit ipc statistics memory. this parameter is a _KSXP_TESTING : KSXP test parameter _KSXP_WAIT_FLAG : tune ksxpwait _KTB_DEBUG_FLAG : ktb-layer debug flags _KTC_DEBUG : for ktc debug _KTSLJ_SEGEXT_R : segment pre-extension retry _KTSLJ_SEGEXT_W : segment pre-extension warning threshold in percentage _KTSLJ_SEGEXT_W : segment pre-extension warning threshold in MB _KTSPSRCH_MAXSC : maximum segments supported by space search cache _KTSPSRCH_SCCHK : cleanout check time of space search cache _KTU_LATCHES : number of KTU latches _KXDBIO_DISABLE : KXDBIO Disable offload for the set opcodes. Value is a _KXDBIO_ENABLE_ : KXDBIO Enable Dumb storage simulation for the set _KXDBIO_HCA_LOA : HCA loadavg threshold at which writes need to get _KXDBIO_UT_CTL : kxdbio unit test controls _LAST_ALLOCATIO : period over which an instance can retain an active _LATCH_CLASSES : latch classes override _LATCH_WAIT_LIS : Time to sleep on latch wait list until getting priority _LDR_IO_SIZE : size of write IOs used during a load operation _LDR_PGA_LIM : pga limit,beyond which new partition loads are delayed _LEFT_NESTED_LO : enable random distribution method for left of _LGWR_DELAY_WRI : LGWR write delay for debugging _LGWR_IO_OUTLIE : LGWR I/O outlier frequency _LGWR_IO_SLAVES : LGWR I/O slaves _LGWR_NS_NL_MAX : Variable to simulate network latency or buffer _LGWR_NS_NL_MIN : Variable to simulate network latency or buffer _LGWR_NS_SIM_ER : Variable to simulate errors lgwrns _LGWR_POSTS_FOR : LGWR posts commit waiters for pending broadcasts _LGWR_TA_SIM_ER : Variable to simulate errors lgwr true async _LIBRARY_CACHE_ : whether KGL advice should be turned on _LIGHTWEIGHT_HD : Lightweight headers for redo _LIKE_WITH_BIND : treat LIKE predicate with bind as an equality predicate _LIMIT_ITLS : limit the number of ITLs in OLTP Compressed Tables _LMN_COMPRESSIO : suppl logging for compression enabled _LM_ACTIVATE_LM : threshold value to activate an additional lms _LM_ASM_ENQ_HAS : if TRUE makes ASM use enqueue master hashing for fusion _LM_BATCH_COMPR : GES threshold to start compression on batch messages _LM_BETTER_DDVI : GES better deadlock victim _LM_BIG_CLUSTER : enable certain big cluster optimizations in drm _LM_BROADCAST_R : Enable broadcast of highest held mode of resource. _LM_BROADCAST_R : Trace string of resource type(s) _LM_CACHE_ALLOC : ratio of cached over allocated resources _LM_CACHE_LVL0_ : how often to cleanup level 0 cache res (in sec) _LM_CACHE_RES_C : percentage of cached resources should be cleanup _LM_CACHE_RES_C : max number of batches of cached resources to free per _LM_CACHE_RES_O : ges resource cache options _LM_CACHE_RES_S : multiple of iniital res cache below which cleanup is _LM_CACHE_RES_T : cache resource: string of lock types(s) _LM_CHECKSUM_BA : GES checksum batch messages _LM_COMM_CHANNE : GES communication channel type _LM_COMM_MSGQ_B : busy wait time in microsecond for msgq _LM_COMM_REAP_C : message reap count for receive _LM_COMM_TKTS_A : Ticket allocation addition factor _LM_COMM_TKTS_C : Weighted average calculation interval length (second) _LM_COMM_TKTS_M : Max number of periods used in weighted avearage _LM_COMM_TKTS_M : Time to wait before allowing an allocation decrease _LM_COMM_TKTS_M : Time to wait before allowing an allocation increase _LM_COMM_TKTS_M : Ticket allocation multiplication factor _LM_COMM_TKTS_N : Null request frequency threshold (percentage) _LM_COMPRESSION : GES compression scheme _LM_CONTIGUOUS_ : number of contiguous blocks that will hash to the same _LM_DD_IGNORE_N : if TRUE nodeadlockwait/nodeadlockblock options are _LM_DD_INTERVAL : dd time interval in seconds _LM_DD_SCAN_INT : dd scan interval in seconds _LM_DD_SEARCH_C : number of dd search per token get _LM_DEFERRED_MS : deferred message timeout _LM_DRMOPT12 : enable drm scan optimizations in 12 _LM_DRM_BATCH_T : time in seconds to wait to batch drm requests _LM_DRM_DISABLE : disable drm in different level _LM_DRM_LOWLOAD : drm low load threshold percentage _LM_DRM_MAX_REQ : dynamic remastering maximum affinity requests processed _LM_DRM_MIN_INT : minimum interval in secs between two consecutive drms _LM_DRM_OBJECT_ : enable/disable object scan to force full table scan _LM_DRM_WINDOW : dynamic remastering bucket window size _LM_DYNAMIC_LMS : dynamic lms invocation _LM_ENABLE_AFF_ : enables affinity benefit computations if TRUE _LM_ENQUEUE_BLO : enqueue blocker dump timeout _LM_ENQUEUE_BLO : enqueue blocker dump timeout count _LM_ENQUEUE_BLO : enqueue blocker kill timeout _LM_ENQUEUE_FRE : Number of enqueue freelist _LM_ENQUEUE_TIM : enqueue suggested min timeout in seconds _LM_ENQ_LOCK_FR : Number of ges enqueue element freelist _LM_ENQ_RCFG : if TRUE enables enqueue reconfiguration _LM_FILE_READ_M : mapping between read-mostly file id and master instance _LM_FREEZE_KILL : timeout for killing unfrozen processes in rcfg/drm _LM_FREE_QUEUE_ : GES free queue threshold _LM_GLOBAL_POST : if TRUE deliver global posts to remote nodes _LM_HASHTABLE_B : High element threshold in hash table bucket _LM_HASHTABLE_B : Low element threshold in hash table bucket _LM_HASHTABLE_B : Threshold for hash table resizing _LM_HB_ACCEPTAB : list of acceptable hang conditions in heartbeat check _LM_HB_CALLSTAC : hb diagnostic call stack collection time in seconds _LM_HB_DISABLE_ : list of process names to be disabled in heartbeat check _LM_HB_ENABLE_A : to enable the wait analysis with acceptable condition _LM_HB_EXPONENT : heartbeat exponential hang time multiplier _LM_HB_MAXIMUM_ : maximum heartbeat hang report count _LM_HIGH_LOAD_S : high watermark system load percentage _LM_HIGH_LOAD_T : high load threshold parameter _LM_IDLE_CONNEC : GES idle connection check _LM_IDLE_CONNEC : GES idle connection check interval time _LM_IDLE_CONNEC : GES idle connection instance check callout _LM_IDLE_CONNEC : GES idle connection kill _LM_IDLE_CONNEC : GES idle connection max skip kill request _LM_IDLE_CONNEC : GES maximum idle connection kill request ignore count _LM_IDLE_CONNEC : GES idle connection health quorum threshold _LM_KILL_FG_ON_ : GES kill fg on IPC timeout _LM_LHUPD_INTER : load and health update interval _LM_LMD_WAITTIM : default wait time for lmd in centiseconds _LM_LMON_NOWAIT : if TRUE makes lmon get nowait latches with timeout loop _LM_LMS : number of background gcs server processes to start _LM_LMS_PRIORIT : frequency of LMS priority decisions in milliseconds _LM_LMS_PRIORIT : enable lms priority modification _LM_LMS_RT_THRE : maximum number of real time lms processes on machine _LM_LMS_SPIN : make lms not sleep _LM_LOCAL_HP_EN : use static file affinity for HP enqueue mastership _LM_LOCKS : number of enqueues configured for cluster database _LM_MASTER_WEIG : master resource weight for this instance _LM_MAX_LMS : max. number of background global cache server processes _LM_MSG_CLEANUP : GES message buffer cleanup interval time _LM_MSG_POOL_DU : GES message pool dump threshold in terms of buffer _LM_NODE_JOIN_O : cluster database node join optimization in reconfig _LM_NON_FAULT_T : disable cluster database fault-tolerance mode _LM_NO_LH_CHECK : skip load and health check at decision points _LM_NUM_PT_BUCK : number of buckets in the object affinity hash table _LM_NUM_PT_LATC : number of latches in the object affinity hash table _LM_POSTEVENT_B : postevent buffer size _LM_PREREGISTER : enqueue type that requires pre-registration to css _LM_PROCESS_BAT : GES implicit process batching for IPC messages _LM_PROCESS_LOC : limit on scanning process lock queue instead of _LM_PROCS : number of client processes configured for cluster _LM_PROC_FREEZE : reconfiguration: process freeze timeout _LM_PSRCFG : enable pseudo reconfiguration _LM_RAC_SPARE_D : rac parameter dp10 _LM_RAC_SPARE_D : rac parameter dp2 _LM_RAC_SPARE_D : rac parameter dp3 _LM_RAC_SPARE_D : rac parameter dp4 _LM_RAC_SPARE_D : rac parameter dp5 _LM_RAC_SPARE_D : rac parameter dp6 _LM_RAC_SPARE_D : rac parameter dp7 _LM_RAC_SPARE_D : rac parameter dp8 _LM_RAC_SPARE_D : rac parameter dp9 _LM_RAC_SPARE_P : rac parameter p1 _LM_RAC_SPARE_P : rac parameter p10 _LM_RAC_SPARE_P : rac parameter p2 _LM_RAC_SPARE_P : rac parameter p3 _LM_RAC_SPARE_P : rac parameter p4 _LM_RAC_SPARE_P : rac parameter p5 _LM_RAC_SPARE_P : rac parameter p6 _LM_RAC_SPARE_P : rac parameter p7 _LM_RAC_SPARE_P : rac parameter p8 _LM_RAC_SPARE_P : rac parameter p9 _LM_RCFG_TIMEOU : dlm reconfiguration timeout _LM_RCVINST : designated instance to do instance recovery _LM_RCVR_HANG_C : to kill receiver hang at control file IO _LM_RCVR_HANG_C : receiver hang check frequency in seconds _LM_RCVR_HANG_C : examine system load when check receiver health _LM_RCVR_HANG_K : to kill receiver hang _LM_RCVR_HANG_S : systemstate dump level upon receiver hang _LM_RESEND_OPEN : timeout in secs before resubmitting the open-convert _LM_RESS : number of resources configured for cluster database _LM_RES_PART : number of resource partition configured for gcs _LM_RM_SLAVES : if non zero,it enables remastering slaves _LM_SEND_MODE : GES send mode _LM_SEND_QUEUE_ : GES send queue maximum length _LM_SHARE_LOCK_ : if TRUE enables share lock optimization _LM_SINGLE_INST : enable single instance affinity lock optimization _LM_SPARE_THREA : number of spare threads to be created by the GPnP _LM_SPARE_UNDO : number of spare undo tablespaces to be created by GPnP _LM_SQ_BATCH_FA : GES send queue minimum batching factor _LM_SQ_BATCH_TY : GES send queue batching mechanism _LM_SQ_BATCH_WA : GES send queue batching waittime in tick _LM_SYNC_TIMEOU : Synchronization timeout for DLM reconfiguration steps _LM_TICKETS : GES messaging tickets _LM_TX_DELTA : TX lock localization delta _LM_USE_TX_TSN : use undo tsn affinity master as TX enqueue master _LM_WAIT_PENDIN : GES wait on pending send queue _LM_WATCHPOINT_ : GES number of watchpoints _LM_WATCHPOINT_ : GES maximum time in seconds to keep watchpoint _LM_XIDS : number of transaction IDs configured for cluster _LOAD_WITHOUT_C : Load PL/SQL or Database objects without compilation _LOCAL_ARC_ASSE : Assert whenever local ORL arch waits for space _LOCAL_COMMUNIC : enable local communication costing when TRUE _LOCAL_COMMUNIC : set the ratio between global and local communication _LOCAL_HANG_ANA : the interval at which local hang analysis is run _LOCK_REF_CONST : number of nowait attempts to lock referential _LOCK_SGA_AREAS : Lock specified areas of the SGA in physical memory _LOGOUT_STORM_R : maximum retry count for logouts _LOGOUT_STORM_T : timeout in centi-seconds for time to wait between _LOG_ARCHIVE_AV : log archive avoid memcpy _LOG_ARCHIVE_BU : Number of buffers to allocate for archiving _LOG_ARCHIVE_CA : archival callout _LOG_ARCHIVE_NE : Log archive network redo buffer size used by ARCH _LOG_ARCHIVE_PR : log archive protection auto demotion _LOG_ARCHIVE_ST : log archive security strong auth _LOG_ARCHIVE_TR : log archive trace pids parameter _LOG_BLOCKS_DUR : log block images when changed during backup _LOG_BUFFERS_CO : corrupt redo buffers before write _LOG_BUFFERS_DE : debug redo buffers (slows things down) _LOG_BUFFER_COA : Coalescing log buffers for log writes _LOG_CHECKPOINT : # redo blocks to verify after checkpoint _LOG_COMMITTIME : Log commit-time block cleanout _LOG_DELETION_P : archivelog deletion policy for mandatory/all _LOG_EVENT_QUEU : number of the log writer event queues _LOG_FILE_SYNC_ : Log file sync timeout (centiseconds) _LOG_MAX_OPTIMI : maximum number of threads to which log scan _LOG_PARALLELIS : Enable dynamic strands _LOG_PARALLELIS : Maximum number of log buffer strands _LOG_PRIVATE_MU : Private strand multiplier for log space preallocation _LOG_PRIVATE_PA : Active sessions multiplier to deduce number of private _LOG_READ_BUFFE : Number of log read buffers for media recovery _LOG_READ_BUFFE : buffer size for reading log files _LOG_SIMULTANEO : number of simultaneous copies into redo buffer(# of _LOG_SPACE_ERRO : should we report space errors to alert log _LOG_SWITCH_TIM : Maximum number of seconds redos in the current log _LOG_UNDO_DF_IN : generate marker to log file# that belong to undo _LOG_WRITER_WOR : LGWR worker DLM health-monitoring heartbeat update _LOG_WRITE_INFO : Size of log write info array _LONGOPS_ENABLE : longops stats enabled _LONG_BCAST_ACK : threshold for long bcast ack warning messages in ms _LONG_LOG_WRITE : threshold for long log write warning messages in ms _LOWRES_DRIFT_A : allowed lowres timer drift for VKTM _LOW_SERVER_THR : low server thresholds _LTC_TRACE : tracing level for load table conventional _LTHREAD_CLNUP_ : timeout after hard killing operation for lthread to _LTHREAD_CLNUP_ : wait timeout for PMON between soft kill and hard kill _LTHREAD_CLNUP_ : timeout for spawner between soft kill and hard kill of _LTHREAD_DEBUG : Enable Debugging mode for lightweight threads _LTHREAD_MAX_SP : maximum time interval a spawner will wait for a lthread _LTHREAD_SPAWN_ : time interval for a spawner to check for spawnee to get _LTHREAD_STEP_D : Enable Step wise Debugging mode for lightweight threads _MAIN_DEAD_PROC : PMON main dead process scan interval (in seconds) _MASTER_DIRECT_ : direct sends for messages from master (DFS) _MAV_REFRESH_CO : refresh materialized views using consistent read _MAV_REFRESH_DO : materialized view MAV refreshes avoid double counting _MAV_REFRESH_OP : optimizations during refresh of materialized views _MAV_REFRESH_UN : # tables for union all expansion during materialized _MAX_AQ_PERSIST : max aq persistent queue memory _MAX_ASYNC_WAIT : Switchover wait time for async LNS to catch up in _MAX_CLIENTS_PE : maximum number of clients per emon _MAX_CR_ROLLBAC : Maximum number of CR rollbacks per block (LMS) _MAX_DATA_TRANS : Maximum size of data transfer cache _MAX_DEFER_GRAN : Maximum deferred granules transferred by MMAN atonce _MAX_EXPONENTIA : max sleep during exponential backoff _MAX_FILESTAT_T : maximum number of file stat tries _MAX_FSU_SEGMEN : Maximum segments to track for fast space usage _MAX_FSU_STALE_ : Allowed space usage staleness in seconds _MAX_INCIDENT_F : Maximum size (in KB,MB,GB,Blocks) of incident dump _MAX_IO_SIZE : Maximum I/O size in bytes for sequential file accesses _MAX_LARGEPAGE_ : Maximum number of seconds to spend on largepage _MAX_LARGE_IO : IORM:max number of large I/O’s to issue _MAX_LOG_WRITE_ : Maximum I/O parallelism within a log write (auto=0) _MAX_LOG_WRITE_ : Maximum parallelism within a log write (auto=0) _MAX_OUTSTANDIN : Maximum number of outstanding redo log writes _MAX_PENDING_SC : maximum number of pending SCN broadcasts _MAX_PROTOCOL_S : Max occurrence protocols supported in a process _MAX_QUEUED_REP : Maximum number of report requests that can be queued in _MAX_REASONABLE : Max reasonable SCN rate _MAX_REPORT_FLU : Max no of report requests that can be flushed per cycle _MAX_RWGS_GROUP : maximum no of groupings on materialized views _MAX_SERVICES : maximum number of database services _MAX_SLEEP_HOLD : max time to sleep while holding a latch _MAX_SMALL_IO : IORM:max number of small I/O’s to issue _MAX_SPACEBG_SL : maximum space management background slaves _MAX_SPACEBG_TA : maximum space management background tasks _MAX_STRING_SIZ : controls error checking for the max_string_size _MAX_SYS_NEXT_E : Dictionary managed SYSTEM tablespace maximum next _MEDIA_RECOVERY : media recovery block read batch _MEMORY_BROKER_ : memory broker num stat entries _MEMORY_BROKER_ : Marginal Utility threshold pct for bc _MEMORY_BROKER_ : Marginal Utility threshold pct for sp _MEMORY_BROKER_ : memory broker allow policy to shrink shared pool _MEMORY_BROKER_ : memory broker allow policy to shrink java pool _MEMORY_BROKER_ : memory broker allow policy to shrink streams pool _MEMORY_BROKER_ : memory broker policy to timeout shrink shared/java pool _MEMORY_BROKER_ : memory broker statistics gathering interval for auto _MEMORY_CHECKIN : check inuse time interval _MEMORY_IMM_MOD : Allow immediate mode without sga/memory target _MEMORY_INITIAL : Initial default sga target percentage with memory _MEMORY_MANAGEM : trace memory management activity _MEMORY_MAX_TGT : counts the times checker increments memory target _MEMORY_MGMT_FA : always fail immediate mode request _MEMORY_MGMT_IM : time in seconds to time out immediate mode request _MEMORY_NOCANCE : do not cancel deferred sga reqs with auto-memory _MEMORY_SANITY_ : partial granule sanity check _MEM_ANNOTATION : private memory annotation collection level _MEM_ANNOTATION : memory annotation pre-allocation scaling _MEM_ANNOTATION : shared memory annotation collection level _MEM_ANNOTATION : memory annotation in-memory store _MEM_STD_EXTENT : standard extent size for fixed-size-extent heaps _MESSAGES : message queue resources – dependent on # processes & # _MGD_RCV_HANDLE : Managed recovery handle orphan datafile situation _MIDTIER_AFFINI : cluster wait precentage threshold to enter affinity _MIDTIER_AFFINI : goodness gradient threshold to dissolve affinity _MINFREE_PLUS : max percentage of block space + minfree before we mark _MINIMAL_STATS_ : prohibit stats aggregation at compile/partition _MINIMUM_BLOCKS : minimum number freeable blocks for shrink to be present _MINIMUM_DB_FLA : Minimum flashback retention _MINIMUM_EXTENT : minimum number freeable extents for shrink to be _MIN_TIME_BETWE : minimum time between PSP0 diagnostic used for flow _MIRROR_REDO_BU : Save buffers for debugging redo corruptions _MMV_QUERY_REWR : allow rewrites with multiple MVs and/or base tables _MODIFY_COLUMN_ : allow ALTER TABLE MODIFY(column) to violate index key _MODULE_ACTION_ : Use module and action old length parameter _MPMT_ENABLED : MPMT mode enabled _MPMT_FG_ENABLE : MPMT mode foreground enabled _MPMT_PROCS_PER : max procs per osp _MULTIPLE_INSTA : use multiple instances for media recovery _MULTI_INSTANCE : force multi instance parallel recovery _MULTI_JOIN_KEY : TRUE iff multi-join-key table lookup prefetch is _MULTI_TRANSACT : reduce SGA memory use during create of a partitioned _MUTEX_SPIN_COU : Mutex spin count _MUTEX_WAIT_SCH : Mutex wait scheme _MUTEX_WAIT_TIM : Mutex wait time _MV_ADD_LOG_PLA : add log placeholder _MV_CLEANUP_ORP : cleanup orphaned materialized view metadata _MV_COMPLETE_RE : use conventional INSERTs for MV complete refresh _MV_DEFERRED_NO : avoid build deferred MV log age validate _MV_EXPRESSION_ : MV expression extend size _MV_GENERALIZED : enable/disable new algorithm for MJV with generalized _MV_REFRESH_ANA : what percent to analyze after complete/PCT refresh _MV_REFRESH_DEL : delta mv as fractional percentage of size of mv _MV_REFRESH_ENH : enable enhanced detection of DML types from MV log _MV_REFRESH_EUT : refresh materialized views using EUT(partition)-based _MV_REFRESH_FOR : force materialized view refreshes to use parallel query _MV_REFRESH_INS : materialized view refresh using insert no append _MV_REFRESH_NEW : materialized view MV refresh new setup disabling _MV_REFRESH_NO_ : avoid index rebuild as part of the MV refresh _MV_REFRESH_PKF : control MV refresh based on the assumption of PK-FK _MV_REFRESH_PKF : control MV refresh based on the use of PK-FK _MV_REFRESH_REB : minimum percentage change required in MV to force an _MV_REFRESH_SEL : create materialized views with selections and fast _MV_REFRESH_UPD : materialized view refresh using update analysis _MV_REFRESH_USE : use hash_sj hint in queries _MV_REFRESH_USE : use no_merge hint in queries _MV_REFRESH_USE : pass cardinality hints to refresh queries _MV_REFSCHED_TI : proportionality constant for dop vs. time in MV refresh _MV_ROLLING_INV : create/alter mv uses rolling cursor invalidation _MWIN_SCHEDULE : Enable/disable Maintenance Window Schedules _NCHAR_IMP_CNV : NLS allow Implicit Conversion between CHAR and NCHAR _NCMB_READAHEAD : enable multi-block readahead for an index scan _NCMB_READAHEAD : turn on multi-block readahead tracing _NCOMP_SHARED_O : native compilation shared objects dir _NESTED_LOOP_FU : nested loop fudge _NESTED_MV_FAST : nested MV refresh fast on commit allowed _NET_TIMEOUT_LA : NET_TIMEOUT latency _NEWSORT_ENABLE : controls whether new sorts can be used as system sort _NEWSORT_ORDERE : controls when new sort avoids sorting ordered input _NEWSORT_TYPE : specifies options for the new sort algorithm _NEW_SORT_COST_ : enables the use of new cost estimate for sort _NINETEENTH_SPA : nineteenth spare parameter – string _NINTH_SPARE_PA : ninth spare parameter – integer _NLJ_BATCHING_A : FAE flag type set after restoring to IO batching buffer _NLJ_BATCHING_E : enable batching of the RHS IO in NLJ _NLJ_BATCHING_M : enable exceptions for buffer cache misses _NLS_PARAMETER_ : enables or disables updates to v$parameter whenever an _NOLOGGING_KCNB : Number of nologging buffer hash buckets _NOLOGGING_KCNB : Number of nologging buffer hash latches _NOLOGGING_LOAD : Nologging standby: direct load buffer size _NOLOGGING_SDCL : Nologging standby append sdcl wait time _NOLOGGING_SEND : Nologging standby: outstanding send buffer ratio _NOLOGGING_TXN_ : Nologging standby transaction commit wait time _NONCDB_TO_PDB : converting a non-cdb to a pdb _NOTIFY_CRS : notify cluster ready services of startup and shutdown _NO_RECOVERY_TH : no recovery through this resetlogs operation _NO_SMALL_FILE : Not to apply new extent scheme for small file temp _NO_STALE_JOINB : No joinbacks if mv is stale _NS_MAX_FLUSH_W : Flush wait time for NetServer to flush oustanding _NS_MAX_SEND_DE : Data Loss Time Bound for NetServer _NUMA_BUFFER_CA : Configure NUMA buffer cache stats _NUMA_INSTANCE_ : Set of nodes that this instance should run on _NUMA_POOL_SIZE : aggregate size in bytes of NUMA pool _NUMA_SHIFT_VAL : user defined value for numa nodes shift _NUMA_TRACE_LEV : numa trace event _NUMBER_CACHED_ : maximum number of cached attributes per instance _NUMBER_CACHED_ : maximum number of cached group memberships _NUMBER_GROUP_M : maximum number of group memberships per cache line _NUM_LONGOP_CHI : number of child latches for long op array _OBJECT_NUMBER_ : Object number cache size _OBJECT_REUSE_B : if 1 or higher,handle object reuse _OBJECT_STATIST : enable the object level statistics collection _OBJECT_STATS_M : Maximum number of entries to be tracked per stat _OBJ_CKPT_TRACI : Enable object checkpoint tracing _ODCI_AGGREGATE : trade speed for space in user-defined aggregation _OFFLINE_ROLLBA : offline undo segment list _OGMS_HOME : GMS home directory _OLAPI_IFACE_OB : enable olapi interface object history collection _OLAPI_IFACE_OB : enable olapi interface object history retention _OLAPI_IFACE_OP : enable olapi interface operation history retention _OLAPI_INTERFAC : enable olapi interface operation history collection _OLAPI_MEMORY_O : enable olapi memory alloc/free history collection _OLAPI_MEMORY_O : enable olapi memory alloc/free history collection _OLAPI_MEMORY_O : enable olapi memory operation history retention _OLAPI_SESSION_ : enable olapi session history collection _OLAPI_SESSION_ : enable olapi session history retention _OLAP_ADV_COMP_ : do additional predicate stats analysis for AW rowsource _OLAP_ADV_COMP_ : do additional predicate stats analysis for AW rowsource _OLAP_AGGREGATE : OLAP Aggregate max buffer size _OLAP_AGGREGATE : OLAP Aggregate debug flags _OLAP_AGGREGATE : OLAP Aggregate function cache enabler _OLAP_AGGREGATE : OLAP Aggregate max thread tuples creation _OLAP_AGGREGATE : OLAP Aggregate min buffer size _OLAP_AGGREGATE : OLAP Aggregate minimum cardinality of dimensions for _OLAP_AGGREGATE : OLAP Aggregate Multi-path Hierarhies enabled _OLAP_AGGREGATE : OLAP Aggregate status array usage threshold _OLAP_AGGREGATE : OLAP Aggregate max worklists generated at once _OLAP_AGGREGATE : OLAP Aggregate max work parents _OLAP_ALLOCATE_ : OLAP Allocate Errorlog Format _OLAP_ALLOCATE_ : OLAP Allocate Errorlog Header format _OLAP_ANALYZE_M : OLAP DML ANALYZE command max cells to analyze _OLAP_CONTINUOU : OLAP logging definition _OLAP_DBGOUTFIL : OLAP DbgOutfile copy output to event log (tracefile) _OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Force _OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Large Threshold _OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Pressure Threshold _OLAP_DIMENSION : OLAP Dimension In-Core Hash Table Maximum Memory Use _OLAP_EIF_EXPOR : OLAP EIF Export BLOB size _OLAP_LMGEN_DIM : Limitmap generator dimension column size _OLAP_LMGEN_MEA : Limitmap generator measure column size _OLAP_OBJECT_HA : OLAP Object Hash Table Class _OLAP_PAGE_POOL : OLAP Page Pool Expand Rate _OLAP_PAGE_POOL : OLAP Page Pool High Watermark _OLAP_PAGE_POOL : OLAP Page Pool Hit Target _OLAP_PAGE_POOL : OLAP Page Pool Low Watermark _OLAP_PAGE_POOL : OLAP Page Pool Pressure Threshold _OLAP_PAGE_POOL : OLAP Page Pool Shrink Rate _OLAP_PARALLEL_ : OLAP parallel update server count _OLAP_PARALLEL_ : OLAP parallel update threshold for number of small _OLAP_PARALLEL_ : OLAP parallel update threshold in pages _OLAP_ROW_LOAD_ : OLAP Row Load Time Precision _OLAP_SESSCACHE : OLAP Session Cache knob _OLAP_SORT_BUFF : OLAP Sort Buffer Size Percentage _OLAP_SORT_BUFF : OLAP Sort Buffer Size _OLAP_STATBOOL_ : OLAP Status Boolean max incore bits _OLAP_STATBOOL_ : OLAP Status Boolean CBM threshold _OLAP_TABLE_FUN : Specify TRUE to output OLAP table function timed _OLAP_WRAP_ERRO : Wrap error messages to OLAP outfile _OLD_CONNECT_BY : enable/disable old connect by _OLD_EXTENT_SCH : Revert to old extent allocation _OLS_CLEANUP_TA : Clean up unnecessary entries in OLS sessinfo table _OLTP_COMPRESSI : oltp compression enabled _OLTP_COMPRESSI : oltp compression gain _OLTP_COMP_DBG_ : oltp compression scan debug _OLTP_SPILL : spill rows for oltp compression if loader pga limit is _OMF : enable/disable OMF _ONESIDE_COLSTA : sanity check on default selectivity for like/range _ONLINE_CTAS_DI : controls dumping diagnostic information for online ctas _ONLINE_PATCH_D : disable check for function on stack for online patches _OPS_PER_SEMOP : the exact number of operations per semop system call _OPTIMIZER_ADAP : enable adaptive plans _OPTIMIZER_ADAP : internal controls for adaptive plans _OPTIMIZER_ADJU : adjust selectivity for null values _OPTIMIZER_ADS_ : maximum number of tables in a join under ADS _OPTIMIZER_ADS_ : maximum time limit (seconds) under ADS _OPTIMIZER_ADS_ : use result cache for ADS queries _OPTIMIZER_ANSI : optimization of left/full ansi-joins and lateral views _OPTIMIZER_ANSI : re-architecture of ANSI left,right,and full outer _OPTIMIZER_AUTO : enable/disable auto stats collection job _OPTIMIZER_AW_J : Enables AW Join Push optimization _OPTIMIZER_AW_S : Enables statistcs on AW olap_table table function _OPTIMIZER_BATC : enable table access by ROWID IO batching _OPTIMIZER_BETT : enable improved costing of index access using _OPTIMIZER_BLOC : standard block size used by optimizer _OPTIMIZER_CACH : cost with cache statistics _OPTIMIZER_CART : optimizer cartesian join enabled _OPTIMIZER_CBQT : cost factor for cost-based query transformation _OPTIMIZER_CBQT : disable cost based transformation query size _OPTIMIZER_CEIL : CEIL cost in CBO _OPTIMIZER_CLUS : enable/disable the cluster by rowid feature _OPTIMIZER_CLUS : internal control for cluster by rowid feature mode _OPTIMIZER_COAL : consider coalescing of subqueries optimization _OPTIMIZER_COMP : enable selectivity estimation for builtin functions _OPTIMIZER_COMP : force index stats collection on index creation/rebuild _OPTIMIZER_CONN : use cost-based transformation for whr clause in connect _OPTIMIZER_CONN : combine no filtering connect by and start with _OPTIMIZER_CONN : use cost-based transformation for connect by _OPTIMIZER_CONN : allow connect by to eliminate duplicates from input _OPTIMIZER_CORR : force correct computation of subquery selectivity _OPTIMIZER_COST : enables cost-based query transformation _OPTIMIZER_COST : enables costing of filter predicates in IO cost model _OPTIMIZER_COST : add cost of generating result set when #rows per key > _OPTIMIZER_COST : optimizer cost model _OPTIMIZER_CUBE : enable cube join _OPTIMIZER_DEGR : force the optimizer to use the same degree of _OPTIMIZER_DIM_ : use join selectivity in choosing star transformation _OPTIMIZER_DISA : disable star transformation sanity checks _OPTIMIZER_DIST : Transforms Distinct Aggregates to non-distinct _OPTIMIZER_DIST : Eliminates redundant SELECT DISTNCT’s _OPTIMIZER_DIST : consider distinct placement optimization _OPTIMIZER_DSDI : controls optimizer usage of dynamic sampling directives _OPTIMIZER_DYN_ : number of blocks for optimizer dynamic sampling _OPTIMIZER_ELIM : optimizer filtering join elimination enabled _OPTIMIZER_ENAB : use improved density computation for selectivity _OPTIMIZER_ENAB : use extended statistics for selectivity estimation _OPTIMIZER_ENAB : consider table lookup by nl transformation _OPTIMIZER_ENHA : push filters before trying cost-based query _OPTIMIZER_EXTE : optimizer extended cursor sharing _OPTIMIZER_EXTE : optimizer extended cursor sharing for relational _OPTIMIZER_EXTE : controls the optimizer usage of extended stats _OPTIMIZER_EXTE : join pred pushdown on group-by,distinct, _OPTIMIZER_FALS : optimizer false predicate pull up transformation _OPTIMIZER_FAST : use fast algorithm to traverse predicates for physical _OPTIMIZER_FAST : use fast algorithm to generate transitive predicates _OPTIMIZER_FEED : controls the optimizer feedback framework _OPTIMIZER_FILT : use cost-based flter predicate pull up transformation _OPTIMIZER_FILT : enable/disable filter predicate pushdown _OPTIMIZER_FKR_ : Optimizer index bias over FTS/IFFS under first K rows _OPTIMIZER_FORC : force CBQT transformation regardless of cost _OPTIMIZER_FREE : free transformation subheap after each transformation _OPTIMIZER_FULL : enable/disable full outer to left outer join conversion _OPTIMIZER_GATH : optimizer gather feedback _OPTIMIZER_GATH : enable/disable online statistics gathering _OPTIMIZER_GENE : optimizer generate transitive predicates _OPTIMIZER_GROU : consider group-by placement optimization _OPTIMIZER_HYBR : enable hybrid full partition-wise join when TRUE _OPTIMIZER_IGNO : enables the embedded hints to be ignored _OPTIMIZER_IMPR : improve table and partial overlap join selectivity _OPTIMIZER_INST : force the optimizer to use the specified number of _OPTIMIZER_INTE : interleave join predicate pushdown during CBQT _OPTIMIZER_INVA : time window for invalidation of cursors of analyzed _OPTIMIZER_JOIN : optimizer join elimination enabled _OPTIMIZER_JOIN : use join factorization transformation _OPTIMIZER_JOIN : controls the optimizer join order search algorithm _OPTIMIZER_JOIN : enable/disable sanity check for multi-column join _OPTIMIZER_MAX_ : optimizer maximum join permutations per query block _OPTIMIZER_MIN_ : set minimum cached blocks _OPTIMIZER_MJC_ : enable merge join cartesian _OPTIMIZER_MODE : force setting of optimizer mode for user recursive SQL _OPTIMIZER_MULT : generate and run plans using several compilation _OPTIMIZER_MULT : control what to report in trace file when run in _OPTIMIZER_MULT : control the types of statements that are run in _OPTIMIZER_MULT : consider join-predicate pushdown that requires _OPTIMIZER_MULT : allows multiple tables on the left of outerjoin _OPTIMIZER_NATI : execute full outer join using native implementaion _OPTIMIZER_NEST : number of groups above which we use nested rollup exec _OPTIMIZER_NEW_ : compute join cardinality using non-rounded input values _OPTIMIZER_NULL : enables null-accepting semijoin _OPTIMIZER_NULL : null-aware antijoin parameter _OPTIMIZER_ORDE : Eliminates order bys from views before query _OPTIMIZER_OR_E : control or expansion approach used _OPTIMIZER_OR_E : Use subheap for optimizer or-expansion _OPTIMIZER_OUTE : enable/disable outer to inner join conversion _OPTIMIZER_OUTE : Enable transformation of outer-join to anti-join if _OPTIMIZER_PART : partial join evaluation parameter _OPTIMIZER_PERC : optimizer percent parallel _OPTIMIZER_PERF : controls the performance feedback _OPTIMIZER_PROC : control the level of processing rates _OPTIMIZER_PROC : control the source of processing rates _OPTIMIZER_PURG : number of rows to be deleted at each iteration of the _OPTIMIZER_PUSH : push down distinct from query block to table _OPTIMIZER_PUSH : use cost-based query transformation for push pred _OPTIMIZER_RAND : optimizer seed value for random plans _OPTIMIZER_REUS : reuse cost annotations during cost-based query _OPTIMIZER_ROWN : Default value to use for rownum bind _OPTIMIZER_ROWN : enable the use of first K rows due to rownum predicate _OPTIMIZER_SAVE : enable/disable saving old versions of optimizer stats _OPTIMIZER_SEAR : optimizer search limit _OPTIMIZER_SELF : account for self-induced caching _OPTIMIZER_SKIP : enable/disable index skip scan _OPTIMIZER_SKIP : consider index skip scan for predicates with guessed _OPTIMIZER_SORT : enable/disable sort-merge join method _OPTIMIZER_SORT : enable/disable sort-merge join using inequality _OPTIMIZER_SQU_ : enables unnesting of subquery in a bottom-up manner _OPTIMIZER_STAR : optimizer star plan enabled _OPTIMIZER_STAR : optimizer star transformation minimum cost _OPTIMIZER_STAR : optimizer star transformation minimum ratio _OPTIMIZER_STAR : enable/disable star transformation in with clause _OPTIMIZER_STRA : allow adaptive pruning of star transformation bitmap _OPTIMIZER_SYST : system statistics usage _OPTIMIZER_TABL : consider table expansion transformation _OPTIMIZER_TRAC : optimizer trace parameter _OPTIMIZER_TRAN : retain equi-join pred upon transitive equality pred _OPTIMIZER_TRY_ : try Star Transformation before Join Predicate Push Down _OPTIMIZER_UNDO : undo changes to query optimizer _OPTIMIZER_UNDO : optimizer undo cost change _OPTIMIZER_UNNE : enables unnesting of every type of subquery _OPTIMIZER_UNNE : Unnesting of correlated set subqueries (TRUE/FALSE) _OPTIMIZER_UNNE : Unnesting of disjunctive subqueries (TRUE/FALSE) _OPTIMIZER_UNNE : enables unnesting of of scalar subquery _OPTIMIZER_USE_ : use rewritten star transformation using cbqt framework _OPTIMIZER_USE_ : optimizer use feedback _OPTIMIZER_USE_ : use GTT session private statistics _OPTIMIZER_USE_ : enable/disable the usage of histograms by the optimizer _OPTIMIZER_USE_ : Enables physical optimizer subheap _OPTIM_ADJUST_F : adjust stats for skews across partitions _OPTIM_DICT_STA : enable/disable dictionary stats gathering at db _OPTIM_ENHANCE_ : TRUE to enable index [fast] full scan more often _OPTIM_NEW_DEFA : improves the way default equijoin selectivity are _OPTIM_PEEK_USE : enable peeking of user binds _ORACLE_SCRIPT : Running an Oracle-supplied script _ORADEBUG_CMDS_ : oradebug commands to execute at instance startup _ORADEBUG_FORCE : force target processes to execute oradebug commands? _ORDERED_SEMIJO : enable ordered semi-join subquery _ORPH_CLN_INTER : qmon periodic interval for removed subscriber messages _OR_EXPAND_NVL_ : enable OR expanded plan for NVL/DECODE predicate _OSS_SKGXP_UDP_ : OSSLIB enable[!0]/disable[0] dynamic credit mgmt for _OS_SCHED_HIGH_ : OS high priority level _OTHER_WAIT_EVE : exclude event names from _other_wait_threshold _OTHER_WAIT_THR : threshold wait percentage for event wait class Other _OUTLINE_BITMAP : BITMAP_TREE hint enabled in outline _PARALLELISM_CO : set the parallelism cost fudge factor _PARALLEL_ADAPT : maximum number of users running with default DOP _PARALLEL_BLACK : parallel execution blackbox enabled _PARALLEL_BLACK : true if blackbox will be allocated in SGA,false if PGA _PARALLEL_BLACK : parallel execution blackbox bucket size _PARALLEL_BROAD : enable broadcasting of small inputs to hash and sort _PARALLEL_CLUST : max percentage of the global buffer cache to use for _PARALLEL_CLUST : policy used for parallel execution on _PARALLEL_CONSE : conservative parallel statement queuing _PARALLEL_CTAS_ : enable/disable parallel CTAS operation _PARALLEL_DEFAU : default maximum number of instances for parallel query _PARALLEL_EXECU : Alignment of PX buffers to OS page boundary _PARALLEL_FAKE_ : fake db-scheduler percent used for testing _PARALLEL_FAULT : total number of faults fault-tolerance will handle _PARALLEL_FIXWR : Number of buckets for each round of fix write _PARALLEL_HEART : interval of snapshot to track px msging between _PARALLEL_HEART : maximum number of historical snapshots archived _PARALLEL_LOAD_ : parallel execution load balanced slave allocation _PARALLEL_LOAD_ : number of threads to allocate per instance _PARALLEL_LOAD_ : diffrence in percentage controlling px load propagation _PARALLEL_MIN_M : minimum size of shared pool memory to reserve for pq _PARALLEL_OPTIM : parallel optimization phase when all slaves are local _PARALLEL_QUEUI : parallel statement queuing: max waiting time in queue _PARALLEL_RECOV : stop at -position- to step through SMON _PARALLEL_REPLA : Number of messages for each round of parallel replay _PARALLEL_SCALA : Parallel scalability criterion for parallel execution _PARALLEL_SERVE : idle time before parallel query server dies (in 1/100 _PARALLEL_SERVE : sleep time between dequeue timeouts (in 1/100ths) _PARALLEL_SLAVE : time(in seconds) to wait before retrying slave _PARALLEL_STATE : parallel statement queuing enabled _PARALLEL_SYSPL : TRUE to obey force parallel query/dml/ddl under System _PARALLEL_TIME_ : unit of work used to derive the degree of parallelism _PARALLEL_TXN_G : enable parallel_txn hint with updates and deletes _PARAMETER_TABL : parameter table block size _PARTIAL_PWISE_ : enable partial partition-wise join when TRUE _PARTITION_ADVI : enables sampling based partitioning validation _PARTITION_CDB_ : partitioned cdb view evaluation enabled _PARTITION_LARG : Enables large extent allocation for partitioned tables _PARTITION_VIEW : enable/disable partitioned views _PART_ACCESS_VE : use version numbers to access versioned objects for _PART_REDEF_GLO : online partition redefinition update global indexes _PASSWORDFILE_E : password file enqueue timeout in seconds _PCT_REFRESH_DO : materialized view PCT refreshes avoid double counting _PDB_USE_SEQUEN : Use sequence cache in PDB mode _PDML_GIM_SAMPL : control separation of global index maintenance for PDML _PDML_GIM_STAGG : slaves start on different index when doing index maint _PDML_SLAVES_DI : slaves start on different partition when doing index _PERCENT_FLASHB : Percent of flashback buffer filled to be considered _PGACTX_CAP_STA : capture stacks for setting pgactx _PGA_LARGE_EXTE : PGA large extent size _PGA_LIMIT_CHEC : microseconds to wait for over limit confirmation _PGA_LIMIT_DUMP : dump PGA summary when signalling ORA-4036 _PGA_LIMIT_INTE : whether to interrupt smaller eligible processes _PGA_LIMIT_MIN_ : bytes of PGA usage below which process will not get _PGA_LIMIT_SIMU : bytes of physical memory to determine _PGA_LIMIT_TARG : default percent of pga_aggregate_target for _PGA_LIMIT_TIME : seconds to wait until direct interrupt _PGA_LIMIT_TIME : seconds to wait before treating process as idle _PGA_LIMIT_TIME : seconds to wait before killing session over limit _PGA_LIMIT_TRAC : trace pga_aggregate_limit activity _PGA_LIMIT_USE_ : use immediate kill for sessions over limit _PGA_LIMIT_WATC : percentage of limit to have processes watch _PGA_LIMIT_WATC : bytes of PGA usage at which process will begin watching _PGA_MAX_SIZE : Maximum size of the PGA memory for one process _PIN_TIME_STATI : if TRUE collect statistics for how long a current pin _PIVOT_IMPLEMEN : pivot implementation method _PKT_ENABLE : enable progressive kill test _PKT_START : start progressive kill test instrumention _PLAN_VERIFY_IM : Performance improvement criterion for evolving plan _PLAN_VERIFY_LO : Local time limit to use for an individual plan _PLSQL_ANON_BLO : PL/SQL anonymous block code-type _PLSQL_CACHE_EN : PL/SQL Function Cache Enabled _PLSQL_DUMP_BUF : conditions upon which the PL/SQL circular buffer is _PLSQL_MAX_STAC : PL/SQL maximum stack size _PLSQL_MINIMUM_ : plsql minimum cache hit percentage required to keep _PLSQL_NATIVE_F : Allocate PL/SQL native frames on the heap if size _PLSQL_NVL_OPTI : PL/SQL NVL optimize _PLUGGABLE_DATA : Debug flag for pluggable database related operations _PMON_DEAD_BLKR : rate to check blockers are alive during cleanup (in _PMON_DEAD_BLKR : max blockers to check during cleanup _PMON_DEAD_BLKR : max attempts per blocker while checking dead blockers _PMON_DEAD_BLKR : rate to scan for dead blockers during cleanup (in _PMON_ENABLE_DE : look for dead blockers during PMON cleanup _PMON_LOAD_CONS : server load balancing constants (S,P,D,I,L,C,M) _PMON_MAX_CONSE : PMON max consecutive posts in main loop _POST_WAIT_QUEU : Post Wait Queues – Num Dynamic Queues _POST_WAIT_QUEU : Post Wait Queues – Num Per Class _PQQ_DEBUG_TXN_ : pq queuing transaction active _PQQ_ENABLED : Enable Resource Manager based Parallel Statement _PRECOMPUTE_GID : precompute gid values and copy them before returning a _PREDICATE_ELIM : allow predicate elimination if set to TRUE _PRED_MOVE_AROU : enables predicate move-around _PRED_PUSH_CDB_ : predicate pushdown enabled for CDB views _PREFERED_STAND : standby db_unique_name prefered for krb operations _PRESCOMM : presume commit of IMU transactions _PRINT_INMEM_HE : print inmem ilm heatmap _PRINT_REFRESH_ : enable dbms_output of materialized view refresh _PRINT_STAT_SEG : print ilm statistics segment _PRIVATE_MEMORY : Start address of large extent memory segment _PROJECTION_PUS : projection pushdown _PROJECTION_PUS : level for projection pushdown debugging _PROJECT_VIEW_C : enable projecting out unreferenced columns of a view _PROP_OLD_ENABL : Shift to pre 11g propagation behaviour _PROTECT_FRAME_ : Protect cursor frame heaps _PTN_CACHE_THRE : flags and threshold to control partition metadata _PUSH_JOIN_PRED : enable pushing join predicate inside a view _PUSH_JOIN_UNIO : enable pushing join predicate inside a union all view _PUSH_JOIN_UNIO : enable pushing join predicate inside a union view _PX_ADAPTIVE_DI : determines the behavior of adaptive distribution _PX_ADAPTIVE_DI : Buffering / decision threshold for adaptive _PX_ADAPTIVE_OF : percentage for PQ adaptive offloading of granules _PX_ADAPTIVE_OF : threshold (GB/s) for PQ adaptive offloading of granules _PX_ASYNC_GETGR : asynchronous get granule in the slave _PX_BACK_TO_PAR : allow going back to parallel after a serial operation _PX_BIND_PEEK_S : enables sharing of px cursors that were built using _PX_BROADCAST_F : set the tq broadcasting fudge factor percentage _PX_BUFFER_TTL : ttl for px mesg buffers in seconds _PX_CHUNKLIST_C : ratio of the number of chunk lists to the default DOP _PX_COMPILATION : debug level for parallel compilation _PX_COMPILATION : tracing level for parallel compilation _PX_CONCURRENT : enables pq with concurrent execution of serial inputs _PX_CPU_OPERATO : CPU operator bandwidth in MB/sec for DOP computation _PX_CPU_PROCESS : CPU process bandwidth in MB/sec for DOP computation _PX_DP_ARRAY_SI : Max number of pq processes supported _PX_DUMP_12805_ : enables or disables tracing of 12805 signal source _PX_DYNAMIC_OPT : turn off/on restartable qerpx dynamic optimization _PX_EXECUTION_S : enable service-based constraint of px slave allocation _PX_FILTER_PARA : enables or disables correlated filter parallelization _PX_FILTER_SKEW : enable correlated filter parallelization to handle skew _PX_FREELIST_LA : Divide the computed number of freelists by this power _PX_GIM_FACTOR : weighted autodop global index maintenance factor _PX_GRANULE_RAN : enables or disables randomization of parallel scans _PX_GRANULE_SIZ : default size of a rowid range granule (in KB) _PX_GROUPBY_PUS : perform group-by pushdown for parallel query _PX_HOLD_TIME : hold px at execution time (unit: second) _PX_INDEX_SAMPL : parallel query sampling for index create based on _PX_IO_PROCESS_ : IO process bandwidth in MB/sec for computing DOP _PX_IO_SYSTEM_B : total IO system bandwidth in MB/sec for computing DOP _PX_JOIN_SKEW_H : enables skew handling for parallel joins _PX_JOIN_SKEW_M : sets minimum frequency(%) for skewed value for parallel _PX_JOIN_SKEW_R : sets skew ratio for parallel joins _PX_KXIB_TRACIN : turn on kxib tracing _PX_LOAD_BALANC : parallel load balancing policy _PX_LOAD_FACTOR : weighted autodop load factor _PX_LOAD_PUBLIS : interval at which LMON will check whether to publish PX _PX_LOC_MSG_COS : CPU cost to send a PX message via shared memory _PX_MAX_GRANULE : maximum number of rowid range granules to generate per _PX_MAX_MAP_VAL : Maximum value of rehash mapping for PX _PX_MESSAGE_COM : enable compression of control messages for parallel _PX_MINUS_INTER : enables pq for minus/interect operators _PX_MIN_GRANULE : minimum number of rowid range granules to generate per _PX_MONITOR_LOA : enable consumer load slave workload monitoring _PX_NET_MSG_COS : CPU cost to send a PX message over the internconnect _PX_NO_GRANULE_ : prevent parallel partition granules to be sorted on _PX_NO_STEALING : prevent parallel granule stealing in shared nothing _PX_NSS_PLANB : enables or disables NSS Plan B reparse with outline _PX_NUMA_SUPPOR : enable/disable PQ NUMA support _PX_OBJECT_SAMP : parallel query sampling for base objects (100000 = _PX_OBJECT_SAMP : use base object sampling when possible for range _PX_ONEPASS_SLA : enable/disable one pass slave acquisition for parallel _PX_PARALLELIZE : enables or disables expression evaluation _PX_PARTIAL_ROL : perform partial rollup pushdown for parallel execution _PX_PARTITION_S : enables or disables parallel partition-based scan _PX_PARTITION_S : least number of partitions per slave to start _PX_PROACTIVE_S : parallel proactive slave allocation threshold/unit _PX_PROC_CONSTR : reduce parallel_max_servers if greater than (processes _PX_PWG_ENABLED : parallel partition wise group by enabled _PX_REPLICATION : enables or disables replication of small table scans _PX_ROUND_ROBIN : round robin row count to enq to next slave _PX_ROWNUM_PD : turn off/on parallel rownum pushdown optimization _PX_SINGLE_SERV : allow single-slave dfo in parallel query _PX_SLAVES_SHAR : slaves share cursors with QC _PX_TQ_ROWHVS : turn on intra-row hash valueing sharing in TQ _PX_USE_LARGE_P : Use Large Pool as source of PX buffers _PX_WIF_DFO_DEC : NDV-aware DFO clumping of multiple window sorts _PX_WIF_EXTEND_ : extend TQ data redistribution keys for window functions _PX_WIF_MIN_NDV : mininum NDV of TQ keys needed per slave for scalable _PX_XTGRANULE_S : default size of a external table granule (in KB) _QA_CONTROL : Oracle internal parameter to control QA _QUERY_EXECUTIO : max size of query execution cache _QUERY_MMVREWRI : query mmv rewrite maximum number of cmaps per dmap in _QUERY_MMVREWRI : query mmv rewrite maximum number of dmaps per query _QUERY_MMVREWRI : query mmv rewrite maximum number of in-lists per _QUERY_MMVREWRI : query mmv rewrite maximum number of intervals per _QUERY_MMVREWRI : query mmv rewrite maximum number of predicates per _QUERY_MMVREWRI : query mmv rewrite maximum number of query in-list _QUERY_MMVREWRI : query mmv rewrite maximum number of region permutations _QUERY_ON_PHYSI : query on physical _QUERY_REWRITE_ : perform query rewrite before&after or only before view _QUERY_REWRITE_ : perform query rewrite before&after or only after view _QUERY_REWRITE_ : mv rewrite and drop redundant joins _QUERY_REWRITE_ : rewrite with cannonical form for expressions _QUERY_REWRITE_ : mv rewrite fresh partition containment _QUERY_REWRITE_ : cost based query rewrite with MVs fudge factor _QUERY_REWRITE_ : mv rewrite with jg migration _QUERY_REWRITE_ : query rewrite max disjuncts _QUERY_REWRITE_ : allow query rewrite,if referenced tables are not _QUERY_REWRITE_ : perform general rewrite using set operator summaries _QUERY_REWRITE_ : prune frocol chain before rewrite after view-merging _QUEUE_BUFFER_M : max number of bytes to dump to trace file for queue _RADM_ENABLED : Data Redaction _RCFG_DISABLE_V : if TRUE disables verify at reconfiguration _RCFG_PARALLEL_ : if TRUE enables parallel fixwrite at reconfiguration _RCFG_PARALLEL_ : if TRUE enables parallel replay and cleanup at _RCFG_PARALLEL_ : if TRUE enables parallel verify at reconfiguration _RDBMS_COMPATIB : default RDBMS compatibility level _RDBMS_INTERNAL : enable CELL FPLIB filtering within rdbms _RDBMS_INTERNAL : enable reraising of any exceptions in CELL FPLIB _READABLE_STAND : readable standby query scn sync timeout _READ_MOSTLY_EN : Read mostly instances enable non-privileged logons _READ_MOSTLY_IN : indicates this is a read_mostly instance _READ_MOSTLY_IN : internal parameter to control read mostly instance QA _READ_MOSTLY_SL : Time to wait on read mostly node when hub not available _READ_ONLY_VIOL : read-only violation dump to trace files _READ_ONLY_VIOL : read-only violation array max count _READ_ONLY_VIOL : read-only violation array per module max count _REALFREE_HEAP_ : minimum max total heap size,in Kbytes _REALFREE_HEAP_ : mode flags for real-free heap _REALFREE_HEAP_ : hint for real-free page size in bytes _REALFREE_PQ_HE : hint for pq real-free page size in bytes _REAL_TIME_APPL : Simulation value with real time apply _RECOVERABLE_RE : Recoverable recovery batch size (percentage of buffer _RECOVERY_ASSER : if TRUE,enable expensive integrity checks _RECOVERY_PERCE : recovery buffer cache percentage _RECOVERY_READ_ : number of recovery reads which can be outstanding _RECOVERY_SKIP_ : allow media recovery even if controlfile seq check _RECOVERY_VERIF : enable thread recovery write verify _RECURSIVE_IMU_ : recursive transactions may be IMU _RECURSIVE_WITH : check for maximum level of recursion instead of _REDEF_ON_STATE : Use on-statement refresh in online redefinition _REDO_COMPATIBI : general and redo/undo compatibility sanity check _REDO_LOG_DEBUG : Various configuration flags for debugging redo logs _REDO_LOG_RECOR : Life time in hours for redo log table records _REDO_READ_FROM : Enable reading redo from in-memory log buffer _REDO_TRANSPORT : Is ASYNC LNS compression allowed? _REDO_TRANSPORT : redo transport sanity check bit mask _REDO_TRANSPORT : I/O stall time before terminating redo transport _REDO_TRANSPORT : long I/O stall time before terminating redo transport _REDO_TRANSPORT : test stream connection? _REDO_TRANSPORT : Stream network writes? _REDO_TRANSPORT : VIO size requirement _REDUCE_SBY_LOG : enable standby log scan optimization _REGION_NAME : gsm region name _RELIABLE_BLOCK : if TRUE,no side channel on reliable interconnect _RELOCATE_PDB : Relocate PDB to another RAC instance after it is closed _RELOCATION_COM : ASM relocation commit batch size _REMOTE_ASM : remote ASM configuration _REMOVE_AGGR_SU : enables removal of subsumed aggregated subquery _REMOVE_EXF_COM : enable/disable removing of components EXF and RUL _REPLACE_VIRTUA : replace expressions with virtual columns _REPORT_CAPTURE : Time (in sec) between two cycles of report capture _REPORT_CAPTURE : 100X Percent of system db time daemon is allowed over _REPORT_CAPTURE : No of report capture cycles after which db time is _REPORT_CAPTURE : Length of time band (in hours) in the reports time _REPORT_REQUEST : Time (in min) after which a report request is deleted _REP_BASE_PATH : base path for EM reports in database _RESOURCE_INCLU : Whether RESOURCE role includes UNLIMITED TABLESPACE _RESOURCE_MANAG : disable the resource manager always _RESOURCE_MANAG : resource mgr top plan for internal use _RESTORE_MAXOPE : restore assumption for maxopenfiles _RESTORE_SPFILE : restore spfile to this location _RESULT_CACHE_A : result cache auto dml monitoring slot _RESULT_CACHE_A : result cache auto dml threshold _RESULT_CACHE_A : result cache auto dml trend threshold _RESULT_CACHE_A : result cache auto execution threshold _RESULT_CACHE_A : result cache auto max size allowed _RESULT_CACHE_A : result cache auto time distance _RESULT_CACHE_A : result cache auto time threshold _RESULT_CACHE_B : result cache block size _RESULT_CACHE_C : blocks to copy instead of pinning the result _RESULT_CACHE_D : result cache deterministic PLSQL functions _RESULT_CACHE_G : Are results available globally across RAC? _RESULT_CACHE_T : maximum time (sec) a session waits for a result _RESUMABLE_CRIT : raise critical alert for resumable failure _REUSE_INDEX_LO : number of blocks being examine for index block reuse _RE_FAST_SQL_OP : enables fast boxable sql operator _RE_INDEPENDENT : defines max number of compiled cached expressions for _RE_NUM_COMPLEX : defines max number of compiled complex operator per _RE_NUM_ROWCACH : defines max number of complex operators loaded with row _RE_RESULT_CACH : defines max number key for result cache hash table _RE_RESULT_CACH : defines max number of cached elements for result cache _RIGHT_OUTER_HA : Right Outer/Semi/Anti Hash Enabled _RMAN_IO_PRIORI : priority at which rman backup i/o’s are done _RMAN_ROUNDROBI : Numa round robin placement for RMAN procs _RM_CLUSTER_INT : interconnects for RAC use (RM) _RM_NUMA_SCHED_ : Is Resource Manager (RM) related NUMA scheduled policy _RM_NUMA_SIMULA : number of cpus for each pg for numa simulation in _RM_NUMA_SIMULA : number of PGs for numa simulation in resource manager _ROLLBACK_SEGME : number of undo segments _ROLLBACK_SEGME : starting undo segment number _ROLLBACK_STOPA : stop at -position to step rollback _ROND_TEST_MODE : rac one node test mode _ROWSETS_CDB_VI : rowsets enabled for CDB views _ROWSETS_ENABLE : enable/disable rowsets _ROWSETS_MAX_RO : maximum number of rows in a rowset _ROWSETS_TARGET : target size in bytes for space reserved in the frame _ROWSOURCE_EXEC : if TRUE,Oracle will collect rowsource statistics _ROWSOURCE_PROF : if TRUE,Oracle will capture active row sources in _ROWSOURCE_STAT : frequency of rowsource statistic sampling (must be a _ROWSRC_TRACE_L : Row source tree tracing level _ROW_CACHE_CURS : number of cached cursors for row cache management _ROW_CR : enable row cr for all sql _ROW_SHIPPING_T : row shipping column selection threshold _RTADDM_TRIGGER : comma-separated list of numeric arguments for RT addm _RTADDM_TRIGGER : To enable or disable Real-Time ADDM automatic trigger _RTA_SYNC_WAIT_ : RTA sync wait timeout _RTC_INFEASIBLE : Redo Transport Compression infeasible threshold _SAMPLE_ROWS_PE : number of rows per block used for sampling IO _SCALAR_TYPE_LO : threshold for VARCHAR2,NVARCHAR2,and RAW storage as _SCATTER_GCS_RE : if TRUE,gcs resources are scattered uniformly across _SCATTER_GCS_SH : if TRUE,gcs shadows are scattered uniformly across sub _SCHED_DELAY_MA : scheduling delay maximum number of samples _SCHED_DELAY_ME : scheduling delay mesurement sleep us _SCHED_DELAY_OS : os tick granularity used by scheduling delay _SCHED_DELAY_SA : scheduling delay sample collection duration threshold _SCHED_DELAY_SA : scheduling delay sampling interval in ms _SCN_WAIT_INTER : max exponential backoff time for scn wait interface in _SCN_WAIT_INTER : max timeout for scn wait interface in kta _SDIAG_CRASH : sql diag crash _SECUREFILES_BR : segment retry before dishonoring retention _SECUREFILES_BU : securefiles segment insert only optization _SECUREFILES_CO : securefiles concurrency estimate _SECUREFILES_FG : segment retry before foreground waits _SECUREFILES_FO : securefiles force flush before allocation _SECUREFILES_ME : securefiles memory as percent of SGA _SECUREFILES_SP : securefiles segment utl optimization _SECUREFILE_LOG : Maximum number of open descriptors for securefile log _SECUREFILE_LOG : Size of securefile log buffer pool from SGA _SECUREFILE_TIM : collect kdlu timers and accumulate per layers _SEC_ENABLE_TES : Whether to enable the test RPCs _SELECTIVITY_FO : enable/disable selectivity for storage reduction factor _SELECT_ANY_DIC : Exclude USER$,XS$VERIFIERS,ENC$ and DEFAULT_PWD$ from _SELFJOIN_MV_DU : control rewrite self-join algorithm _SELFTUNE_CHECK : Self-tune checkpointing lag the tail of the redo log _SELFTUNE_CHECK : Percentage of total physical i/os for self-tune ckpt _SEM_PER_SEMID : the exact number of semaphores per semaphore set to _SEND_AST_TO_FO : if TRUE,send ast message to foreground _SEND_CLOSE_WIT : if TRUE,send close with block even with direct sends _SEND_REQUESTS_ : if TRUE,try to send CR requests to PI buffers _SERIALIZABLE : serializable _SERIAL_DIRECT_ : enable direct read in serial _SERIAL_LOG_WRI : Serialize log write slave I/O _SERIAL_RECOVER : force serial recovery or parallel recovery _SERVICE_CLEANU : timeout to peform service cleanup _SESSION_ALLOCA : one latch per group of sessions _SESSION_CACHED : Number of pl/sql instantiations to cache in a session. _SESSION_CONTEX : session app context size _SESSION_IDLE_B : one latch per session or a latch per group of sessions _SESSION_PAGE_E : Session Page Extent Size _SESSION_WAIT_H : enable session wait history collection _SET_CONTAINER_ : set container service _SET_MGD_RECOVE : set mgd recovery state to new value _SEVENTEENTH_SP : seventeenth spare parameter – string _SEVENTH_SPARE_ : seventh spare parameter – integer _SF_DEFAULT_ENA : enable 12g securefile default _SGA_ALLOC_SLAV : Termination timeout in secs for SA** slaves _SGA_CLEAR_DUMP : Allow dumping encrypted blocks in clear for debugging _SGA_LOCKING : sga granule locking state _SHARED_IO_POOL : Shared IO pool buffer size _SHARED_IO_POOL : trace kcbi debug info to tracefile _SHARED_IO_POOL : Size of shared IO pool _SHARED_IO_SET_ : shared io pool size set internal value – overwrite zero _SHARED_POOL_MA : shared pool maximum size when auto SGA enabled _SHARED_POOL_MI : shared pool minimum size when auto SGA enabled _SHARED_POOL_RE : minimum allocation size in bytes for reserved area of _SHARED_POOL_RE : percentage memory of the shared pool allocated for the _SHARED_SERVER_ : shared server load balance _SHARED_SERVER_ : number of shared server common queues _SHMPROTECT : allow mprotect use for shared memory _SHOW_MGD_RECOV : Show internal managed recovery state _SHRD_QUE_TM_PR : number of sharded queue Time Managers to start _SHRD_QUE_TM_ST : Shaded queue statistics collection window duration _SHRUNK_AGGS_DI : percentage of exceptions at which to switch to full _SHRUNK_AGGS_EN : enable use of variable sized buffers for non-distinct _SHUTDOWN_COMPL : minutes for shutdown operation to wait for sessions to _SIDE_CHANNEL_B : number of messages to batch in a side channel message _SIDE_CHANNEL_B : timeout before shipping out the batched side _SIDE_CHANNEL_B : timeout before shipping out the batched side _SIMPLE_VIEW_ME : control simple view merging performed by the optimizer _SIMULATED_LOG_ : Simulated latency of log writes (usecs) _SIMULATE_DISK_ : Enables skgfr to report simulated disk sector size _SIMULATE_IO_WA : Simulate I/O wait to test segment advisor _SIMULATE_MEM_T : simulate auto memory sga/pga transfers _SIMULATOR_BUCK : LRU bucket minimum delta _SIMULATOR_INTE : simulator internal bound percent _SIMULATOR_LRU_ : LRU list rebalance threshold (size) _SIMULATOR_LRU_ : LRU list rebalance threshold (count) _SIMULATOR_LRU_ : LRU scan count _SIMULATOR_PIN_ : maximum count of invalid chunks on pin list _SIMULATOR_RESE : simulator reserved heap count _SIMULATOR_RESE : simulator reserved object count _SIMULATOR_SAMP : sampling factor for the simulator _SIMULATOR_UPPE : upper bound multiple of pool size _SINGLE_PROCESS : run without detached processes _SIOP_PERC_OF_B : percentange * 100 of cache to transfer to shared io _SIXTEENTH_SPAR : sixteenth spare parameter – string _SIXTH_SPARE_PA : sixth spare parameter – integer _SKGXPG_LAST_PA : last defined skgxpg parameter – oss _SKGXP_ANT_OPTI : SKGXP ANT options (oss) _SKGXP_CTX_FLAG : IPC debug options flags (oss) _SKGXP_CTX_FLAG : IPC debug options flags mask (oss) _SKGXP_DYNAMIC_ : IPC protocol override _SKGXP_GEN_ANT_ : VRPC request timeout when ANT disabled _SKGXP_GEN_ANT_ : ANT protocol ping miss count _SKGXP_GEN_RPC_ : ANT ping protocol miss count _SKGXP_GEN_RPC_ : VRPC request timeout when ANT enabled _SKGXP_INETS : limit SKGXP networks (oss) _SKGXP_MIN_ZCPY : IPC threshold for zcpy operation (default = 0 – _SKGXP_REAPING : tune skgxp OSD reaping limit _SKGXP_SPARE_PA : ipc oss spare parameter 1 _SKGXP_SPARE_PA : ipc oss spare parameter 2 _SKGXP_SPARE_PA : ipc oss spare parameter 3 _SKGXP_SPARE_PA : ipc oss spare parameter 4 _SKGXP_SPARE_PA : ipc oss spare parameter 5 _SKGXP_UDP_ACH_ : time in minutes before idle ach’s are reaped _SKGXP_UDP_ACK_ : Enables delayed acks _SKGXP_UDP_ENAB : Enables dynamic credit management _SKGXP_UDP_HIWA : ach hiwat mark warning interval _SKGXP_UDP_INTE : time in seconds between interface detection checks _SKGXP_UDP_KEEP : connection idle time in seconds before keep alive is _SKGXP_UDP_LMP_ : MTU size for UDP LMP testing _SKGXP_UDP_LMP_ : enable UDP long message protection _SKGXP_UDP_TIME : diagnostic log buffering space (in bytes) for timed _SKGXP_UDP_TIME : time in seconds before timed wait is invoked _SKGXP_UDP_USE_ : disable use of high speek timer _SKGXP_ZCPY_FLA : IPC zcpy options flags _SKIP_ACFS_CHEC : Override checking if on an ACFS file system _SKIP_ASSUME_MS : if TRUE,skip assume message for consigns at the master _SKIP_TRSTAMP_C : Skip terminal recovery stamp check _SLAVE_MAPPING_ : enable slave mapping when TRUE _SLAVE_MAPPING_ : force the number of slave group in a slave mapper _SLAVE_MAPPING_ : maximum skew before slave mapping is disabled _SMALL_TABLE_TH : lower threshold level of table size for direct reads _SMM_ADVICE_ENA : if TRUE,enable v$pga_advice _SMM_ADVICE_LOG : overwrites default size of the PGA advice workarea _SMM_AUTO_COST_ : if TRUE,use the AUTO size policy cost functions _SMM_AUTO_MAX_I : Maximum IO size (in KB) used by sort/hash-join in auto _SMM_AUTO_MIN_I : Minimum IO size (in KB) used by sort/hash-join in auto _SMM_BOUND : overwrites memory manager automatically computed bound _SMM_ISORT_CAP : maximum work area for insertion sort(v1) _SMM_MIN_SIZE : minimum work area size in auto mode _SMM_PX_MAX_SIZ : static maximum work area size in auto mode (global) _SMM_RETAIN_SIZ : work area retain size in SGA for shared server sessions _SMM_TRACE : Turn on/off tracing for SQL memory manager _SMON_UNDO_SEG_ : limit of SMON continous undo segments re-scan _SMU_DEBUG_MODE : <debug-flag> – set debug event for testing SMU _SMU_ERROR_SIMU : site ID of error simulation in KTU code _SMU_ERROR_SIMU : error type for error simulation in KTU code _SMU_TIMEOUTS : comma-separated *AND double-quoted* list of AUM _SNAPSHOT_RECOV : enable/disable snapshot recovery _SORT_ELIMINATI : cost ratio for sort eimination under first_rows mode _SORT_MULTIBLOC : multi-block read count for sort _SORT_SPILL_THR : force sort to spill to disk each time this many rows _SORT_SYNC_MIN_ : controls the size of mininum run size for synchronized _SORT_SYNC_MIN_ : controls the mininum spill size for synchronized spill _SPACE_ALIGN_SI : space align size _SPARE_TEST_PAR : Spare test parameter _SPAWN_DIAG_OPT : thread spawn diagnostic options _SPAWN_DIAG_THR : thread spawn diagnostic minimal threshold in seconds _SPIN_COUNT : Amount to spin waiting for a latch _SPR_USE_AW_AS : enable AW for hash table in spreadsheet _SQLEXEC_PROGRE : sql execution progression monitoring cost threshold _SQLMON_BINDS_X : format of column binds_xml in [G]V$SQL_MONITOR _SQLMON_MAX_PLA : Maximum number of plans entry that can be monitored. _SQLMON_MAX_PLA : Number of plan lines beyond which a plan cannot be _SQLMON_RECYCLE : Minimum time (in s) to wait before a plan entry can be _SQLMON_THRESHO : CPU/IO time threshold before a statement is monitored. _SQLTUNE_CATEGO : Parsed category qualifier for applying hintsets _SQL_ANALYZE_EN : SQL Analyze Autonomous Transaction control parameter _SQL_ANALYZE_PA : SQL Analyze Parse Model control parameter _SQL_COMPATIBIL : sql compatability bit vector _SQL_CONNECT_CA : SQL Connect Capability Table Override _SQL_CONNECT_CA : SQL Connect Capability Table (testing only) _SQL_DIAG_REPO_ : duarations where sql diag repository are retained _SQL_DIAG_REPO_ : retain sql diag repository to cursor or not _SQL_HASH_DEBUG : Hash value of the SQL statement to debug _SQL_HVSHARE_TH : threshold to control hash value sharing across _SQL_MODEL_UNFO : specifies compile-time unfolding of sql model forloops _SQL_NCG_MODE : Optimization mode for SQL NCG _SQL_PLAN_MANAG : controls various internal SQL Plan Management _SQL_SHOW_EXPRE : show expression evalution as shared hash producer in _SRVNTFN_JOBSUB : srvntfn job submit interval _SRVNTFN_JOB_DE : srvntfn job deq timeout _SRVNTFN_MAX_CO : srvntfn max concurrent jobs _SRVNTFN_Q_MSGC : srvntfn q msg count for job exit _SRVNTFN_Q_MSGC : srvntfn q msg count increase for job submit _SSCR_DIR : Session State Capture and Restore DIRectory object _STANDBY_CAUSAL : readable standby causal heartbeat timeout _STANDBY_FLUSH_ : standby flush mode _STANDBY_IMPLIC : minutes to wait for redo during standby implicit _STANDBY_SWITCH : Number of secords for standby switchover enqueue _STATIC_BACKGRO : static backgrounds _STATISTICS_BAS : enable/disable the use of statistics for storage _STAT_AGGS_ONE_ : enable one pass algorithm for variance-related _STA_CONTROL : SQL Tuning Advisory control parameter _STREAMS_POOL_M : streams pool maximum size when auto SGA enabled _SUBQUERY_PRUNI : subquery pruning cost factor _SUBQUERY_PRUNI : enable the use of subquery predicates to perform _SUBQUERY_PRUNI : enable the use of subquery predicates with MVs to _SUBQUERY_PRUNI : subquery pruning reduction factor _SUPPRESS_IDENT : supress owner index name err msg _SWITCHOVER_TIM : Switchover timeout in minutes _SWITCHOVER_TO_ : option for graceful switchover to standby _SWITCHOVER_TO_ : Switchover to standby switches log for open redo _SWITCH_CURRENT : switch current uses scan scn _SWRF_METRIC_FR : Enable/disable SWRF Metric Frequent Mode Collection _SWRF_MMON_DBFU : Enable/disable SWRF MMON DB Feature Usage _SWRF_MMON_FLUS : Enable/disable SWRF MMON FLushing _SWRF_MMON_METR : Enable/disable SWRF MMON Metrics Collection _SWRF_ON_DISK_E : Parameter to enable/disable SWRF _SWRF_TEST_ACTI : test action parameter for SWRF _SWRF_TEST_DBFU : Enable/disable DB Feature Usage Testing _SYNC_PRIMARY_W : wait time for alter session sync with primary _SYNONYM_REPOIN : whether to trace metadata comparisons for synonym _SYSAUX_TEST_PA : test parameter for SYSAUX _SYSTEM_API_INT : enable debug tracing for system api interception _SYSTEM_INDEX_C : optimizer percent system index caching _SYSTEM_TRIG_EN : are system triggers enabled _SYS_LOGON_DELA : failed logon delay for sys _TABLESPACES_PE : estimated number of tablespaces manipulated by each _TABLE_LOOKUP_P : table lookup prefetch vector size _TABLE_LOOKUP_P : table lookup prefetch threshold _TABLE_SCAN_COS : bump estimated full table scan and index ffs cost by _TARGET_LOG_WRI : Do log write if this many redo blocks in buffer _TARGET_LOG_WRI : How long LGWR will wait for redo to accumulate (csecs) _TARGET_RBA_MAX : target rba max log lag percentage _TA_LNS_WAIT_FO : LNS Wait time for arhcived version of online log _TDB_DEBUG_MODE : set debug mode for testing transportable database _TEMP_TRAN_CACH : determines if temp table is created with cache option _TEMP_UNDO_DISA : is temp undo disabled on ADG _TENTH_SPARE_PA : tenth spare parameter – integer _TEST_HM_EXTENT : heatmap related – to be used by oracle dev only _TEST_KSUSIGSKI : test the function ksusigskip _TEST_PARAM_1 : test parmeter 1 – integer _THIRTEENTH_SPA : thirteenth spare parameter – integer _THREAD_STATE_C : Thread state change timeout for PnP instance (in sec) _THRESHOLD_ALER : if 1,issue threshold-based alerts _TIMEMODEL_COLL : enable timemodel collection _TIMEOUT_ACTION : enables or disables KSU timeout actions _TIMER_PRECISIO : VKTM timer precision in milli-sec _TIME_BASED_RCV : time-based incremental recovery checkpoint target in _TIME_BASED_RCV : time-based incremental recovery file header update _TOTAL_LARGE_EX : Total memory for allocating large extents _TQ_DUMP_PERIOD : time period for duping of TQ statistics (s) _TRACE_DUMP_ALL : if TRUE on error buckets of all processes will be _TRACE_DUMP_CLI : if TRUE dump client (ie. non-kst) buckets _TRACE_DUMP_CUR : if TRUE on error just dump our process bucket _TRACE_DUMP_STA : if TRUE filter trace dumps to always loaded dlls _TRACE_EVENTS : trace events enabled at startup _TRACE_KQLIDP : trace kqlidp0 operation _TRACE_PIN_TIME : trace how long a current pin is held _TRACE_PROCESSE : enable KST tracing in process _TRACE_TEMP : Trace Tempspace Management _TRACK_METRICS_ : Enable/disable Metrics Memory Tracking _TRANSACTION_AU : transaction auditing records generated in the redo log _TRANSACTION_RE : max number of parallel recovery slaves that may be used _TRANSIENT_LOGI : clear KCCDI2HMRP flag during standby recovery _TRUNCATE_OPTIM : do truncate optimization if set to TRUE _TSENC_OBFUSCAT : Encryption key obfuscation in memory _TSENC_TRACING : Enable TS encryption tracing _TSM_DISABLE_AU : Disable TSM auto cleanup actions _TSTZ_LOCALTIME : Should TTC not convert to LocalTime to preserve _TTS_ALLOW_CHAR : allow plugging in a tablespace with an incompatible _TWELFTH_SPARE_ : twelfth spare parameter – integer _TWENTIETH_SPAR : twentieth spare parameter – string _TWENTY-EIGHTH_ : twenty-eighth spare parameter – boolean _TWENTY-FIFTH_S : twenty-fifth spare parameter – string list _TWENTY-FIRST_S : twenty-first spare parameter – string list _TWENTY-FOURTH_ : twenty-fourth spare parameter – string list _TWENTY-SECOND_ : twenty-second spare parameter – string list _TWENTY-SEVENTH : twenty-seventh spare parameter – boolean _TWENTY-SIXTH_S : twenty-sixth spare parameter – boolean _TWENTY-THIRD_S : twenty-third spare parameter – string list _TWO_PASS : enable two-pass thread recovery _TXN_CONTROL_TR : size the in-memory buffer size of txn control _UGA_CGA_LARGE_ : UGA/CGA large extent size _ULTRAFAST_LATC : maintain fast-path statistics for ultrafast latches _UNDO_AUTOTUNE : enable auto tuning of undo_retention _UNDO_DEBUG_MOD : debug flag for undo related operations _UNDO_DEBUG_USA : invoke undo usage functions for testing _UNIFIED_AUDIT_ : Unified Audit SGA Queue Flush Interval _UNIFIED_AUDIT_ : Unified Audit SGA Queue Flush Threshold _UNIFIED_AUDIT_ : Disable Default Unified Audit Policies on DB Create _UNION_REWRITE_ : expand queries with GSets into UNIONs for rewrite _UNNEST_SUBQUER : enables unnesting of complex subqueries _UNUSED_BLOCK_C : enable unused block compression _UPDATE_DATAFIL : user requested update of datafile headers of locally _UPDDEL_DBA_HAS : controls masking of lower order bits in DBA _USE_ADAPTIVE_L : Adaptively switch between post/wait and polling _USE_BEST_FIT : use best fit to allocate space _USE_FIPS_MODE : Enable use of crypographic libraries in FIPS mode _USE_HYBRID_ENC : Enable platform optimized encryption in hybrid mode _USE_ISM : Enable Shared Page Tables – ISM _USE_NOSEGMENT_ : use nosegment indexes in explain plan _USE_PLATFORM_C : Enable platform optimized compression implementation _USE_PLATFORM_E : Enable platform optimized encryption implementation _USE_REALFREE_H : use real-free based allocator for PGA memory _USE_SEQ_PROCES : whether to use process local seq cache _USE_SINGLE_LOG : Use a single process for redo log writing _USE_VECTOR_POS : use vector post _USE_ZERO_COPY_ : Should network vector IO interface be used for data _UTLMMIG_TABLE_ : enable/disable utlmmig table stats gathering at upgrade _UTS_FIRST_SEGM : Should we retain the first trace segment _UTS_FIRST_SEGM : Maximum size (in bytes) of first segments _UTS_TRACE_DISK : Trace disk threshold parameter _UTS_TRACE_SEGM : Maximum number of trace segments _UTS_TRACE_SEGM : Maximum size (in bytes) of a trace segment _VALIDATE_FLASH : Scan database to validate result of flashback database _VALIDATE_METRI : Enable/disable SGA Metric Structure validation _VALIDATE_READM : validate redo blocks read from in-memory log buffer _VENDOR_LIB_LOC : Vendor library search root directory _VERIFY_FLASHBA : Verify that the redo logs needed for flashback are _VERIFY_UNDO_QU : TRUE – verify consistency of undo quota statistics _VERY_LARGE_OBJ : upper threshold level of object size for direct reads _VERY_LARGE_PAR : very_large_partitioned_table _VIRTUAL_COLUMN : overload virtual columns expression _VKRM_SCHEDULE_ : VKRM scheduling interval _VKTM_ASSERT_TH : soft assert threshold VKTM timer drift _WAIT_BREAKUP_T : Wait breakup threshold (in centiseconds) _WAIT_BREAKUP_T : Wait breakup time (in centiseconds) _WAIT_FOR_SYNC : wait for sync on commit MUST BE ALWAYS TRUE _WAIT_SAMPLES_M : Wait Samples maximum time in seconds _WAIT_TRACKER_I : Wait Tracker number of seconds per interval _WAIT_TRACKER_N : Wait Tracker number of intervals _WAIT_YIELD_HP_ : Wait Yield – High Priority Mode _WAIT_YIELD_MOD : Wait Yield – Mode _WAIT_YIELD_SLE : Wait Yield – Sleep Frequency _WAIT_YIELD_SLE : Wait Yield – Sleep Time (in milliseconds) _WAIT_YIELD_YIE : Wait Yield – Yield Frequency _WALK_INSERT_TH : maximum number of unusable blocks to walk across _WATCHPOINT_ON : is the watchpointing feature turned on? _WCR_GRV_CACHE_ : Oracle internal: Set the replay cache size for _WCR_SEQ_CACHE_ : Oracle internal: Set the replay cache size for _WIDETAB_COMP_E : wide table compression enabled _WINDOWFUNC_OPT : settings for window function optimizations _WITH_SUBQUERY : WITH subquery transformation _XDS_MAX_CHILD_ : Maximum number of XDS user-specific child cursors _XENGEM_DEVNAME : override default VM GEM device name used by skgvm _XENGEM_ENABLED : Enable OVM GEM support _XPL_TRACE : Explain Plan tracing parameter _XSOLAPI_AUTO_M : OLAP API behavior for auto materialization _XSOLAPI_BUILD_ : OLAP API output build info to trace file _XSOLAPI_DEBUG_ : OLAP API debug output disposition _XSOLAPI_DENSIF : OLAP API cube densification _XSOLAPI_DIMENS : OLAP API symmetric overfetch _XSOLAPI_DML_TR : OLAP API output dml commands and expressions to trace _XSOLAPI_FETCH_ : OLAP API fetch type _XSOLAPI_FIX_VP : OLAP API Enable vptr fixing logic in shared server mode _XSOLAPI_GENERA : OLAP API generates WITH clause? _XSOLAPI_HIERAR : OLAP API hierarchy value type _XSOLAPI_LOAD_A : When to load OLAP API library at server process start _XSOLAPI_MATERI : OLAP API min number of rows required to use rowcache in _XSOLAPI_MATERI : OLAP API Enable source materialization _XSOLAPI_METADA : OLAP API metadata reader mode _XSOLAPI_ODBO_M : OLAP API uses ODBO mode? _XSOLAPI_OPTIMI : OLAP API optimizes suppressions? _XSOLAPI_OPT_AW : OLAP API enables AW position and count optimization? _XSOLAPI_PRECOM : OLAP API precomputes subqueries? _XSOLAPI_REMOVE : OLAP API removes columns for materialization? _XSOLAPI_SET_NL : OLAP API sets NLS? _XSOLAPI_SHARE_ : OLAP API share executors? _XSOLAPI_SOURCE : OLAP API output Source definitions to trace file _XSOLAPI_SQL_AL : OLAP API multi-join non-base hints _XSOLAPI_SQL_AL : OLAP API non-base hints _XSOLAPI_SQL_AU : OLAP API enable automatic dimension hints _XSOLAPI_SQL_AU : OLAP API enable automatic measure hints _XSOLAPI_SQL_DI : OLAP API dimension hints _XSOLAPI_SQL_EN : OLAP API enables AW join? _XSOLAPI_SQL_EN : OLAP API enables AW QDR merge? _XSOLAPI_SQL_HI : OLAP API generic hints _XSOLAPI_SQL_ME : OLAP API measure hints _XSOLAPI_SQL_MI : OLAP API SQL MINUS threshold _XSOLAPI_SQL_OP : OLAP API enable optimization _XSOLAPI_SQL_PR : OLAP API prepare statement cache size _XSOLAPI_SQL_RE : OLAP API enable remove unused columns optimizations _XSOLAPI_SQL_RE : OLAP API result set cache size _XSOLAPI_SQL_SY : OLAP API enable symmetric predicate for dimension _XSOLAPI_SQL_TO : OLAP API top dimension hints _XSOLAPI_SQL_TO : OLAP API top measure hints _XSOLAPI_SQL_US : OLAP API enable bind variables optimization _XSOLAPI_STRING : OLAP API stringifies order levels? _XSOLAPI_SUPPOR : OLAP API MTM mapping classes supported? _XSOLAPI_SUPPRE : OLAP API suppression AW mask threshold _XSOLAPI_SUPPRE : OLAP API suppression chunk size _XSOLAPI_USE_MO : OLAP API uses models? _XSOLAPI_USE_OL : OLAP API uses OLAP DML? _XSOLAPI_USE_OL : OLAP API uses OLAP DML for rank? _XS_CLEANUP_TAS : Triton Session Cleanup _XS_DISPATCHER_ : XS dispatcher only mode _XTBUFFER_SIZE : buffer size in KB needed for populate/query operation _XTTS_SET_PLATF : set cross platform info during file header read _XT_COVERAGE : external tables code coverage parameter _ZONEMAP_STALEN : control the staleness tracking of zonemaps via trigger _ZONEMAP_USE_EN : enable the use of zonemaps for IO pruning __DATA_TRANSFER : Actual size of data transfer cache __DB_CACHE_SIZE : Actual size of DEFAULT buffer pool for standard block __DG_BROKER_SER : service names for broker use __JAVA_POOL_SIZ : Actual size in bytes of java pool __LARGE_POOL_SI : Actual size in bytes of large pool __ORACLE_BASE : ORACLE_BASE __SGA_TARGET : Actual size of SGA __SHARED_POOL_S : Actual size in bytes of shared pool __STREAMS_POOL_ : Actual size in bytes of streams pool 2984 rows selected. References: Oracle Documentation (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |