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 >>
Received on Thu Jul 06 2000 - 02:29:25 CDT