DOCUMENTED PARAMETERS IN 12c

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:

Home

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

 

——————-

 

2 thoughts on “DOCUMENTED PARAMETERS IN 12c

Your comments and suggestions are welcome!