Hey Larry, With all that free time you got, I got some databases over here that need to be upgraded...a couple of developers that need their hands held (or smacked) while they code their SQL...and some production tables that need to be rebuilt...then I can poke around hex dumps of the database....(big grin)
Thanks, your the greatest. Oh, and the answer is 12... Chris -----Original Message----- Sent: Tuesday, December 04, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Listers, Playing around with dumping a block to determine rows which are locked. I did an update to a single row in a table and did not commit. I dumped the block. Here is the relevant info: tab 0, row 0, @0x19c3 tl: 21 fb: --H-FL-- lb: 0x1 cc: 3 After rolling back and dumping the block, I get the following: tab 0, row 0, @0x1977 tl: 27 fb: --H-FL-- lb: 0x0 cc: 3 It looks like to me that the "lb:" value indicates the presence of a lock on the row -- 0x1 for a lock, 0x0 for not locked. I've been googling for a bit, searching usenet, and the typical web sites for info on this and came up empty handed. So, can anyone confirm this idea of lb: 0x0 meaning no lock and 0x1 meaning the row is locked? Also, there seems to be some differences in the block header info related to ITL's: Lock present: Itl Xid Uba Flag Lck Scn/Fsc 0x01 xid: 0x0002.018.00000482 uba: 0x0080c4a8.0340.0e ---- 1 fsc 0x0006.00000000 No lock: Itl Xid Uba Flag Lck Scn/Fsc 0x01 xid: 0x0001.037.000004c3 uba: 0x00800107.06dc.31 C--- 0 scn 0x0000.00594c1b Can I assume that Scn/Fsc value of non-zero means there is a lock? And last but not least, any good info anywhere on reading block dumps? Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
