Re: Memory Allocations
- From: "Dereck L. Dietz" <dietzdl@xxxxxxxxxxxxx>
- Date: Wed, 12 Sep 2007 23:10:14 GMT
"Brian Peasland" <dba@xxxxxxxxxxxxxxxxxxx> wrote in message
Dereck L. Dietz wrote:
I was told by someone that the general rule of thumb for the initial
memory allocation in an Oracle instance was something like 40% for the
SGA and 60% for the PGA.
Anybody willing to comment on how accurate/inaccurate that statement was?
Personally, I've never used that rule of thumb. The sizes of the PGA and
SGA should be determined by your application and data usage patterns. Your
application and the way your users access the data may denote that a 2GB
SGA is appropriate. Servers with 4GB, 8GB, and 16GB of physical memory
(RAM) would arrive at entirely different estimates for the SGA using this
You can use rules of thumb similar to these as a starting point. But I
would expect that in short order, you would need to adjust your SGA and
If you sized your instance by the rules you stated, 100% of the server's
physical memory would be tied up with just the Oracle instance!
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Posted via a free Usenet account from http://www.teranews.com
Thanks. I realize it's just a starting point. Also, it's not for all the
server's memory - just the amount of memory which is going to be allocated
to the Oracle instance.
- Prev by Date: ETL
- Next by Date: Re: Corrupted dbf file... help!!
- Previous by thread: Re: Memory Allocations
- Next by thread: Re: deadlocks and redologs interaction