Locking Issue

[kevb]

Occasionally I'll compile a package with in plsql/developer and the program crashes. When reloaded the package will hang and not recompile as the package has been locked. I then have to log into oracle as sys to kill the locks. Is there anything that can be done about this?

 

[Christo Kutrovsky]

Same here.

I would like to be able to "cancel" compiles which are hanging due to locks.

Same goes for queries for example in the "Sessions" window tabs.

 

[Marco Kalter]

The problem with locks is that you can only kill the session to cancel the operation. A normal break action will not help.

------------------
Marco Kalter
Allround Automations

 

[hadfieldjohn]

Have a look at :
http://asktom.oracle.com/pls/ask/f?p=4950:8:6577634075896402975::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:358013111598

It contains some useful information on the problem you're having. May even provide enough detail for PL/SQL dev to issue a warning?

Cheers

J.

 

[Marco Kalter]

Thanks for the tip. I have added this to the list of enhancement requests.

------------------
Marco Kalter
Allround Automations