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 184.108.40.206 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