I have a problem: when I try to replace or delete a package I recive
an error message ORA-04021: timeout occurred while waiting to lock object XXX
Of course it's becouse this package is used by another session.
In v$access table I've found out whitch session it is, but I don't
know how to kill or stop this session to allowed replacing of package.
I killed the session and its status is marked as killed but the
package is still used.
Pls help me it's very important. Any solution how to compile this
package is welcomed. Restart of database doesn't help, I tried :-(
Thanx a lot.
Find the thread of the process to kill...
sql> select p.spid "Thread", s.sid "SID-Top Sessions",
substr(s.osuser,1,15) "OS User", substr(s.program,1,25) "Program Running"
from v$process p, v$session s
order by substr(s.osuser,1,15)