| How to size SGA [message #54916] |
Sun, 15 December 2002 13:59  |
SSV
Messages: 11
Registered: October 2002
|
Junior Member |
|
|
hello all,
please explain for a machine with X MB ram, how much SGA need to be set for optimal performance.
and also lease explain me in that how much to set for Library cache, Shared pool, Java pool ..
Thanks in advance,
sai
|
|
|
|
| Re: How to size SGA [message #54917 is a reply to message #54916] |
Mon, 16 December 2002 03:51  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
only one answer ... depending on ur server and app..
Ur server should never swapping ...
generally ( if U run one DB and not more ) between 30% and 50% of total RAM ...
SGA depend on ur app too ... U can not set library_cache .. it's a part of shared_pool ( with row_cache )... Java pool... unsing java ??? if not => 0
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
