12C的参数介绍

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