Overblog Suivre ce blog
Editer la page Administration Créer mon blog
/ / /


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)

Partager cette page

Repost 0
Published by