oracle12c_pdb级可以修改的参数
- WBOYOriginal
- 2016-06-07 16:37:501549Durchsuche
oracle12c虽然提供了可以在pdb中设置一些参数，但是能设置的很少。列出来以备不时之需 SQL SELECT NAME,VALUE,DISPLAY_VALUE,ISPDB_MODIFIABLE FROM v$parameter WHERE ISPDB_MODIFIABLE='TRUE'; NAME VALUE DISPLAY_VALUE ISPDB---------------------------
oracle12c虽然提供了可以在pdb中设置一些参数，但是能设置的很少。列出来以备不时之需
SQL> SELECT NAME,VALUE,DISPLAY_VALUE,ISPDB_MODIFIABLE FROM v$parameter WHERE ISPDB_MODIFIABLE='TRUE'; NAME VALUE DISPLAY_VALUE ISPDB ---------------------------------------- ---------------------------------------- ---------------------------------------- ----- sessions 472 472 TRUE timed_statistics TRUE TRUE TRUE timed_os_statistics 0 0 TRUE resource_limit FALSE FALSE TRUE nls_language AMERICAN AMERICAN TRUE nls_territory AMERICA AMERICA TRUE nls_sort BINARY BINARY TRUE nls_date_language AMERICAN AMERICAN TRUE nls_date_format DD-MON-RR DD-MON-RR TRUE nls_currency $ $ TRUE nls_numeric_characters ., ., TRUE nls_iso_currency AMERICA AMERICA TRUE nls_calendar GREGORIAN GREGORIAN TRUE nls_time_format HH.MI.SSXFF AM HH.MI.SSXFF AM TRUE nls_timestamp_format DD-MON-RR HH.MI.SSXFF AM DD-MON-RR HH.MI.SSXFF AM TRUE nls_time_tz_format HH.MI.SSXFF AM TZR HH.MI.SSXFF AM TZR TRUE nls_timestamp_tz_format DD-MON-RR HH.MI.SSXFF AM TZR DD-MON-RR HH.MI.SSXFF AM TZR TRUE nls_dual_currency $ $ TRUE nls_comp BINARY BINARY TRUE nls_length_semantics BYTE BYTE TRUE nls_nchar_conv_excp FALSE FALSE TRUE resource_manager_plan TRUE log_archive_dest_1 location=/other/archivelog location=/other/archivelog TRUE log_archive_dest_2 TRUE log_archive_dest_3 TRUE log_archive_dest_4 TRUE log_archive_dest_5 TRUE log_archive_dest_6 TRUE log_archive_dest_7 TRUE log_archive_dest_8 TRUE log_archive_dest_9 TRUE log_archive_dest_10 TRUE log_archive_dest_11 TRUE log_archive_dest_12 TRUE log_archive_dest_13 TRUE log_archive_dest_14 TRUE log_archive_dest_15 TRUE log_archive_dest_16 TRUE log_archive_dest_17 TRUE log_archive_dest_18 TRUE log_archive_dest_19 TRUE log_archive_dest_20 TRUE log_archive_dest_21 TRUE log_archive_dest_22 TRUE log_archive_dest_23 TRUE log_archive_dest_24 TRUE log_archive_dest_25 TRUE log_archive_dest_26 TRUE log_archive_dest_27 TRUE log_archive_dest_28 TRUE log_archive_dest_29 TRUE log_archive_dest_30 TRUE log_archive_dest_31 TRUE log_archive_dest_state_1 enable enable TRUE log_archive_dest_state_2 enable enable TRUE log_archive_dest_state_3 enable enable TRUE log_archive_dest_state_4 enable enable TRUE log_archive_dest_state_5 enable enable TRUE log_archive_dest_state_6 enable enable TRUE log_archive_dest_state_7 enable enable TRUE log_archive_dest_state_8 enable enable TRUE log_archive_dest_state_9 enable enable TRUE log_archive_dest_state_10 enable enable TRUE log_archive_dest_state_11 enable enable TRUE log_archive_dest_state_12 enable enable TRUE log_archive_dest_state_13 enable enable TRUE log_archive_dest_state_14 enable enable TRUE log_archive_dest_state_15 enable enable TRUE log_archive_dest_state_16 enable enable TRUE log_archive_dest_state_17 enable enable TRUE log_archive_dest_state_18 enable enable TRUE log_archive_dest_state_19 enable enable TRUE log_archive_dest_state_20 enable enable TRUE log_archive_dest_state_21 enable enable TRUE log_archive_dest_state_22 enable enable TRUE log_archive_dest_state_23 enable enable TRUE log_archive_dest_state_24 enable enable TRUE log_archive_dest_state_25 enable enable TRUE log_archive_dest_state_26 enable enable TRUE log_archive_dest_state_27 enable enable TRUE log_archive_dest_state_28 enable enable TRUE log_archive_dest_state_29 enable enable TRUE log_archive_dest_state_30 enable enable TRUE log_archive_dest_state_31 enable enable TRUE log_archive_min_succeed_dest 1 1 TRUE db_file_multiblock_read_count 106 106 TRUE db_create_file_dest TRUE db_create_online_log_dest_1 TRUE db_create_online_log_dest_2 TRUE db_create_online_log_dest_3 TRUE db_create_online_log_dest_4 TRUE db_create_online_log_dest_5 TRUE db_unrecoverable_scn_tracking TRUE TRUE TRUE temp_undo_enabled FALSE FALSE TRUE resumable_timeout 0 0 TRUE heat_map ON ON TRUE recyclebin ON ON TRUE db_index_compression_inheritance NONE NONE TRUE db_securefile PREFERRED PREFERRED TRUE create_stored_outlines TRUE O7_DICTIONARY_ACCESSIBILITY FALSE FALSE TRUE global_names FALSE FALSE TRUE listener_networks TRUE remote_dependencies_mode TIMESTAMP TIMESTAMP TRUE smtp_out_server TRUE plsql_v2_compatibility FALSE FALSE TRUE plsql_warnings DISABLE:ALL DISABLE:ALL TRUE plsql_code_type INTERPRETED INTERPRETED TRUE plsql_debug FALSE FALSE TRUE plsql_optimize_level 2 2 TRUE plsql_ccflags TRUE plscope_settings IDENTIFIERS:NONE IDENTIFIERS:NONE TRUE java_jit_enabled TRUE TRUE TRUE cursor_sharing EXACT EXACT TRUE result_cache_mode MANUAL MANUAL TRUE parallel_instance_group TRUE result_cache_remote_expiration 0 0 TRUE object_cache_optimal_size 102400 102400 TRUE object_cache_max_size_percent 10 10 TRUE commit_write TRUE commit_wait TRUE commit_logging TRUE optimizer_features_enable 12.1.0.1 12.1.0.1 TRUE fixed_date TRUE sort_area_size 65536 65536 TRUE sort_area_retained_size 0 0 TRUE cell_offload_processing TRUE TRUE TRUE cell_offload_decryption TRUE TRUE TRUE cell_offload_parameters TRUE cell_offload_compaction ADAPTIVE ADAPTIVE TRUE cell_offload_plan_display AUTO AUTO TRUE open_cursors 300 300 TRUE sql_trace FALSE FALSE TRUE optimizer_mode ALL_ROWS ALL_ROWS TRUE star_transformation_enabled FALSE FALSE TRUE parallel_degree_policy MANUAL MANUAL TRUE parallel_io_cap_enabled FALSE FALSE TRUE optimizer_index_cost_adj 100 100 TRUE optimizer_index_caching 0 0 TRUE query_rewrite_enabled TRUE TRUE TRUE query_rewrite_integrity enforced enforced TRUE workarea_size_policy AUTO AUTO TRUE optimizer_dynamic_sampling 2 2 TRUE statistics_level TYPICAL TYPICAL TRUE cursor_bind_capture_destination memory+disk memory+disk TRUE skip_unusable_indexes TRUE TRUE TRUE optimizer_secure_view_merging TRUE TRUE TRUE ddl_lock_timeout 0 0 TRUE deferred_segment_creation TRUE TRUE TRUE optimizer_use_pending_statistics FALSE FALSE TRUE optimizer_capture_sql_plan_baselines FALSE FALSE TRUE optimizer_use_sql_plan_baselines TRUE TRUE TRUE parallel_min_time_threshold AUTO AUTO TRUE parallel_degree_limit CPU CPU TRUE parallel_force_local FALSE FALSE TRUE optimizer_use_invisible_indexes FALSE FALSE TRUE dst_upgrade_insert_conv TRUE TRUE TRUE max_string_size STANDARD STANDARD TRUE optimizer_adaptive_reporting_only FALSE FALSE TRUE parallel_fault_tolerance_enabled FALSE FALSE TRUE parallel_degree_level 100 100 TRUE optimizer_adaptive_features TRUE TRUE TRUE enable_ddl_logging FALSE FALSE TRUE xml_db_events enable enable TRUE olap_page_pool_size 0 0 TRUE asm_diskstring TRUE sqltune_category DEFAULT DEFAULT TRUE spatial_vector_acceleration FALSE FALSE TRUE max_dump_file_size unlimited unlimited TRUE cell_offloadgroup_name TRUE pdb_file_name_convert TRUE 171 ROWS selected.
原文地址：oracle12c_pdb级可以修改的参数, 感谢原作者分享。
Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：ORACLE DBA必备技能 – 使用OSWatcher(OSWBB)工具监控系统性能负Nächster Artikel：组合索引如何选择前导列的几点考虑