Re: Table Cacheing in 7.1

In article <42nu28$54o_at_nntpd.lkg.dec.com>,

   roderick_at_eps.enet.dec.com (Lisa Roderick) wrote:
>In article <427dpg$hdt_at_inet-nntp-gw-1.us.oracle.com>, gsalem_at_fr.oracle.com
>says...
>>
>>you can use the cache option when you create the table (see doc.
>>addendum for release 7.1)
>>
>Or to alter an existing table:
>
> alter table tablename cache;
>
>Just make sure your database buffer cache is large enough!

If you want to avoid *big* cached table to 'eat' all your SGA memory, you can also specify the 'cache_size_threshold' in your init.ora : the rdbms will cache the 'cache flagged' tables if their size is smaller than this parameter.
You won't have to worry about big table, simply cache the tables you suspect to behave as perf. bottlenecks.

Hope it helps.

   ('<      Gilles BRUNO.   Universite Joseph Fourier.
  ,',)      Tel: +33 76 63 56 68    Fax: +33 76 51 42 74
 ''<<       E-mail: Gilles.Bruno_at_ujf-grenoble.fr
----""-------------------------------------------------------