問題文
In an Automatic Workload Repository report for a two-instance Oracle RAC database, the wait event with the highest total time is the one that reports a current block arriving as busy. What does that event tell the DBA?
選択肢
- The block arrived from the resource master with one message and one transfer and was not busy, pinned, or waiting for a log flush.
- The block was not cached anywhere in the cluster, so a global grant was given and the requesting instance read the block from disk.
- The delay happened inside the global cache service because the node was short of processor time, so more processors or a redistribution of load is needed.
- The block was held up on the remote instance before it could be shipped, for example because the redo for its changes had not yet been written to a log file.