Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Caching Oracle internal tables (such as hist_head$, etc...) in memory

Caching Oracle internal tables (such as hist_head$, etc...) in memory

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Thu, 25 Jan 2007 00:44:00 +0000
Message-ID: <BAY103-F40C82763CA3056EE78095FD2A30@phx.gbl>

We have a requirement for a specific transactions to provide response within 2-3 seconds 99% of the time.  The transaction has lots of SQL's and all are optimized (this is an Oracle Apps transaction).

We're able to pin all related cursors and tables/indexes in memory and most of the time are able to provide the required response time.  However, there are some Oracle internal tables that can not be pinned in KEEP pool or cache as normal objects can (besides just having a cron job manually scan these tables but this does not do it entirely either...)

Any idea is appreciated.

Thanks.



Turn searches into helpful donations. Make your search count. -- http://www.freelists.org/webpage/oracle-l Received on Wed Jan 24 2007 - 18:44:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US