Re: sql stmt causing lock

From: Danisment Gazi Unal (ubTools) <dunal_at_ubTools.com>
Date: Tue, 15 Jun 2004 10:19:05 +0300
Message-ID: <016f01c452a9$0d5dac90$fe19100a@danismentgu>

Yes,

It's still possible to see locks after the startup. But, it's not so easy. You have to take block dumps of both data and rbs header before running any statement on data blocks to prevent data blocks from block cleanouts.

best regards...

http://www.ubTools.com
Web Based Oracle Products and Services

Original Message ----- From: "Naveen, Nahata (IE10)" <Naveen.Nahata_at_honeywell.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, June 15, 2004 10:10 AM Subject: RE: sql stmt causing lock

> 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
> -----------------------------------------------------------------

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:15:30 CDT