中烟测试数据库优化测试

  1. PGA

ORACLE to the proposal: OLTP systems PGA = (Total Memory) * 80% * 20%. DSS systems PGA = (Total Memory) * 80% * 50%. ORACLE recommends a database server, sub-80% of the memory to the database, 20% of the memory to the operating system. 

select value/1024/1024 as value from v$pgastat where name='maximum PGA allocated';
alter system set pga_aggregate_target=XXXM;
  1. SGA 

SELECT ( (SELECT SUM(value) FROM V$SGA) - (SELECT CURRENT_SIZE FROM V$SGA_DYNAMIC_FREE_MEMORY)) "SGA_TARGET" FROM DUAL;
alter system set sga_target=XXXM;
  1. log_buffer is generally 5meg or less.

    https://dbpost.wordpress.com/tag/disable-asmm/

    http://blog.csdn.net/wll_1017/article/details/8296199

    http://www.orafaq.com/wiki/SGA_target

    https://docs.oracle.com/cd/E17781_01/server.112/e18804/memory.htm#ADMQS179

172.16.33.149

PGA = 24*0.8*0.2 = 3.84GB SGA = 24*0.8-4 = 15GB 

# First at all, backup spfile.
create pfile='/oracle/pfile.ora' from spfile;
alter system set sga_max_size=12G scope=spfile;

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:30011178429375

首頁/2016-10-11 (last edited 2016-10-12 04:01:35 by localhost)