select privilege#,levelIt looks like a query Oracle uses to find out if a user has the privilege to do something.
connect by grantee#=prior privilege# and
start with (grantee#=:1 or
The increase in execution therefore may relate toOur user base has indeed increased, but only by a small percentage and it was certainly not a "big bang" scenario. So I don't think the first two are applicable. The third is obviously true.
increased user base, number of logon attempts and
increase in the use of system and object privileges.
It may be normal to have it at the 10 tp of CPUI will do that if this thread does not lead to an explanation.
consumers, but the seriourness depends on how much
CPU does it use. If you think it is in excess, I
would suggest you check with Oracle Support.
What has changed in the database from Feb 06As I described above and in answer to Lutz.
(Upgrades? Patches? Database Community Usage? etc)