当前位置:Gxlcms > mysql > oracle12c_pdb级可以修改的参数

oracle12c_pdb级可以修改的参数

时间:2021-07-01 10:21:17 帮助过:69人阅读

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.

人气教程排行