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) | |