Initialization Parameters

ORACLE SQL 10G Pour les Nuls
Commandes SQL pour DBA & Développeurs

Liste des parametres d'initialisation d'une Instance Oracle répertorié par catégorie fonctionnelle.

SQL> SELECT * FROM V$PARAMETER;

PARAMETERS	DESCRIPTIONS
Sauvegarde et restauration
BACKUP_TAPE_IO_SLAVES	Backup Tape I/O Slaves
RECYCLEBIN	Recyclebin Processing
TAPE_ASYNCH_IO	Use Asynch I/O Requests For Tape Devices
BFILES Binary Files
SESSION_MAX_OPEN_FILES	Maximum Number Of Open Files Allowed Per Session
Buffer Cache and I/O
DB_BLOCK_BUFFERS	Number Of Database Blocks Cached In Memory
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_FILE_MULTIBLOCK_READ_COUNT	Db Block To Be Read Each Io
DB_KEEP_CACHE_SIZE	Size Of Keep Buffer Pool For Standard Block Size Buffers
DB_RECYCLE_CACHE_SIZE	Size Of Recycle Buffer Pool For Standard Block Size Buffers
DB_WRITER_PROCESSES	Number Of Background Database Writer Processes To Start
DBWR_IO_SLAVES	Dbwr I/O Slaves
DISK_ASYNCH_IO	Use Asynch I/O For Random Access Devices
FILESYSTEMIO_OPTIONS	Io Operations On Filesystem Files
READ_ONLY_OPEN_DELAYED	If True Delay Opening Of Read Only Files Until First Access
USE_INDIRECT_DATA_BUFFERS	Enable Indirect Data Buffers (Very Large Sga On 32-Bit Platforms)
Cursors and Library Cache
CURSOR_SHARING	Cursor Sharing Mode
CURSOR_SPACE_FOR_TIME	Use More Memory In Order To Get Faster Execution
OPEN_CURSORS	Max # Cursors Per Session
SESSION_CACHED_CURSORS	Number Of Cursors To Cache In A Session.
Identification Instance
DB_NAME	Database Name Specified In Create Database
DB_DOMAIN	Directory Part Of Global Database Name Stored With Create Database
INSTANCE_NAME	Instance Name Supported By The Instance
Diagnostics et statistiques
BACKGROUND_CORE_DUMP	Core Size For Background Processes
BACKGROUND_DUMP_DEST	Detached Process Dump Directory
CORE_DUMP_DEST	Core Dump Directory
DB_BLOCK_CHECKING	Header Checking And Data And Index Block Checking
DB_BLOCK_CHECKSUM	Store Checksum In Db Blocks And Check During Reads
EVENT	Debug Event Control - Default Null String
MAX_DUMP_FILE_SIZE	Maximum Size (Blocks) Of Dump File
SHADOW_CORE_DUMP	Core Size For Shadow Processes
STATISTICS_LEVEL	Statistics Level
TIMED_OS_STATISTICS	Internal Os Statistic Gathering Interval In Seconds
TIMED_STATISTICS	Maintain Internal Timing Statistics
TRACEFILE_IDENTIFIER	Trace File Custom Identifier
TRACE_ENABLED	Enable Kst Tracing
USER_DUMP_DEST	User Process Dump Directory
Replication / Distributed
COMMIT_POINT_STRENGTH	Bias This Node Has Toward Not Preparing In A Two-Phase Commit
DISTRIBUTED_LOCK_TIMEOUT	Number Of Seconds A Distributed Transaction Waits For A Lock
GLOBAL_NAMES	Enforce That Database Links Have Same Name As Remote Database
HS_AUTOREGISTER	Enable Automatic Server Dd Updates In Hs Agent Self-Registration
OPEN_LINKS	Max # Open Links Per Session
OPEN_LINKS_PER_INSTANCE	Max # Open Links Per Instance
REPLICATION_DEPENDENCY_TRACKING	Tracking Dependency For Replication Parallel Propagation
Emplacements fichiers, noms, tailles
AUDIT_FILE_DEST	Directory In Which Auditing Files Are To Reside
BACKGROUND_CORE_DUMP	Core Size For Background Processes
BACKGROUND_DUMP_DEST	Detached Process Dump Directory
CORE_DUMP_DEST	Core Dump Directory
CONTROL_FILES	Control File Names List
DB_CREATE_FILE_DEST	Default Database Location
DB_CREATE_ONLINE_LOG_DEST_n	Online Log/Controlfile Destination #n
DB_FILES	Max Allowable # Db Files
DB_RECOVERY_FILE_DEST	Default Database Recovery File Location
DB_RECOVERY_FILE_DEST_SIZE	Database Recovery Files Size Limit
FILE_MAPPING	Enable File Mapping
LOG_ARCHIVE_DEST_n	Archival Destination #n Text String
SPFILE	Server Parameter File
Globalization
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_LANGUAGE	Nls Date Language Name
NLS_DUAL_CURRENCY	Dual Currency Symbol
NLS_ISO_CURRENCY	Nls Iso Currency Territory Name
NLS_LANGUAGE	Nls Language Name
NLS_LENGTH_SEMANTICS	Create Columns Using Byte Or Char Semantics By Default
NLS_NCHAR_CONV_EXCP	Nls Raise An Exception Instead Of Allowing Implicit Conversion
NLS_NUMERIC_CHARACTERS	Nls Numeric Characters
NLS_SORT	Nls Linguistic Definition Name
NLS_TERRITORY	Nls Territory Name
NLS_TIMESTAMP_FORMAT	Time Stamp Format
NLS_TIMESTAMP_TZ_FORMAT	Timestampe With Timezone Format
NLS_TIME_FORMAT	Time Format
NLS_TIME_TZ_FORMAT	Time With Timezone Format
Java
JAVA_MAX_SESSIONSPACE_SIZE	Max Allowed Size In Bytes Of A Java Sessionspace
JAVA_POOL_SIZE	Size In Bytes Of Java Pool
JAVA_SOFT_SESSIONSPACE_LIMIT	Warning Limit On Size In Bytes Of A Java Sessionspace
Job Queues
JOB_QUEUE_PROCESSES	Number Of Job Queue Slave Processes
License Limits
LICENSE_MAX_SESSIONS	Maximum Number Of Non-System User Sessions Allowed
LICENSE_MAX_USERS	Maximum Number Of Named Users That Can Be Created In The Database
LICENSE_SESSIONS_WARNING	Warning Level For Number Of Non-System User Sessions
Mémoire
LARGE_POOL_SIZE	Size In Bytes Of Large Pool
SHARED_POOL_RESERVED_SIZE	Size In Bytes Of Reserved Area Of Shared Pool
SHARED_POOL_SIZE	Size In Bytes Of Shared Pool
DIVERS
AQ_TM_PROCESSES	Number Of Aq Time Managers To Start
COMPATIBLE	Database Will Be Completely Compatible With This Software Version
FIXED_DATE	Fixed Sysdate Value
Réseaux
LOCAL_LISTENER	Local Listener
REMOTE_LISTENER	Remote Listener
SERVICE_NAMES	Service Names Supported By The Instance
Objects and LOBs
OBJECT_CACHE_MAX_SIZE_PERCENT	Percentage Of Maximum Size Over Optimal Of The User Session'S Object Cache
OBJECT_CACHE_OPTIMAL_SIZE	Optimal Size Of The User Session'S Object Cache In Bytes
OLAP
OLAP_PAGE_POOL_SIZE	Size Of The Olap Page Pool In Bytes
Optimizer
OPTIMIZER_DYNAMIC_SAMPLING	Optimizer Dynamic Sampling
OPTIMIZER_FEATURES_ENABLE	Optimizer Plan Compatibility Parameter
OPTIMIZER_INDEX_CACHING	Optimizer Percent Index Caching
OPTIMIZER_INDEX_COST_ADJ	Optimizer Index Cost Adjustment
OPTIMIZER_MODE	Optimizer Mode
OPTIMIZER_SECURE_VIEW_MERGING	Optimizer Secure View Merging And Predicate Pushdown/Movearound
QUERY_REWRITE_ENABLED	Allow Rewrite Of Queries Using Materialized Views If Enabled
QUERY_REWRITE_INTEGRITY	Perform Rewrite Using Materialized Views With Desired Integrity
STAR_TRANSFORMATION_ENABLED	Enable The Use Of Star Transformation
Parallel Execution
PARALLEL_ADAPTIVE_MULTI_USER	Enable Adaptive Setting Of Degree For Multiple User Streams
PARALLEL_EXECUTION_MESSAGE_SIZE	Message Buffer Size For Parallel Execution
PARALLEL_INSTANCE_GROUP	Instance Group To Use For All Parallel Operations
PARALLEL_MAX_SERVERS	Maximum Parallel Query Servers Per Instance
PARALLEL_MIN_PERCENT	Minimum Percent Of Threads Required For Parallel Query
PARALLEL_MIN_SERVERS	Minimum Parallel Query Servers Per Instance
PARALLEL_THREADS_PER_CPU	Number Of Parallel Execution Threads Per Cpu
PL/SQL
PLSQL_NATIVE_LIBRARY_DIR	Plsql Native Library Dir
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT	Plsql Native Library Number Of Subdirectories
PLSQL_V2_COMPATIBILITY	Pl/Sql Version 2.X Compatibility Flag
REMOTE_DEPENDENCIES_MODE	Remote-Procedure-Call Dependencies Mode Parameter
UTL_FILE_DIR	Utl_File Accessible Directories List
PL/SQL Compiler
PLSQL_CCFLAGS	Pl/Sql Ccflags
PLSQL_CODE_TYPE	Pl/Sql Code-Type
PLSQL_DEBUG	Pl/Sql Debug
PLSQL_OPTIMIZE_LEVEL	Pl/Sql Optimize Level
PLSQL_WARNINGS	Pl/Sql Compiler Warnings Settings
SGA Memory
DB_nK_CACHE_SIZE	Size Of Cache For nk Buffers
DB_CACHE_ADVICE	Buffer Cache Sizing Advisory
DB_CACHE_SIZE	Size Of Default Buffer Pool For Standard Block Size Buffers
HI_SHARED_MEMORY_ADDRESS	Sga Starting Address (High Order 32-Bits On 64-Bit Platforms)
JAVA_POOL_SIZE	Size In Bytes Of Java Pool
LOCK_SGA	Lock Entire Sga In Physical Memory
OLAP_PAGE_POOL_SIZE	Size Of The Olap Page Pool In Bytes
PGA_AGGREGATE_TARGET	Target Size For The Aggregate Pga Memory Consumed By The Instance
PRE_PAGE_SGA	Pre-Page Sga For Process
SGA_MAX_SIZE	Max Total Sga Size
SHARED_MEMORY_ADDRESS	Sga Starting Address (Low Order 32-Bits On 64-Bit Platforms)
Real Application Clusters
ACTIVE_INSTANCE_COUNT	Number Of Active Instances In The Cluster Database
CLUSTER_DATABASE	If True Startup In Cluster Database Mode
CLUSTER_DATABASE_INSTANCES	Number Of Instances To Use For Sizing Cluster Db Sga Structures
CLUSTER_INTERCONNECTS	Interconnects For Rac Use
GC_FILES_TO_LOCKS	Mapping Between File Numbers And Global Cache Locks
INSTANCE_GROUPS	List Of Instance Group Names
INSTANCE_NUMBER	Instance Number
MAX_COMMIT_PROPAGATION_DELAY	Max Age Of New Snapshot In .01 Seconds (Obsolete)
PARALLEL_INSTANCE_GROUP	Instance Group To Use For All Parallel Operations
THREAD	Redo Thread To Mount
Redo Logs, Archiving, and Recovery
CONTROL_FILE_RECORD_KEEP_TIME	Control File Record Keep Time In Days
DB_CREATE_ONLINE_LOG_DEST_n	Online Log/Controlfile Destination #n
DB_RECOVERY_FILE_DEST	Default Database Recovery File Location
DB_RECOVERY_FILE_DEST_SIZE	Database Recovery Files Size Limit
FAST_START_MTTR_TARGET	Mttr Target Of Forward Crash Recovery In Seconds
LOG_BUFFER	Redo Circular Buffer Size
LOG_CHECKPOINT_INTERVAL	# Redo Blocks Checkpoint Threshold
LOG_CHECKPOINT_TIMEOUT	Maximum Time Interval Between Checkpoints In Seconds
LOG_CHECKPOINTS_TO_ALERT	Log Checkpoint Begin/End To Alert File
LOG_ARCHIVE_CONFIG	Log Archive Config Parameter
LOG_ARCHIVE_DEST_n	Archival Destination #n Text String
LOG_ARCHIVE_DEST_STATE_n	Archival Destination #n State Text String
LOG_ARCHIVE_DUPLEX_DEST	Duplex Archival Destination Text String
LOG_ARCHIVE_FORMAT	Archival Destination Format
LOG_ARCHIVE_MAX_PROCESSES	Maximum Number Of Active Arch Processes
LOG_ARCHIVE_MIN_SUCCEED_DEST	Minimum Number Of Archive Destinations That Must Succeed
LOG_ARCHIVE_TRACE	Establish Archivelog Operation Tracing Level
RECOVERY_PARALLELISM	Number Of Server Processes To Use For Parallel Recovery
Resource Manager
RESOURCE_LIMIT	Master Switch For Resource Limit
RESOURCE_MANAGER_PLAN	Resource Mgr Top Plan
Security and Auditing
AUDIT_FILE_DEST	Directory In Which Auditing Files Are To Reside
AUDIT_SYS_OPERATIONS	Enable Sys Auditing
AUDIT_TRAIL	Enable System Auditing
O7_DICTIONARY_ACCESSIBILITY	Version 7 Dictionary Accessibility Support
OS_AUTHENT_PREFIX	Prefix For Auto-Logon Accounts
OS_ROLES	Retrieve Roles From The Operating System
RDBMS_SERVER_DN	Rdbms'S Distinguished Name
REMOTE_LOGIN_PASSWORDFILE	Password File Usage Parameter
REMOTE_OS_AUTHENT	Allow Non-Secure Remote Clients To Use Auto-Logon Accounts
REMOTE_OS_ROLES	Allow Non-Secure Remote Clients To Use Os Roles
SQL92_SECURITY	Require Select Privilege For Searched Update/Delete
Sessions and Processes
CPU_COUNT	Number Of Cpus For This Instance
PROCESSES	User Processes
SESSIONS	User And System Sessions
Shared Server Architecture
CIRCUITS	Max Number Of Circuits
DISPATCHERS	Specifications Of Dispatchers
MAX_DISPATCHERS	Max Number Of Dispatchers
MAX_SHARED_SERVERS	Max Number Of Shared Servers
SHARED_SERVERS	Number Of Shared Servers To Start Up
SHARED_SERVER_SESSIONS	Max Number Of Shared Server Sessions
Standby Database
ARCHIVE_LAG_TARGET	Maximum Number Of Seconds Of Redos The Standby Could Lose
DB_UNIQUE_NAME	Database Unique Name
DG_BROKER_CONFIG_FILEn	Data Guard Broker Configuration File #n
DG_BROKER_START	Start Data Guard Broker Framework (Dmon Process)
FAL_CLIENT	Fal Client
FAL_SERVER	Fal Server List
LOG_FILE_NAME_CONVERT	Logfile Name Convert Patterns And Strings For Standby/Clone Db
STANDBY_ARCHIVE_DEST	Standby Database Archivelog Destination Text String
STANDBY_FILE_MANAGEMENT	If Auto Then Files Are Created/Dropped Automatically On Standby
Temporary Sort Space
BITMAP_MERGE_AREA_SIZE	Maximum Memory Allow For Bitmap Merge
CREATE_BITMAP_AREA_SIZE	Size Of Create Bitmap Buffer For Bitmap Index
HASH_AREA_SIZE	Size Of In-Memory Hash Work Area
PGA_AGGREGATE_TARGET	Target Size For The Aggregate Pga Memory Consumed By The Instance
SORT_AREA_RETAINED_SIZE	Size Of In-Memory Sort Work Area Retained Between Fetch Calls
SORT_AREA_SIZE	Size Of In-Memory Sort Work Area
WORKAREA_SIZE_POLICY	Policy Used To Size Sql Working Areas (Manual/Auto)
Transactions
COMMIT_WRITE	Transaction Commit Log Write Behaviour
DML_LOCKS	Dml Locks - One For Each Table Modified In A Transaction
FAST_START_PARALLEL_ROLLBACK	Max Number Of Parallel Recovery Slaves That May Be Used
TRANSACTIONS	Max. Number Of Concurrent Active Transactions
Undo Management
RESUMABLE_TIMEOUT	Set Resumable_Timeout
ROLLBACK_SEGMENTS	Undo Segment List
TRANSACTIONS_PER_ROLLBACK_SEGMENT	Number Of Active Transactions Per Rollback Segment
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
Obsolete Parameter 10G
BUFFER_POOL_KEEP	Number Of Database Blocks/Latches In Keep Buffer Pool (Obsolete)
BUFFER_POOL_RECYCLE	Number Of Database Blocks/Latches In Recycle Buffer Pool (Obsolete)
DRS_START	Start Dg Broker Monitor (Dmon Process) (Obsolete)
FAST_START_IO_TARGET	Upper Bound On Recovery Reads (Obsolete)
GLOBAL_CONTEXT_POOL_SIZE	Global Application Context Pool Size In Bytes (Obsolete)
LOCK_NAME_SPACE	Lock Name Space Used For Generating Lock Names For Standby/Clone Database (Obsolete)
LOGMNR_MAX_PERSISTENT_SESSIONS	Maximum Number Of Threads To Mine (Obsolete)
LOG_ARCHIVE_START	Start Archival Process On Sga Initialization (Obsolete)
MAX_ENABLED_ROLES	Max Number Of Roles A User Can Have Enabled (Obsolete)
PLSQL_COMPILER_FLAGS	Pl/Sql Compiler Flags (Obsolete)
REMOTE_ARCHIVE_ENABLE	Remote Archival Enable Setting (Obsolete)
SERIAL_REUSE	Reuse The Frame Segments (Obsolete)
SQL_TRACE	Enable Sql Trace (Obsolete)
PARALLEL_SERVER	If True Startup In Parallel Server Mode (Obsolete)
PARALLEL_SERVER_INSTANCES	Number Of Instances To Use For Sizing Ops Sga Structures (Obsolete)
PARALLEL_AUTOMATIC_TUNING	Enable Intelligent Defaults For Parallel Execution Parameters (Obsolete)