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 _ASYNC_RECOVERY? :? if TRUE,issue recovery reads asynchronously _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 _GCR_ENABLE_HIG? :? if TRUE,GCR may enable a RM plan under high load _GCR_ENABLE_HIG? :? if TRUE,GCR may boost bg priority under high load _GCR_ENABLE_HIG? :? if TRUE,GCR may kill foregrounds under high memory _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 _GC_AFFINITY_LO? :? if TRUE,get affinity locks _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 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |