Oracle 优化参数 parameter

> 

archive log list;

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     4
Current log sequence           5

>

SELECT LOG_MODE,flashback_on,force_logging, supplemental_log_data_min min,
       supplemental_log_data_pk pk,
       supplemental_log_data_ui ui,
       supplemental_log_data_fk fk,
       supplemental_log_data_all allc
  FROM v$database;  
  
 LOG_MODE     FLASHBACK_ON       FORCE_LOGGING                           MIN      PK  UI  FK  ALL
------------ ------------------ --------------------------------------- -------- --- --- --- ---
NOARCHIVELOG NO                 NO                                      NO       NO  NO  NO  NO
 

Parameter Existing Value  New Value
Remove: sga_max_size  80G 
Change: sga_target  16G 140G
Change: pga_aggregate_target  15G 60G
Add: parallel_force_local   TRUE
Add: parallel_max_servers   128
Add: streams_pool_size    2G
Add: heat_map   ON
Change: open_cursors  300 1000
Change: global_names  FALSE TRUE
Add: parallel_force_local   TRUE
Add: parallel_max_servers   128
Add: streams_pool_size    2G
Add: heat_map   ON
Remove cursor_sharing=FORCE    
 

    
 select p.name, sp.name, sp.value
from v$system_parameter sp, v$pdbs p
where sp.con_id = p.con_id 
and sp.isdefault = 'FALSE'
order by 1, 2;

select sp.name, sp.value
from v$parameter sp
where sp.isdefault = 'FALSE'
order by 1; 
 

col name for a26

原文地址：https://blog.csdn.net/jnrjian/article/details/142702503

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！