RE: LOCKS - Reading Block Dumps

Paul,

Thanks for the response -- and a good recommendation, I refer to those sites quite often. I had been searching at the Adams site and browsing Lewis's site prior to sending the email. For whatever reason, I missed/skipped the details on *interpreting* a block dump at the Adams site. I went back later and was able find more info. And the whole reason for this email is discussions by those folks and others about (besides the case of the sometimes useful columns in V$SESSION) doing block dumps to determine locked rows. And the Morle book is on my buy list, just haven't gotten around to it yet.

Once again, thanks for your help.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> Paul.Parker_at_bmwna.com
> Sent: Tuesday, December 04, 2001 2:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: LOCKS - Reading Block Dumps
>
>
> Hi Larry,
>
> the lb (lock byte) in the row piece of the block points to an ITL entry.
>
> As for the ITL entry, there is a slight confusion in that the
> headings don't
> line up exactly with values. In your case, when uncommitted, the contents
> are :
>
>
> Itl 0x01 (ITL no.)
> Xid xid: 0x0002.018.00000482 (transaction ID)
> Uba uba: 0x0080c4a8.0340.0e (undo block address)
> Flag ---- (state of
> transaction)
> Lck 1 (no. of rows
> locked by this transaction within this block)
> Scn/Fsc fsc 0x0006.00000000 (SCN or
> Free Space Credit)
>
> Steve Adams and Jonathan Lewis' sites have some info on block
> dumps. Also,
> "Scaling Oracle 8i" by James Morle also has some info.
>
> HTH,
> Paul

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  INET: elkinsl_at_flash.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).