There are 171 parameters modifiable at PDB level.
In the list below I filtered one the log_archive_* ones as this would make a too long list.
SQL> select banner from v$version where rownum < 2;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
SQL> select name, ispdb_modifiable
2 from v$parameter
3 where ispdb_modifiable='TRUE' and name not like 'log_archive%
NAME ISPDB
---------------------------------------- -----
sessions TRUE
timed_statistics TRUE
timed_os_statistics TRUE
resource_limit TRUE
nls_language TRUE
nls_territory 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 TRUE
nls_length_semantics TRUE
nls_nchar_conv_excp TRUE
resource_manager_plan TRUE
db_file_multiblock_read_count 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
temp_undo_enabled TRUE
resumable_timeout TRUE
heat_map TRUE
recyclebin TRUE
db_index_compression_inheritance TRUE
db_securefile TRUE
create_stored_outlines TRUE
O7_DICTIONARY_ACCESSIBILITY TRUE
global_names TRUE
listener_networks TRUE
remote_dependencies_mode TRUE
smtp_out_server TRUE
plsql_v2_compatibility TRUE
plsql_warnings TRUE
plsql_code_type TRUE
plsql_debug TRUE
plsql_optimize_level TRUE
plsql_ccflags TRUE
plscope_settings TRUE
java_jit_enabled TRUE
cursor_sharing TRUE
result_cache_mode TRUE
parallel_instance_group TRUE
result_cache_remote_expiration TRUE
object_cache_optimal_size TRUE
object_cache_max_size_percent TRUE
commit_write TRUE
commit_wait TRUE
commit_logging TRUE
optimizer_features_enable TRUE
fixed_date TRUE
sort_area_size TRUE
sort_area_retained_size TRUE
cell_offload_processing TRUE
cell_offload_decryption TRUE
cell_offload_parameters TRUE
cell_offload_compaction TRUE
cell_offload_plan_display TRUE
open_cursors TRUE
sql_trace TRUE
optimizer_mode TRUE
star_transformation_enabled TRUE
parallel_degree_policy TRUE
parallel_io_cap_enabled TRUE
optimizer_index_cost_adj TRUE
optimizer_index_caching TRUE
query_rewrite_enabled TRUE
query_rewrite_integrity TRUE
workarea_size_policy TRUE
optimizer_dynamic_sampling TRUE
statistics_level TRUE
cursor_bind_capture_destination TRUE
skip_unusable_indexes TRUE
optimizer_secure_view_merging TRUE
ddl_lock_timeout TRUE
deferred_segment_creation TRUE
optimizer_use_pending_statistics TRUE
optimizer_capture_sql_plan_baselines TRUE
optimizer_use_sql_plan_baselines TRUE
parallel_min_time_threshold TRUE
parallel_degree_limit TRUE
parallel_force_local TRUE
optimizer_use_invisible_indexes TRUE
dst_upgrade_insert_conv TRUE
max_string_size TRUE
optimizer_adaptive_reporting_only TRUE
parallel_fault_tolerance_enabled TRUE
parallel_degree_level TRUE
optimizer_adaptive_features TRUE
enable_ddl_logging TRUE
xml_db_events TRUE
olap_page_pool_size TRUE
asm_diskstring TRUE
sqltune_category TRUE
spatial_vector_acceleration TRUE
max_dump_file_size TRUE
cell_offloadgroup_name TRUE
pdb_file_name_convert TRUE
No comments:
Post a Comment