Re: sql stmt causing lock
- From: "Danisment Gazi Unal (ubTools)" <dunal@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Jun 2004 10:19:05 +0300
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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
> -----------------------------------------------------------------
----------------------------------------------------------------
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:
