Global Resource Directory (GRD) in Oracle 19c RAC and ASM

1Z0-078 By islever Editorial Last updated

RAC architecture and global resources

Short answer

BCE Shadow GRD resources may exist in multiple instances, Clustered ASM distributes GRD resources among all ASM instances, and Enqueue Resource master metadata is held in the shared pool.

Question

Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
  1. Only one GRD shadow resource may exist for an Enqueue Resource.
  2. Shadow GRD resources may exist in more than one database instance for a resource. Correct Answer
  3. Clustered ASM has GRD resources distributed among all ASM instances. Correct Answer
  4. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
  5. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance. Correct Answer

Key Takeaways

The exam tests your understanding of GRD resource distribution and memory placement; the common trap is confusing the 'large pool' with the 'shared pool' for enqueue metadata or misunderstanding the multiplicity of shadow resources.

This question examines the architecture of the Global Resource Directory (GRD) in Oracle 19c RAC and Clustered ASM, specifically regarding shadow resources and memory allocation. It establishes that shadow GRD resources can exist across multiple instances, ASM distributes GRD resources among all instances, and enqueue metadata resides in the shared pool.

Common mistake: Candidates often select Option D instead of E, incorrectly believing enqueue metadata is stored in the large pool. Others may miss Option B, failing to recognize that shadow resources are not limited to a single instance.

Expert Analysis

Why the Answer Is Correct

The Global Resource Directory (GRD) manages global resources in RAC. Statement B is true because shadow GRD resources can indeed exist in more than one database instance for a given resource to ensure availability and performance. Statement C is true because in a Clustered ASM configuration, GRD resources are distributed among all ASM instances to manage disk group metadata globally. Statement E is true because the master metadata for GRD Enqueue Resources is held in the shared pool of the specific instance that owns the master role, not the large pool.

Why the Other Options Are Wrong

Option A is incorrect because there can be multiple GRD shadow resources for an Enqueue Resource, not just one; this redundancy supports load balancing and failover. Option D is incorrect because the master metadata for enqueue resources is stored in the shared pool, which is optimized for library cache and dictionary caching, whereas the large pool is typically used for backup and recovery operations or parallel execution servers.

Community Comment Notes

Community consensus strongly supports options B, C, and G (where G corresponds to the shared pool concept, mapped here to E). As lcoleandro noted, "Shadow GRD resources may exist in multiple database instances" and "GRD resources in Clustered ASM are distributed among all ASM instances." Another user confirmed that "BCG is correct," aligning with the standard Oracle documentation on GRD architecture. Comments consistently refute the idea that only one shadow resource exists or that the large pool holds enqueue metadata.

Exam Strategy

When studying RAC architecture, focus on the distinction between the Shared Pool and Large Pool usage for different types of internal structures like the GRD and Library Cache. Memorize that GRD resources are distributed across instances in both RAC databases and Clustered ASM to ensure high availability.

Frequently Asked Questions

Why is enqueue metadata in the shared pool, not large pool?

Enqueue resources require frequent access to library cache-like structures, which are optimized in the shared pool. The large pool is reserved for large contiguous allocations like backup buffers.

Can multiple shadow GRD resources exist for one enqueue?

Yes, multiple shadow resources can exist to provide redundancy and allow other instances to quickly access lock information without contacting the master instance immediately.

More 1Z0-078 FAQ →

Discussion 3 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 3

  1. lcoleandro 👍 1
    Correct Statements B: Shadow GRD resources may exist in multiple database instances for a resource. C: GRD resources in Clustered ASM are distributed among all ASM instances. G: GRD cache resources in RAC databases are stored in the shared pool of each instance. Incorrect Statements A: Incorrect because there can be multiple GRD shadow resources for an Enqueue Resource. D: Incorrect because GRD metadata is not held in the large pool. E: Incorrect because GRD metadata is not held in the shared pool of just one instance. F: Incorrect because GRD cache resources are not stored in the large pool.
  2. Test_1 👍 2
    BCG is correct
  3. krwi1 👍 2
    F is wrog

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Which Three Resources Use Global Concurrency Control in 19c RAC?

S-grade

Which Task Must Precede OPatch Patching of Grid Infrastructure 19c?

S-grade

What Does opatch apply Do in a Four-Node RAC Cluster?

S-grade

ACFS Encryption True Statements

S-grade

← Back to 1Z0-078 Study Guide