Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?
In Oracle 12c RAC databases, global enqueues manage resources across multiple instances, and they can have owners, waiters, and converters within the same instance. This ensures coordinated access and resource management among nodes in the RAC cluster. Although in a single-instance RAC configuration, there is indeed an LMD0 process, the handling and coordination of global enqueues remain consistent. Therefore, global enqueues may have owners and waiters (E) and converters and waiters (F) within the same instance.
AF is correct.
what happens when in a One Node RAC database is needed to start a new instance for maintaining purposes? I think exists always a lmd0 process in RAC databases be One node or not; so my answer is E,F
BF, why no LMD process in one node RAC? Its a RAC DB afterall
no , LMD0 will lock for global lock , which is remote lock , that is mean there is another instance will access , in one node RAC there is only on instance .