Re: Raw Devices: Increased Performance?

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??

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
Received on Fri Jul 19 1996 - 00:00:00 CEST