【統計】能夠在session級別和system級別修改的oracle引數統計

secooler發表於2009-02-21
這個列表回答了一個問題:哪些引數是可以在session級別進行修改的,哪些引數必須在system級別進行修改。
session級別修改的含義是,可以使用SQL語句alter session set Oracle_Parameter='***'進行修改。
system級別修改的含義是,需要使用SQL語句alter system set Oracle_Parameter='***'進行修改。

統計列表如下:

NAME                          SES_MOD SYS_MOD  NAME                              SES_MOD SYS_MOD

O7_DICTIONARY_ACCESSIBILITY   NO      NO       log_archive_dest_state_3          YES     YES
active_instance_count         NO      NO       log_archive_dest_state_4          YES     YES  
aq_tm_processes               NO      YES      log_archive_dest_state_5          YES     YES  
archive_lag_target            NO      YES      log_archive_dest_state_6          YES     YES  
asm_diskgroups                NO      YES      log_archive_dest_state_7          YES     YES  
asm_diskstring                NO      YES      log_archive_dest_state_8          YES     YES  
asm_power_limit               YES     YES      log_archive_dest_state_9          YES     YES  
audit_file_dest               NO      NO       log_archive_duplex_dest           NO      YES  
audit_sys_operations          NO      NO       log_archive_format                NO      NO   
audit_trail                   NO      NO       log_archive_local_first           NO      YES  
background_core_dump          NO      NO       log_archive_max_processes         NO      YES  
background_dump_dest          NO      YES      log_archive_min_succeed_dest      YES     YES  
backup_tape_io_slaves         NO      NO       log_archive_start                 NO      NO   
bitmap_merge_area_size        NO      NO       log_archive_trace                 NO      YES  
blank_trimming                NO      NO       log_buffer                        NO      NO   
buffer_pool_keep              NO      NO       log_checkpoint_interval           NO      YES  
buffer_pool_recycle           NO      NO       log_checkpoint_timeout            NO      YES  
circuits                      NO      YES      log_checkpoints_to_alert          NO      YES  
cluster_database              NO      NO       log_file_name_convert             NO      NO   
cluster_database_instances    NO      NO       logmnr_max_persistent_sessions    NO      NO   
cluster_interconnects         NO      NO       max_commit_propagation_delay      NO      NO   
commit_point_strength         NO      NO       max_dispatchers                   NO      YES  
commit_write                  YES     YES      max_dump_file_size                YES     YES  
compatible                    NO      NO       max_enabled_roles                 NO      NO   
control_file_record_keep_time NO      YES      max_shared_servers                NO      YES  
control_files                 NO      NO       object_cache_max_size_percent     YES     NO   
core_dump_dest                NO      YES      object_cache_optimal_size         YES     NO   
cpu_count                     NO      YES      olap_page_pool_size               YES     NO   
create_bitmap_area_size       NO      NO       open_cursors                      NO      YES  
create_stored_outlines        YES     YES      open_links                        NO      NO   
cursor_sharing                YES     YES      open_links_per_instance           NO      NO   
cursor_space_for_time         NO      NO       optimizer_dynamic_sampling        YES     YES  
db_16k_cache_size             NO      YES      optimizer_features_enable         YES     YES  
db_2k_cache_size              NO      YES      optimizer_index_caching           YES     YES  
db_32k_cache_size             NO      YES      optimizer_index_cost_adj          YES     YES  
db_4k_cache_size              NO      YES      optimizer_mode                    YES     YES  
db_8k_cache_size              NO      YES      optimizer_secure_view_merging     NO      YES  
db_block_buffers              NO      NO       os_authent_prefix                 NO      NO   
db_block_checking             YES     YES      os_roles                          NO      NO   
db_block_checksum             NO      YES      parallel_adaptive_multi_user      NO      YES  
db_block_size                 NO      NO       parallel_automatic_tuning         NO      NO   
db_cache_advice               NO      YES      parallel_execution_message_size   NO      NO   
db_cache_size                 NO      YES      parallel_instance_group           YES     YES  
db_create_file_dest           YES     YES      parallel_max_servers              NO      YES  
db_create_online_log_dest_1   YES     YES      parallel_min_percent              YES     NO   
db_create_online_log_dest_2   YES     YES      parallel_min_servers              NO      YES  
db_create_online_log_dest_3   YES     YES      parallel_server                   NO      NO   
db_create_online_log_dest_4   YES     YES      parallel_server_instances         NO      NO   
db_create_online_log_dest_5   YES     YES      parallel_threads_per_cpu          NO      YES  
db_domain                     NO      NO       pga_aggregate_target              NO      YES  
db_file_multiblock_read_count YES     YES      plsql_ccflags                     YES     YES  
db_file_name_convert          YES     NO       plsql_code_type                   YES     YES  
db_files                      NO      NO       plsql_compiler_flags              YES     YES  
db_flashback_retention_target NO      YES      plsql_debug                       YES     YES  
db_keep_cache_size            NO      YES      plsql_native_library_dir          NO      YES  
db_name                       NO      NO       plsql_native_library_subdir_count NO      YES  
db_recovery_file_dest         NO      YES      plsql_optimize_level              YES     YES  
db_recovery_file_dest_size    NO      YES      plsql_v2_compatibility            YES     YES  
db_recycle_cache_size         NO      YES      plsql_warnings                    YES     YES  
db_unique_name                NO      NO       pre_page_sga                      NO      NO   
db_writer_processes           NO      NO       processes                         NO      NO   
dbwr_io_slaves                NO      NO       query_rewrite_enabled             YES     YES  
ddl_wait_for_locks            YES     YES      query_rewrite_integrity           YES     YES  
dg_broker_config_file1        NO      YES      rdbms_server_dn                   NO      NO   
dg_broker_config_file2        NO      YES      read_only_open_delayed            NO      NO   
dg_broker_start               NO      YES      recovery_parallelism              NO      NO   
disk_asynch_io                NO      NO       recyclebin                        YES     YES  
dispatchers                   NO      YES      remote_archive_enable             NO      NO   
distributed_lock_timeout      NO      NO       remote_dependencies_mode          YES     YES  
dml_locks                     NO      NO       remote_listener                   NO      YES  
drs_start                     NO      YES      remote_login_passwordfile         NO      NO   
event                         NO      NO       remote_os_authent                 NO      NO   
fal_client                    NO      YES      remote_os_roles                   NO      NO   
fal_server                    NO      YES      replication_dependency_tracking   NO      NO   
fast_start_io_target          NO      YES      resource_limit                    NO      YES  
fast_start_mttr_target        NO      YES      resource_manager_plan             NO      YES  
fast_start_parallel_rollback  NO      YES      resumable_timeout                 YES     YES  
file_mapping                  NO      YES      rollback_segments                 NO      NO   
fileio_network_adapters       NO      NO       serial_reuse                      NO      NO   
filesystemio_options          NO      NO       service_names                     NO      YES  
fixed_date                    NO      YES      session_cached_cursors            YES     NO   
gc_files_to_locks             NO      NO       session_max_open_files            NO      NO   
gcs_server_processes          NO      NO       sessions                          NO      NO   
global_context_pool_size      NO      NO       sga_max_size                      NO      NO   
global_names                  YES     YES      sga_target                        NO      YES  
hash_area_size                YES     NO       shadow_core_dump                  NO      NO   
hi_shared_memory_address      NO      NO       shared_memory_address             NO      NO   
hs_autoregister               NO      YES      shared_pool_reserved_size         NO      NO   
ifile                         NO      NO       shared_pool_size                  NO      YES  
instance_groups               NO      NO       shared_server_sessions            NO      YES  
instance_name                 NO      NO       shared_servers                    NO      YES  
instance_number               NO      NO       skip_unusable_indexes             YES     YES  
instance_type                 NO      NO       smtp_out_server                   YES     YES  
java_max_sessionspace_size    NO      NO       sort_area_retained_size           YES     NO   
java_pool_size                NO      YES      sort_area_size                    YES     NO   
java_soft_sessionspace_limit  NO      NO       spfile                            NO      NO   
job_queue_processes           NO      YES      sql92_security                    NO      NO   
large_pool_size               NO      YES      sql_trace                         YES     YES  
ldap_directory_access         NO      YES      sql_version                       YES     NO   
license_max_sessions          NO      YES      sqltune_category                  YES     YES  
license_max_users             NO      YES      standby_archive_dest              NO      YES  
license_sessions_warning      NO      YES      standby_file_management           NO      YES  
local_listener                NO      YES      star_transformation_enabled       YES     YES  
lock_name_space               NO      NO       statistics_level                  YES     YES  
lock_sga                      NO      NO       streams_pool_size                 NO      YES  
log_archive_config            NO      YES      tape_asynch_io                    NO      NO   
log_archive_dest              NO      YES      thread                            NO      YES  
log_archive_dest_1            YES     YES      timed_os_statistics               YES     YES  
log_archive_dest_10           YES     YES      timed_statistics                  YES     YES  
log_archive_dest_2            YES     YES      trace_enabled                     NO      YES  
log_archive_dest_3            YES     YES      tracefile_identifier              YES     NO   
log_archive_dest_4            YES     YES      transactions                      NO      NO   
log_archive_dest_5            YES     YES      transactions_per_rollback_segment NO      NO   
log_archive_dest_6            YES     YES      undo_management                   NO      NO   
log_archive_dest_7            YES     YES      undo_retention                    NO      YES  
log_archive_dest_8            YES     YES      undo_tablespace                   NO      YES  
log_archive_dest_9            YES     YES      use_indirect_data_buffers         NO      NO   
log_archive_dest_state_1      YES     YES      user_dump_dest                    NO      YES  
log_archive_dest_state_10     YES     YES      utl_file_dir                      NO      NO   
log_archive_dest_state_2      YES     YES      workarea_size_policy              YES     YES 

這個列表回答了Manager Lee的問題。

-- The End --

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/519536/viewspace-557305/,如需轉載,請註明出處,否則將追究法律責任。

相關文章