RE: Segments storage in memory

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 16 May 2000 18:28:26 -0400
Message-Id: <10499.105792@fatcity.com>

You are missing Oracle 8.x

-----Original Message-----
From: Viktor Naumov [mailto:stant_98_at_yahoo.com] Sent: Tuesday, May 16, 2000 5:06 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Segments storage in memory

First,I haven't heard anything about BUFFER_POOL KEEP clause. Am I missing something here?
Secondly, when you say CACHE when creating a table(recommended for small tables), your SGA will cache the table which will make data retreval faster. Lastly, I haven't heard anything such as creating INDEX
with CACHE spec. Am I missing something here too?

• Andrey Bronfin <bronfin_at_VisualTop.com> wrote:
  > Dear DBAs !
  >
  > Could U please clear the following for me :
  >
  > 1) What's the difference between creating a table
  > with storage ( BUFFER_POOL KEEP) vs . creating a
  > table with CACHE specification ?
  >
  > 2) Is it possible to create an index specifying
  > CACHE ? ( I did not succeed so far and i don't have
  > a doc to look at ) .
  >
  > Thanks a lot in advance !
  >
  >
  >
  

  ---

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

-- 
Author: Viktor Naumov
  INET: stant_98_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue May 16 2000 - 17:28:26 CDT