oracle12c_pdb级可以修改的参数
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.
原文地址：oracle12c_pdb级可以修改的参数, 感谢原作者分享。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1389
52
How to change the personal name in the group on DingTalk_How to modify the personal name in the group on DingTalk
Mar 29, 2024 pm 08:41 PM
1. First open DingTalk. 2. Open the group chat and click the three dots in the upper right corner. 3. Find my nickname in this group. 4. Click to enter to modify and save.
Can Douyin Blue V change its name? What are the steps to change the name of corporate Douyin Blue V account?
Mar 22, 2024 pm 12:51 PM
Douyin Blue V certification is the official certification of a company or brand on the Douyin platform, which helps enhance brand image and credibility. With the adjustment of corporate development strategy or the update of brand image, the company may want to change the name of Douyin Blue V certification. So, can Douyin Blue V change its name? The answer is yes. This article will introduce in detail the steps to modify the name of the enterprise Douyin Blue V account. 1. Can Douyin Blue V change its name? You can change the name of Douyin Blue V account. According to Douyin’s official regulations, corporate Blue V certified accounts can apply to change their account names after meeting certain conditions. Generally speaking, enterprises need to provide relevant supporting materials, such as business licenses, organization code certificates, etc., to prove the legality and necessity of changing the name. 2. What are the steps to modify the name of corporate Douyin Blue V account?
Win10 sleep time modification tips revealed
Mar 08, 2024 pm 06:39 PM
Win10 Sleep Time Modification Tips Revealed As one of the currently widely used operating systems, Windows 10 has a sleep function to help users save power and protect the screen when not using the computer. However, sometimes the default sleep time does not meet the needs of users, so it is particularly important to know how to modify the Win10 sleep time. This article will reveal the tips for modifying the sleep time of Win10, allowing you to easily customize the system’s sleep settings. 1. Modify Win10 sleep time through “Settings” First, the simplest fix
C++ function parameter type safety check
Apr 19, 2024 pm 12:00 PM
C++ parameter type safety checking ensures that functions only accept values of expected types through compile-time checks, run-time checks, and static assertions, preventing unexpected behavior and program crashes: Compile-time type checking: The compiler checks type compatibility. Runtime type checking: Use dynamic_cast to check type compatibility, and throw an exception if there is no match. Static assertion: Assert type conditions at compile time.
How to modify the address location of published products on Xianyu
Mar 28, 2024 pm 03:36 PM
When publishing products on the Xianyu platform, users can customize the geographical location information of the product according to the actual situation, so that potential buyers can more accurately grasp the specific location of the product. Once the product is successfully put on the shelves, there is no need to worry if the seller's location changes. The Xianyu platform provides a flexible and convenient modification function. So when we want to modify the address of a published product, how do we modify it? This tutorial guide will provide you with a detailed step-by-step guide. I hope it can help. Everyone! How to modify the release product address in Xianyu? 1. Open Xianyu, click on what I published, select the product, and click Edit. 2. Click the positioning icon and select the address you want to set.
How to modify the greeting content for boss direct recruitment
Mar 01, 2024 pm 03:40 PM
In the job recruitment software called Boss Direct Jobs, users can personalize their greetings to better demonstrate their personality and job search intentions. However, sometimes the default greeting terms are rather mechanical and rigid. Many users want to make their own changes but don’t know where to set them. So this tutorial guide will introduce the detailed modification steps for players who want to know more. Come and follow this article to find out! How to change the answer when a boss directly hires someone to say hello: [Boss directly hires]-[My]-[Settings Icon]-[Greeting Language]. Specific steps: 1. First, we click on the boss direct recruitment software. After entering the homepage, we click [My] in the lower right corner; 2. Then when we come to the My page, we can see the relevant data.
Go Language Programming Guide: Implementation of Modifying Hosts File
Mar 07, 2024 am 10:51 AM
Title: Go Language Programming Guide: Implementation of Modifying the Hosts File In the daily software development process, we often encounter situations where we need to modify the hosts file in the operating system. The Hosts file is a text file without extension used to map IP addresses and host names. It is usually used to set up domain name resolution locally. In this article, we will introduce how to use the Go language to implement the function of modifying the hosts file of the operating system, and give specific code examples. First, we need to create a G that can modify the hosts file
Use jQuery to modify the text content of all a tags
Feb 28, 2024 pm 05:42 PM
Title: Use jQuery to modify the text content of all a tags. jQuery is a popular JavaScript library that is widely used to handle DOM operations. In web development, we often encounter the need to modify the text content of the link tag (a tag) on the page. This article will explain how to use jQuery to achieve this goal, and provide specific code examples. First, we need to introduce the jQuery library into the page. Add the following code in the HTML file:
