Re: Oracle hints
From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Wed, 30 Jan 2008 17:56:28 -0800 (PST)
Message-ID: <42d33f92-e6a4-4059-bbc6-a79d2149fa8c@f47g2000hsd.googlegroups.com>
Date: Wed, 30 Jan 2008 17:56:28 -0800 (PST)
Message-ID: <42d33f92-e6a4-4059-bbc6-a79d2149fa8c@f47g2000hsd.googlegroups.com>
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