Re: sql stmt causing lock

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 15 Jun 2004 02:57:51 -0400
Message-ID: <20040615065751.GA4027@medo.noip.com>

On 06/15/2004 02:47:35 AM, manoj.gurnani_at_polaris.co.in wrote:

> Can I know the sql which caused a lock on table after the database
> has been recycled.
> Which table can give this info.Also is it possible to know which program
> caused the lock.

V$LOCK, V$SESSION,V$SQL_AREA, http://tahiti.oracle.com/ You can look in database concepts, Steve Adams, DBA 101, DBA Guide and many other books. Always have The Guide and a towel. Don't panic.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 15 2004 - 01:54:37 CDT