Database Administration (MOSC)

MOSC Banner

grant select on gv_$instance returns ORA-04021

edited Mar 18, 2019 9:42AM in Database Administration (MOSC) 15 commentsAnswered ✓

In version 11.2.0.4, connected as SYSDBA:

SQL> GRANT SELECT ON sys.gv_$instance TO user;

GRANT SELECT ON sys.gv_$instance TO user

                    *

ERROR at line 1:

ORA-04021: timeout occurred while waiting to lock object

This is happening in just 4 of my instances.  However, one of those is not currently in use!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center