| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle Caching
Matt..
You can use plan stability which essentially uses the same optimizer plan for different systems/data running the same query so you get consistent/expected index choice etc.
-----Original Message-----
From: woodworth_at_acm.org (Matt Woodworth) [mailto:woodworth_at_acm.org]
Posted At: Friday, July 27, 2001 3:08 PM
Posted To: server
Conversation: Oracle Caching
Subject: Re: Oracle Caching
Norman,
Thanks you so much for you help. I'm good with the concept of LRU. It's used in operating systems principles as well. I've spoken to some of the oracle experts around here and they seem to think that oracle's use of the cache revolves around the query having a matching explain plan. Have you heard that before?
Also, I'd really like to find the Oracle Concepts Manual. The link you provided, www.docs.oracle.com, didn't work. However, docs.oracle.com worked fine. From there I went to the 8i section to look for it. The closest I could find was Oracle Enterprise Manager Concepts Guide. That wasn't too helpful because it had only five chapters (ie no chapter 6).
Could have have given the wrong name for the guide?
Thanks in advance.
Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk> wrote in message
news:<48B95088F03ED511BE5A00508BEED08820A3A2_at_tapps.leeds.lfs.co.uk>...
<snipped content>
>
> Check out the Oracle Comcempts Manual, chapter 6 for full details.
> If you don't have it, logon to www.docs.oracle.com and check out the
> docs in the 'database' section.
>
> Regards,
> Norman
>
>
 |
 |