#acl merlyn:read,write All:read

= 中烟测试数据库优化测试 =
 i. 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;
}}}
 i. 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;
}}}
 
 i. 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