Re: Raw Devices: Increased Performance?

In <4snl9t$gtj_at_atlas.aethos.co.uk>, steve_at_aethos.demon.co.uk (Steve Holdoway) writes:
>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??

Only if the blocks are some of the most commonly accessed in the database

>
>TIA
>
>Steve.
>
>>In article <1996Jul18.141402.24958_at_rossinc.com>,
 

>>Joel Garry <joelga_at_rossinc.com> wrote:
>>>
>>>buffer again - so Oracle is only smart enough when it's under
>>>SMALL_TABLE_THRESHOLD. Not likely for most of the data, although
>>>possibly a good argument to not put all lookup codes in one table.
>>>
>>--
>>Glenn Fawcett, Technical Marketing Engineer voice: (503)578-3712
>>Sequent Computer Systems FAX: (503)578-5453
>>15450 SW Koll Pkwy (MS CHA1-371) UUCP: ..uunet!sequent!glennf
>>Beaverton, Oregon 97006-6063 internet: glennf_at_sequent.com
>
>

Bye,
Steve

| any similarity 'tween my opinions and that |
|  of my employers are purely hypothetical   |
|     and should give no cause for alarm     |
 --------------------------------------------