Correction : suM of the EXTENT sizes of the Tables
> -----Original Message-----
> From: VIVEK_SHARMA
> Sent: Thursday, July 06, 2000 3:47 PM
> To: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk'
> Subject: 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
> > also send the HELP command for other information (like subscribing).
>
> --------
> 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
Received on Thu Jul 06 2000 - 05:43:08 CDT
