Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Caching a table

Re: Caching a table

From: Noodles <noodles_at_aol.com>
Date: 1996/12/11
Message-ID: <19961211192400.OAA01746@ladder01.news.aol.com>#1/1 







Per page 6-31 of the Oracle Performance tuning class documentation, "Use
the cache hint clause when you create small lookup tables used by many
users".   Too many cached tables can overcrowd the cache.  If you still
want to load the table into memory, use the cache clause on the create
table statement.



Cliff


(cbuetikofer_at_isinet.com)
Received on Wed Dec 11 1996 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US