Cache hit rate

From: <larionov_at_yahoo.com>
Date: Mon, 18 May 1998 15:59:44 GMT
Message-ID: <6jpltg$env$1@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 - 10:59:44 CDT