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.