| RAM Tuning [message #172461] |
Tue, 16 May 2006 11:30  |
yash_v
Messages: 24
Registered: April 2006
|
Junior Member |
|
|
Hi,
How to I set my database server to utilize the memory 12 GB Ram available on the server. Currently the database is configured using AWE to use 3 GB of data block buffers.
I have been monitoring the system for a while and I can see excessive paging occurring on the database server, how can I prevent this?
I am using 10gR2 on windows 2003 server.
Thanks,
Yash
|
|
|
|
|
|
| Re: RAM Tuning [message #172649 is a reply to message #172461] |
Wed, 17 May 2006 08:23  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
There is more to memory use that buffer cache. Also look at the shared pool. But with 10gR2 you might consider sga_target.
Also check your pga_aggregate_target, lots of places have it at a mere 25mb which is far too low.
|
|
|
|
| Re: RAM Tuning [message #172673 is a reply to message #172649] |
Wed, 17 May 2006 10:06 |
yash_v
Messages: 24
Registered: April 2006
|
Junior Member |
|
|
If I got the database parameters right then sga_target can't be used when we are using the database with use_indirect_data_buffers=TRUE and AWE enabled on the database. Please correct me if I am wrong in this.
Thanks,
Yash
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
