| best SGA [message #155756] |
Wed, 18 January 2006 07:42  |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
hello
i would like your help in setting the SGA parameter for an oracle 9i database on windows 2000 advanced server ,supporting 150 user
thanks
|
|
|
|
| Re: best SGA [message #155894 is a reply to message #155756] |
Thu, 19 January 2006 09:38  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
How much ram do you have ?
How much transaction you are expecting daily?
Is it OLTP or OLAP ?
Data base is 24X7 or not...?
150 user means Multithreaded server DB will not be in dedicated mode...
For 1 GB
Suppose if we consider SGA of 1 GB than
1. Shared pool is 48% of SGA
2. Database buffer is 48% of SGA.
3. Log Buffer is 4 MB of SGA.
4. Java pool 20 MB
5. Large pool 20 MB.
earlier on this forum their was big discussion on this issue i still remember.... i hope site adminstrator will give link of that site to you....
Regards
Friendly sunilkumar
[Updated on: Thu, 19 January 2006 09:47] Report message to a moderator |
|
|
|
| Re: best SGA [message #156256 is a reply to message #155756] |
Tue, 24 January 2006 02:35 |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
thanks for your help
i have 2 GB of RAM
do i apply the numbers you gave me on the 2 GB
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
