Chris, And I always thought the answer was 42 ;-)
And other than a 3 day gig next week, I've got lots of time on my hands. So, do you want me to dial in or fly out ;-) The reason for asking the question was in relation to a back-channel discussion with someone on locks. I'm familiar with working through the deadlock graph in a trace file, and sometimes using the lock related columns in V$SESSION, as well as all the other lock type of scripts, Metalink notes, etc. But, I had never done a block dump, as some well respected folks recommend, for determining locked rows. Just trying to learn something new. I have since been able to get more info, as well as getting the helpful email from Paul Parker. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Grabowy, > Chris > Sent: Tuesday, December 04, 2001 2:30 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: LOCKS - Reading Block Dumps > > > 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 -- 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).
