Re: sql stmt causing lock
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Jun 2004 02:57:51 -0400
On 06/15/2004 02:47:35 AM, manoj.gurnani@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
