Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)
A.
They are used when an application uses the DBMS_LOCK package for UL lock types.
B.
They are used to coordinate the next value for a sequence created with the CACHE and
ORDBR clauses.
C.
They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.
D.
They are used to coordinate access across multiple library caches for the same stored procedure.
E.
They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.
Instance Locks are relate to
– Row cache entries
– Library cache entries
– Result cache entries
So D, E
Agree Correct D,E