RE: sql stmt causing lock

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Tue, 15 Jun 2004 00:10:36 -0700
Message-ID: <77ED2BF75D59D1439F90412CC5B109740D8D8D28@ie10-sahara.hiso.honeywell.com>

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_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 - 02:01:35 CDT