Re: Dealock on Rollback Segment (I think)

> a) If a process has to wait for an ITL slot to become empty,
> you get a TX lock requested in mode 4 with an ID1/ID2
> that matches the TX lock of the session it is waiting for.

What do ID1 and ID2 mean (for TX lock) Can get any usefull info from these numbers?

> The result was
> Row 1:
> varchar2( 3904), varchar2(4000), varchar2(90)
> Row 2:
> varchar2(96) - next rowid, same block row 1.
>
> In other words the first 96 bytes of column 1 of
> my row had been inserted as one row in the block,
> with the rest of the row the target of a chain into
> the same block !!

That's definitely strange. But how can you see, how oracle chains a row? LIST CHAINED ROWS gives you only head rowids of chaind rows, nothing else?

Sent via Deja.com
http://www.deja.com/ Received on Sat Dec 30 2000 - 20:48:39 CST