RE: Transaction table- Keep Pool
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Aug 2004 08:56:26 -0500
Sami
The general advice on the KEEP pool is to look for objects you want to
keep in memory. This means they should be fairly small and frequently used.
I don't know what you mean by a transaction table. To me a transaction table
is something you are continually appending new transactions to, and rarely
reading. My largest table is a transaction table, labeled as such by the
application vendor. The very opposite of what you'd want cached.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
jaysingh1@xxxxxxxxxxxxx
Sent: Thursday, August 05, 2004 8:08 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Transaction table- Keep Pool
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
1) Increase the size of the DB buffer cache .
Currently DB buffer cache is 2GB and SGA is 3.5 GB.
2) 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
