Re: How to drill down on a TX lock

Doug,

I've had to reply to the NG as your mail agent seems to think the direct reply was spam !

it will be in one of the tables locked with a TM lock.

alter system dump datafile NNN block min PPP block max QQQ; or
alter system dump datafile NNN block XXX;

Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com Use spare CPU to assist in cancer research.

-----Original Message-----
From: Doug C <dcowles_at_i84.net>
To: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> Date: 05 August 2001 20:44
Subject: Re: How to drill down on a TX lock

Hey Jon - 2 questions -
1) If I don't know exactly where the TX lock is holding rows, do I have to dump
the whole database :(, or can I assume that there in one of the tables that the
same session is holding a TM lmode 3 lock? 2) How do I dump a block anyhow? I just opened that on metalink but I figured
you would be faster :).

Thanks,
Much appreciated as always
D Received on Sun Aug 05 2001 - 15:20:51 CDT