检查12C环境下可在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	TRUE	TRUE	TRUE
nls_language	AMERICAN	AMERICAN	TRUE
nls_territory	AMERICA	AMERICA	TRUE
nls_sort			TRUE
nls_date_language			TRUE
nls_date_format			TRUE
nls_currency			TRUE
nls_numeric_characters			TRUE
nls_iso_currency			TRUE
nls_calendar			TRUE
nls_time_format			TRUE
nls_timestamp_format			TRUE
nls_time_tz_format			TRUE
nls_timestamp_tz_format			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
db_performance_profile			TRUE
log_archive_dest_1			TRUE
log_archive_dest_2	service=DGTCDB lgwr sync affir m valid_for=(online_logfiles,p rimary_role) db_unique_name=DG TCDB	service=DGTCDB lgwr sync affirm valid_fo r=(online_logfiles,p rimary_role) db_uniq ue_name=DGTCDB	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	128	128	TRUE
db_create_file_dest	+DATADG01	+DATADG01	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	OFF	OFF	TRUE
inmemory_size	0	0	TRUE
db_block_checking	FALSE	FALSE	TRUE
recyclebin	on	on	TRUE
db_index_compression_inheritance	NONE	NONE	TRUE
db_securefile	PREFERRED	PREFERRED	TRUE
inmemory_clause_default			TRUE
inmemory_force	DEFAULT	DEFAULT	TRUE
inmemory_query	ENABLE	ENABLE	TRUE
create_stored_outlines			TRUE
O7_DICTIONARY_ACCESSIBILITY	FALSE	FALSE	TRUE
global_names	FALSE	FALSE	TRUE
shared_servers	1	1	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
job_queue_processes	1000	1000	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.2	12.1.0.2	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_degree_level	100	100	TRUE
optimizer_adaptive_features	TRUE	TRUE	TRUE
optimizer_inmemory_aware	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_os_credential			TRUE
pdb_lockdown			TRUE
pdb_file_name_convert			TRUE
exclude_seed_cdb_view	TRUE	TRUE	TRUE

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28612416/viewspace-2120125/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28612416/viewspace-2120125/