| sizing SGA in a 9i db [message #177713] |
Fri, 16 June 2006 03:35  |
alanm
Messages: 284
Registered: March 2005
|
Senior Member |
|
|
Hello All,
I am looking after a 9i database on an IBM server which has 32 GB ram. I am looking at sizing the SGA. Is it advisable with so much memory to play with that I make the SGA multi gig in size. I have set the PGA_AGGREGATE to 5GB.
current SGA is 3.5 GB
regards
Alan
|
|
|
|
| Re: sizing SGA in a 9i db [message #178322 is a reply to message #177713] |
Tue, 20 June 2006 11:06  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
The larger the SGA, the more work oracle will have to do to manage it. 3.5 gig is already quite huge. Not sure you have a choice but to test various configurations and their performance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
