| performance problem [message #65345] |
Thu, 12 August 2004 22:38  |
j.nandi@tcs.com
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
Dear All,
While searching for a party in the application, it is taking a long time. This occurs after the system is running for 4-5 hours with 10-12 users.
So we need to shutdown & restart the DB . Then it runs fine for the next 4 hours.
Can anyone suggest a solution for it? Do we need to increase the sort_area.
oracle is 9i, server RAM is 2GB, raid 5, sort_area_size=524288, db_cache_size=250M,shared_pool_size=400M
Thanks,
Jay
|
|
|
|
| Re: performance problem [message #65346 is a reply to message #65345] |
Fri, 13 August 2004 02:01  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Well its very tough to say anything about this with such a limited info you have provided. But one thing which you can do is, set the WORKAREA_SIZE_POLICY initialization parameter to AUTO. It will turn on the automatic PGA memory management, and you would be free from tuning all *_area_size parameters. Also set PGA_AGGREGATE_TARGET to appropriate value like 1GB(in your case), which is basically the total size of PGA memory that can be attached to the database.
Daljit Singh.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
