RE: Block dump - Uncommitted TXN

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 20 Sep 2006 09:57:30 -0400
Message-ID: <003301c6dcbc$b7aa6e00$0c00a8c0@Thing1>

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 table).

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of goran bogdanovic
Sent: Wednesday, September 20, 2006 8:51 AM To: bnsarma_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Block dump - Uncommitted TXN - Help Urgent

Hi,

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

goran

On 9/20/06, BN < bnsarma_at_gmail.com <mailto:bnsarma_at_gmail.com> > wrote:

On 9/19/06, Christian Antognini <Christian.Antognini_at_trivadis.com <mailto:Christian.Antognini_at_trivadis.com> > 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;

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

--
http://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 

 




--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 20 2006 - 08:57:30 CDT

RE: Block dump - Uncommitted TXN - Help Urgent