When it's sitting there, from another session as sys, see if the session is
waiting on anything. I have a pretty godd feeling you will see a library
cache wait on that session. Do you have a job running (using dbms_aq) that
is holding a share lock on the advanced queue?
Arup
- Original Message
Hello All,
I'm having problems with a oracle 8.7.1 database running on SuSE 7.1. My
original problem was unable to drop a user, searching through the archive
I found the problem described at
http://www.orafaq.net/archive/oracle-l/2002/03/01/144826.htm
This was the exact problem, the trace file w