Cache Table

Mark

Is space Equal to ONLY the Data in the Table Allocated from the db_block_buffers
& NOT the SUN of EXTENT Sizes of the Table ?

NOTE - The EXTENT Size can be far greater than Actual Data Size in the Table

> -----Original Message-----
> From: aheda_at_cdotd.ernet.in [SMTP:aheda_at_cdotd.ernet.in]
> Sent: Thursday, July 06, 2000 2:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: <No subject>
>
> but even if the whole table cannot be cached but should my hitratio should
> be as low as 45% as 40 rows are selected in single block read.
>
>
> Arvind
>
>
> On Wed, 5 Jul 2000 uucp-relay-delhi!mleith_at_bradmark.co.uk wrote:
>
> > Your table is too large for your db block buffer.
> >
> > 100,000 rows, 40 rows in a block - 2500 blocks * 4kb = 10,000 which is
> around 10mb. Your db block buffer is only 8mb, if you want to fully cache
> this table you need to increase your db block buffer.
> >
> > HTH
> >
> > Mark
> >
> > -----Original Message-----
> > From: MIME :aheda_at_cdotd.ernet.in Sent: Wednesday, July 05,
> 2000 7:07 AM
> > To: Mark Leith
> > Cc: ORACLE-L_at_fatcity.com
> > Subject: RE: <No subject>
> >
> >
> >
> > Arvind
> > For the fist question : I had tried the alter table xxxx cache
> > but even after doing this when I give a select query on the same table i
> > misses the cache and goes to the Disk
> >
> > about second question I can give you the size of sga and shared poll
> > sga=24Mb
> > shared pool 15Mb
> > data bufers 8Mb
> > table size=1 Mb
> > block size 4kb
> >
> >
> > thanks
> > arvind On Tue, 4 Jul 2000 uucp-relay-delhi!mleith_at_bradmark.co.uk wrote:
> >
> > > alter table xxxxx cache;
> > > > To undo this statement - alter table xxxxx nocache;
> > > > Need a bit of environment info for your second question please..
> > > > HTH
> > > > Mark
> > > > -----Original Message-----
> > > From: MIME :aheda_at_cdotd.ernet.in Sent: Tuesday, July 04,
> 2000 3:30 PM
> > > To: ORACLE-L_at_fatcity.com
> > > Subject: <No subject>
> > > > > 1).how can we cache the whole data of a table?
> > > > 2) why do we get a hit ratio of less than 50 % while we execute
> select *
> > > query on a single table contaiining 100000 rows and each db_block
> contains
> > > aroud 40 rows of table.
> > > > > > Arvind
> > > > > -- Author: INET: aheda_at_cdotd.ernet.in
> > > > 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).
> > > > << File: ENVELOPE.TXT >> > << File: ENVELOPE.TXT >>
> >
>
>
> --
> Author:
> INET: aheda_at_cdotd.ernet.in
>
> 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
Received on Thu Jul 06 2000 - 05:16:43 CDT