Re: Block dump - Uncommitted TXN - Help Urgent

  • From: "goran bogdanovic" <goran00@xxxxxxxxx>
  • To: bnsarma@xxxxxxxxx
  • Date: Wed, 20 Sep 2006 14:50:36 +0200

Hi,

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

goran

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



On 9/19/06, Christian Antognini <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 > > Hi > > Here an example of sessions waiting for a transaction slot: > > SQL> SELECT event FROM v$session_wait WHERE sid = 12; > > EVENT > ----------- > enqueue > > 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). > > > HTH > Chris > -- > //www.freelists.org/webpage/oracle-l > > > Greetings,

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
BN

Other related posts: