Your table will be kept in the keep buffer pool.
The keep, recycle and default buffer pool are taken
from db_block_buffers.
The best option is to put your tables in the keep
buffer pool.
Make sure to size correctly the buffer pools.
- Andrey Bronfin <bronfin_at_VisualTop.com> a icrit : >
HI All & thanks !
> I've done :
> create table XXX ( a number ) storage (buffer_pool
> keep ) cache ;
>
> Where is it placed now ? In db_block_buffers or
> outside of them ?
> My goal is to keep the entire table in memory and
> possibly never let it age
> out .
> What is the best option to use ?
> Thanks a lot .
>
>
> ----- Original Message -----
> To: "Andrey Bronfin" <bronfin_at_VisualTop.com>;
> <ORACLE-L_at_fatcity.com>;
> <oracledba_at_quickdoc.co.uk>;
> <ORACLE-L_at_lists.sunysb.edu>
> Sent: Tuesday, May 16, 2000 7:39 PM
>
>
> > Not totally sure but buffer pool will use buffers
> outside of the
> > db_block_buffers.
> > Oracle 8 has atleast two different pools of block
> buffers. The cache
> option
> > will put the buffers on the top of the lru instead
> of the bottom. This
> will
> > cause
> > the table to spend more time in the sga b4 getting
> paged out.
> >
> > hth and hope IM not full of crap.
> >
> >
> > nabil
> >
> > > -----Original Message-----
> > > From: Andrey Bronfin
> [SMTP:bronfin_at_VisualTop.com]
> > > Sent: Thursday, November 23, 2000 12:28 PM
> > > To: ORACLE-L_at_fatcity.com;
> oracledba_at_quickdoc.co.uk;
> > > ORACLE-L_at_lists.sunysb.edu
> > > Subject: Segments storage in memory
> > >
> > > 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 !
> > >
> > >
> >
> > --------
> > If you're bored, then visit the list's website:
> http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to
> oracledba-subscribe_at_quickdoc.co.uk
> >
>
> --
> Author: Andrey Bronfin
> INET: bronfin_at_VisualTop.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 Thu May 18 2000 - 08:06:07 CDT
