Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)

(no subject)

From: <aheda_at_cdotd.ernet.in>
Date: Tue, 4 Jul 2000 18:51:07 +0500 (GMT+0500)
Message-Id: <10548.111168@fatcity.com>

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                                                 


 From: "Suhen Pather" <pathers5_at_telkom.co.za> Received on Tue Jul 04 2000 - 08:51:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US