Re: db file multiblock read count

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 4 Sep 2005 17:21:59 +0200
Message-ID: <431b1115$0$18124$ba620e4c@news.skynet.be>

"sushil" <shettysushil_at_gmail.com> wrote in message news:1125582984.029784.296790_at_g47g2000cwa.googlegroups.com...
> any idea about the exact parameter to look for the supported I/O on
> your OS.does it come out in kmtune?
>
> sushil
>

Increasing DBMRC will also "cheapen" the cost of full-table scans, so you might pay attention to this and use statspack to measure the number of full-table scans before and after any changes. It could be that you end up with more FTS instead of indexed scans and this could decrease performance.

Matthias Received on Sun Sep 04 2005 - 10:21:59 CDT