Use the following to look for the source of the locking:
Once the sid has been determined the process locking the object can be killed.
RESOLUTION 2Contact Oracle Support to clarify why the select privilege cannot be granted to gv_$instance.
As a workaround the following code may be successful in granting the privilege:
DECLARE vcmd varchar2(4000); BEGIN vcmd :=' grant select on gv_$instance to FOGLIGHT'; sys.execute_immediate(vcmd,-02030); END; /