My Oracle Support Banner

Grant / Set Role Hanging / slow performance in 12.2 DB (Doc ID 2611007.1)

Last updated on DECEMBER 28, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


We are trying to grant role to user. it is hanging for long time.

SQL> grant connect ,resource to <user>;


Customer is performing some 50+ grants on a PDB which are taking a very long time to complete.
When looking at the sqltraces the majority of the time is spent on recursive
select from sys.sysauth.

Problem gets worse when more rows are added to sys.sysauth$


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.