Hi,
Same problem here, just after login into a 10gR2, two sessions are created and one of them keep active and running the command below forever.
select count(*) from user$ u, xdb.xdb$schema s where u.user#= :1
and u.name = s.xmldata.schema_owner
and...