Home » RDBMS Server » Performance Tuning » performance problem
performance problem [message #65345] Thu, 12 August 2004 22:38 Go to next message
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



Re: performance problem [message #65346 is a reply to message #65345] Fri, 13 August 2004 02:01 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member

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.
Re: performance problem [message #65406 is a reply to message #65346] Thu, 09 September 2004 13:20 Go to previous message
Messages: 1
Registered: September 2004
Junior Member
Hi could it be that your application forgets to close sessions ? You should monitor the database for decreasing resources.

Previous Topic: Oracle 10G OEM tuning & diagnostics pack missing
Next Topic: unable to allocate 4372 *
Goto Forum:

Current Time: Sat Mar 02 18:33:01 CST 2024