This content has been marked as final. Show 3 replies
if you have database control or Grid control then try searching for your session and see if this is active and what is showing under activity.
I should have said that I'd already checked this:
I see the session. Its inactive but I see the sql-text "Select * from v$session" under the open-cursors so the sqltext is passed to the DB. Under waits, I see "SQL *net message from client" and the second in waits increases as I click on refresh and it sits there forever.
One more thing: I installed a 10g client on this machine ( that means now I have 11g and 10g client on this machine) and if I connect with 10g then there is no problem and it works just fine. so the issue only happens with 11g client ...