Re: Block dump - Uncommitted TXN

From: Diego Cutrone <diegocutrone_at_yahoo.com.ar>
Date: Wed, 20 Sep 2006 11:38:44 -0300 (ART)
Message-ID: <20060920143844.13251.qmail@web33002.mail.mud.yahoo.com>

Hi BN

They way I do this is by taking a block dump on the table blocks (all of them if possible - or the ones closer to the HWM otherwise) and check for the ITC value. This will report the maximun ammount of concurrent transactions that the block suffered. I'm sure you can then go from there and set up an accurate figure for the 'inittrans' value.

LINUX:oracle10:TEST10:/u01/app/oracle/admin/TEST10/udump> grep itc test10_ora_9715.trc
seg/obj: 0x1d72 csc: 0x00.454cc itc: 3 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.5058b itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.5058b itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50711 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50711 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50711 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50711 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50715 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50715 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50715 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50715 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50715 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50716 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50716 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.50716 itc: 2 flg: - typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.5071a itc: 2 flg: O typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.5071a itc: 2 flg: O typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.5071a itc: 2 flg: O typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.5071a itc: 2 flg: O typ: 1 - DATA
seg/obj: 0x1d72 csc: 0x00.5071a itc: 2 flg: O typ: 1 - DATA

Hope this helps
Regards
diego
----- Original Message -----
From: BN
To: Christian.Antognini_at_trivadis.com
Cc: oracle-l_at_freelists.org
Sent: Wednesday, September 20, 2006 9:34 AM Subject: Re: Block dump - Uncommitted TXN - Help Urgent

On 9/19/06, Christian Antognini
<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 


	
	
		
__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya! 
http://www.yahoo.com.ar/respuestas

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

Received on Wed Sep 20 2006 - 09:38:44 CDT