In this post, I will give a list of all (367) documented 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,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 (367) documented 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
————— ——————————————————-
ACTIVE_INSTANCE : number of active instances in the cluster database
_COUNT
AQ_TM_PROCESSES : number of AQ Time Managers to start
ARCHIVE_LAG_TAR : Maximum number of seconds of redos the standby could
GET lose
ASM_DISKGROUPS : disk groups to mount automatically
ASM_DISKSTRING : disk set locations for discovery
ASM_POWER_LIMIT : number of parallel relocations for disk rebalancing
ASM_PREFERRED_R : preferred read failure groups
EAD_FAILURE_GRO
UPS
AUDIT_FILE_DEST : Directory in which auditing files are to reside
AUDIT_SYSLOG_LE : Syslog facility and level
VEL
AUDIT_SYS_OPERA : enable sys auditing
TIONS
AUDIT_TRAIL : enable system auditing
AWR_SNAPSHOT_TI : Setting for AWR Snapshot Time Offset
ME_OFFSET
BACKGROUND_CORE : Core Size for Background Processes
_DUMP
BACKGROUND_DUMP : Detached process dump directory
_DEST
BACKUP_TAPE_IO_ : BACKUP Tape I/O slaves
SLAVES
BITMAP_MERGE_AR : maximum memory allow for BITMAP MERGE
EA_SIZE
BLANK_TRIMMING : blank trimming semantics parameter
BUFFER_POOL_KEE : Number of database blocks/latches in keep buffer pool
P
BUFFER_POOL_REC : Number of database blocks/latches in recycle buffer
YCLE pool
CELL_OFFLOADGRO : Set the offload group name
UP_NAME
CELL_OFFLOAD_CO : Cell packet compaction strategy
MPACTION
CELL_OFFLOAD_DE : enable SQL processing offload of encrypted data to
CRYPTION cells
CELL_OFFLOAD_PA : Additional cell offload parameters
RAMETERS
CELL_OFFLOAD_PL : Cell offload explain plan display
AN_DISPLAY
CELL_OFFLOAD_PR : enable SQL processing offload to cells
OCESSING
CIRCUITS : max number of circuits
CLIENT_RESULT_C : client result cache maximum lag in milliseconds
ACHE_LAG
CLIENT_RESULT_C : client result cache max size in bytes
ACHE_SIZE
CLONEDB : clone database
CLUSTER_DATABAS : if TRUE startup in cluster database mode
E
CLUSTER_DATABAS : number of instances to use for sizing cluster db SGA
E_INSTANCES structures
CLUSTER_INTERCO : interconnects for RAC use
NNECTS
COMMIT_LOGGING : transaction commit log write behaviour
COMMIT_POINT_ST : Bias this node has toward not preparing in a two-phase
RENGTH commit
COMMIT_WAIT : transaction commit log wait behaviour
COMMIT_WRITE : transaction commit log write behaviour
COMPATIBLE : Database will be completely compatible with this
software version
CONNECTION_BROK : connection brokers specification
ERS
CONTROL_FILES : control file names list
CONTROL_FILE_RE : control file record keep time in days
CORD_KEEP_TIME
CONTROL_MANAGEM : declares which manageability packs are enabled
ENT_PACK_ACCESS
CORE_DUMP_DEST : Core dump directory
CPU_COUNT : number of CPUs for this instance
CREATE_BITMAP_A : size of create bitmap buffer for bitmap index
REA_SIZE
CREATE_STORED_O : create stored outlines for DML statements
UTLINES
CURSOR_BIND_CAP : Allowed destination for captured bind variables
TURE_DESTINATIO
N
CURSOR_SHARING : cursor sharing mode
CURSOR_SPACE_FO : use more memory in order to get faster execution
R_TIME
DBWR_IO_SLAVES : DBWR I/O slaves
DB_16K_CACHE_SI : Size of cache for 16K buffers
ZE
DB_2K_CACHE_SIZ : Size of cache for 2K buffers
E
DB_32K_CACHE_SI : Size of cache for 32K buffers
ZE
DB_4K_CACHE_SIZ : Size of cache for 4K buffers
E
DB_8K_CACHE_SIZ : Size of cache for 8K buffers
E
DB_BIG_TABLE_CA : Big table cache target size in percentage
CHE_PERCENT_TAR
GET
DB_BLOCK_BUFFER : Number of database blocks cached in memory
S
DB_BLOCK_CHECKI : header checking and data and index block checking
NG
DB_BLOCK_CHECKS : store checksum in db blocks and check during reads
UM
DB_BLOCK_SIZE : Size of database block in bytes
DB_CACHE_ADVICE : Buffer cache sizing advisory
DB_CACHE_SIZE : Size of DEFAULT buffer pool for standard block size
buffers
DB_CREATE_FILE_ : default database location
DEST
DB_CREATE_ONLIN : online log/controlfile destination #1
E_LOG_DEST_1
DB_CREATE_ONLIN : online log/controlfile destination #2
E_LOG_DEST_2
DB_CREATE_ONLIN : online log/controlfile destination #3
E_LOG_DEST_3
DB_CREATE_ONLIN : online log/controlfile destination #4
E_LOG_DEST_4
DB_CREATE_ONLIN : online log/controlfile destination #5
E_LOG_DEST_5
DB_DOMAIN : directory part of global database name stored with
CREATE DATABASE
DB_FILES : max allowable # db files
DB_FILE_MULTIBL : db block to be read each IO
OCK_READ_COUNT
DB_FILE_NAME_CO : datafile name convert patterns and strings for
NVERT standby/clone db
DB_FLASHBACK_RE : Maximum Flashback Database log retention time in
TENTION_TARGET minutes.
DB_FLASH_CACHE_ : flash cache file for default block size
FILE
DB_FLASH_CACHE_ : flash cache size for db_flash_cache_file
SIZE
DB_INDEX_COMPRE : options for table or tablespace level compression
SSION_INHERITAN inheritance
CE
DB_KEEP_CACHE_S : Size of KEEP buffer pool for standard block size
IZE buffers
DB_LOST_WRITE_P : enable lost write detection
ROTECT
DB_NAME : database name specified in CREATE DATABASE
DB_RECOVERY_FIL : default database recovery file location
E_DEST
DB_RECOVERY_FIL : database recovery files size limit
E_DEST_SIZE
DB_RECYCLE_CACH : Size of RECYCLE buffer pool for standard block size
E_SIZE buffers
DB_SECUREFILE : permit securefile storage during lob creation
DB_ULTRA_SAFE : Sets defaults for other parameters that control
protection levels
DB_UNIQUE_NAME : Database Unique Name
DB_UNRECOVERABL : Track nologging SCN in controlfile
E_SCN_TRACKING
DB_WRITER_PROCE : number of background database writer processes to
SSES start
DDL_LOCK_TIMEOU : timeout to restrict the time that ddls wait for dml
T lock
DEFERRED_SEGMEN : defer segment creation to first insert
T_CREATION
DG_BROKER_CONFI : data guard broker configuration file #1
G_FILE1
DG_BROKER_CONFI : data guard broker configuration file #2
G_FILE2
DG_BROKER_START : start Data Guard broker (DMON process)
DIAGNOSTIC_DEST : diagnostic base directory
DISK_ASYNCH_IO : Use asynch I/O for random access devices
DISPATCHERS : specifications of dispatchers
DISTRIBUTED_LOC : number of seconds a distributed transaction waits for a
K_TIMEOUT lock
DML_LOCKS : dml locks – one for each table modified in a
transaction
DNFS_BATCH_SIZE : Max number of dNFS asynch I/O requests queued per
session
DST_UPGRADE_INS : Enables/Disables internal conversions during DST
ERT_CONV upgrade
ENABLE_DDL_LOGG : enable ddl logging
ING
ENABLE_PLUGGABL : Enable Pluggable Database
E_DATABASE
EVENT : debug event control – default null string
FAL_CLIENT : FAL client
FAL_SERVER : FAL server list
FAST_START_IO_T : Upper bound on recovery reads
ARGET
FAST_START_MTTR : MTTR target in seconds
_TARGET
FAST_START_PARA : max number of parallel recovery slaves that may be used
LLEL_ROLLBACK
FILEIO_NETWORK_ : Network Adapters for File I/O
ADAPTERS
FILESYSTEMIO_OP : IO operations on filesystem files
TIONS
FILE_MAPPING : enable file mapping
FIXED_DATE : fixed SYSDATE value
GCS_SERVER_PROC : number of background gcs server processes to start
ESSES
GLOBAL_CONTEXT_ : Global Application Context Pool Size in Bytes
POOL_SIZE
GLOBAL_NAMES : enforce that database links have same name as remote
database
GLOBAL_TXN_PROC : number of background global transaction processes to
ESSES start
HASH_AREA_SIZE : size of in-memory hash work area
HEAT_MAP : ILM Heatmap Tracking
HI_SHARED_MEMOR : SGA starting address (high order 32-bits on 64-bit
Y_ADDRESS platforms)
HS_AUTOREGISTER : enable automatic server DD updates in HS agent
self-registration
IFILE : include file in init.ora
INSTANCE_GROUPS : list of instance group names
INSTANCE_NAME : instance name supported by the instance
INSTANCE_NUMBER : instance number
INSTANCE_TYPE : type of instance to be executed
JAVA_JIT_ENABLE : Java VM JIT enabled
D
JAVA_MAX_SESSIO : max allowed size in bytes of a Java sessionspace
NSPACE_SIZE
JAVA_POOL_SIZE : size in bytes of java pool
JAVA_SOFT_SESSI : warning limit on size in bytes of a Java sessionspace
ONSPACE_LIMIT
JOB_QUEUE_PROCE : maximum number of job queue slave processes
SSES
LARGE_POOL_SIZE : size in bytes of large pool
LDAP_DIRECTORY_ : RDBMS’s LDAP access option
ACCESS
LDAP_DIRECTORY_ : OID usage parameter
SYSAUTH
LICENSE_MAX_SES : maximum number of non-system user sessions allowed
SIONS
LICENSE_MAX_USE : maximum number of named users that can be created in
RS the database
LICENSE_SESSION : warning level for number of non-system user sessions
S_WARNING
LISTENER_NETWOR : listener registration networks
KS
LOCAL_LISTENER : local listener
LOCK_NAME_SPACE : lock name space used for generating lock names for
standby/clone database
LOCK_SGA : Lock entire SGA in physical memory
LOG_ARCHIVE_CON : log archive config parameter
FIG
LOG_ARCHIVE_DES : archival destination text string
T
LOG_ARCHIVE_DES : archival destination #1 text string
T_1
LOG_ARCHIVE_DES : archival destination #10 text string
T_10
LOG_ARCHIVE_DES : archival destination #11 text string
T_11
LOG_ARCHIVE_DES : archival destination #12 text string
T_12
LOG_ARCHIVE_DES : archival destination #13 text string
T_13
LOG_ARCHIVE_DES : archival destination #14 text string
T_14
LOG_ARCHIVE_DES : archival destination #15 text string
T_15
LOG_ARCHIVE_DES : archival destination #16 text string
T_16
LOG_ARCHIVE_DES : archival destination #17 text string
T_17
LOG_ARCHIVE_DES : archival destination #18 text string
T_18
LOG_ARCHIVE_DES : archival destination #19 text string
T_19
LOG_ARCHIVE_DES : archival destination #2 text string
T_2
LOG_ARCHIVE_DES : archival destination #20 text string
T_20
LOG_ARCHIVE_DES : archival destination #21 text string
T_21
LOG_ARCHIVE_DES : archival destination #22 text string
T_22
LOG_ARCHIVE_DES : archival destination #23 text string
T_23
LOG_ARCHIVE_DES : archival destination #24 text string
T_24
LOG_ARCHIVE_DES : archival destination #25 text string
T_25
LOG_ARCHIVE_DES : archival destination #26 text string
T_26
LOG_ARCHIVE_DES : archival destination #27 text string
T_27
LOG_ARCHIVE_DES : archival destination #28 text string
T_28
LOG_ARCHIVE_DES : archival destination #29 text string
T_29
LOG_ARCHIVE_DES : archival destination #3 text string
T_3
LOG_ARCHIVE_DES : archival destination #30 text string
T_30
LOG_ARCHIVE_DES : archival destination #31 text string
T_31
LOG_ARCHIVE_DES : archival destination #4 text string
T_4
LOG_ARCHIVE_DES : archival destination #5 text string
T_5
LOG_ARCHIVE_DES : archival destination #6 text string
T_6
LOG_ARCHIVE_DES : archival destination #7 text string
T_7
LOG_ARCHIVE_DES : archival destination #8 text string
T_8
LOG_ARCHIVE_DES : archival destination #9 text string
T_9
LOG_ARCHIVE_DES : archival destination #1 state text string
T_STATE_1
LOG_ARCHIVE_DES : archival destination #10 state text string
T_STATE_10
LOG_ARCHIVE_DES : archival destination #11 state text string
T_STATE_11
LOG_ARCHIVE_DES : archival destination #12 state text string
T_STATE_12
LOG_ARCHIVE_DES : archival destination #13 state text string
T_STATE_13
LOG_ARCHIVE_DES : archival destination #14 state text string
T_STATE_14
LOG_ARCHIVE_DES : archival destination #15 state text string
T_STATE_15
LOG_ARCHIVE_DES : archival destination #16 state text string
T_STATE_16
LOG_ARCHIVE_DES : archival destination #17 state text string
T_STATE_17
LOG_ARCHIVE_DES : archival destination #18 state text string
T_STATE_18
LOG_ARCHIVE_DES : archival destination #19 state text string
T_STATE_19
LOG_ARCHIVE_DES : archival destination #2 state text string
T_STATE_2
LOG_ARCHIVE_DES : archival destination #20 state text string
T_STATE_20
LOG_ARCHIVE_DES : archival destination #21 state text string
T_STATE_21
LOG_ARCHIVE_DES : archival destination #22 state text string
T_STATE_22
LOG_ARCHIVE_DES : archival destination #23 state text string
T_STATE_23
LOG_ARCHIVE_DES : archival destination #24 state text string
T_STATE_24
LOG_ARCHIVE_DES : archival destination #25 state text string
T_STATE_25
LOG_ARCHIVE_DES : archival destination #26 state text string
T_STATE_26
LOG_ARCHIVE_DES : archival destination #27 state text string
T_STATE_27
LOG_ARCHIVE_DES : archival destination #28 state text string
T_STATE_28
LOG_ARCHIVE_DES : archival destination #29 state text string
T_STATE_29
LOG_ARCHIVE_DES : archival destination #3 state text string
T_STATE_3
LOG_ARCHIVE_DES : archival destination #30 state text string
T_STATE_30
LOG_ARCHIVE_DES : archival destination #31 state text string
T_STATE_31
LOG_ARCHIVE_DES : archival destination #4 state text string
T_STATE_4
LOG_ARCHIVE_DES : archival destination #5 state text string
T_STATE_5
LOG_ARCHIVE_DES : archival destination #6 state text string
T_STATE_6
LOG_ARCHIVE_DES : archival destination #7 state text string
T_STATE_7
LOG_ARCHIVE_DES : archival destination #8 state text string
T_STATE_8
LOG_ARCHIVE_DES : archival destination #9 state text string
T_STATE_9
LOG_ARCHIVE_DUP : duplex archival destination text string
LEX_DEST
LOG_ARCHIVE_FOR : archival destination format
MAT
LOG_ARCHIVE_LOC : Establish EXPEDITE attribute default value
AL_FIRST
LOG_ARCHIVE_MAX : maximum number of active ARCH processes
_PROCESSES
LOG_ARCHIVE_MIN : minimum number of archive destinations that must
_SUCCEED_DEST succeed
LOG_ARCHIVE_STA : start archival process on SGA initialization
RT
LOG_ARCHIVE_TRA : Establish archivelog operation tracing level
CE
LOG_BUFFER : redo circular buffer size
LOG_CHECKPOINTS : log checkpoint begin/end to alert file
_TO_ALERT
LOG_CHECKPOINT_ : # redo blocks checkpoint threshold
INTERVAL
LOG_CHECKPOINT_ : Maximum time interval between checkpoints in seconds
TIMEOUT
LOG_FILE_NAME_C : logfile name convert patterns and strings for
ONVERT standby/clone db
MAX_DISPATCHERS : max number of dispatchers
MAX_DUMP_FILE_S : Maximum size (in bytes) of dump file
IZE
MAX_ENABLED_ROL : max number of roles a user can have enabled
ES
MAX_SHARED_SERV : max number of shared servers
ERS
MAX_STRING_SIZE : controls maximum size of VARCHAR2, NVARCHAR2, and RAW
types in SQL
MEMORY_MAX_TARG : Max size for Memory Target
ET
MEMORY_TARGET : Target size of Oracle SGA and PGA memory
NLS_CALENDAR : NLS calendar system name
NLS_COMP : NLS comparison
NLS_CURRENCY : NLS local currency symbol
NLS_DATE_FORMAT : NLS Oracle date format
NLS_DATE_LANGUA : NLS date language name
GE
NLS_DUAL_CURREN : Dual currency symbol
CY
NLS_ISO_CURRENC : NLS ISO currency territory name
Y
NLS_LANGUAGE : NLS language name
NLS_LENGTH_SEMA : create columns using byte or char semantics by default
NTICS
NLS_NCHAR_CONV_ : NLS raise an exception instead of allowing implicit
EXCP conversion
NLS_NUMERIC_CHA : NLS numeric characters
RACTERS
NLS_SORT : NLS linguistic definition name
NLS_TERRITORY : NLS territory name
NLS_TIMESTAMP_F : time stamp format
ORMAT
NLS_TIMESTAMP_T : timestamp with timezone format
Z_FORMAT
NLS_TIME_FORMAT : time format
NLS_TIME_TZ_FOR : time with timezone format
MAT
NONCDB_COMPATIB : Non-CDB Compatible
LE
O7_DICTIONARY_A : Version 7 Dictionary Accessibility Support
CCESSIBILITY
OBJECT_CACHE_MA : percentage of maximum size over optimal of the user
X_SIZE_PERCENT session’s object cache
OBJECT_CACHE_OP : optimal size of the user session’s object cache in
TIMAL_SIZE bytes
OLAP_PAGE_POOL_ : size of the olap page pool in bytes
SIZE
OPEN_CURSORS : max # cursors per session
OPEN_LINKS : max # open links per session
OPEN_LINKS_PER_ : max # open links per instance
INSTANCE
OPTIMIZER_ADAPT : controls adaptive features
IVE_FEATURES
OPTIMIZER_ADAPT : use reporting-only mode for adaptive optimizations
IVE_REPORTING_O
NLY
OPTIMIZER_CAPTU : automatic capture of SQL plan baselines for repeatable
RE_SQL_PLAN_BAS statements
ELINES
OPTIMIZER_DYNAM : optimizer dynamic sampling
IC_SAMPLING
OPTIMIZER_FEATU : optimizer plan compatibility parameter
RES_ENABLE
OPTIMIZER_INDEX : optimizer percent index caching
_CACHING
OPTIMIZER_INDEX : optimizer index cost adjustment
_COST_ADJ
OPTIMIZER_MODE : optimizer mode
OPTIMIZER_SECUR : optimizer secure view merging and predicate
E_VIEW_MERGING pushdown/movearound
OPTIMIZER_USE_I : Usage of invisible indexes (TRUE/FALSE)
NVISIBLE_INDEXE
S
OPTIMIZER_USE_P : Control whether to use optimizer pending statistics
ENDING_STATISTI
CS
OPTIMIZER_USE_S : use of SQL plan baselines for captured sql statements
QL_PLAN_BASELIN
ES
OS_AUTHENT_PREF : prefix for auto-logon accounts
IX
OS_ROLES : retrieve roles from the operating system
PARALLEL_ADAPTI : enable adaptive setting of degree for multiple user
VE_MULTI_USER streams
PARALLEL_AUTOMA : enable intelligent defaults for parallel execution
TIC_TUNING parameters
PARALLEL_DEGREE : adjust the computed degree in percentage
_LEVEL
PARALLEL_DEGREE : limit placed on degree of parallelism
_LIMIT
PARALLEL_DEGREE : policy used to compute the degree of parallelism
_POLICY (MANUAL/LIMITED/AUTO/ADAPTIVE)
PARALLEL_EXECUT : message buffer size for parallel execution
ION_MESSAGE_SIZ
E
PARALLEL_FAULT_ : enables or disables fault-tolerance for parallel
TOLERANCE_ENABL statement
ED
PARALLEL_FORCE_ : force single instance execution
LOCAL
PARALLEL_INSTAN : instance group to use for all parallel operations
CE_GROUP
PARALLEL_IO_CAP : enable capping DOP by IO bandwidth
_ENABLED
PARALLEL_MAX_SE : maximum parallel query servers per instance
RVERS
PARALLEL_MIN_PE : minimum percent of threads required for parallel query
RCENT
PARALLEL_MIN_SE : minimum parallel query servers per instance
RVERS
PARALLEL_MIN_TI : threshold above which a plan is a candidate for
ME_THRESHOLD parallelization (in seconds)
PARALLEL_SERVER : if TRUE startup in parallel server mode
PARALLEL_SERVER : instance target in terms of number of parallel servers
S_TARGET
PARALLEL_SERVER : number of instances to use for sizing OPS SGA
_INSTANCES structures
PARALLEL_THREAD : number of parallel execution threads per CPU
S_PER_CPU
PDB_FILE_NAME_C : PDB file name convert patterns and strings for create
ONVERT cdb/pdb
PERMIT_92_WRAP_ : allow 9.2 or older wrap format in PL/SQL
FORMAT
PGA_AGGREGATE_L : limit of aggregate PGA memory consumed by the instance
IMIT
PGA_AGGREGATE_T : Target size for the aggregate PGA memory consumed by
ARGET the instance
PLSCOPE_SETTING : plscope_settings controls the compile time collection,
S cross reference, and storage of PL/SQL source code
identifier data
PLSQL_CCFLAGS : PL/SQL ccflags
PLSQL_CODE_TYPE : PL/SQL code-type
PLSQL_DEBUG : PL/SQL debug
PLSQL_OPTIMIZE_ : PL/SQL optimize level
LEVEL
PLSQL_V2_COMPAT : PL/SQL version 2.x compatibility flag
IBILITY
PLSQL_WARNINGS : PL/SQL compiler warnings settings
PRE_PAGE_SGA : pre-page sga for process
PROCESSES : user processes
PROCESSOR_GROUP : Name of the processor group that this instance should
_NAME run in.
QUERY_REWRITE_E : allow rewrite of queries using materialized views if
NABLED enabled
QUERY_REWRITE_I : perform rewrite using materialized views with desired
NTEGRITY integrity
RDBMS_SERVER_DN : RDBMS’s Distinguished Name
READ_ONLY_OPEN_ : if TRUE delay opening of read only files until first
DELAYED access
RECOVERY_PARALL : number of server processes to use for parallel recovery
ELISM
RECYCLEBIN : recyclebin processing
REDO_TRANSPORT_ : Data Guard transport user when using password file
USER
REMOTE_DEPENDEN : remote-procedure-call dependencies mode parameter
CIES_MODE
REMOTE_LISTENER : remote listener
REMOTE_LOGIN_PA : password file usage parameter
SSWORDFILE
REMOTE_OS_AUTHE : allow non-secure remote clients to use auto-logon
NT accounts
REMOTE_OS_ROLES : allow non-secure remote clients to use os roles
REPLICATION_DEP : tracking dependency for Replication parallel
ENDENCY_TRACKIN propagation
G
RESOURCE_LIMIT : master switch for resource limit
RESOURCE_MANAGE : Resource Manager CPU allocation
R_CPU_ALLOCATIO
N
RESOURCE_MANAGE : resource mgr top plan
R_PLAN
RESULT_CACHE_MA : maximum result size as percent of cache size
X_RESULT
RESULT_CACHE_MA : maximum amount of memory to be used by the cache
X_SIZE
RESULT_CACHE_MO : result cache operator usage mode
DE
RESULT_CACHE_RE : maximum life time (min) for any result using a remote
MOTE_EXPIRATION object
RESUMABLE_TIMEO : set resumable_timeout
UT
ROLLBACK_SEGMEN : undo segment list
TS
SEC_CASE_SENSIT : case sensitive password enabled for logon
IVE_LOGON
SEC_MAX_FAILED_ : maximum number of failed login attempts on a connection
LOGIN_ATTEMPTS
SEC_PROTOCOL_ER : TTC protocol error continue action
ROR_FURTHER_ACT
ION
SEC_PROTOCOL_ER : TTC protocol error action
ROR_TRACE_ACTIO
N
SEC_RETURN_SERV : whether the server retruns the complete version
ER_RELEASE_BANN information
ER
SERIAL_REUSE : reuse the frame segments
SERVICE_NAMES : service names supported by the instance
SESSIONS : user and system sessions
SESSION_CACHED_ : Number of cursors to cache in a session.
CURSORS
SESSION_MAX_OPE : maximum number of open files allowed per session
N_FILES
SGA_MAX_SIZE : max total SGA size
SGA_TARGET : Target size of SGA
SHADOW_CORE_DUM : Core Size for Shadow Processes
P
SHARED_MEMORY_A : SGA starting address (low order 32-bits on 64-bit
DDRESS platforms)
SHARED_POOL_RES : size in bytes of reserved area of shared pool
ERVED_SIZE
SHARED_POOL_SIZ : size in bytes of shared pool
E
SHARED_SERVERS : number of shared servers to start up
SHARED_SERVER_S : max number of shared server sessions
ESSIONS
SKIP_UNUSABLE_I : skip unusable indexes if set to TRUE
NDEXES
SMTP_OUT_SERVER : utl_smtp server and port configuration parameter
SORT_AREA_RETAI : size of in-memory sort work area retained between fetch
NED_SIZE calls
SORT_AREA_SIZE : size of in-memory sort work area
SPATIAL_VECTOR_ : enable spatial vector acceleration
ACCELERATION
SPFILE : server parameter file
SQL92_SECURITY : require select privilege for searched update/delete
SQLTUNE_CATEGOR : Category qualifier for applying hintsets
Y
SQL_TRACE : enable SQL trace
STANDBY_ARCHIVE : standby database archivelog destination text string
_DEST
STANDBY_FILE_MA : if auto then files are created/dropped automatically on
NAGEMENT standby
STAR_TRANSFORMA : enable the use of star transformation
TION_ENABLED
STATISTICS_LEVE : statistics level
L
STREAMS_POOL_SI : size in bytes of the streams pool
ZE
TAPE_ASYNCH_IO : Use asynch I/O requests for tape devices
TEMP_UNDO_ENABL : is temporary undo enabled
ED
THREAD : Redo thread to mount
THREADED_EXECUT : Threaded Execution Mode
ION
TIMED_OS_STATIS : internal os statistic gathering interval in seconds
TICS
TIMED_STATISTIC : maintain internal timing statistics
S
TRACEFILE_IDENT : trace file custom identifier
IFIER
TRACE_ENABLED : enable in memory tracing
TRANSACTIONS : max. number of concurrent active transactions
TRANSACTIONS_PE : number of active transactions per rollback segment
R_ROLLBACK_SEGM
ENT
UNDO_MANAGEMENT : instance runs in SMU mode if TRUE, else in RBU mode
UNDO_RETENTION : undo retention in seconds
UNDO_TABLESPACE : use/switch undo tablespace
UNIFIED_AUDIT_S : Size of Unified audit SGA Queue
GA_QUEUE_SIZE
USER_DUMP_DEST : User process dump directory
USE_DEDICATED_B : Use dedicated connection broker
ROKER
USE_INDIRECT_DA : Enable indirect data buffers (very large SGA on 32-bit
TA_BUFFERS platforms)
USE_LARGE_PAGES : Use large pages if available (TRUE/FALSE/ONLY)
UTL_FILE_DIR : utl_file accessible directories list
WORKAREA_SIZE_P : policy used to size SQL working areas (MANUAL/AUTO)
OLICY
XML_DB_EVENTS : are XML DB events enabled
367 rows selected.
References: Oracle Documentation
——————————————————————–
Related Links:
Database Index
Oracle 12c Index
12c: SQL Management Base Stores Plan Rows too
New SPfile Parameters In Oracle Database 12.2.0.1
Parameters Deprecated in 12c
Undocumented Parameters in 12c
——————-
what does documented mean to us here ? Supported parameters or deprecated .
The query lists all the documented parameters – supported as well as deprecated.
Pls refer to following post for deprecated parameters:
http://oracleinaction.com/deprecated-parameters-in-12c/
regards
Anju