Oracle12c版本中未归档隐藏参数有哪些
本篇文章为大家展示了Oracle12c版本中未归档隐藏参数有哪些,内容简明扼要并且容易理解,绝对能使你眼前一亮,通过这篇文章的详细介绍希望你能有所收获。
创新互联公司是一家集网站设计制作、做网站、网站页面设计、网站优化SEO优化为一体的专业网络公司,已为成都等多地近百家企业提供网站建设服务。追求良好的浏览体验,以探求精品塑造与理念升华,设计最适合用户的网站页面。 合作只是第一步,服务才是根本,我们始终坚持讲诚信,负责任的原则,为您进行细心、贴心、认真的服务,与众多客户在蓬勃发展的市场环境中,互促共生。
我将列出Oracle 12.1.0.1c中所有未记录的参数。下面是一个查询,用于查看所有参数(已记录和未记录),这些参数包含提示时输入的字符串:
–出现提示时输入参数的名称
SET linesize 235 col Parameter FOR a50 col SESSION FOR a28 col Instance FOR a55 col S FOR a1 col I FOR a1 col D FOR a1 col Description FOR a90 SELECT a.ksppinm "Parameter", decode(p.isses_modifiable,'FALSE',NULL,NULL,NULL,b.ksppstvl) "Session", c.ksppstvl "Instance", decode(p.isses_modifiable,'FALSE','F','TRUE','T') "S", decode(p.issys_modifiable,'FALSE','F','TRUE','T','IMMEDIATE','I','DEFERRED','D') "I", decode(p.isdefault,'FALSE','F','TRUE','T') "D", a.ksppdesc "Description" FROM x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter p WHERE a.indx = b.indx AND a.indx = c.indx AND p.name(+) = a.ksppinm AND UPPER(a.ksppinm) LIKE UPPER('%&1%') ORDER BY a.ksppinm; Enter value for 1:
Here is the list of all (2984) undocumented parameters in Oracle 12.1.0.1c :
SQL> col parameter for a15 word_wrapped col Description for a55 word_wrapped set pagesize 50000 set linesize 80 select upper(KSPPINM) parameter, ' : ', KSPPDESC Description from x$ksppi where substr(ksppinm,1,1) = '_'order by 1,3;
PARAMETER DESCRIPTION
————— ——————————————————-
_4030_DUMP_BITV : bitvec to specify dumps prior to 4030 error
EC
_4031_DUMP_BITV : bitvec to specify dumps prior to 4031 error
EC
_4031_DUMP_INTE : Dump 4031 error once for each n-second interval
RVAL
_4031_MAX_DUMPS : Maximum number of 4031 dumps for this process
_4031_SGA_DUMP_ : Dump 4031 SGA heapdump error once for each n-second
INTERVAL interval
_4031_SGA_MAX_D : Maximum number of SGA heapdumps
UMPS
_ABORT_ON_MRP_C : abort database instance when MRP crashes
RASH
_ABORT_RECOVERY : if TRUE, abort recovery on join reconfigurations
_ON_JOIN
_ACCEPT_VERSION : List of parameters for rolling operation
S
_ACTIVE_INSTANC : number of active instances in the cluster database
E_COUNT
_ACTIVE_SESSION : active session idle limit
_IDLE_LIMIT
_ACTIVE_SESSION : active session legacy behavior
_LEGACY_BEHAVIO
R
_ACTIVE_STANDBY : if TRUE optimize dlm reconfiguration for active/standby
_FAST_RECONFIGU OPS
RATION
_AC_ENABLE_DSCN : Enable Dependent Commit SCN tracking
_IN_RAC
_ADAPTIVE_DIREC : Adaptive Direct Read
T_READ
_ADAPTIVE_DIREC : Adaptive Direct Write
T_WRITE
_ADAPTIVE_FETCH : enable/disable adaptive fetch in parallel group by
_ENABLED
_ADAPTIVE_LOG_F : Threshold for frequent log file sync mode switches (per
ILE_SYNC_HIGH_S minute)
WITCH_FREQ_THRE
SHOLD
_ADAPTIVE_LOG_F : Polling interval selection bias (conservative=0,
ILE_SYNC_POLL_A aggressive=100)
GGRESSIVENESS
_ADAPTIVE_LOG_F : Window (in seconds) for measuring average scheduling
ILE_SYNC_SCHED_ delay
DELAY_WINDOW
_ADAPTIVE_LOG_F : Ratio of redo synch time to expected poll time as a
ILE_SYNC_USE_PO percentage
LLING_THRESHOLD
_ADAPTIVE_LOG_F : Percentage of foreground load from when post/wait was
ILE_SYNC_USE_PO last used
STWAIT_THRESHOL
D
_ADAPTIVE_SCALA : Percentage of overlap across multiple outstanding
BLE_LOG_WRITER_ writes
DISABLE_WORKER_
THRESHOLD
_ADAPTIVE_SCALA : Increase in redo generation rate as a percentage
BLE_LOG_WRITER_
ENABLE_WORKER_T
HRESHOLD
_ADAPTIVE_WINDO : enable/disable adaptive window consolidator PX plan
W_CONSOLIDATOR_
ENABLED
_ADDM_AUTO_ENAB : governs whether ADDM gets run automatically after every
LE AWR snapshot
_ADDM_SKIPRULES : comma-separated list of ADDM nodes to skip
_ADDM_VERSION_C : governs whether ADDM checks the input AWR snapshot
HECK version
_ADD_COL_OPTIM_ : Allows new add column optimization
ENABLED
_ADD_NULLABLE_C : Allows add of a nullable column with default
OLUMN_WITH_DEFA optimization
ULT_OPTIM
_ADD_STALE_MV_T : add stale mv to dependency list
O_DEPENDENCY_LI
ST
_ADD_TRIM_FOR_N : add trimming for fixed char semantics
LSSORT
_ADG_BUFFER_WAI : Active Dataguard buffer wait time in cs
T_TIMEOUT
_ADG_INSTANCE_R : enable ADG instance recovery
ECOVERY
_ADJUST_LITERAL : If TRUE, we will adjust the SQL/PLUS output
_REPLACEMENT
_ADR_MIGRATE_RU : Enable/disable ADR Migrate Runonce action
NONCE
_ADVANCED_INDEX : advanced index compression options
_COMPRESSION_OP
TIONS
_ADVANCED_INDEX : advanced index compression options2
_COMPRESSION_OP
TIONS_VALUE
_ADVANCED_INDEX : advanced index compression trace
_COMPRESSION_TR
ACE
_AFFINITY_ON : enable/disable affinity at run time
_AGED_OUT_CURSO : number of seconds an aged out session cached cursor
R_CACHE_TIME stay in cache
_AGGREGATION_OP : settings for aggregation optimizations
TIMIZATION_SETT
INGS
_AIOWAIT_TIMEOU : Number of aiowait timeouts before error is reported
TS
_ALERT_EXPIRATI : seconds before an alert message is moved to exception
ON queue
_ALERT_MESSAGE_ : Enable Alert Message Cleanup
CLEANUP
_ALERT_MESSAGE_ : Enable Alert Message Purge
PURGE
_ALERT_POST_BAC : Enable Background Alert Posting
KGROUND
_ALLOCATE_CREAT : should files be examined in creation order during
ION_ORDER allocation
_ALLOCATION_UPD : interval at which successful search in L1 should be
ATE_INTERVAL updated
_ALLOW_CELL_SMA : Allow checking smart_scan_capable Attr
RT_SCAN_ATTR
_ALLOW_COMMUTAT : allow for commutativity of +, * when comparing
IVITY expressions
_ALLOW_COMPATIB : allow advancing DB compatibility with guaranteed
ILITY_ADV_W_GRP restore points
_ALLOW_DROP_SNA : Allow dropping snapshot standby guaranteed restore
PSHOT_STANDBY_G point
RSP
_ALLOW_DROP_TS_ : Allow drop Tablespace with guaranteed restore points
WITH_GRP
_ALLOW_ERROR_SI : Allow error simulation for testing
MULATION
_ALLOW_FILE_1_O : don’t signal ORA-1245 due to file 1 being offline
FFLINE_ERROR_12
45
_ALLOW_LEVEL_WI : allow level without connect by
THOUT_CONNECT_B
Y
_ALLOW_READ_ONL : allow read-only open even if database is corrupt
Y_CORRUPTION
_ALLOW_RESETLOG : allow resetlogs even if it will cause corruption
S_CORRUPTION
_ALLOW_TERMINAL : Finish terminal recovery even if it may cause
_RECOVERY_CORRU corruption
PTION
_ALL_SHARED_DBL : treat all dblinks as shared
INKS
_ALTERNATE_IOT_ : enable alternate index-organized table leaf-block
LEAF_BLOCK_SPLI split-points
T_POINTS
_ALTER_COMMON_U : allow local user to create objects in common schema
SER_SCHEMA
_ALWAYS_ANTI_JO : always use this method for anti-join when possible
IN
_ALWAYS_SEMI_JO : always use this method for semi-join when possible
IN
_ALWAYS_STAR_TR : always favor use of star transformation
ANSFORMATION
_AM_CONTAINER_F : allocation unit size for non-ASM containers
ILESYSTEM_AUSIZ
E
_AM_MAX_CONTAIN : maximum number of containers
ERS
_AM_MAX_GROUPS : maximum number of containers
_AM_MAX_SEG_BYT : maximum number of bytes per array segment
ES
_AM_TIMEOUTS_EN : enable timeouts
ABLED
_AM_TRACE_BUFFE : size of per-process I/O trace buffer
R_SIZE
_AND_PRUNING_EN : allow partition pruning based on multiple mechanisms
ABLED
_APPQOS_CDB_SET : QoSM CDB Performance Class Setting
TING
_APPQOS_PO_MULT : Multiplier for PC performance objective value
IPLIER
_APPQOS_QT : System Queue time retrieval interval
_AQSHARDED_CACH : Limit for cached enqueue/dequeue operations
E_LIMIT
_AQ_DISABLE_X : AQ – Disable new cross processes at an instance
_AQ_DQ_SESSIONS : Deq session count
_AQ_EQ_SESSIONS : Enq session count
_AQ_INIT_SHARDS : Minimum enqueue shards per queue at an instance
_AQ_MAX_SCAN_DE : Maximum allowable scan delay for AQ indexes and IOTs
LAY
_AQ_PRECRT_PART : Precreate Partitions
ITIONS
_AQ_PT_PROCESSE : Partition background processes
S
_AQ_STOP_BACKGR : Stop all AQ background processes
OUNDS
_AQ_SUBSHARD_SI : Sub Shard Size
ZE
_AQ_TM_DEQCOUNT : dequeue count interval for Time Managers to cleanup DEQ
INTERVAL IOT BLOCKS
_AQ_TM_SCANLIMI : scan limit for Time Managers to clean up IOT
T
_AQ_TM_STATISTI : statistics collection window duration
CS_DURATION
_ARCH_COMPRESSI : archive compression enabled
ON
_ARCH_COMPRESS_ : enable/disable row checksums for archive compressed
CHECKSUMS blocks
_ARCH_COMP_DBG_ : archive compression scan debug
SCAN
_ARCH_COMP_DEC_ : decompress archive compression blocks for checking and
BLOCK_CHECK_DUM dumping
P
_ARCH_IO_SLAVES : ARCH I/O slaves
_ARCH_SIM_MODE : Change behavior of local archiving
_ARRAY_CDB_VIEW : array mode enabled for CDB views
_ENABLED
_ARRAY_UPDATE_V : Enable array update vector read
ECTOR_READ_ENAB
LED
_ASH_COMPRESSIO : To enable or disable string compression in ASH
N_ENABLE
_ASH_DISK_FILTE : Ratio of the number of in-memory samples to the number
R_RATIO of samples actually written to disk
_ASH_DISK_WRITE : To enable or disable Active Session History flushing
_ENABLE
_ASH_DUMMY_TEST : Oracle internal dummy ASH parameter used ONLY for
_PARAM testing!
_ASH_EFLUSH_TRI : The percentage above which if the in-memory ASH is full
GGER the emergency flusher will be triggered
_ASH_ENABLE : To enable or disable Active Session sampling and
flushing
_ASH_MIN_MMNL_D : Minimum Time interval passed to consider MMNL Dump
UMP
_ASH_SAMPLE_ALL : To enable or disable sampling every connected session
including ones waiting for idle waits
_ASH_SAMPLING_I : Time interval between two successive Active Session
NTERVAL samples in millisecs
_ASH_SIZE : To set the size of the in-memory Active Session History
buffers
_ASMSID : ASM instance id
_ASM_ACCESS : ASM File access mechanism
_ASM_ACD_CHUNKS : initial ACD chunks created
_ASM_ADMIN_WITH : Does the sysdba role have administrative privileges on
_SYSDBA ASM?
_ASM_ALLOWDEGEN : Allow force-mounts of DGs w/o proper quorum
ERATEMOUNTS
_ASM_ALLOW_APPL : Allow DROP DISK/FAILUREGROUP NOFORCE on ASM Appliances
IANCE_DROPDISK_
NOFORCE
_ASM_ALLOW_LVM_ : Enable disk resilvering for external redundancy
RESILVERING
_ASM_ALLOW_ONLY : Discovery only raw devices
_RAW_DISKS
_ASM_ALLOW_SYST : if system alias renaming is allowed
EM_ALIAS_RENAME
_ASM_ALLOW_UNSA : attempt unsafe reconnect to ASM
FE_RECONNECT
_ASM_APPLIANCE_ : Appliance configuration file name
CONFIG_FILE
_ASM_AUSIZE : allocation unit size
_ASM_AUTOMATIC_ : automatically rebalance free space across zones
REZONE
_ASM_AVOID_PST_ : Avoid PST Scans
SCANS
_ASM_BLKSIZE : metadata block size
_ASM_CHECK_FOR_ : check for misbehaving CF-holding clients
MISBEHAVING_CF_
CLIENTS
_ASM_COMPATIBIL : default ASM compatibility level
ITY
_ASM_DBA_BATCH : ASM Disk Based Allocation Max Batch Size
_ASM_DBA_SPCCHK : ASM Disk Based Allocation Space Check Threshold
_THLD
_ASM_DBA_THRESH : ASM Disk Based Allocation Threshold
OLD
_ASM_DBMSDG_NOH : dbms_diskgroup.checkfile does not check block headers
DRCHK
_ASM_DIAG_DEAD_ : diagnostics for dead clients
CLIENTS
_ASM_DIRECT_CON : Expire time for idle direct connection to ASM instance
_EXPIRE_TIME
_ASM_DISABLE_AM : Disable AMDU dump
DU_DUMP
_ASM_DISABLE_AS : disable async intra-instance messaging
YNC_MSGS
_ASM_DISABLE_MU : Disable checking for multiple ASM instances on a given
LTIPLE_INSTANCE node
_CHECK
_ASM_DISABLE_PR : disable profile query for discovery
OFILEDISCOVERY
_ASM_DISABLE_SM : Do Not create smr
R_CREATION
_ASM_DISABLE_UF : disable ufg member kill
GMEMBERKILL
_ASM_DISABLE_UF : disable terminated umbilicus diagnostic
G_DUMP
_ASM_DISKERR_TR : Number of read/write errors per disk a process can
ACES trace
_ASM_DISKGROUPS : disk groups to mount automatically set 2
2
_ASM_DISKGROUPS : disk groups to mount automatically set 3
3
_ASM_DISKGROUPS : disk groups to mount automatically set 4
4
_ASM_DISK_REPAI : seconds to wait before dropping a failing disk
R_TIME
_ASM_EMULATE_NF : Emulate NFS disk test event
S_DISK
_ASM_EMULMAX : max number of concurrent disks to emulate I /O errors
_ASM_EMULTIMEOU : timeout before emulation begins (in 3s ticks)
T
_ASM_ENABLE_XRO : Enable XROV capability
V
_ASM_EVENREAD : ASM Even Read level
_ASM_EVENREAD_A : ASM Even Read Alpha
LPHA
_ASM_EVENREAD_A : ASM Even Read Second Alpha
LPHA2
_ASM_EVENREAD_F : ASM Even Read Fast Start Threshold
ASTSTART
_ASM_FAIL_RANDO : Randomly fail some RX enqueue gets
M_RX
_ASM_FOB_TAC_FR : Timeout frequency for FOB cleanup
EQUENCY
_ASM_FORCE_QUIE : Force diskgroup quiescing
SCE
_ASM_GLOBAL_DUM : System state dump level for ASM asserts
P_LEVEL
_ASM_HBEATIOWAI : number of secs to wait for PST Async Hbeat IO return
T
_ASM_HBEATWAITQ : quantum used to compute time-to-wait for a PST Hbeat
UANTUM check
_ASM_HEALTHCHEC : seconds until health check takes action
K_TIMEOUT
_ASM_IMBALANCE_ : hundredths of a percentage of inter-disk imbalance to
TOLERANCE tolerate
_ASM_INSTLOCK_Q : ASM Instance Lock Quota
UOTA
_ASM_IOSTAT_LAT : ASM I/O statistics latch count
CH_COUNT
_ASM_KFDPEVENT : KFDP event
_ASM_KILL_UNRES : kill unresponsive ASM clients
PONSIVE_CLIENTS
_ASM_LIBRARIES : library search order for discovery
_ASM_LOG_SCALE_ : Rebalance power uses logarithmic scale
REBALANCE
_ASM_LSOD_BUCKE : ASM lsod bucket size
T_SIZE
_ASM_MAXIO : Maximum size of individual I/O request
_ASM_MAX_COD_ST : maximum number of COD strides
RIDES
_ASM_MAX_REDO_B : asm maximum redo buffer size
UFFER_SIZE
_ASM_NETWORKS : ASM network subnet addresses
_ASM_NETWORK_TI : Keepalive timeout for ASM network connections
MEOUT
_ASM_NODEKILL_E : secs until escalating to nodekill if fence incomplete
SCALATE_TIME
_ASM_NOEVENREAD : List of disk groups having even read disabled
_DISKGROUPS
_ASM_PARTNER_TA : target maximum number of disk partners for repartnering
RGET_DISK_PART
_ASM_PARTNER_TA : target maximum number of failure group relationships
RGET_FG_REL for repartnering
_ASM_PRIMARY_LO : Number of cycles/extents to load for non-mirrored files
AD
_ASM_PRIMARY_LO : True if primary load is in cycles, false if extent
AD_CYCLES counts
_ASM_PROCS_TRAC : Number of processes allowed to trace a disk failure
E_DISKERR
_ASM_PROXY_STAR : Maximum time to wait for ASM proxy connection
TWAIT
_ASM_RANDOM_ZON : Random zones for new files
E
_ASM_REBALANCE_ : maximum rebalance work unit
PLAN_SIZE
_ASM_REBALANCE_ : number of out of space errors allowed before aborting
SPACE_ERRORS rebalance
_ASM_REMOTE_CLI : timeout before killing disconnected remote clients
ENT_TIMEOUT
_ASM_REPAIRQUAN : quantum (in 3s) used to compute elapsed time for disk
TUM drop
_ASM_RESERVE_SL : reserve ASM slaves for CF txns
AVES
_ASM_RESYNCCKPT : number of extents to resync before flushing checkpoint
_ASM_ROOT_DIREC : ASM default root directory
TORY
_ASM_RUNTIME_CA : runtime capability for volume support returns supported
PABILITY_VOLUME
_SUPPORT
_ASM_SCRUB_LIMI : ASM disk scrubbing power
T
_ASM_SECONDARY_ : Number of cycles/extents to load for mirrored files
LOAD
_ASM_SECONDARY_ : True if secondary load is in cycles, false if extent
LOAD_CYCLES counts
_ASM_SERIALIZE_ : Serialize volume rebalance
VOLUME_REBALANC
E
_ASM_SHADOW_CYC : Inverse shadow cycle requirement
LE
_ASM_SKIP_DISKV : skip client side discovery for disk revalidate
AL_CHECK
_ASM_SKIP_RENAM : skip the checking of the clients for s/w compatibility
E_CHECK for rename
_ASM_SKIP_RESIZ : skip the checking of the clients for s/w compatibility
E_CHECK for resize
_ASM_STORAGEMAY : PST Split Possible
SPLIT
_ASM_STRIPESIZE : ASM file stripe size
_ASM_STRIPEWIDT : ASM file stripe width
H
_ASM_SYNC_REBAL : Rebalance uses sync I/O
ANCE
_ASM_TRACE_LIMI : Time-out in milliseconds to reset the number of traces
T_TIMEOUT per disk and the number of processes allowed to trace
_ASM_USD_BATCH : ASM USD Update Max Batch Size
_ASM_WAIT_TIME : Max/imum time to wait before asmb exits
_ASSM_DEFAULT : ASSM default
_ASSM_FORCE_FET : enable metadata block fetching in ASSM segment scan
CHMETA
_ASSM_HIGH_GSP_ : Number of blocks rejected before growing segment
THRESHOLD
_ASSM_LOW_GSP_T : Number of blocks rejected before collecting stats
HRESHOLD
_ASYNC_RECOVERY : if TRUE, issue recovery claims asynchronously
_CLAIMS
_ASYNC_RECOVERY : if TRUE, issue recovery reads asynchronously
_READS
_ASYNC_TS_THRES : check tablespace thresholds asynchronously
HOLD
_AUTOMATIC_MAIN : Enable AUTOTASK Test Mode
TENANCE_TEST
_AUTOMEMORY_BRO : memory broker statistics gathering interval for auto
KER_INTERVAL memory
_AUTOTASK_MAX_W : Maximum Logical Maintenance Window Length in minutes
INDOW
_AUTOTASK_MIN_W : Minimum Maintenance Window Length in minutes
INDOW
_AUTOTASK_TEST_ : Name of current Autotask Test (or test step)
NAME
_AUTOTUNE_GTX_I : idle time to trigger auto-shutdown a gtx background
DLE_TIME process
_AUTOTUNE_GTX_I : interval to autotune global transaction background
NTERVAL processes
_AUTOTUNE_GTX_T : auto-tune threshold for degree of global transaction
HRESHOLD concurrency
_AUTO_ASSIGN_CG : auto assign CGs for sessions
_FOR_SESSIONS
_AUTO_BMR : enable/disable Auto BMR
_AUTO_BMR_BG_TI : Auto BMR Process Run Time
ME
_AUTO_BMR_FC_TI : Auto BMR Flood Control Time
ME
_AUTO_BMR_PUB_T : Auto BMR Publish Timeout
IMEOUT
_AUTO_BMR_REQ_T : Auto BMR Requester Timeout
IMEOUT
_AUTO_BMR_SESS_ : Auto BMR Request Session Threshold
THRESHOLD
_AUTO_BMR_SYS_T : Auto BMR Request System Threshold
HRESHOLD
_AUTO_MANAGE_EN : perodically check for OFFLINE disks and attempt to
ABLE_OFFLINE_CH ONLINE
ECK
_AUTO_MANAGE_EX : Automate Exadata disk management
ADATA_DISKS
_AUTO_MANAGE_IN : TEST: Set infrequent timeout action to run at this
FREQ_TOUT interval, unit is seconds
_AUTO_MANAGE_IO : oss_ioctl buffer size, to read and respond to cell
CTL_BUFSZ notifications
_AUTO_MANAGE_MA : Max. attempts to auto ONLINE an ASM disk
X_ONLINE_TRIES
_AUTO_MANAGE_NU : Max. number of out-standing msgs in the KXDAM pipe
M_PIPE_MSGS
_AUTO_MANAGE_NU : Num. tries before giving up on a automation operation
M_TRIES
_AUTO_MANAGE_ON : Allow Max. attempts to auto ONLINE an ASM disk after
LINE_TRIES_EXPI lapsing this time (unit in seconds)
RE_TIME
_AUX_DFC_KEEP_T : auxiliary datafile copy keep time in minutes
IME
_AVAILABLE_CORE : number of cores for this instance
_COUNT
_AVOID_PREPARE : if TRUE, do not prepare a buffer when the master is
local
_AWR_CDBPERF_TH : Setting for AWR CDBPERF Threshold
RESHOLD
_AWR_CORRUPT_MO : AWR Corrupt Mode
DE
_AWR_DISABLED_F : Disable flushing of specified AWR tables
LUSH_TABLES
_AWR_FLUSH_THRE : Enable/Disable Flushing AWR Threshold Metrics
SHOLD_METRICS
_AWR_FLUSH_WORK : Enable/Disable Flushing AWR Workload Metrics
LOAD_METRICS
_AWR_MMON_CPUUS : Enable/disable AWR MMON CPU Usage Tracking
AGE
_AWR_MMON_DEEP_ : Allows deep purge to purge AWR data for all expired
PURGE_ALL_EXPIR snapshots
ED
_AWR_MMON_DEEP_ : Set extent of rows to check each deep purge run
PURGE_EXTENT
_AWR_MMON_DEEP_ : Set interval for deep purge of AWR contents
PURGE_INTERVAL
_AWR_MMON_DEEP_ : Set max number of rows per table to delete each deep
PURGE_NUMROWS purge run
_AWR_PDB_REGIST : Parameter to enable/disable AWR PDB Registration
RATION_ENABLED
_AWR_REMOTE_TAR : AWR Remote Target DBLink for Flushing
GET_DBLINK
_AWR_RESTRICT_M : AWR Restrict Mode
ODE
_AWR_SQL_CHILD_ : Setting for AWR SQL Child Limit
LIMIT
_BACKUP_ALIGN_W : align backup write I/Os
RITE_IO
_BACKUP_AUTOMAT : automatic retry on backup write errors
IC_RETRY
_BACKUP_DISK_BU : number of buffers used for DISK channels
FCNT
_BACKUP_DISK_BU : size of buffers used for DISK channels
FSZ
_BACKUP_DISK_IO : BACKUP Disk I/O slaves
_SLAVES
_BACKUP_DYNAMIC : dynamically compute backup/restore buffer sizes
_BUFFERS
_BACKUP_ENCRYPT : specifies encryption block optimization mode
_OPT_MODE
_BACKUP_FILE_BU : number of buffers used for file access
FCNT
_BACKUP_FILE_BU : size of buffers used for file access
FSZ
_BACKUP_IO_POOL : memory to reserve from the large pool
_SIZE
_BACKUP_KGC_BLK : specifies buffer size to be used by HIGH compression
SIZ
_BACKUP_KGC_BUF : specifies buffer size to be used by BASIC compression
SZ
_BACKUP_KGC_MEM : specifies memory level for MEDIUM compression
LEVEL
_BACKUP_KGC_NIT : specifies number of iterations done by BASIC
ERS compression
_BACKUP_KGC_PER : specifies compression (performance) level for MEDIUM
FLEVEL compression
_BACKUP_KGC_SCH : specifies compression scheme
EME
_BACKUP_KGC_TYP : specifies compression type used by kgc BASIC
E compression
_BACKUP_KGC_WIN : specifies window size for MEDIUM compression
DOWBITS
_BACKUP_KSFQ_BU : number of buffers used for backup/restore
FCNT
_BACKUP_KSFQ_BU : maximum amount of memory (in bytes) used for buffers
FMEM_MAX for backup/restore
_BACKUP_KSFQ_BU : size of buffers used for backup/restore
FSZ
_BACKUP_LZO_SIZ : specifies buffer size for LOW compression
E
_BACKUP_MAX_GAP : largest gap in an incremental/optimized backup buffer,
_SIZE in bytes
_BACKUP_MIN_CT_ : mimimun size in bytes of change tracking to apply
UNUSED_OPTIM unused space optimuzation
_BACKUP_SEQ_BUF : number of buffers used for non-DISK channels
CNT
_BACKUP_SEQ_BUF : size of buffers used for non-DISK channels
SZ
_BCT_BITMAPS_PE : number of bitmaps to store for each datafile
R_FILE
_BCT_BUFFER_ALL : maximum size of all change tracking buffer allocations,
OCATION_MAX in bytes
_BCT_BUFFER_ALL : mininum number of extents to allocate per buffer
OCATION_MIN_EXT allocation
ENTS
_BCT_BUFFER_ALL : size of one change tracking buffer allocation, in bytes
OCATION_SIZE
_BCT_CHUNK_SIZE : change tracking datafile chunk size, in bytes
_BCT_CRASH_RESE : change tracking reserved crash recovery SGA space, in
RVE_SIZE bytes
_BCT_FILE_BLOCK : block size of change tracking file, in bytes
_SIZE
_BCT_FILE_EXTEN : extent size of change tracking file, in bytes
T_SIZE
_BCT_FIXTAB_FIL : change tracking file for fixed tables
E
_BCT_HEALTH_CHE : CTWR health check interval (seconds), zero to disable
CK_INTERVAL
_BCT_INITIAL_PR : initial number of entries in the private change
IVATE_DBA_BUFFE tracking dba buffers
R_SIZE
_BCT_MRP_TIMEOU : CTWR MRP wait timeout (seconds), zero to wait forever
T
_BCT_PUBLIC_DBA : allow dynamic resizing of public dba buffers, zero to
_BUFFER_DYNRESI disable
ZE
_BCT_PUBLIC_DBA : max buffer size permitted for public dba buffers, in
_BUFFER_MAXSIZE bytes
_BCT_PUBLIC_DBA : total size of all public change tracking dba buffers,
_BUFFER_SIZE in bytes
_BG_SPAWN_DIAG_ : background processes spawn diagnostic options
OPTS
_BITMAP_OR_IMPR : controls extensions to partition pruning for general
OVEMENT_ENABLED predicates
_BLOCKING_SESS_ : blocking session graph cache size in bytes
GRAPH_CACHE_SIZ
E
_BLOCKS_PER_CAC : number of consecutive blocks per global cache server
HE_SERVER
_BLOCK_LEVEL_OF : High Latency Threshold for Block Level Offload
FLOAD_HIGH_LAT_ operations
THRESH
_BLOCK_SAMPLE_R : controls readahead value during block sampling
EADAHEAD_PROB_T
HRESHOLD
_BLOOM_FILTER_D : debug level for bloom filtering
EBUG
_BLOOM_FILTER_E : enables or disables bloom filter
NABLED
_BLOOM_FILTER_S : bloom filter vector size (in KB)
IZE
_BLOOM_FOLDING_ : bloom filter folding density lower bound
DENSITY
_BLOOM_FOLDING_ : Enable folding of bloom filter
ENABLED
_BLOOM_FOLDING_ : bloom filter folding size lower bound (in KB)
MIN
_BLOOM_MAX_SIZE : maximum bloom filter size (in KB)
_BLOOM_MINMAX_E : enable or disable bloom min max filtering
NABLED
_BLOOM_PREDICAT : enables or disables bloom filter predicate pushdown
E_ENABLED
_BLOOM_PREDICAT : enables or disables bloom filter predicate offload to
E_OFFLOAD cells
_BLOOM_PRUNING_ : Enable partition pruning using bloom filtering
ENABLED
_BLOOM_PUSHING_ : bloom filter pushing size upper bound (in KB)
MAX
_BLOOM_PUSHING_ : bloom filter combined pushing size upper bound (in KB)
TOTAL_MAX
_BLOOM_RM_FILTE : remove bloom predicate in favor of zonemap join pruning
R predicate
_BLOOM_SM_ENABL : enable bloom filter optimization using slave mapping
ED
_BRANCH_TAGGING : enable branch tagging for distributed transaction
_BROADCAST_SCN_ : broadcast-on-commit scn mode
MODE
_BROADCAST_SCN_ : broadcast-on-commit scn wait timeout in centiseconds
WAIT_TIMEOUT
_BSLN_ADAPTIVE_ : Adaptive Thresholds Enabled
THRESHOLDS_ENAB
LED
_BT_MMV_QUERY_R : allow rewrites with multiple MVs and base tables
EWRITE_ENABLED
_BUFFERED_MESSA : Buffered message spill age
GE_SPILL_AGE
_BUFFERED_PUBLI : Flow control threshold for buffered publishers except
SHER_FLOW_CONTR capture
OL_THRESHOLD
_BUFFER_BUSY_WA : buffer busy wait time in centiseconds
IT_TIMEOUT
_BUFQ_STOP_FLOW : Stop enforcing flow control for buffered queues
_CONTROL
_BUILD_DEFERRED : DEFERRED MV creation skipping MV log setup update
_MV_SKIPPING_MV
LOG_UPDATE
_BUMP_HIGHWATER : how many blocks should we allocate per free list on
_MARK_COUNT advancing HWM
_BWR_FOR_FLUSHE : if TRUE, generate a BWR for a flushed PI
D_PI
_BYPASS_SRL_FOR : bypass SRL for S/O EOR logs
_SO_EOR
_BYPASS_XPLATFO : bypass datafile header cross-platform-compliance errors
RM_ERROR
_B_TREE_BITMAP_ : enable the use of bitmap plans for tables w. only
PLANS B-tree indexes
_CACHE_ORL_DURI : cache online logs
NG_OPEN
_CACHE_STATS_MO : if TRUE, enable cache stats monitoring
NITOR
_CAPTURE_BUFFER : To set the size of the PGA I/O recording buffers
_SIZE
_CAPTURE_PUBLIS : Flow control threshold for capture publishers
HER_FLOW_CONTRO
L_THRESHOLD
_CASE_SENSITIVE : case sensitive logon enabled
_LOGON
_CAUSAL_STANDBY : Causal standby wait timeout
_WAIT_TIMEOUT
_CDB_COMPATIBLE : CDB Compatible
_CDB_RAC_AFFINI : rac affinity for parallel cdb operations
TY
_CDC_SUBSCRIPTI : Change Data Capture subscription_owner
ON_OWNER
_CDMP_DIAGNOSTI : cdmp directory diagnostic level
C_LEVEL
_CELL_FAST_FILE : Allow optimized file creation path for Cells
_CREATE
_CELL_FAST_FILE : Allow optimized rman restore for Cells
_RESTORE
_CELL_FILE_FORM : Cell file format chunk size in MB
AT_CHUNK_SIZE
_CELL_INDEX_SCA : enable CELL processing of index FFS
N_ENABLED
_CELL_MATERIALI : Force materialization of all offloadable expressions on
ZE_ALL_EXPRESSI the cells
ONS
_CELL_MATERIALI : enable offload of expressions underlying virtual
ZE_VIRTUAL_COLU columns to cells
MNS
_CELL_OBJECT_EX : flashcache object expiration timeout
PIRATION_HOURS
_CELL_OFFLOAD_C : specifies capability table to load
APABILITIES_ENA
BLED
_CELL_OFFLOAD_C : enable complex SQL processing offload to cells
OMPLEX_PROCESSI
NG
_CELL_OFFLOAD_E : enable offload of expressions to cells
XPRESSIONS
_CELL_OFFLOAD_H : Query offloading of hybrid columnar compressed tables
YBRIDCOLUMNAR to exadata
_CELL_OFFLOAD_P : enable out-of-order SQL processing offload to cells
REDICATE_REORDE
RING_ENABLED
_CELL_OFFLOAD_S : enable offload of SYS_CONTEXT evaluation to cells
YS_CONTEXT
_CELL_OFFLOAD_T : enable timezone related SQL processing offload to cells
IMEZONE
_CELL_OFFLOAD_V : enable offload of predicates on virtual columns to
IRTUAL_COLUMNS cells
_CELL_RANGE_SCA : enable CELL processing of index range scans
N_ENABLED
_CELL_STORIDX_M : Cell Storage Index mode
ODE
_CGS_ALLGROUP_P : CGS DBALL group polling interval in milli-seconds
OLL_TIME
_CGS_COMM_READI : CGS communication readiness check
NESS_CHECK
_CGS_DBALL_GROU : CGS DBALL group registration type
P_REGISTRATION
_CGS_DBGROUP_PO : CGS DB group polling interval in milli-seconds
LL_TIME
_CGS_HEALTH_CHE : CGS health check during reconfiguration
CK_IN_RECONFIG
_CGS_MEMBERKILL : allow a RIM instance to issue a CSS member kill
_FROM_RIM_INSTA
NCE
_CGS_MSG_BATCHI : CGS message batching
NG
_CGS_MSG_BATCH_ : CGS message batch size in bytes
SIZE
_CGS_NODE_KILL_ : CGS node kill escalation to CSS
ESCALATION
_CGS_NODE_KILL_ : CGS wait time to escalate node kill to CSS in seconds
ESCALATION_WAIT
_CGS_RECONFIG_E : CGS reconfiguration extra wait time for CSS in seconds
XTRA_WAIT
_CGS_RECONFIG_T : CGS reconfiguration timeout interval
IMEOUT
_CGS_SEND_TIMEO : CGS send timeout value
UT
_CGS_TICKETS : CGS messaging tickets
_CGS_TICKET_SEN : CGS ticket active sendback percentage threshold
DBACK
_CGS_ZOMBIE_MEM : CGS zombie member kill wait time in seconds
BER_KILL_WAIT
_CHANGE_VECTOR_ : Number of change vector buffers for media recovery
BUFFERS
_CHECK_BLOCK_AF : perform block check after checksum if both are turned
TER_CHECKSUM on
_CHECK_BLOCK_NE : check block new invariant for flashback
W_INVARIANT_FOR
_FLASHBACK
_CHECK_COLUMN_L : check column length
ENGTH
_CHECK_PDBID_IN : Enable checking of pluggable database ID in redo
_REDO
_CHECK_TS_THRES : check tablespace thresholds
HOLD
_CLEANOUT_SHRCU : if TRUE, cleanout shrcur buffers
R_BUFFERS
_CLEANUP_ROLLBA : no. of undo entries to apply per transaction cleanup
CK_ENTRIES
_CLEANUP_TIMEOU : timeout value for PMON cleanup
T
_CLEANUP_TIMEOU : flags for PMON cleanup timeout
T_FLAGS
_CLEAR_BUFFER_B : Always zero-out buffer before reuse for security
EFORE_REUSE
_CLIENT_ENABLE_ : enable automatic unregister after a send fails with
AUTO_UNREGISTER timeout
_CLIENT_NTFN_CL : interval after which dead client registration cleanup
EANUP_INTERVAL task repeats
_CLIENT_NTFN_PI : time between pings to unreachable notification clients
NGINTERVAL
_CLIENT_NTFN_PI : number of times to ping unreachable notification
NGRETRIES clients
_CLIENT_NTFN_PI : timeout to connect to unreachable notification clients
NGTIMEOUT
_CLIENT_RESULT_ : bypass the client result cache
CACHE_BYPASS
_CLIENT_TSTZ_ER : Should Client give error for suspect Timestamp with
ROR_CHECK Timezone operations
_CLI_CACHEBKTAL : Percentage of memory to allocate
LOC
_CLONE_ONE_PDB_ : Recover ROOT and only one PDB in clone database
RECOVERY
_CLOSE_CACHED_O : close cursors cached by PL/SQL at each commit
PEN_CURSORS
_CLOSE_DEQ_BY_C : Close Dequeue By Condition Cursors
OND_CURS
_CLOUD_NAME : gsm cloud name
_CLUSTERWIDE_GL : enable/disable clusterwide global transactions
OBAL_TRANSACTIO
NS
_CLUSTER_LIBRAR : cluster library selection
Y
_COLLAPSE_WAIT_ : collapse wait history
HISTORY
_COLLECT_TEMPUN : Collect Statistics v$tempundostat
DO_STATS
_COLLECT_UNDO_S : Collect Statistics v$undostat
TATS
_COLUMN_COMPRES : Column compression ratio
SION_FACTOR
_COLUMN_ELIMINA : turn off predicate-only column elimination
TION_OFF
_COLUMN_TRACKIN : column usage tracking
G_LEVEL
_COMMON_DATA_VI : common objects returned through dictionary views
EW_ENABLED
_COMMON_USER_PR : Enforce restriction on a prefix of a Common
EFIX User/Role/Profile name
_COMPILATION_CA : Size of the compilation call heaps extents
LL_HEAP_EXTENT_
SIZE
_COMPLEX_VIEW_M : enable complex view merging
ERGING
_COMPRESSION_AB : number of recompression above cache for sanity check
OVE_CACHE
_COMPRESSION_AD : Compression advisor
VISOR
_COMPRESSION_CH : percentage of chained rows allowed for Compression
AIN
_COMPRESSION_CO : Compression compatability
MPATIBILITY
_CONCURRENCY_CH : what is the chosen value of concurrency
OSEN
_CONNECTION_BRO : connection broker host for listen address
KER_HOST
_CONNECT_BY_USE : use union all for connect by
_UNION_ALL
_CONTROLFILE_AU : time delay (in seconds) for performing controlfile
TOBACKUP_DELAY autobackups
_CONTROLFILE_BA : enable check of the copied blocks during controlfile
CKUP_COPY_CHECK backup copy
_CONTROLFILE_BL : control file block size in bytes
OCK_SIZE
_CONTROLFILE_CE : Flash cache hint for control file accesses
LL_FLASH_CACHIN
G
_CONTROLFILE_EN : dump the system states after controlfile enqueue
QUEUE_DUMP timeout
_CONTROLFILE_EN : control file enqueue max holding time in seconds
QUEUE_HOLDING_T
IME
_CONTROLFILE_EN : control file enqueue holding time tracking size
QUEUE_HOLDING_T
IME_TRACKING_SI
ZE
_CONTROLFILE_EN : control file enqueue timeout in seconds
QUEUE_TIMEOUT
_CONTROLFILE_SE : control file initial section size
CTION_INIT_SIZE
_CONTROLFILE_SE : control file max expansion rate
CTION_MAX_EXPAN
D
_CONTROLFILE_UP : controlfile update sanity check
DATE_CHECK
_CONVERT_SET_TO : enables conversion of set operator to join
_JOIN
_COORD_MESSAGE_ : parallel recovery coordinator side extra message buffer
BUFFER size
_CORRUPTED_ROLL : corrupted undo segment list
BACK_SEGMENTS
_COST_EQUALITY_ : enables costing of equality semi-join
SEMI_JOIN
_CPU_EFF_THREAD : CPU effective thread multiplier
_MULTIPLIER
_CPU_TO_IO : divisor for converting CPU cost to I/O cost
_CP_NUM_HASH_LA : connection pool number of hash latches
TCHES
_CRASH_DOMAIN_O : allow domain to exit for exceptions in any thread
N_EXCEPTION
_CREATE_STAT_SE : create ilm statistics segment
GMENT
_CREATE_TABLE_I : allow creation of table in a cluster not owned by the
N_ANY_CLUSTER user
_CR_GRANT_GLOBA : if TRUE, grant lock for CR requests when block is in
L_ROLE global role
_CR_GRANT_LOCAL : turn 3-way CR grants off, make it automatic, or turn it
_ROLE on
_CR_GRANT_ONLY : if TRUE, grant locks when possible and do not send the
block
_CR_SERVER_LOG_ : if TRUE, flush redo log before serving a CR buffer
FLUSH
_CR_TRC_BUF_SIZ : size of cr trace buffer
E
_CTX_DOC_POLICY : enable ctx_doc.policy_stems api
_STEMS
_CURSOR_BIND_CA : maximum size of the cursor bind capture area
PTURE_AREA_SIZE
_CURSOR_BIND_CA : interval (in seconds) between two bind capture for a
PTURE_INTERVAL cursor
_CURSOR_CACHE_T : number of seconds a session cached cursor stay in
IME cache.
_CURSOR_DB_BUFF : additional number of buffers a cursor can pin at once
ERS_PINNED
_CURSOR_FEATURE : Shared cursor features enabled bits.
S_ENABLED
_CURSOR_OBSOLET : Number of cursors per parent before obsoletion.
E_THRESHOLD
_CURSOR_PLAN_EN : enable collection and display of cursor plans
ABLED
_CURSOR_PLAN_HA : version of cursor plan hash value
SH_VERSION
_CURSOR_PLAN_UN : enables/disables using unparse to build
PARSE_ENABLED projection/predicates
_CURSOR_RELOAD_ : Number of failed reloads before marking cursor unusable
FAILURE_THRESHO
LD
_CURSOR_RUNTIME : Shared cursor runtime heap memory limit
HEAP_MEMLIMIT
_CURSOR_STATS_E : Enable cursor stats
NABLED
_CU_ROW_LOCKING : CU row level locking
_CVMAP_BUFFERS : Number of change vector buffers for multi instance
media recovery
_CVW_ENABLE_WEA : enable weak view checking
K_CHECKING
_DATAFILE_COW : Use copy on write snapshot for the renamed file
_DATAFILE_WRITE : datafile write errors crash instance
_ERRORS_CRASH_I
NSTANCE
_DATAPUMP_COMPR : specifies buffer size for BASIC compression algorithm
ESSBAS_BUFFER_S
IZE
_DATAPUMP_METAD : specifies buffer size for metadata file I/O
ATA_BUFFER_SIZE
_DATAPUMP_TABLE : specifies buffer size for table data file I/O
DATA_BUFFER_SIZ
E
_DATA_TRANSFER_ : Percentange * 100 of buffer cache to transfer to data
CACHE_BC_PERC_X transfer cache
100
_DATA_TRANSFER_ : Size of data transfer cache
CACHE_SIZE
_DATA_WAREHOUSI : if TRUE, enable data warehousing scan buffers
NG_SCAN_BUFFERS
_DBFS_MODIFY_IM : DBFS Link allows implicit fetch on modify – only on
PLICIT_FETCH SecureFiles
_DBG_PROC_START : debug process startup
UP
_DBG_SCAN : generic scan debug
_DBMS_SQL_SECUR : Security level in DBMS_SQL
ITY_LEVEL
_DBOP_ENABLED : Any positive number enables automatic DBOP monitoring.
0 is disabled
_DBPOOL_NAME : gsm database pool name
_DBRM_DYNAMIC_T : DBRM dynamic threshold setting
HRESHOLD
_DBRM_NUM_RUNNA : Resource Manager number of runnable list per NUMA node
BLE_LIST
_DBRM_QUANTUM : DBRM quantum
_DBRM_RUNCHK : Resource Manager Diagnostic Running Thread Check
_DBRM_SHORT_WAI : Resource Manager short wait length
T_US
_DBWR_ASYNC_IO : Enable dbwriter asynchronous writes
_DBWR_SCAN_INTE : dbwriter scan interval
RVAL
_DBWR_TRACING : Enable dbwriter tracing
_DB_16K_FLASH_C : flash cache file for 16k block size
ACHE_FILE
_DB_16K_FLASH_C : flash cache size for _db_16k_flash_cache_file
ACHE_SIZE
_DB_2K_FLASH_CA : flash cache file for 2k block size
CHE_FILE
_DB_2K_FLASH_CA : flash cache size for _db_2k_flash_cache_file
CHE_SIZE
_DB_32K_FLASH_C : flash cache file for 32k block size
ACHE_FILE
_DB_32K_FLASH_C : flash cache size for _db_32k_flash_cache_file
ACHE_SIZE
_DB_4K_FLASH_CA : flash cache file for 4k block size
CHE_FILE
_DB_4K_FLASH_CA : flash cache size for _db_4k_flash_cache_file
CHE_SIZE
_DB_8K_FLASH_CA : flash cache file for 8k block size
CHE_FILE
_DB_8K_FLASH_CA : flash cache size for _db_8k_flash_cache_file
CHE_SIZE
_DB_AGING_COOL_ : Touch count set when buffer cooled
COUNT
_DB_AGING_FREEZ : Make CR buffers always be too cold to keep in cache
E_CR
_DB_AGING_HOT_C : Touch count which sends a buffer to head of replacement
RITERIA list
_DB_AGING_STAY_ : Touch count set when buffer moved to head of
COUNT replacement list
_DB_AGING_TOUCH : Touch count which sends a buffer to head of replacement
_TIME list
_DB_ALWAYS_CHEC : Always perform block check and checksum for System
K_SYSTEM_TS tablespace
_DB_BLOCKS_PER_ : Number of blocks per hash latch
HASH_LATCH
_DB_BLOCK_ADJCH : adjacent cache buffer checks – low blkchk overwrite
ECK parameter
_DB_BLOCK_ADJCH : adjacent cache buffer check level
K_LEVEL
_DB_BLOCK_ALIGN : Align Direct Reads
_DIRECT_READ
_DB_BLOCK_BAD_W : enable bad write checks
RITE_CHECK
_DB_BLOCK_BUFFE : Number of database blocks cached in memory: hidden
RS parameter
_DB_BLOCK_CACHE : Always clone data blocks on get (for debugging)
_CLONE
_DB_BLOCK_CACHE : buffer header tracing (non-zero only when debugging)
_HISTORY
_DB_BLOCK_CACHE : buffer header tracing level
_HISTORY_LEVEL
_DB_BLOCK_CACHE : buffer header tracing for lru operations
_HISTORY_LRU
_DB_BLOCK_CACHE : number of unmapped buffers (for tracking swap calls on
_NUM_UMAP blocks)
_DB_BLOCK_CACHE : protect database blocks (true only when debugging)
_PROTECT
_DB_BLOCK_CACHE : protect database blocks (for strictly internal use
_PROTECT_INTERN only)
AL
_DB_BLOCK_CHECK : Check more and dump block before image for debugging
_FOR_DEBUG
_DB_BLOCK_CHECK : check objd and typ on cache disk read
_OBJTYP
_DB_BLOCK_CHUNK : chunkify noncontig multi block reads
IFY_NCMBR
_DB_BLOCK_CORRU : threshold number of block recovery attempts
PTION_RECOVERY_
THRESHOLD
_DB_BLOCK_DO_FU : do full block read even if some blocks are in cache
LL_MBREADS
_DB_BLOCK_HASH_ : Number of database block hash buckets
BUCKETS
_DB_BLOCK_HASH_ : Number of database block hash latches
LATCHES
_DB_BLOCK_HEADE : number of extra buffer headers to use as guard pages
R_GUARD_LEVEL
_DB_BLOCK_HI_PR : Fraction of writes for high priority reasons
IORITY_BATCH_SI
ZE
_DB_BLOCK_KNOWN : Initial Percentage of buffers to maintain known clean
_CLEAN_PCT
_DB_BLOCK_LRU_L : number of lru latches
ATCHES
_DB_BLOCK_MAX_C : Maximum Allowed Number of CR buffers per dba
R_DBA
_DB_BLOCK_MAX_S : Percentage of buffers to inspect when looking for free
CAN_PCT
_DB_BLOCK_MED_P : Fraction of writes for medium priority reasons
RIORITY_BATCH_S
IZE
_DB_BLOCK_NUMA : Number of NUMA nodes
_DB_BLOCK_PREFE : Batched IO enable fast longjumps
TCH_FAST_LONGJU
MPS_ENABLED
_DB_BLOCK_PREFE : Prefetch limit in blocks
TCH_LIMIT
_DB_BLOCK_PREFE : Prefetch force override in blocks
TCH_OVERRIDE
_DB_BLOCK_PREFE : Batched IO enable private cache
TCH_PRIVATE_CAC
HE_ENABLED
_DB_BLOCK_PREFE : Prefetch quota as a percent of cache size
TCH_QUOTA
_DB_BLOCK_PREFE : Batched IO enable skip reading buffers
TCH_SKIP_READIN
G_ENABLED
_DB_BLOCK_PREFE : Allowed wasted percent threshold of prefetched size
TCH_WASTED_THRE
SHOLD_PERC
_DB_BLOCK_TABLE : Size of shared table scan read buffer
_SCAN_BUFFER_SI
ZE
_DB_BLOCK_TEMP_ : generate redo for temp blocks
REDO
_DB_BLOCK_TRACE : trace buffer protect calls
_PROTECT
_DB_BLOCK_VLM_C : check of rvlm mapping leaks (for debugging)
HECK
_DB_BLOCK_VLM_L : Threshold for allowable vlm leaks
EAK_THRESHOLD
_DB_CACHE_ADVIC : cache advisory maximum multiple of current size to
E_MAX_SIZE_FACT similate
OR
_DB_CACHE_ADVIC : cache advisory sampling factor
E_SAMPLE_FACTOR
_DB_CACHE_ADVIC : cache simulation sanity check
E_SANITY_CHECK
_DB_CACHE_BLOCK : dump short call stack for block reads
_READ_STACK_TRA
CE
_DB_CACHE_CRX_C : check for costly crx examination functions
HECK
_DB_CACHE_MISS_ : check LEs after cache miss
CHECK_LES
_DB_CACHE_MMAN_ : check for wait latch get under MMAN ops in kcb
LATCH_CHECK
_DB_CACHE_PRE_W : Buffer Cache Pre-Warm Enabled : hidden parameter
ARM
_DB_CACHE_PROCE : maximum number of cr pins a process may have
SS_CR_PIN_MAX
_DB_CACHE_WAIT_ : trace new kslwaits
DEBUG
_DB_CHANGE_NOTI : enable db change notification
FICATION_ENABLE
_DB_CHECK_CELL_ :
HINTS
_DB_DISABLE_TEM : Disable Temp Encryption for Spills
P_ENCRYPTION
_DB_DUMP_FROM_D : dump contents from disk and efc
ISK_AND_EFC
_DB_DW_SCAN_ADA : if TRUE, enable adaptive DW scan cooling
PTIVE_COOLING
_DB_DW_SCAN_MAX : DW Scan adaptive cooling max shadow count
_SHADOW_COUNT
_DB_DW_SCAN_OBJ : DW Scan object cooling factor to cool all temperatures
_COOLING_FACTOR
_DB_DW_SCAN_OBJ : DW Scan object cooling interval in number of scans,
_COOLING_INTERV seconds, or pct of cache size
AL
_DB_DW_SCAN_OBJ : DW scan objtect cooling policy
_COOLING_POLICY
_DB_DW_SCAN_OBJ : DW Scan object warming increment when an object is
_WARMING_INCREM scanned
ENT
_DB_FAST_OBJ_CH : enable fast object drop sanity check
ECK
_DB_FAST_OBJ_CK : enable fast object checkpoint
PT
_DB_FAST_OBJ_TR : enable fast object truncate
UNCATE
_DB_FILE_DIRECT : Sequential I/O buf size
_IO_COUNT
_DB_FILE_EXEC_R : multiblock read count for regular clients
EAD_COUNT
_DB_FILE_FORMAT : Block formatting I/O buf count
_IO_BUFFERS
_DB_FILE_NONCON : number of noncontiguous db blocks to be prefetched
TIG_MBLOCK_READ
_COUNT
_DB_FILE_OPTIMI : multiblock read count for regular clients
ZER_READ_COUNT
_DB_FLASHBACK_I : Flashback IO Buffer Size
OBUF_SIZE
_DB_FLASHBACK_L : Minimum flashback database log size in bytes
OG_MIN_SIZE
_DB_FLASHBACK_L : Minimum flashback database log total space in bytes
OG_MIN_TOTAL_SP
ACE
_DB_FLASHBACK_N : Flashback Number of IO buffers
UM_IOBUF
_DB_FLASH_CACHE : Flash cache force replenish lower limit in buffers
_FORCE_REPLENIS
H_LIMIT
_DB_FLASH_CACHE : Flash cache keep buffer upper limit in percentage
_KEEP_LIMIT
_DB_FLASH_CACHE : Flash cache maximum latency allowed in 10 milliseconds
_MAX_LATENCY
_DB_FLASH_CACHE : Flash cache maximum outstanding writes allowed
_MAX_OUTSTANDIN
G_WRITES
_DB_FLASH_CACHE : Flash cache max read retry
_MAX_READ_RETRY
_DB_FLASH_CACHE : Flash cache maximum slow io allowed
_MAX_SLOW_IO
_DB_FLASH_CACHE : Flash cache write buffer upper limit in percentage
_WRITE_LIMIT
_DB_HANDLES : System-wide simultaneous buffer operations
_DB_HANDLES_CAC : Buffer handles cached each process
HED
_DB_HOT_BLOCK_T : track hot blocks for hash latch contention
RACKING
_DB_INDEX_BLOCK : index block checking override parameter
_CHECKING
_DB_INITIAL_CAC : size of cache created at startup
HESIZE_CREATE_M
B
_DB_L2_TRACING : flash cache debug tracing
_DB_LARGE_DIRTY : Number of buffers which force dirty queue to be written
_QUEUE
_DB_LOST_WRITE_ : Enable scn based lost write detection mechanism
CHECKING
_DB_LOST_WRITE_ : Enable _db_lost_write_checking tracing
TRACING
_DB_MTTR_ADVICE : MTTR advisory
_DB_MTTR_PARTIT : number of partitions for MTTR advisory
IONS
_DB_MTTR_SAMPLE : MTTR simulation sampling factor
_FACTOR
_DB_MTTR_SIM_TA : MTTR simulation targets
RGET
_DB_MTTR_SIM_TR : MTTR simulation trace size
ACE_SIZE
_DB_MTTR_TRACE_ : dump trace entries to alert file
TO_ALERT
_DB_NOARCH_DISB : Image redo logging (NOARCHIVEMODE)
LE_OPTIM
_DB_NUM_EVICT_W : number of evict wait events
AITEVENTS
_DB_NUM_GSM : database number in gsm dbpool
_DB_OBJ_ENABLE_ : enable ksr in object checkpoint/reuse
KSR
_DB_PERCENT_HOT : Percent of default buffer pool considered hot
_DEFAULT
_DB_PERCENT_HOT : Percent of keep buffer pool considered hot
_KEEP
_DB_PERCENT_HOT : Percent of recycle buffer pool considered hot
_RECYCLE
_DB_PERCPU_CREA : size of cache created per cpu in deferred cache create
TE_CACHESIZE
_DB_PREFETCH_HI : maintain prefetch histogram statistics in x$kcbprfhs
STOGRAM_STATIST
ICS
新闻标题:Oracle12c版本中未归档隐藏参数有哪些
本文路径:http://pwwzsj.com/article/pjdpip.html