【統計】能夠在session級別和system級別修改的oracle引數統計
這個列表回答了一個問題:哪些引數是可以在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 --
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11g 修改表級別的自動收集統計資訊比率Oracle
- 系統執行級別及修改方法
- PostgreSQLGUC引數級別介紹SQL
- 主從故障處理--session 級別引數複製錯誤Session
- Oracle不同版本檢視資料庫session/system級別設定了哪些eventsOracle資料庫Session
- 在Oracle中session和process的區別(轉)OracleSession
- 修改oracle 的統計資訊Oracle
- alter database和alter system和alter session的區別DatabaseSession
- 系統級別的window,應用級別的彈出框Dialog/popwindow (dismiss和cancel和hide)IDE
- Linux執行級別的檢視和修改Linux
- 事務系統的隔離級別
- ORACLE的隔離級別Oracle
- 程式設計師修仙之路--優雅快速的統計千萬級別uv(留言送書)程式設計師
- 量子計算能夠量級加速人工智慧的發展人工智慧
- 程式設計師級別,你到哪一級?程式設計師
- 程式設計師的八種級別程式設計師
- 程式設計師的八個級別程式設計師
- Linux 系統執行級別Linux
- Linux系統執行級別Linux
- 別人家的面試題:統計“1”的個數面試題
- 程式設計師的八種級別,你在哪一級?程式設計師
- 四個級別的 “自由” 程式設計師程式設計師
- 程式設計師的八個級別薦程式設計師
- mysql修改事務隔離級別MySql
- 如何處理表空間級別,表級別,索引級別的碎片索引
- 統計session 開啟的遊標數目Session
- Oracle收集統計資訊之NO_INVALIDATE引數Oracle
- Oracle 統計量NO_INVALIDATE引數配置(下)Oracle
- Oracle 統計量NO_INVALIDATE引數配置(上)Oracle
- Linux系統的七個執行級別Linux
- Oracle SYS使用者無法設定session級別的read onlyOracleSession
- 【江楓 】Oracle 9i和10g在create index和rebuild index的統計資訊的區別OracleIndexRebuild
- Redis 實戰篇:巧用資料型別實現億級資料統計Redis資料型別
- 在Linux中,系統預設的執行級別是什麼?Linux
- 9i,10g 優化器動態取樣級別引數 -- optimizer_dynamic_sampling (統計優化)優化
- Oracle升級中的引數補充Oracle
- Oracle的隔離級別(Isolation Level)Oracle
- 程式設計師的十種級別[轉載]程式設計師