| SGA PARAMETERS [message #57772] |
Sun, 06 July 2003 13:41  |
GJ
Messages: 3
Registered: July 2001
|
Junior Member |
|
|
I recently upgraded my server to 2 Gigs of memory. Could anyone advise the appropriate values for the SGA variables current settings are as follows:
SHARED POOL 30M
BUFFER CACHE 18M
LARGE POOL 600K
JAVA POOL 20M
AND
SORT AREA SIZE 64K
I'm hoping to increase the performance of my server which is a SUN Sparc running Oracle 8.1.7..
Thanks
GJ
|
|
|
|
| Re: SGA PARAMETERS [message #57773 is a reply to message #57772] |
Sun, 06 July 2003 16:43  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
depends on your need...you
can increse the buffere cache etc.
But start from increaseing the semaphore settings....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
