Re: Block dump - Uncommitted TXN - Help Urgent
- From: Diego Cutrone <diegocutrone@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 20 Sep 2006 11:38:44 -0300 (ART)
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@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Wednesday, September 20, 2006 9:34 AM
Subject: Re: Block dump - Uncommitted TXN - Help
Urgent
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
__________________________________________________
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
