Oracle DB hanging after upgrade to 11.2.0.3
select privilege#
from sysauth$
where (grantee#=:1 or grantee#=1) and privilege#&gt;0


That SQL is executed as a user authenticates to the database upon login. This is mentioned in support doc 730066.1

Is there a storm of logins happening periodically?