Re: Segments storage in memory

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 ----- From: "Jamaleddin, Nabil" <NJamaleddin_at_wycokck.org> 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 Subject: RE: Segments storage in memory

> 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
Received on Thu Nov 23 2000 - 13:07:59 CST