Message-Id: <10548.111173@fatcity.com> From: "Libal, Ivo" Date: Tue, 4 Jul 2000 16:58:44 +0200 Subject: AW: do you have the table cached for full scans? (alter table ..... cache; ) > -----Urspr=FCngliche Nachricht----- > Von: aheda@cdotd.ernet.in [SMTP:aheda@cdotd.ernet.in] > Gesendet am: Dienstag, 4. Juli 2000 16:37 > An: Multiple recipients of list ORACLE-L > Betreff:=09 >=20 >=20 > 1).how can we cache the whole data of a table? >=20 > 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. >=20 >=20 >=20 > Arvind=20 > =09 >=20 >=20 > --=20 > Author:=20 > INET: aheda@cdotd.ernet.in >=20 > 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@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).