Oracle® 非公式 SQL, PL/SQL & DBA's ガイドサイト
初期化パラメータ一覧
|
| パラメータ | タイミング | データタイプ | 概要 | 廃止 |
| O7_DICTIONARY_ACCESSIBILITY | SPFILE/変更不可 | <boolean> | Version 7 Dictionary Accessibility Support | |
| active_instance_count | 変更不可 | number of active instances in the cluster database | ||
| aq_tm_processes | SYSTEM 即時反映 | 0〜10 | number of AQ Time Managers to start | |
| archive_lag_target | SYSTEM 即時反映 | 0/60〜7200 | Maximum number of seconds of redos the standby could lose | |
| asm_diskgroups | SYSTEM 即時反映 | <string_list> | disk groups to mount automatically | |
| asm_diskstring | SYSTEM 即時反映 | <string_list> | disk set locations for discovery | |
| asm_power_limit | SESSION SYSTEM 即時反映 | 1〜11 | number of processes for disk rebalancing | |
| audit_file_dest | SYSTEM 遅延 | <directory_path> | enable sys auditing | |
| audit_sys_operations | 変更不可 | <boolean> | enable sys auditing | |
| audit_trail | 変更不可 | <enum>*1 | enable system auditing | |
| background_core_dump | 変更不可 | partial/full | Core Size for Background Processes | |
| background_dump_dest | SYSTEM 即時反映 | <directory_path> | Detached process dump directory | |
| backup_tape_io_slaves | SYSTEM 遅延 | <boolean> | BACKUP Tape I/O slaves | |
| bitmap_merge_area_size | 変更不可 | 1048576 | maximum memory allow for BITMAP MERGE | |
| blank_trimming | 変更不可 | <boolean> | blank trimming semantics parameter | |
| × buffer_pool_keep | SPFILE/変更不可 | Number of database blocks/latches in keep buffer pool | ※ | |
| × buffer_pool_recycle | SPFILE/変更不可 | Number of database blocks/latches in recycle buffer pool | ※ | |
| circuits | SYSTEM 即時反映 | 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:ip | interconnects 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.0 | Database will be completely compatible with this software version | |
| control_file_record_keep_time | SYSTEM 即時反映 | 7(0〜365) | control file record keep time in days | |
| control_files | 変更不可 | file_path_list(〜8files) | control file names list | |
| core_dump_dest | 即時反映 | directory_path | Core dump directory | |
| cpu_count | 変更禁止 | 2 | number of CPUs for this instance | |
| create_bitmap_area_size | 変更不可 | 8388608 | size of create bitmap buffer for bitmap index | |
| create_stored_outlines | SESSION SYSTEM 即時反映 | true/false/category_name | create stored outlines for DML statements | |
| cursor_sharing | SESSION SYSTEM 即時反映 | SIMILAR/EXACT/FORCE | cursor sharing mode | |
| cursor_space_for_time | 変更不可 | <boolean> | use more memory in order to get faster execution | |
| db_2k_cache_size | SYSTEM 即時反映 | integer{K/M/G} | Size of cache for 2K buffers | |
| db_32k_cache_size | SYSTEM 即時反映 | integer{K/M/G} | Size of cache for 32K buffers | |
| db_4k_cache_size | SYSTEM 即時反映 | integer{K/M/G} | Size of cache for 4K buffers | |
| db_8k_cache_size | SYSTEM 即時反映 | integer{K/M/G} | Size of cache for 8K buffers | |
| db_16k_cache_size | SYSTEM 即時反映 | integer{K/M/G} | Size of cache for 16K buffers | |
| db_block_buffers | 変更不可 | 0 | Number of database blocks cached in memory | |
| db_block_checking | SESSION SYSTEM 即時反映 | <boolean> | data and index block checking | |
| db_block_checksum | SYSTEM 即時反映 | <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_advice | SYSTEM 即時反映 | ON/READY/OFF | Buffer cache sizing advisory | |
| db_cache_size | SYSTEM 即時反映 | integer [K/M/G] | Size of DEFAULT buffer pool for standard block size buffers | |
| db_create_file_dest | SESSION SYSTEM 即時反映 | <directory>/disk group | default database location | |
| db_create_online_log_dest_1 | SESSION SYSTEM 即時反映 | <directory>/disk group | online log/controlfile destination #1 | |
| db_create_online_log_dest_2 | SESSION SYSTEM 即時反映 | <directory>/disk group | online log/controlfile destination #2 | |
| db_create_online_log_dest_3 | SESSION SYSTEM 即時反映 | <directory>/disk group | online log/controlfile destination #3 | |
| db_create_online_log_dest_4 | SESSION SYSTEM 即時反映 | <directory>/disk group | online log/controlfile destination #4 | |
| db_create_online_log_dest_5 | SESSION SYSTEM 即時反映 | <directory>/disk group | online log/controlfile destination #5 | |
| db_domain | 変更不可 | directory part of global database name stored with CREATE DATABASE | ||
| db_file_multiblock_read_count | SESSION SYSTEM 即時反映 | 8(integer) | db block to be read each IO | |
| db_file_name_convert | SESSION | pattern_string_list | datafile name convert patterns and strings for standby/clone db | |
| db_files | 変更不可 | 200(integer) | max allowable # db files | |
| db_flashback_retention_target | SYSTEM 即時反映 | 1440 | Maximum Flashback Database log retention time in minutes. | |
| db_keep_cache_size | 即時反映 | 0 | Size of KEEP buffer pool for standard block size buffers | |
| db_name | SPFILE/変更不可 | mono | database name specified in CREATE DATABASE | |
| db_recovery_file_dest | 即時反映 | directory_path | default database recovery file location | |
| db_recovery_file_dest_size | 即時反映 | 2147483648 | database recovery files size limit | |
| db_recycle_cache_size | SYSTEM 即時反映 | 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 | 変更不可 | integer | DBWR I/O slaves | |
| ddl_wait_for_locks | SESSION SYSTEM 即時反映 | <boolean> | Disable NOWAIT DML lock acquisitions | |
| dg_broker_config_file1 | SYSTEM 即時反映 | <filename> | data guard broker configuration file #1 | |
| dg_broker_config_file2 | SYSTEM 即時反映 | <filename> | data guard broker configuration file #2 | |
| dg_broker_start | SYSTEM 即時反映 | <boolean> | start Data Guard broker framework (DMON process) | |
| disk_asynch_io | 変更不可 | <boolean> | Use asynch I/O for random access devices | |
| dispatchers | SYSTEM 即時反映 | <dispatch_clause> | specifications of dispatchers | |
| distributed_lock_timeout | 変更不可 | 60(integer) | number of seconds a distributed transaction waits for a lock | |
| dml_locks | 変更不可 | 748 | dml locks - one for each table modified in a transaction | |
| × drs_start | 即時反映 | <boolean> | start DG Broker monitor (DMON process) | ※ |
| enqueue_resources | 変更不可 | 968 | resources for enqueues | |
| event | 変更不可 | debug event control - default null string | ||
| fal_client | SYSTEM 即時反映 | FAL client | ||
| fal_server | SYSTEM 即時反映 | FAL server list | ||
| △ fast_start_io_target | SYSTEM 即時反映 | 0 | Upper bound on recovery reads | ※ |
| fast_start_mttr_target | SYSTEM 即時反映 | 0 | MTTR target of forward crash recovery in seconds | |
| fast_start_parallel_rollback | SYSTEM 即時反映 | HIGH/LOW/FALSE | max number of parallel recovery slaves that may be used | |
| file_mapping | SYSTEM 即時反映 | <boolean> | enable file mapping | |
| fileio_network_adapters | 変更不可 | <adappter_name_list> | Network Adapters for File I/O | |
| filesystemio_options | SESSION SYSTEM 即時反映 | none/setall/directIO/asynch | IO operations on filesystem files | |
| fixed_date | SYSTEM 即時反映 | fixed SYSDATE value | ||
| gc_files_to_locks | SPFILE/変更不可 | mapping between file numbers and global cache locks (DFS) | ||
| gcs_server_processes | SPFILE/変更不可 | 0 | number of background gcs server processes to start | |
| global_context_pool_size | SPFILE/変更不可 | Global Application Context Pool Size in Bytes | ※ | |
| global_names | 即時反映 | <boolean> | enforce that database links have same name as remote database | |
| hash_area_size | SPFILE/変更不可 | 131072 | size of in-memory hash work area | |
| hi_shared_memory_address | SPFILE/変更不可 | 0 | SGA starting address (high order 32-bits on 64-bit platforms) | |
| hs_autoregister | 即時反映 | <boolean> | enable automatic server DD updates in HS agent self-registration | |
| ifile | SPFILE/変更不可 | include file in init.ora | ||
| instance_groups | SPFILE/変更不可 | list of instance group names | ||
| instance_name | SPFILE/変更不可 | mono | instance name supported by the instance | |
| instance_number | SPFILE/変更不可 | 0 | instance number | |
| instance_type | SPFILE/変更不可 | RDBMS | type of instance to be executed | |
| java_max_sessionspace_size | SPFILE/変更不可 | 0 | max allowed size in bytes of a Java sessionspace | |
| java_pool_size | 即時反映 | 50331648 | size in bytes of java pool | |
| java_soft_sessionspace_limit | SPFILE/変更不可 | 0 | warning limit on size in bytes of a Java sessionspace | |
| job_queue_processes | 即時反映 | 10 | number of job queue slave processes | |
| large_pool_size | 即時反映 | 8388608 | size in bytes of large pool | |
| ldap_directory_access | 即時反映 | NONE | RDBMS's LDAP access option | |
| license_max_sessions | 即時反映 | 0 | maximum number of non-system user sessions allowed | |
| license_max_users | 即時反映 | 0 | maximum number of named users that can be created in the database | |
| license_sessions_warning | 即時反映 | 0 | warning level for number of non-system user sessions | |
| local_listener | 即時反映 | local listener | ||
| lock_name_space | SPFILE/変更不可 | lock name space used for generating lock names for standby/clone database | ※ | |
| lock_sga | SPFILE/変更不可 | <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 | 即時反映 | enable | archival destination #1 state text string | |
| log_archive_dest_state_10 | 即時反映 | enable | archival destination #10 state text string | |
| log_archive_dest_state_2 | 即時反映 | enable | archival destination #2 state text string | |
| log_archive_dest_state_3 | 即時反映 | enable | archival destination #3 state text string | |
| log_archive_dest_state_4 | 即時反映 | enable | archival destination #4 state text string | |
| log_archive_dest_state_5 | 即時反映 | enable | archival destination #5 state text string | |
| log_archive_dest_state_6 | 即時反映 | enable | archival destination #6 state text string | |
| log_archive_dest_state_7 | 即時反映 | enable | archival destination #7 state text string | |
| log_archive_dest_state_8 | 即時反映 | enable | archival destination #8 state text string | |
| log_archive_dest_state_9 | 即時反映 | enable | archival destination #9 state text string | |
| log_archive_duplex_dest | 即時反映 | duplex archival destination text string | ||
| log_archive_format | SPFILE/変更不可 | ARC%S_%R.%T | archival destination format | |
| log_archive_local_first | 即時反映 | <boolean> | Establish EXPEDITE attribute default value | |
| log_archive_max_processes | 即時反映 | 2 | maximum number of active ARCH processes | |
| log_archive_min_succeed_dest | 即時反映 | 1 | minimum number of archive destinations that must succeed | |
| log_archive_start | SPFILE/変更不可 | <boolean> | start archival process on SGA initialization | ※ |
| log_archive_trace | 即時反映 | 0 | Establish archivelog operation tracing level | |
| log_buffer | SPFILE/変更不可 | 524288 | redo circular buffer size | |
| log_checkpoint_interval | 即時反映 | 0 | # redo blocks checkpoint threshold | |
| log_checkpoint_timeout | 即時反映 | 1800 | Maximum time interval between checkpoints in seconds | |
| log_checkpoints_to_alert | 即時反映 | <boolean> | log checkpoint begin/end to alert file | |
| log_file_name_convert | SPFILE/変更不可 | logfile name convert patterns and strings for standby/clone db | ||
| logmnr_max_persistent_sessions | SPFILE/変更不可 | 1 | maximum number of threads to mine | |
| max_commit_propagation_delay | SPFILE/変更不可 | 700 | Max age of new snapshot in .01 seconds | |
| max_dispatchers | 即時反映 | max number of dispatchers | ||
| max_dump_file_size | 即時反映 | UNLIMITED | Maximum size (blocks) of dump file | |
| max_enabled_roles | SPFILE/変更不可 | 150 | max number of roles a user can have enabled | ※ |
| max_shared_servers | 即時反映 | max number of shared servers | ||
| nls_calendar | SPFILE/変更不可 | NLS calendar system name | ||
| nls_comp | SPFILE/変更不可 | NLS comparison | ||
| nls_currency | SPFILE/変更不可 | NLS local currency symbol | ||
| nls_date_format | SPFILE/変更不可 | NLS Oracle date format | ||
| nls_date_language | SPFILE/変更不可 | NLS date language name | ||
| nls_dual_currency | SPFILE/変更不可 | Dual currency symbol | ||
| nls_iso_currency | SPFILE/変更不可 | NLS ISO currency territory name | ||
| nls_language | SPFILE/変更不可 | JAPANESE | NLS language name | |
| nls_length_semantics | 即時反映 | BYTE | create columns using byte or char semantics by default | |
| nls_nchar_conv_excp | 即時反映 | <boolean> | NLS raise an exception instead of allowing implicit conversion | |
| nls_numeric_characters | SPFILE/変更不可 | NLS numeric characters | ||
| nls_sort | SPFILE/変更不可 | NLS linguistic definition name | ||
| nls_territory | SPFILE/変更不可 | JAPAN | NLS territory name | |
| nls_time_format | SPFILE/変更不可 | time format | ||
| nls_time_tz_format | SPFILE/変更不可 | time with timezone format | ||
| nls_timestamp_format | SPFILE/変更不可 | time stamp format | ||
| nls_timestamp_tz_format | SPFILE/変更不可 | timestampe with timezone format | ||
| object_cache_max_size_percent | 遅延 | 10 | percentage of maximum size over optimal of the user session's object cache | |
| object_cache_optimal_size | 遅延 | 102400 | optimal size of the user session's object cache in bytes | |
| olap_page_pool_size | 遅延 | 0 | size of the olap page pool in bytes | |
| open_cursors | 即時反映 | 300 | max # cursors per session | |
| open_links | SPFILE/変更不可 | 4 | max # open links per session | |
| open_links_per_instance | SPFILE/変更不可 | 4 | max # open links per instance | |
| optimizer_dynamic_sampling | 即時反映 | 2 | optimizer dynamic sampling | |
| optimizer_features_enable | 即時反映 | 10.1.0 | optimizer plan compatibility parameter | |
| optimizer_index_caching | 即時反映 | 0 | optimizer percent index caching | |
| optimizer_index_cost_adj | 即時反映 | 100 | optimizer index cost adjustment | |
| optimizer_mode | 即時反映 | ALL_ROWS | optimizer mode | |
| os_authent_prefix | SPFILE/変更不可 | OPS$ | prefix for auto-logon accounts | |
| os_roles | SPFILE/変更不可 | <boolean> | retrieve roles from the operating system | |
| parallel_adaptive_multi_user | 即時反映 | <boolean> | enable adaptive setting of degree for multiple user streams | |
| parallel_automatic_tuning | SPFILE/変更不可 | <boolean> | enable intelligent defaults for parallel execution parameters | ※ |
| parallel_execution_message_size | SPFILE/変更不可 | 2148 | message buffer size for parallel execution | |
| parallel_instance_group | 即時反映 | instance group to use for all parallel operations | ||
| parallel_max_servers | 即時反映 | 40 | maximum parallel query servers per instance | |
| parallel_min_percent | SPFILE/変更不可 | 0 | minimum percent of threads required for parallel query | |
| parallel_min_servers | 即時反映 | 0 | minimum parallel query servers per instance | |
| parallel_server | SPFILE/変更不可 | <boolean> | if TRUE startup in parallel server mode | ※ |
| parallel_server_instances | SPFILE/変更不可 | 1 | number of instances to use for sizing OPS SGA structures | ※ |
| parallel_threads_per_cpu | 即時反映 | 2 | number of parallel execution threads per CPU | |
| pga_aggregate_target | 即時反映 | 25165824 | Target size for the aggregate PGA memory consumed by the instance | |
| plsql_code_type | 即時反映 | INTERPRETED | PL/SQL code-type | |
| plsql_compiler_flags | 即時反映 | INTERPRETED, NON_DEBUG | PL/SQL compiler flags | ※ |
| plsql_debug | 即時反映 | <boolean> | PL/SQL debug | |
| plsql_native_library_dir | 即時反映 | plsql native library dir | ||
| plsql_native_library_subdir_count | 即時反映 | 0 | plsql native library number of subdirectories | |
| plsql_optimize_level | 即時反映 | 2 | PL/SQL optimize level | |
| plsql_v2_compatibility | 即時反映 | <boolean> | PL/SQL version 2.x compatibility flag | |
| plsql_warnings | 即時反映 | DISABLE:ALL | PL/SQL compiler warnings settings | |
| pre_page_sga | SPFILE/変更不可 | <boolean> | pre-page sga for process | |
| processes | SPFILE/変更不可 | 150 | user processes | |
| query_rewrite_enabled | 即時反映 | <boolean> | allow rewrite of queries using materialized views if enabled | |
| query_rewrite_integrity | 即時反映 | enforced | perform rewrite using materialized views with desired integrity | |
| rdbms_server_dn | SPFILE/変更不可 | RDBMS's Distinguished Name | ||
| read_only_open_delayed | SPFILE/変更不可 | <boolean> | if TRUE delay opening of read only files until first access | |
| recyclebin | SESSEION SYSTEM 即時反映 | ON,OFF | recyclebin enable(ON),disble(OFF) | |
| recovery_parallelism | SPFILE/変更不可 | 0 | number of server processes to use for parallel recovery | |
| remote_archive_enable | SPFILE/変更不可 | true | remote archival enable setting | |
| remote_dependencies_mode | 即時反映 | TIMESTAMP | remote-procedure-call dependencies mode parameter | |
| remote_listener | 即時反映 | remote listener | ||
| remote_login_passwordfile | SPFILE/変更不可 | EXCLUSIVE | password file usage parameter | |
| remote_os_authent | SPFILE/変更不可 | <boolean> | allow non-secure remote clients to use auto-logon accounts | |
| remote_os_roles | SPFILE/変更不可 | <boolean> | allow non-secure remote clients to use os roles | |
| replication_dependency_tracking | SPFILE/変更不可 | <boolean> | tracking dependency for Replication parallel propagation | |
| resource_limit | 即時反映 | <boolean> | master switch for resource limit | |
| resource_manager_plan | 即時反映 | resource mgr top plan | ||
| resumable_timeout | 即時反映 | 0 | set resumable_timeout | |
| rollback_segments | SPFILE/変更不可 | undo segment list | ||
| serial_reuse | SPFILE/変更不可 | DISABLE | reuse the frame segments | |
| service_names | 即時反映 | mono.silver | service names supported by the instance | |
| session_cached_cursors | SPFILE/変更不可 | 0 | Number of cursors to cache in a session. | |
| session_max_open_files | SPFILE/変更不可 | 10 | maximum number of open files allowed per session | |
| sessions | SPFILE/変更不可 | 170 | user and system sessions | |
| sga_max_size | SPFILE/変更不可 | 171966464 | max total SGA size | |
| sga_target | 即時反映 | 0 | Target size of SGA | |
| shadow_core_dump | SPFILE/変更不可 | partial | Core Size for Shadow Processes | |
| shared_memory_address | SPFILE/変更不可 | 0 | SGA starting address (low order 32-bits on 64-bit platforms) | |
| shared_pool_reserved_size | SPFILE/変更不可 | 4194304 | size in bytes of reserved area of shared pool | |
| shared_pool_size | 即時反映 | 83886080 | size in bytes of shared pool | |
| shared_server_sessions | 即時反映 | max number of shared server sessions | ||
| shared_servers | 即時反映 | 1 | number of shared servers to start up | |
| skip_unusable_indexes | 即時反映 | <boolean> | skip unusable indexes if set to TRUE | |
| smtp_out_server | SPFILE/変更不可 | utl_smtp server and port configuration parameter | ||
| sort_area_retained_size | 遅延 | 0 | size of in-memory sort work area retained between fetch calls | |
| sort_area_size | 遅延 | 65536 | size of in-memory sort work area | |
| sp_name | SPFILE/変更不可 | mono | Service Provider Name | |
| spfile | SPFILE/変更不可 | file_path | server parameter file | |
| sql92_security | SPFILE/変更不可 | <boolean> | require select privilege for searched update/delete | |
| sql_trace | 即時反映 | <boolean> | enable SQL trace | |
| sql_version | SPFILE/変更不可 | NATIVE | sql language version parameter for compatibility issues | |
| sqltune_category | 即時反映 | DEFAULT | Category qualifier for applying hintsets | |
| standby_archive_dest | 即時反映 | directory_path | standby database archivelog destination text string | |
| standby_file_management | 即時反映 | MANUAL | if auto then files are created/dropped automatically on standby | |
| star_transformation_enabled | 即時反映 | <boolean> | enable the use of star transformation | |
| statistics_level | 即時反映 | TYPICAL | statistics level | |
| streams_pool_size | 即時反映 | 0 | size in bytes of the streams pool | |
| tape_asynch_io | SPFILE/変更不可 | <boolean> | Use asynch I/O requests for tape devices | |
| thread | SPFILE/変更不可 | 0 | Redo thread to mount | |
| timed_os_statistics | 即時反映 | 0 | internal os statistic gathering interval in seconds | |
| timed_statistics | 即時反映 | <boolean> | maintain internal timing statistics | |
| trace_enabled | 即時反映 | <boolean> | enable KST tracing | |
| tracefile_identifier | SPFILE/変更不可 | trace file custom identifier | ||
| transactions | SPFILE/変更不可 | 187 | max. number of concurrent active transactions | |
| transactions_per_rollback_segment | SPFILE/変更不可 | 5 | number of active transactions per rollback segment | |
| undo_management | SPFILE/変更不可 | AUTO | instance runs in SMU mode if TRUE, else in RBU mode | |
| undo_retention | 即時反映 | 900 | undo retention in seconds | |
| undo_tablespace | 即時反映 | UNDOTBS1 | use/switch undo tablespace | |
| use_indirect_data_buffers | SPFILE/変更不可 | <boolean> | Enable indirect data buffers (very large SGA on 32-bit platforms) | |
| user_dump_dest | 即時反映 | directory_path | User process dump directory | |
| utl_file_dir | SPFILE/変更不可 | directory_path | utl_file accessible directories list | |
| workarea_size_policy | 即時反映 | AUTO | policy used to size SQL working areas (MANUAL/AUTO) |
|
|
|
|
|
|
■
■
■
印刷表示