RE: <No subject>

Your table is too large for your db block buffer=2E=20=

100,000 rows, 40 rows in a block - 2500 blocks * 4kb =3D 10,000 which is around=20= 10mb=2E Your db block buffer is only 8mb, if you want to fully cache this table=20= you need to increase your db block buffer=2E=20=

HTH Mark

-----Original Message-----

From:	MIME :aheda_at_cdotd=2Eernet=2Ein=20=
Sent:	Wednesday, July 05, 2000 7:07 AM
To:	Mark Leith
Cc:	ORACLE-L_at_fatcity=2Ecom
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=3D24Mb
shared pool 15Mb
data bufers 8Mb
table size=3D1 Mb
block size 4kb

thanks
 arvind On Tue, 4 Jul 2000 uucp-relay-delhi!mleith_at_bradmark=2Eco=2Euk wrote:

> alter table xxxxx cache;
> > To undo this statement - alter table xxxxx nocache;
> > Need a bit of environment info for your second question please=2E=2E
> > HTH
> > Mark
> > -----Original Message-----
> From: MIME :aheda_at_cdotd=2Eernet=2Ein Sent: Tuesday, July 04, 2000 3:30 PM
> To: ORACLE-L_at_fatcity=2Ecom
> Subject: <No subject>
> > > 1)=2Ehow 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=2E
> > > > Arvind
> > > -- Author: INET: aheda_at_cdotd=2Eernet=2Ein
> > 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=2Ecom (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)=2E You may
> also send the HELP command for other information (like subscribing)=2E
> > << File: ENVELOPE=2ETXT >> > << File: ENVELOPE=2ETXT >>=20=
Received on Wed Jul 05 2000 - 03:22:47 CDT