初期化パラメータ一覧 Oracle 10g

パラメータタイミングデータタイプ概要廃止
O7_DICTIONARY_ACCESSIBILITYSPFILE/変更不可<boolean>Version 7 Dictionary Accessibility Support
active_instance_count変更不可number of active instances in the cluster database
aq_tm_processesSYSTEM 即時反映0〜10number of AQ Time Managers to start
archive_lag_targetSYSTEM 即時反映0/60〜7200Maximum number of seconds of redos the standby could lose
asm_diskgroupsSYSTEM 即時反映<string_list>disk groups to mount automatically
asm_diskstringSYSTEM 即時反映<string_list>disk set locations for discovery
asm_power_limitSESSION SYSTEM 即時反映1〜11number of processes for disk rebalancing
audit_file_destSYSTEM 遅延<directory_path>enable sys auditing
audit_sys_operations変更不可<boolean>enable sys auditing
audit_trail変更不可<enum>*1enable system auditing
background_core_dump変更不可partial/fullCore Size for Background Processes
background_dump_destSYSTEM 即時反映<directory_path>Detached process dump directory
backup_tape_io_slavesSYSTEM 遅延<boolean>BACKUP Tape I/O slaves
bitmap_merge_area_size変更不可1048576maximum memory allow for BITMAP MERGE
blank_trimming変更不可<boolean>blank trimming semantics parameter
× buffer_pool_keepSPFILE/変更不可Number of database blocks/latches in keep buffer pool
× buffer_pool_recycleSPFILE/変更不可Number of database blocks/latches in recycle buffer pool
circuitsSYSTEM 即時反映max number of circuits
cluster_database変更不可<boolean>if TRUE startup in cluster database mode
cluster_database_instances変更不可<decimal>number of instances to use for sizing cluster db SGA structures
cluster_interconnects変更不可<ip_address_list>ip:ipinterconnects for RAC use
commit_point_strength変更不可1(0〜255)Bias this node has toward not preparing in a two-phase commit
compatible変更不可10.1.0.2.0Database will be completely compatible with this software version
control_file_record_keep_timeSYSTEM 即時反映7(0〜365)control file record keep time in days
control_files変更不可file_path_list(〜8files)control file names list
core_dump_dest即時反映directory_pathCore dump directory
cpu_count変更禁止2number of CPUs for this instance
create_bitmap_area_size変更不可8388608size of create bitmap buffer for bitmap index
create_stored_outlinesSESSION SYSTEM 即時反映true/false/category_namecreate stored outlines for DML statements
cursor_sharingSESSION SYSTEM 即時反映SIMILAR/EXACT/FORCEcursor sharing mode
cursor_space_for_time変更不可<boolean>use more memory in order to get faster execution
db_2k_cache_sizeSYSTEM 即時反映integer{K/M/G}Size of cache for 2K buffers
db_32k_cache_sizeSYSTEM 即時反映integer{K/M/G}Size of cache for 32K buffers
db_4k_cache_sizeSYSTEM 即時反映integer{K/M/G}Size of cache for 4K buffers
db_8k_cache_sizeSYSTEM 即時反映integer{K/M/G}Size of cache for 8K buffers
db_16k_cache_sizeSYSTEM 即時反映integer{K/M/G}Size of cache for 16K buffers
db_block_buffers変更不可0Number of database blocks cached in memory
db_block_checkingSESSION SYSTEM 即時反映<boolean>data and index block checking
db_block_checksumSYSTEM 即時反映<boolean>store checksum in db blocks and check during reads
db_block_size変更禁止2048〜32768(2/4/8/16/32K)Size of database block in bytes
db_cache_adviceSYSTEM 即時反映ON/READY/OFFBuffer cache sizing advisory
db_cache_sizeSYSTEM 即時反映integer [K/M/G]Size of DEFAULT buffer pool for standard block size buffers
db_create_file_destSESSION SYSTEM 即時反映<directory>/disk groupdefault database location
db_create_online_log_dest_1SESSION SYSTEM 即時反映<directory>/disk grouponline log/controlfile destination #1
db_create_online_log_dest_2SESSION SYSTEM 即時反映<directory>/disk grouponline log/controlfile destination #2
db_create_online_log_dest_3SESSION SYSTEM 即時反映<directory>/disk grouponline log/controlfile destination #3
db_create_online_log_dest_4SESSION SYSTEM 即時反映<directory>/disk grouponline log/controlfile destination #4
db_create_online_log_dest_5SESSION SYSTEM 即時反映<directory>/disk grouponline log/controlfile destination #5
db_domain変更不可directory part of global database name stored with CREATE DATABASE
db_file_multiblock_read_countSESSION SYSTEM 即時反映8(integer)db block to be read each IO
db_file_name_convertSESSIONpattern_string_listdatafile name convert patterns and strings for standby/clone db
db_files変更不可200(integer)max allowable # db files
db_flashback_retention_targetSYSTEM 即時反映1440Maximum Flashback Database log retention time in minutes.
db_keep_cache_size即時反映0Size of KEEP buffer pool for standard block size buffers
db_nameSPFILE/変更不可monodatabase name specified in CREATE DATABASE
db_recovery_file_dest即時反映directory_pathdefault database recovery file location
db_recovery_file_dest_size即時反映2147483648database recovery files size limit
db_recycle_cache_sizeSYSTEM 即時反映0(integer [K/M/G]Size of RECYCLE buffer pool for standard block size buffers
db_unique_name変更不可Database Unique Name
db_writer_processes変更不可1(1〜20)number of background database writer processes to start
dbwr_io_slaves変更不可integerDBWR I/O slaves
ddl_wait_for_locksSESSION SYSTEM 即時反映<boolean>Disable NOWAIT DML lock acquisitions
dg_broker_config_file1SYSTEM 即時反映<filename>data guard broker configuration file #1
dg_broker_config_file2SYSTEM 即時反映<filename>data guard broker configuration file #2
dg_broker_startSYSTEM 即時反映<boolean>start Data Guard broker framework (DMON process)
disk_asynch_io変更不可<boolean>Use asynch I/O for random access devices
dispatchersSYSTEM 即時反映<dispatch_clause>specifications of dispatchers
distributed_lock_timeout変更不可60(integer)number of seconds a distributed transaction waits for a lock
dml_locks変更不可748dml locks - one for each table modified in a transaction
× drs_start即時反映<boolean>start DG Broker monitor (DMON process)
enqueue_resources変更不可968resources for enqueues
event変更不可debug event control - default null string
fal_clientSYSTEM 即時反映FAL client
fal_serverSYSTEM 即時反映FAL server list
△ fast_start_io_targetSYSTEM 即時反映0Upper bound on recovery reads
fast_start_mttr_targetSYSTEM 即時反映0MTTR target of forward crash recovery in seconds
fast_start_parallel_rollbackSYSTEM 即時反映HIGH/LOW/FALSEmax number of parallel recovery slaves that may be used
file_mappingSYSTEM 即時反映<boolean>enable file mapping
fileio_network_adapters変更不可<adappter_name_list>Network Adapters for File I/O
filesystemio_optionsSESSION SYSTEM 即時反映none/setall/directIO/asynchIO operations on filesystem files
fixed_dateSYSTEM 即時反映fixed SYSDATE value
gc_files_to_locksSPFILE/変更不可mapping between file numbers and global cache locks (DFS)
gcs_server_processesSPFILE/変更不可0number of background gcs server processes to start
global_context_pool_sizeSPFILE/変更不可Global Application Context Pool Size in Bytes
global_names即時反映<boolean>enforce that database links have same name as remote database
hash_area_sizeSPFILE/変更不可131072size of in-memory hash work area
hi_shared_memory_addressSPFILE/変更不可0SGA starting address (high order 32-bits on 64-bit platforms)
hs_autoregister即時反映<boolean>enable automatic server DD updates in HS agent self-registration
ifileSPFILE/変更不可include file in init.ora
instance_groupsSPFILE/変更不可list of instance group names
instance_nameSPFILE/変更不可monoinstance name supported by the instance
instance_numberSPFILE/変更不可0instance number
instance_typeSPFILE/変更不可RDBMStype of instance to be executed
java_max_sessionspace_sizeSPFILE/変更不可0max allowed size in bytes of a Java sessionspace
java_pool_size即時反映50331648size in bytes of java pool
java_soft_sessionspace_limitSPFILE/変更不可0warning limit on size in bytes of a Java sessionspace
job_queue_processes即時反映10number of job queue slave processes
large_pool_size即時反映8388608size in bytes of large pool
ldap_directory_access即時反映NONERDBMS's LDAP access option
license_max_sessions即時反映0maximum number of non-system user sessions allowed
license_max_users即時反映0maximum number of named users that can be created in the database
license_sessions_warning即時反映0warning level for number of non-system user sessions
local_listener即時反映local listener
lock_name_spaceSPFILE/変更不可lock name space used for generating lock names for standby/clone database
lock_sgaSPFILE/変更不可<boolean>Lock entire SGA in physical memory
log_archive_config即時反映log archive config parameter
log_archive_dest即時反映archival destination text string
log_archive_dest_1即時反映archival destination #1 text string
log_archive_dest_10即時反映archival destination #10 text string
log_archive_dest_2即時反映archival destination #2 text string
log_archive_dest_3即時反映archival destination #3 text string
log_archive_dest_4即時反映archival destination #4 text string
log_archive_dest_5即時反映archival destination #5 text string
log_archive_dest_6即時反映archival destination #6 text string
log_archive_dest_7即時反映archival destination #7 text string
log_archive_dest_8即時反映archival destination #8 text string
log_archive_dest_9即時反映archival destination #9 text string
log_archive_dest_state_1即時反映enablearchival destination #1 state text string
log_archive_dest_state_10即時反映enablearchival destination #10 state text string
log_archive_dest_state_2即時反映enablearchival destination #2 state text string
log_archive_dest_state_3即時反映enablearchival destination #3 state text string
log_archive_dest_state_4即時反映enablearchival destination #4 state text string
log_archive_dest_state_5即時反映enablearchival destination #5 state text string
log_archive_dest_state_6即時反映enablearchival destination #6 state text string
log_archive_dest_state_7即時反映enablearchival destination #7 state text string
log_archive_dest_state_8即時反映enablearchival destination #8 state text string
log_archive_dest_state_9即時反映enablearchival destination #9 state text string
log_archive_duplex_dest即時反映duplex archival destination text string
log_archive_formatSPFILE/変更不可ARC%S_%R.%Tarchival destination format
log_archive_local_first即時反映<boolean>Establish EXPEDITE attribute default value
log_archive_max_processes即時反映2maximum number of active ARCH processes
log_archive_min_succeed_dest即時反映1minimum number of archive destinations that must succeed
log_archive_startSPFILE/変更不可<boolean>start archival process on SGA initialization
log_archive_trace即時反映0Establish archivelog operation tracing level
log_bufferSPFILE/変更不可524288redo circular buffer size
log_checkpoint_interval即時反映0# redo blocks checkpoint threshold
log_checkpoint_timeout即時反映1800Maximum time interval between checkpoints in seconds
log_checkpoints_to_alert即時反映<boolean>log checkpoint begin/end to alert file
log_file_name_convertSPFILE/変更不可logfile name convert patterns and strings for standby/clone db
logmnr_max_persistent_sessionsSPFILE/変更不可1maximum number of threads to mine
max_commit_propagation_delaySPFILE/変更不可700Max age of new snapshot in .01 seconds
max_dispatchers即時反映max number of dispatchers
max_dump_file_size即時反映UNLIMITEDMaximum size (blocks) of dump file
max_enabled_rolesSPFILE/変更不可150max number of roles a user can have enabled
max_shared_servers即時反映max number of shared servers
nls_calendarSPFILE/変更不可NLS calendar system name
nls_compSPFILE/変更不可NLS comparison
nls_currencySPFILE/変更不可NLS local currency symbol
nls_date_formatSPFILE/変更不可NLS Oracle date format
nls_date_languageSPFILE/変更不可NLS date language name
nls_dual_currencySPFILE/変更不可Dual currency symbol
nls_iso_currencySPFILE/変更不可NLS ISO currency territory name
nls_languageSPFILE/変更不可JAPANESENLS language name
nls_length_semantics即時反映BYTEcreate columns using byte or char semantics by default
nls_nchar_conv_excp即時反映<boolean>NLS raise an exception instead of allowing implicit conversion
nls_numeric_charactersSPFILE/変更不可NLS numeric characters
nls_sortSPFILE/変更不可NLS linguistic definition name
nls_territorySPFILE/変更不可JAPANNLS territory name
nls_time_formatSPFILE/変更不可time format
nls_time_tz_formatSPFILE/変更不可time with timezone format
nls_timestamp_formatSPFILE/変更不可time stamp format
nls_timestamp_tz_formatSPFILE/変更不可timestampe with timezone format
object_cache_max_size_percent遅延10percentage of maximum size over optimal of the user session's object cache
object_cache_optimal_size遅延102400optimal size of the user session's object cache in bytes
olap_page_pool_size遅延0size of the olap page pool in bytes
open_cursors即時反映300max # cursors per session
open_linksSPFILE/変更不可4max # open links per session
open_links_per_instanceSPFILE/変更不可4max # open links per instance
optimizer_dynamic_sampling即時反映2optimizer dynamic sampling
optimizer_features_enable即時反映10.1.0optimizer plan compatibility parameter
optimizer_index_caching即時反映0optimizer percent index caching
optimizer_index_cost_adj即時反映100optimizer index cost adjustment
optimizer_mode即時反映ALL_ROWSoptimizer mode
os_authent_prefixSPFILE/変更不可OPS$prefix for auto-logon accounts
os_rolesSPFILE/変更不可<boolean>retrieve roles from the operating system
parallel_adaptive_multi_user即時反映<boolean>enable adaptive setting of degree for multiple user streams
parallel_automatic_tuningSPFILE/変更不可<boolean>enable intelligent defaults for parallel execution parameters
parallel_execution_message_sizeSPFILE/変更不可2148message buffer size for parallel execution
parallel_instance_group即時反映instance group to use for all parallel operations
parallel_max_servers即時反映40maximum parallel query servers per instance
parallel_min_percentSPFILE/変更不可0minimum percent of threads required for parallel query
parallel_min_servers即時反映0minimum parallel query servers per instance
parallel_serverSPFILE/変更不可<boolean>if TRUE startup in parallel server mode
parallel_server_instancesSPFILE/変更不可1number of instances to use for sizing OPS SGA structures
parallel_threads_per_cpu即時反映2number of parallel execution threads per CPU
pga_aggregate_target即時反映25165824Target size for the aggregate PGA memory consumed by the instance
plsql_code_type即時反映INTERPRETEDPL/SQL code-type
plsql_compiler_flags即時反映INTERPRETED, NON_DEBUGPL/SQL compiler flags
plsql_debug即時反映<boolean>PL/SQL debug
plsql_native_library_dir即時反映plsql native library dir
plsql_native_library_subdir_count即時反映0plsql native library number of subdirectories
plsql_optimize_level即時反映2PL/SQL optimize level
plsql_v2_compatibility即時反映<boolean>PL/SQL version 2.x compatibility flag
plsql_warnings即時反映DISABLE:ALLPL/SQL compiler warnings settings
pre_page_sgaSPFILE/変更不可<boolean>pre-page sga for process
processesSPFILE/変更不可150user processes
query_rewrite_enabled即時反映<boolean>allow rewrite of queries using materialized views if enabled
query_rewrite_integrity即時反映enforcedperform rewrite using materialized views with desired integrity
rdbms_server_dnSPFILE/変更不可RDBMS's Distinguished Name
read_only_open_delayedSPFILE/変更不可<boolean>if TRUE delay opening of read only files until first access
recyclebinSESSEION SYSTEM 即時反映ON,OFFrecyclebin enable(ON),disble(OFF)
recovery_parallelismSPFILE/変更不可0number of server processes to use for parallel recovery
remote_archive_enableSPFILE/変更不可trueremote archival enable setting
remote_dependencies_mode即時反映TIMESTAMPremote-procedure-call dependencies mode parameter
remote_listener即時反映remote listener
remote_login_passwordfileSPFILE/変更不可EXCLUSIVEpassword file usage parameter
remote_os_authentSPFILE/変更不可<boolean>allow non-secure remote clients to use auto-logon accounts
remote_os_rolesSPFILE/変更不可<boolean>allow non-secure remote clients to use os roles
replication_dependency_trackingSPFILE/変更不可<boolean>tracking dependency for Replication parallel propagation
resource_limit即時反映<boolean>master switch for resource limit
resource_manager_plan即時反映resource mgr top plan
resumable_timeout即時反映0set resumable_timeout
rollback_segmentsSPFILE/変更不可undo segment list
serial_reuseSPFILE/変更不可DISABLEreuse the frame segments
service_names即時反映mono.silverservice names supported by the instance
session_cached_cursorsSPFILE/変更不可0Number of cursors to cache in a session.
session_max_open_filesSPFILE/変更不可10maximum number of open files allowed per session
sessionsSPFILE/変更不可170user and system sessions
sga_max_sizeSPFILE/変更不可171966464max total SGA size
sga_target即時反映0Target size of SGA
shadow_core_dumpSPFILE/変更不可partialCore Size for Shadow Processes
shared_memory_addressSPFILE/変更不可0SGA starting address (low order 32-bits on 64-bit platforms)
shared_pool_reserved_sizeSPFILE/変更不可4194304size in bytes of reserved area of shared pool
shared_pool_size即時反映83886080size in bytes of shared pool
shared_server_sessions即時反映max number of shared server sessions
shared_servers即時反映1number of shared servers to start up
skip_unusable_indexes即時反映<boolean>skip unusable indexes if set to TRUE
smtp_out_serverSPFILE/変更不可utl_smtp server and port configuration parameter
sort_area_retained_size遅延0size of in-memory sort work area retained between fetch calls
sort_area_size遅延65536size of in-memory sort work area
sp_nameSPFILE/変更不可monoService Provider Name
spfileSPFILE/変更不可file_pathserver parameter file
sql92_securitySPFILE/変更不可<boolean>require select privilege for searched update/delete
sql_trace即時反映<boolean>enable SQL trace
sql_versionSPFILE/変更不可NATIVEsql language version parameter for compatibility issues
sqltune_category即時反映DEFAULTCategory qualifier for applying hintsets
standby_archive_dest即時反映directory_pathstandby database archivelog destination text string
standby_file_management即時反映MANUALif auto then files are created/dropped automatically on standby
star_transformation_enabled即時反映<boolean>enable the use of star transformation
statistics_level即時反映TYPICALstatistics level
streams_pool_size即時反映0size in bytes of the streams pool
tape_asynch_ioSPFILE/変更不可<boolean>Use asynch I/O requests for tape devices
threadSPFILE/変更不可0Redo thread to mount
timed_os_statistics即時反映0internal os statistic gathering interval in seconds
timed_statistics即時反映<boolean>maintain internal timing statistics
trace_enabled即時反映<boolean>enable KST tracing
tracefile_identifierSPFILE/変更不可trace file custom identifier
transactionsSPFILE/変更不可187max. number of concurrent active transactions
transactions_per_rollback_segmentSPFILE/変更不可5number of active transactions per rollback segment
undo_managementSPFILE/変更不可AUTOinstance runs in SMU mode if TRUE, else in RBU mode
undo_retention即時反映900undo retention in seconds
undo_tablespace即時反映UNDOTBS1use/switch undo tablespace
use_indirect_data_buffersSPFILE/変更不可<boolean>Enable indirect data buffers (very large SGA on 32-bit platforms)
user_dump_dest即時反映directory_pathUser process dump directory
utl_file_dirSPFILE/変更不可directory_pathutl_file accessible directories list
workarea_size_policy即時反映AUTOpolicy used to size SQL working areas (MANUAL/AUTO)


初期化パラメータの関連トピックス

日本オラクル
■ 日本オラクル 株式会社
■ オラクルマスター資格 (オラクルマスターとは
■ Oracle のライセンスがわからない…
Oracle Direct (ネットで聞いても最後はここで要確認)

*1 audit_trail=db/os/none/true/false/db_extended