Database Memory & 4030/4031 (MOSC)

MOSC Banner

oracle memory allocate question

edited Oct 15, 2009 7:16AM in Database Memory & 4030/4031 (MOSC) 9 commentsAnswered
suggest I have a database  in server ( ram is 4G),

 this is 11g

1.how did  i allocate memory .to oracle?

for my opinion, i use 4G*50% to allocate sga_target, 4G*10% to allocate pga_aggregate_target, is this ok?

2.what is pga_aggregate_target mean, i kown mostly it use to for sort area size, use command like such as :

select PGA_USED_MEM, PGA_ALLOC_MEM, PGA_MAX_MEM from v$process can calculate pga use for every process;

but if i set pga_aggregate_target =400M, if this mean that the max sum of all connection shadow process will consume 400M ,not use any more

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center