| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Segments storage in memory
Andrey,
It will not be in the memory until the 1st time you read the blocks in.
Winnie
"Andrey Bronfin" <bronfin_at_VisualTop.com> on 11/23/2000 11:07:59 AM
To: "Jamaleddin, Nabil" <NJamaleddin_at_wycokck.org>, ORACLE-L_at_fatcity.com,
oracledba_at_quickdoc.co.uk, ORACLE-L_at_lists.sunysb.edu cc: (bcc: Winnie Liu/HQ/ISC)
Subject: 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 .
> 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
>
 |
 |