RE: sql stmt causing lock
- From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Jun 2004 00:10:36 -0700
If by recycled you mean shutdown and started again, AFAIK you cannot get
this information. Oracle stores information only on the current locks held.
If Oracle started storing information about all the locks it acquires, in
persistent objects, you will run out of space very soon.
Regards
Naveen
>
>Hi ,
> 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.
----------------------------------------------------------------
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:
