Home » RDBMS Server » Performance Tuning » Large SGA
icon7.gif  Large SGA [message #167600] Fri, 14 April 2006 07:25 Go to next message
yash_v
Messages: 24
Registered: April 2006
Junior Member
Hello,
I am looking out for information on configuring large SGA, greater than 8GB or how to increase the data buffers on Window 2003 Ent Edition with Oracle 10g. Any information or links welcome.

Thanks in advance,
Yash
Re: Large SGA [message #167624 is a reply to message #167600] Fri, 14 April 2006 13:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am looking out for information on configuring large SGA, greater than 8GB
WHY?
Do you have benchmarks which show that this is a worthwhile effort?
Re: Large SGA [message #167668 is a reply to message #167624] Sat, 15 April 2006 02:34 Go to previous messageGo to next message
yash_v
Messages: 24
Registered: April 2006
Junior Member
I am running some data migration test and can see a bottleneck with disk I/O and paging. So looking out for steps to increase data block buffers. How can I configure data block buffers with AWE?

Yash
Re: Large SGA [message #167700 is a reply to message #167600] Sat, 15 April 2006 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It matters very little whether file data blocks reside in RAM in OS file buffer or in RAM in SGA. RAM is RAM. Paging occurs when data blocks get moved from RAM to disk to make room for other data blocks moving from disk to RAM (either OS file buffer or "SGA").
You only trying to move the waterline on the Titantic which will not significantly reduce paging.
Re: Large SGA [message #167715 is a reply to message #167700] Sat, 15 April 2006 10:42 Go to previous messageGo to next message
yash_v
Messages: 24
Registered: April 2006
Junior Member
thanks for replying. I have 12 GB of ram on the system so looking out for options to fully utilize it.
Re: Large SGA [message #167716 is a reply to message #167600] Sat, 15 April 2006 10:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>so looking out for options to fully utilize it.
If the system is paging (as you previously stated), then all of the RAM is being utilized.
When a system is paging, all the RAM is being used; otherwise no paging activity would occur.
Re: Large SGA [message #167754 is a reply to message #167600] Sun, 16 April 2006 17:31 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member

type in show sga to sql and post back here

goto task manager and performane and monitor system to get a feel for performance.
Previous Topic: sort unique problem
Next Topic: High Disk Reads and FTS
Goto Forum:
  


Current Time: Wed May 22 19:01:51 CDT 2024