CNDBA社区
http://www.cndba.cn/dave/article/218
在Oracle 12c中可以在CDB和PDB级别修改参数，可以直接查看v$parameter 视图来查看PDB 级别可以修改的参数，具体如下：http://www.cndba.cn/dave/article/218
http://www.cndba.cn/dave/article/218
http://www.cndba.cn/dave/article/218
http://www.cndba.cn/dave/article/218http://www.cndba.cn/dave/article/218http://www.cndba.cn/dave/article/218
http://www.cndba.cn/dave/article/218
SQL> col DISPLAY_VALUE for a30 SQL> set lin 130 SQL> col name for a40 SQL> col value for a30 SQL> set pages 300 SQL> set colsep | SQL> SELECT NAME,VALUE,DISPLAY_VALUE FROM v$parameter WHERE ISPDB_MODIFIABLE='TRUE'; NAME |VALUE |DISPLAY_VALUE ----------------------------------------|------------------------------|------------------------------ sessions |472 |472 timed_statistics |TRUE |TRUE timed_os_statistics |0 |0 resource_limit |TRUE |TRUE nls_language |AMERICAN |AMERICAN nls_territory |AMERICA |AMERICA nls_sort |BINARY |BINARY nls_date_language |AMERICAN |AMERICAN nls_date_format |YYYY:MM:DD HH24:MI:SS |YYYY:MM:DD HH24:MI:SS nls_currency |$ |$ nls_numeric_characters |., |., nls_iso_currency |AMERICA |AMERICA nls_calendar |GREGORIAN |GREGORIAN nls_time_format |HH.MI.SSXFF AM |HH.MI.SSXFF AM nls_timestamp_format |DD-MON-RR HH.MI.SSXFF AM |DD-MON-RR HH.MI.SSXFF AM nls_time_tz_format |HH.MI.SSXFF AM TZR |HH.MI.SSXFF AM TZR nls_timestamp_tz_format |DD-MON-RR HH.MI.SSXFF AM TZR |DD-MON-RR HH.MI.SSXFF AM TZR nls_dual_currency |$ |$ nls_comp |BINARY |BINARY nls_length_semantics |BYTE |BYTE nls_nchar_conv_excp |FALSE |FALSE resource_manager_plan | | db_performance_profile | | log_archive_dest_1 | | log_archive_dest_2 | | log_archive_dest_3 | | log_archive_dest_4 | | log_archive_dest_5 | | log_archive_dest_6 | | log_archive_dest_7 | | log_archive_dest_8 | | log_archive_dest_9 | | log_archive_dest_10 | | log_archive_dest_11 | | log_archive_dest_12 | | log_archive_dest_13 | | log_archive_dest_14 | | log_archive_dest_15 | | log_archive_dest_16 | | log_archive_dest_17 | | log_archive_dest_18 | | log_archive_dest_19 | | log_archive_dest_20 | | log_archive_dest_21 | | log_archive_dest_22 | | log_archive_dest_23 | | log_archive_dest_24 | | log_archive_dest_25 | | log_archive_dest_26 | | log_archive_dest_27 | | log_archive_dest_28 | | log_archive_dest_29 | | log_archive_dest_30 | | log_archive_dest_31 | | log_archive_dest_state_1 |enable |enable log_archive_dest_state_2 |enable |enable log_archive_dest_state_3 |enable |enable log_archive_dest_state_4 |enable |enable log_archive_dest_state_5 |enable |enable log_archive_dest_state_6 |enable |enable log_archive_dest_state_7 |enable |enable log_archive_dest_state_8 |enable |enable log_archive_dest_state_9 |enable |enable log_archive_dest_state_10 |enable |enable log_archive_dest_state_11 |enable |enable log_archive_dest_state_12 |enable |enable log_archive_dest_state_13 |enable |enable log_archive_dest_state_14 |enable |enable log_archive_dest_state_15 |enable |enable log_archive_dest_state_16 |enable |enable log_archive_dest_state_17 |enable |enable log_archive_dest_state_18 |enable |enable log_archive_dest_state_19 |enable |enable log_archive_dest_state_20 |enable |enable log_archive_dest_state_21 |enable |enable log_archive_dest_state_22 |enable |enable log_archive_dest_state_23 |enable |enable log_archive_dest_state_24 |enable |enable log_archive_dest_state_25 |enable |enable log_archive_dest_state_26 |enable |enable log_archive_dest_state_27 |enable |enable log_archive_dest_state_28 |enable |enable log_archive_dest_state_29 |enable |enable log_archive_dest_state_30 |enable |enable log_archive_dest_state_31 |enable |enable log_archive_min_succeed_dest |1 |1 db_file_multiblock_read_count |127 |127 db_create_file_dest |+DATA |+DATA db_create_online_log_dest_1 | | db_create_online_log_dest_2 | | db_create_online_log_dest_3 | | db_create_online_log_dest_4 | | db_create_online_log_dest_5 | | db_unrecoverable_scn_tracking |TRUE |TRUE temp_undo_enabled |FALSE |FALSE resumable_timeout |0 |0 heat_map |OFF |OFF inmemory_size |0 |0 db_block_checking |FALSE |FALSE recyclebin |on |on db_index_compression_inheritance |NONE |NONE db_securefile |PREFERRED |PREFERRED inmemory_clause_default | | inmemory_force |DEFAULT |DEFAULT inmemory_query |ENABLE |ENABLE create_stored_outlines | | O7_DICTIONARY_ACCESSIBILITY |FALSE |FALSE global_names |FALSE |FALSE shared_servers |1 |1 listener_networks | | remote_dependencies_mode |TIMESTAMP |TIMESTAMP smtp_out_server | | plsql_v2_compatibility |FALSE |FALSE plsql_warnings |DISABLE:ALL |DISABLE:ALL plsql_code_type |INTERPRETED |INTERPRETED plsql_debug |FALSE |FALSE plsql_optimize_level |2 |2 plsql_ccflags | | plscope_settings |IDENTIFIERS:NONE |IDENTIFIERS:NONE java_jit_enabled |TRUE |TRUE job_queue_processes |1000 |1000 cursor_sharing |EXACT |EXACT result_cache_mode |MANUAL |MANUAL parallel_instance_group | | result_cache_remote_expiration |0 |0 object_cache_optimal_size |102400 |102400 object_cache_max_size_percent |10 |10 commit_write | | commit_wait | | commit_logging | | optimizer_features_enable |12.1.0.2 |12.1.0.2 fixed_date | | sort_area_size |65536 |65536 sort_area_retained_size |0 |0 cell_offload_processing |TRUE |TRUE cell_offload_decryption |TRUE |TRUE cell_offload_parameters | | cell_offload_compaction |ADAPTIVE |ADAPTIVE cell_offload_plan_display |AUTO |AUTO open_cursors |300 |300 sql_trace |FALSE |FALSE optimizer_mode |ALL_ROWS |ALL_ROWS star_transformation_enabled |FALSE |FALSE parallel_degree_policy |MANUAL |MANUAL parallel_io_cap_enabled |FALSE |FALSE optimizer_index_cost_adj |100 |100 optimizer_index_caching |0 |0 query_rewrite_enabled |TRUE |TRUE query_rewrite_integrity |enforced |enforced workarea_size_policy |AUTO |AUTO optimizer_dynamic_sampling |2 |2 statistics_level |TYPICAL |TYPICAL cursor_bind_capture_destination |memory+disk |memory+disk skip_unusable_indexes |TRUE |TRUE optimizer_secure_view_merging |TRUE |TRUE ddl_lock_timeout |0 |0 deferred_segment_creation |TRUE |TRUE optimizer_use_pending_statistics |FALSE |FALSE optimizer_capture_sql_plan_baselines |FALSE |FALSE optimizer_use_sql_plan_baselines |TRUE |TRUE parallel_min_time_threshold |AUTO |AUTO parallel_degree_limit |CPU |CPU parallel_force_local |FALSE |FALSE optimizer_use_invisible_indexes |FALSE |FALSE dst_upgrade_insert_conv |TRUE |TRUE max_string_size |STANDARD |STANDARD optimizer_adaptive_reporting_only |FALSE |FALSE parallel_degree_level |100 |100 optimizer_adaptive_features |TRUE |TRUE optimizer_inmemory_aware |TRUE |TRUE enable_ddl_logging |FALSE |FALSE xml_db_events |enable |enable olap_page_pool_size |0 |0 asm_diskstring | | sqltune_category |DEFAULT |DEFAULT spatial_vector_acceleration |FALSE |FALSE max_dump_file_size |unlimited |unlimited cell_offloadgroup_name | | pdb_os_credential | | pdb_lockdown | | pdb_file_name_convert | | exclude_seed_cdb_view |TRUE |TRUE 182 rows selected.
http://www.cndba.cn/dave/article/218
http://www.cndba.cn/dave/article/218
版权声明：本文为博主原创文章，未经博主允许不得转载。
