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?

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

A.
In a RAC One Node database, there is no LMD0 process if only one instance is running.

B.
Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

C.
In a RAC database, there is no LMD0 process if only one instance is running.

D.
Global Enqueues and Instance Locks replace latches completely in RAC database instances.

E.
Global Enqueues may have owners and waiters in the same instance.

F.
Global Enqueues may have converters and waiters in the same instance.

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.
http://www.datadisk.co.uk/html_docs/rac/grd.htm



Leave a Reply 6

Your email address will not be published. Required fields are marked *


edge

edge

Hi guys

Why LMD0 shouldn’t run in a RAC one Node. For me A is false

And I will choose answers E and F

Any idea

regards

Marc

Marc

Hello

E and F are the correct answer.

Regard

WGCM

WGCM

Correct is “E” and “F”!

“A” and “C” is wrong!

If ASM is clustered, additional processes related to cluster management will be running in the ASM instance. Some of these processes include the following:
. LMON: The global enqueue service monitor process
. LZ4Dn: The global enqueue service daemons
. LMSn The global cache service processes
. LCKn The lock processes

“B” and “D” is wrong!

Need for Global Concurrency Control
Oracle requires concurrency control because it is a multi-user system.
• Single-instance Oracle provides concurrency control:
— Latches or mutexes for memory structures
— Enqueues for resource control
— Buffer cache pins for cache management
• In RAC, structures and resources may be accessed by or modified by a session running on any database instance.
• RAC, therefore, requires additional global concurrency controls to mediate access across instances.
— Global locks control library and row cache access.
— Global enqueues control resource access.
— Cache fusion controls buffer cache access.

Latches and mutexes may only protect access to memory structures if they are accessed by processes in the same instance.
In RAC, latches and mutexes are still used, but for global concurrency control, some additional global enqueues are used to provide protection across instances.

“E” and “F” is right!

Global enqueues are used to control access to resources, where the owner(s), waiter(s) if any, or converter(s) if any, or both, may be sessions in the same or different instances. Some global enqueues serve the same purpose they would serve in a single instance. For example, table manipulation (TM) enqueues. transaction enqueues (TX), control file enqueues (cF), high watermark enqueues (Hw), sequence cache replenishment (sQ), and redo thread enqueues (RT) all serve the same purpose as they would in a single instance. However, there are master and shadow metadata structures as described earlier in this lesson in the GRD, and the mastering instance will keep track of the waiters and converters.
Instance locks are enqueues that represent resources in the row cache or library cache protected within each instance by pins, mutexes, or latches. For cross-instance concurrency control, an enqueue is used, the owner(s) of which is or are the instance(s) that is or are currently the “source of truth” with regard to the current state of that resource. The LCKO process acts as the owner, waiter, or converter of the enqueue as a “proxy” process representing the instance. These enqueues are known as instance locks.

WGCM

WGCM

Ops! LZ4Dn/LMDn

jipenlee

jipenlee

Agree,

Correct E,F

Source

D81250GC10 Oracle Database 12c: RAC Administration 6-2,3,4