Re: Oracle hints

From: Peter Teoh <>
Date: Wed, 30 Jan 2008 17:56:28 -0800 (PST)
Message-ID: <>

Got another idea, instead of completely not storing in V$SQLAREA cache, is there a way to store it such that it will timeout in the soonest time possible?

Eg, in a LRU algorithm, if u explicitly queue it at the back, it is expected to be reused soon, and will take the longest to get flushed out. But what if u queue it in FRONT? Any HINTs for doing that? Received on Wed Jan 30 2008 - 19:56:28 CST

Original text of this message