lock on plsql-objects: database needed restart 
Author Message
 lock on plsql-objects: database needed restart

has anyone experience with a compile/lock problem at Oracle 8?

When we are manipulating database objects, and there are many invalid,
and we're trying to compile objects, the process hangs until killed.
There must be a lock at some plsql-objects, and our only solution is now
to restart the database.

Can anyone offer a better solution? Does anyone know, where i can view
locks on plsql-objects?


Titus Leskien

Sent via Deja.com http://www.***.com/
Before you buy.

Wed, 18 Jun 1902 08:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. SQL server need to restart every day in peak hrs because of dead locks

2. Postgresql goes down need to restart (redhat postgresql service script) lock files removal avoid 2 postmasters

3. Locking advice needed - are locking hints needed here?

4. Restarting continuous replication locks tables

5. PLSQL-proc calling PLSQL-proc on another machine

6. 9iRelease 2 Upgrade Alert -- PLSQL Objects referencing 8iDatabase over DBLink

7. restarting web service after file server restart

8. Command Object vs Connection Object for Row Level Locking

9. transfer Database object is locking up in EM

10. Command Object vs Connection Object for Row Level Locking

11. Database link error after the remote database restarts (comes up after down for a while)

12. What is needed to publish a basic PLSQL web page

Powered by phpBB® Forum Software