pl/sql developer hangs

[Manish Aggarwal]

We are experiencing that the pl/sql developer 5.1.6.747 hangs while connecting to oracle 8.1.7.4 database.

A lot of developers are experiencing this.

When i look in oracle, this is the last statement i see coming from pl/sql developer while it is hung.

BEGIN
:ID := SYS.DBMS_TRANSACTION.local_transaction_id;
END;

Any help is highly appreciated.

Thanks
Manish Aggarwal

 

[Marco Kalter]

We received a support request about this issue from one of your colleagues. It has not been reported before, so there must be something specific to your configuration.

It seems that this statement is waiting for a library cache pin, which may hint at a shared pool issue.

In any case, we're working on this with your colleague. If anybody else has an idea though, it would be appreciated.