Re: Block dump - Uncommitted TXN - Help Urgent

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
--
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


Other related posts: