RE: Block dump - Uncommitted TXN - Help Urgent

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <goran00@xxxxxxxxx>, <bnsarma@xxxxxxxxx>
  • Date: Wed, 20 Sep 2006 09:57:30 -0400

That's a bit high in some cases. How about the minimum of (maximum number of
rows in a single block, maximum number of concurrent transactions on the



From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of goran bogdanovic
Sent: Wednesday, September 20, 2006 8:51 AM
To: bnsarma@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Block dump - Uncommitted TXN - Help Urgent



The inittrans should correspond to your max active concurrent dml sessions
on that table


On 9/20/06, BN < bnsarma@xxxxxxxxx <mailto:bnsarma@xxxxxxxxx> > wrote:


On 9/19/06, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx
<mailto:Christian.Antognini@xxxxxxxxxxxx> > wrote:

> I was thinking of INITRANS , is there a way to track that from
> v$lock,
> I remember once Steve Adams  answering some body looking at v$lock
> looking at Request Column, not sure though


Here an example of sessions waiting for a transaction slot:

SQL> SELECT event FROM v$session_wait WHERE sid = 12;


SQL> SELECT type, id1, id2, lmode, request FROM v$lock WHERE sid = 12; 

TY        ID1        ID2      LMODE    REQUEST
-- ---------- ---------- ---------- ----------
TM      34522          0          3          0
TX     393247       9877          0          4

As you can see the request mode is S (4). 



Yes I saw  Request=4 for quite a few sessions. I ahve Identified the Tables
that needs INITRANS Bump. Is there a way to figureout  how much should I
bump for each table in question 

Regards & Thanks



Other related posts: