Transaction table- Keep Pool

From: <jaysingh1_at_optonline.net>
Date: Thu, 05 Aug 2004 09:08:05 -0400
Message-id: <3d7d8f43d80055.3d800553d7d8f4@optonline.net>

Hi All,

Few queries are taking longer time (40 sec =10*normal time) to execute in intermittent manner.For example, 99 percent of the time it got executed within 3 to 4 secs and 1 percent of the time it is taking more than 35 secs. (35 secs is the application timeout limit)

What we are think is that if the requested data block is not in DB buffer cache(flushed out by someother query/data) it is going for physical read and that may be the reason for longer execution time.

We are trying to two things

Increase the size of the DB buffer cache . Currently DB buffer cache is 2GB and SGA is 3.5 GB.
Assign all the objects(indexes and tables) invoved in timeout queries to KEEP POOL

Is it okay to assign tansactions tables to KEEP POOL?

Thanks
Sami

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Aug 05 2004 - 08:06:44 CDT