| Oracle Parameter Setting [message #173601] |
Tue, 23 May 2006 06:54  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hello,
Following questions are pertaining to Oracle 9i Release 2 on Linux Environment.
Is it possible for anybody to give the guidelines for estimating the following parameters(in termes of %) :
pga_aggregate_target
db_cache_size
shared_pool_size
shared_pool_reserved_size
log_buffer
java_pool_size
sga_max_size
Also please suggest whether is it possible to change the sga_max_size? If yes, how to change it?
How to know what amount of memory is allocated to Oracle?
How do we use amount RAM for calculating some memory parameters?
Thanks in Advance,
Pratap
|
|
|
|
| Re: Oracle Parameter Setting [message #174359 is a reply to message #173601] |
Sun, 28 May 2006 08:12  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Dont allocate more than is available to Oracle or your server will be swapping. About 1M per sesion is needed. That really depends on how you set up the user.
I user target and max and it works well.
You need to know how much RAM your sever has and figure the percentage for youself.
Neil.
|
|
|
|
| Re: Oracle Parameter Setting [message #174906 is a reply to message #173601] |
Wed, 31 May 2006 00:20 |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi,
Thanks for your reply.
However, still question remains there!
Knowing amount of RAM, how do i know how much is allocated to Oracle?
Regards,
Pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
