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.