Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The database is hanging randomly (with some leniency I would say almost each hour). Top session is:

select privilege#
from sysauth$
where (grantee#=:1 or grantee#=1) and privilege#>0
or 
select /*+ connect_by_filtering */ privilege#, level
from sysauth$ connect by grantee#=prior privilege# and privilege#>0 
start with grantee#=:1 and privilege#>0

In ash I saw these top wait events:high concurrency on event library cache: mutex X and latch: shared pool

This problem occurred after upgrading from 11.2.0.1 to 11.2.0.3.

These queries are almost always in top sessions but the wait event when the database is not hanging is CPU. In 11.2.0.1 they didn't appear. We are using DRCP.

share|improve this question
    
going to post it also in serverfault, but it should apply in both, might be something the code is generating against the new version, or the new version by itself –  capi Jan 6 '12 at 13:26
1  
@capi Please don't cross post, you can flag for migration –  Sathya Jan 6 '12 at 14:56
add comment

migrated from stackoverflow.com Jan 6 '12 at 15:40

This question came from our site for professional and enthusiast programmers.

1 Answer

select privilege#
from sysauth$
where (grantee#=:1 or grantee#=1) and privilege#>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?

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.