Re: Raw Devices: Increased Performance?

In article <4snl9t$gtj_at_atlas.aethos.co.uk> steve_at_aethos.demon.co.uk (Steve Holdoway) writes:
>From: steve_at_aethos.demon.co.uk (Steve Holdoway)
>Subject: Re: Raw Devices: Increased Performance?
>Date: Fri, 19 Jul 1996 09:48:36 GMT
 

>glennf_at_crg8.sequent.com (Glenn "Daddy G" Fawcett) wrote:
 

>>In Oracle 7.3 you can alter a specific table's properties to place buffers
>>obtained by a tablescan at the MRU end of the LRU chain.
 

>> ALTER TABLE abc123 CACHE;
 

>What happens if you've not got enough space in the SGA to hold the
>complete table? What I'm praying that you'll say is that the most
>commonly used parts of the table are kept in memory. Or can you force
>this to happen if it's not the default case??

Oracle keeps a portion of the tables you access in memory(SGA) buffers. The CACHE parameter forces Oracle to put the entire table or whatever will fit in the SGA, which will bump other data from other tables out. Received on Fri Jul 19 1996 - 00:00:00 CEST