RE: <No subject>

From: <mleith_at_bradmark.co.uk>
Date: Tue, 4 Jul 2000 15:38:26 +0100
Message-Id: <10548.111172@fatcity.com>

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=20=
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 Received on Tue Jul 04 2000 - 09:38:26 CDT