My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2020

Applies to:

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

Symptoms

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

SQL> grant connect ,resource to <user>;

or

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$

Cause

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
Symptoms
Cause
Solution
References


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