The buffer pool functionnality is available since
Oracle 8.0
- Winnie_Liu_at_infonet.com a icrit : >
> Viktor,
>
> The BUFFER_POOL keep is the new features of Oracle
> 8i.
>
> In Oracle 8i, you will have better control over the
> database buffer cache.
> In addition to the original db_block_buffers (the
> default pool), Oracle
> introduce the concept of recycle pool and keep pool.
>
> Oracle also use another a new concept of mid-point
> insert to handle the LRU
> list in Oracle 8i.
>
> Winnie
>
>
>
>
>
> Viktor Naumov <stant_98_at_yahoo.com> on 05/16/2000
> 02:05:40 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc: (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
> 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).
>
>
>
>
>
>
> --
> Author:
> INET: Winnie_Liu_at_infonet.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).
>
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Wed May 17 2000 - 02:41:35 CDT
