Re: pinning a table in memory

On Thu, 28 Nov 2002 22:58:40 -0000, "David Sharples" <david.sharples3_at_ntlworld.com> wrote:

>We have a largeish table (6 million records) and the queries we have on this
>table are a tad slow and the disk is the bottleneck.
>
>We have considered putting the table in cache (alter table xyz cache)
>
>Was wondering if this would help very much seeing as though the indexes for
>this table is still held on disk.
>
>Any opinions??
>
>Thanks
>

cache only comes into play with full table scans. Blocks being read during full table scans are always put at the lower end of the LRU list (so they are paged out immediately), with cache you can avoid.
The cache mechanism has been replaced by the keep buffer pool in 8.0, and the keep buffer pool works for all types of queries.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Nov 28 2002 - 17:14:05 CST