Sachin Bhise wrote:The buffer cache is meant for storing the buffers fetched the queries but not the queries itself. So in short, no it's not possible!
i want to ask how to keep a query in buffer cache always?
a query which runs frequently in a database will always stay in buffer cache due to LRU. LRU will not allow that query to flush out form buffer cache as it is running frequently.but if i want to place a query explicitly in buffer cache what should i do?
please answer it soon..Why? What makes you think that this is really such an important question that it needs to be answered soon ?
mbobak wrote:Thankyou for reminding me of this, I've just looked it up and I see that by specfying the address and hash value one can prevent a statement from aging out. I wonder if this is actually of any value: each time the statement gets re-loaded (which will happen following every startup) it will have a different address. I suppose one could write a routine that would find the statement and keep it each time.
Actually, John, you can use:To keep a cursor (SQL query) in the shared pool.