Freeze on Edit view

[neckermitt]

Hi,
I have a strange problem: When I choose
"Edit" on some views in browser window then PL/SQL Developer stops responding.
If I look what is happening in this session I see that the session is active, but waiting on "SQL*Net message from client" and query

"select sql_text from v$sqltext_with_newlines
where address = hextorawsql_address)
and hash_value = :sql_hash_value
order by piece
/* concatenate */"

returns that the session of the frozen PL/SQL developer window is performing the source select of the wiew.

This problem appears on Oracle server 10.2.0.3, version of PL/SQL Developer doesn't seem to matter - tried several versions from 6.0.x to 7.1.5, all the same.
In some other development tools (TOra, SQL Developer) it works fine and also application has no problem using this view.

Any hints, command line parameters, ... ?

Thanks in advance

Mike

 

[Marco Kalter]

I don't think this query is related. It comes from the "Sessions" tool. Did you have this tool open at that time?

 

[neckermitt]

Actually I have open 2 instances of PL/SQL Developer.
In the first one I try to edit the view and the "Sessions" tool is open i the other one.
No other - even inactive - session from my station is open.
The reason for 2 simultaneously open plsdevs is that the first instance just goes frozen, a white window with a window title, nothing more.

Another thing I forgot to mention is that when I kill the first session in OS on the server, the first plsdev begins responding again and source of the view is displayed in the edit window.
The "only" problem is that the session is logged out and also the killing on the server is not comfortable ;-)

Thanks

Mike