Re: Raw Devices: Increased Performance?

From: Glenn <glennf_at_crg8.sequent.com>
Date: 1996/07/18
Message-ID: <4slqdh$dnu_at_scel.sequent.com>#1/1


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;

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 Thu Jul 18 1996 - 00:00:00 CEST

Original text of this message