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 truetimed_statistics true true truetimed_os_statistics 0 0 trueresource_limit false false truenls_language american american truenls_territory america america truenls_sort binary binary truenls_date_language american american truenls_date_format dd-mon-rr dd-mon-rr truenls_currency $ $ truenls_numeric_characters ., ., truenls_iso_currency america america truenls_calendar gregorian gregorian truenls_time_format hh.mi.ssxff am hh.mi.ssxff am truenls_timestamp_format dd-mon-rr hh.mi.ssxff am dd-mon-rr hh.mi.ssxff am truenls_time_tz_format hh.mi.ssxff am tzr hh.mi.ssxff am tzr truenls_timestamp_tz_format dd-mon-rr hh.mi.ssxff am tzr dd-mon-rr hh.mi.ssxff am tzr truenls_dual_currency $ $ truenls_comp binary binary truenls_length_semantics byte byte truenls_nchar_conv_excp false false trueresource_manager_plan truelog_archive_dest_1 location=/other/archivelog location=/other/archivelog truelog_archive_dest_2 truelog_archive_dest_3 truelog_archive_dest_4 truelog_archive_dest_5 truelog_archive_dest_6 truelog_archive_dest_7 truelog_archive_dest_8 truelog_archive_dest_9 truelog_archive_dest_10 truelog_archive_dest_11 truelog_archive_dest_12 truelog_archive_dest_13 truelog_archive_dest_14 truelog_archive_dest_15 truelog_archive_dest_16 truelog_archive_dest_17 truelog_archive_dest_18 truelog_archive_dest_19 truelog_archive_dest_20 truelog_archive_dest_21 truelog_archive_dest_22 truelog_archive_dest_23 truelog_archive_dest_24 truelog_archive_dest_25 truelog_archive_dest_26 truelog_archive_dest_27 truelog_archive_dest_28 truelog_archive_dest_29 truelog_archive_dest_30 truelog_archive_dest_31 truelog_archive_dest_state_1 enable enable truelog_archive_dest_state_2 enable enable truelog_archive_dest_state_3 enable enable truelog_archive_dest_state_4 enable enable truelog_archive_dest_state_5 enable enable truelog_archive_dest_state_6 enable enable truelog_archive_dest_state_7 enable enable truelog_archive_dest_state_8 enable enable truelog_archive_dest_state_9 enable enable truelog_archive_dest_state_10 enable enable truelog_archive_dest_state_11 enable enable truelog_archive_dest_state_12 enable enable truelog_archive_dest_state_13 enable enable truelog_archive_dest_state_14 enable enable truelog_archive_dest_state_15 enable enable truelog_archive_dest_state_16 enable enable truelog_archive_dest_state_17 enable enable truelog_archive_dest_state_18 enable enable truelog_archive_dest_state_19 enable enable truelog_archive_dest_state_20 enable enable truelog_archive_dest_state_21 enable enable truelog_archive_dest_state_22 enable enable truelog_archive_dest_state_23 enable enable truelog_archive_dest_state_24 enable enable truelog_archive_dest_state_25 enable enable truelog_archive_dest_state_26 enable enable truelog_archive_dest_state_27 enable enable truelog_archive_dest_state_28 enable enable truelog_archive_dest_state_29 enable enable truelog_archive_dest_state_30 enable enable truelog_archive_dest_state_31 enable enable truelog_archive_min_succeed_dest 1 1 truedb_file_multiblock_read_count 106 106 truedb_create_file_dest truedb_create_online_log_dest_1 truedb_create_online_log_dest_2 truedb_create_online_log_dest_3 truedb_create_online_log_dest_4 truedb_create_online_log_dest_5 truedb_unrecoverable_scn_tracking true true truetemp_undo_enabled false false trueresumable_timeout 0 0 trueheat_map on on truerecyclebin on on truedb_index_compression_inheritance none none truedb_securefile preferred preferred truecreate_stored_outlines trueo7_dictionary_accessibility false false trueglobal_names false false truelistener_networks trueremote_dependencies_mode timestamp timestamp truesmtp_out_server trueplsql_v2_compatibility false false trueplsql_warnings disable:all disable:all trueplsql_code_type interpreted interpreted trueplsql_debug false false trueplsql_optimize_level 2 2 trueplsql_ccflags trueplscope_settings identifiers:none identifiers:none truejava_jit_enabled true true truecursor_sharing exact exact trueresult_cache_mode manual manual trueparallel_instance_group trueresult_cache_remote_expiration 0 0 trueobject_cache_optimal_size 102400 102400 trueobject_cache_max_size_percent 10 10 truecommit_write truecommit_wait truecommit_logging trueoptimizer_features_enable 12.1.0.1 12.1.0.1 truefixed_date truesort_area_size 65536 65536 truesort_area_retained_size 0 0 truecell_offload_processing true true truecell_offload_decryption true true truecell_offload_parameters truecell_offload_compaction adaptive adaptive truecell_offload_plan_display auto auto trueopen_cursors 300 300 truesql_trace false false trueoptimizer_mode all_rows all_rows truestar_transformation_enabled false false trueparallel_degree_policy manual manual trueparallel_io_cap_enabled false false trueoptimizer_index_cost_adj 100 100 trueoptimizer_index_caching 0 0 truequery_rewrite_enabled true true truequery_rewrite_integrity enforced enforced trueworkarea_size_policy auto auto trueoptimizer_dynamic_sampling 2 2 truestatistics_level typical typical truecursor_bind_capture_destination memory+disk memory+disk trueskip_unusable_indexes true true trueoptimizer_secure_view_merging true true trueddl_lock_timeout 0 0 truedeferred_segment_creation true true trueoptimizer_use_pending_statistics false false trueoptimizer_capture_sql_plan_baselines false false trueoptimizer_use_sql_plan_baselines true true trueparallel_min_time_threshold auto auto trueparallel_degree_limit cpu cpu trueparallel_force_local false false trueoptimizer_use_invisible_indexes false false truedst_upgrade_insert_conv true true truemax_string_size standard standard trueoptimizer_adaptive_reporting_only false false trueparallel_fault_tolerance_enabled false false trueparallel_degree_level 100 100 trueoptimizer_adaptive_features true true trueenable_ddl_logging false false truexml_db_events enable enable trueolap_page_pool_size 0 0 trueasm_diskstring truesqltune_category default default truespatial_vector_acceleration false false truemax_dump_file_size unlimited unlimited truecell_offloadgroup_name truepdb_file_name_convert true 171 rows selected.
原文地址：oracle12c_pdb级可以修改的参数, 感谢原作者分享。