Navigator Window Hangs

[gbanner]

Using 10.1.0.3.0 database and pl/sql developer version 6.0.1.848 03.21082.
This weekend started having problems with the client hanging when trying to open any of the items in the navigator window (eg, tables, procedures).
Here is the sql I can see from the oracle side for those pl/sql dev sessions:
SELECT count(*)
FROM user$ u, xdb.xdb$schema s
WHERE
u.user# = :1 AND
u.name = s.xmldata.schema_owner AND
xdb.xdb$extname2intname(s.xmldata.schema_url, s.xmldata.schema_owner)
= :2
.
These sessions stay "active" in oracle, even after the pl/sql dev clients are killed. (Maybe another bug there, with sessions failing to disconnect gracefully.)
Anyone else seeing this behavior?
Any ideas?

 

[Marco Kalter]

This query is not directly executed by PL/SQL Developer, and it's not immediately familiar to me.

You mention that this started this weekend. Did anything change on the database server? Does it help if you shutdown/restart the instance?