Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?

The correct answer is A. In a RAC One Node database, there is no LMD0 process if only one instance is running. F. Global Enqueues may have converters and waiters in the same isntance. F: A convert queue is a queue of locks that are waiting to be converted to particular mode, this is the process of changing a lock from one mode to another, even a NULL is a lock. A resource has a lock value block (LVB). The Global Resource Manager (GRM) keeps the lock…

Manage Global Resources

Question

Options

AIn a RAC One Node database, there is no LMD0 process if only one instance is running.
BGlobal Enqueues and Instance Locks replace mutexes completely in RAC database instances.
CIn a RAC database, there is no LMD0 process if only one instance is running.
DGlobal Enqueues and Instance Locks replace latches completely in RAC database isntances.
EGlobal Enqueues may have owners and waiters in the same instance.
FGlobal Enqueues may have converters and waiters in the same isntance.

How the community answered

(26 responses)

A
77% (20)
B
8% (2)
D
4% (1)
E
12% (3)

Explanation

F: A convert queue is a queue of locks that are waiting to be converted to particular mode, this is the process of changing a lock from one mode to another, even a NULL is a lock. A resource has a lock value block (LVB). The Global Resource Manager (GRM) keeps the lock information valid and correct across the cluster. Oracle 10g release 2 and beyond replaced some latch mechanisms with the mutex approach, claiming that they are faster and more efficient than traditional locking mechanisms. Incorrect Answers: B, D: Mutexes are objects that exist within the operating system to provide access to shared memory structures. They are similar to latches.

Topics

#Global Enqueue Service#LMD0 process#instance locks#RAC cache fusion

Community Discussion

No community discussion yet for this question.

Full 1Z0-068 Practice