Re: Cache hit rate

From: Sunit Patke <supatke_at_us.ibm.com>
Date: Mon, 18 May 1998 17:15:29 -0400
Message-ID: <3560A4F1.1F940574@us.ibm.com>

Check your db_block_buffers parameter in INITsid.ORA

HTH
Sunit

larionov_at_yahoo.com wrote:

> 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 - 16:15:29 CDT