Re: Tuning

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 14 Feb 2000 07:01:20 GMT
Message-ID: <38a76dd2.613893972@news.eagles.bbs.net.au>

Hello Sanjeev,

Adjusting db_writers will have no effect on data block contention. You need to work out which blocks are the subject of contention, and why. To do so, you need to catch the wait parameters for these waits, either from V$SESSION_WAIT or (better) from an event 10046, level 8 trace. The p1 and p2 values give you the file and block numbers of the hot blocks, and the p3 value gives a reason code. The tuning steps depend on what you find. There is more information about all this on my web site.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/

On Sun, 13 Feb 2000 12:29:41 -0800, "Sanjeev K Singh" <SJKSINGH_at_prodigy.net> wrote:

>
>Hi Folks,
>
>Have a tuning question. When i select class = 'data block' from v$waitstat i
>am getting a very high # in count. It seems like i have data block
>contention. What step should i take?
>
>Should i increase DB_WRITER ?
>
>Thanks,
>
>
>
>
>
Received on Mon Feb 14 2000 - 01:01:20 CST