Re: Cache hit rate

From: Pei L. Ku <pku_at_gte.net>
Date: 19 May 1998 02:55:32 GMT
Message-ID: <6jqsb4$1e0$1@gte2.gte.net>

Oracle uses multiblock_read_count for full table scan only. If the rows you are updating are fetched via index lookup, multiblock_read_count does not come into play.

Pei

larionov_at_yahoo.com wrote in article <6jpltg$env$1_at_nnrp1.dejanews.com>...
> Sorry if this question(s) sounds silly!
>
> I want to improve the cache hit rate.
> Would it help If I decrease multiblock_read_count?
>
> On my system I have a bunch of random updates,
> where just one row is search-updated in a 5GB table.
> Of ourse I don't need to read 32 blocks to update
> just one row, so high multiblock_read_count is just a waste of
> SGA! Am I wrong?
>
> Also, can I set the multiblock_read_count just for one table
> and leave untouched for other tables?
> What degree of paralellism on this table would be preferable?
>
> Thank you!
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Mon May 18 1998 - 21:55:32 CDT