do you have the table cached for full scans?
(alter table ..... cache; )
> -----Urspr=FCngliche Nachricht-----
> Von: aheda_at_cdotd.ernet.in [SMTP:aheda_at_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_at_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_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).
Received on Tue Jul 04 2000 - 09:58:44 CDT
