Hi, guys
we have a Oracle 7.3
I create triggers for it, they were compiling without any problems before I restrat Oracle. Now when I try to compile trigger or package Oracle session hangs. In the lock table I can see that my user session holds Exclusive Transaction lock (SID=9), object_id=372 is :
SELECT NAME FROM sys.obj$ where obj#=372
CLU
Code:
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
-------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
0A533B48 0A533BF8 9 TX 327798 372 6 0 0 0
08C09694 08C096A4 3 RT 1 0 6 0 0 0
08C096C8 08C096D8 2 MR 6 0 4 0 0 0
08C096FC 08C0970C 2 MR 5 0 4 0 0 0
08C09730 08C09740 2 MR 4 0 4 0 0 0
08C09764 08C09774 2 MR 3 0 4 0 0 0
08C09798 08C097A8 2 MR 2 0 4 0 0 0
08C097CC 08C097DC 2 MR 1 0 4 0 0 0
When I try to kill session it does not affect on hanging session, and field status in the v$session has value 'killed'.
In the same time I can create/drop table. make a query.
I will appreciate any advices.