Question 3) Oracle Database 10g: New Features

Single Answer Multiple Choice

You want to know the details of all active Automatic Storage Management (ASM) disk rebalancing operations running in your ASM instance. Which view displays the details of every active operation running in your ASM instance?

A. V$ASM_DISK
B. V$ASM_CLIENT
C. V$ASM_SESSION
D. V$ASM_OPERATION

Answer:
D. V$ASM_OPERATION

Tutorial:
The V$ASM_OPERATION view displays detailed information about every active operation running in your ASM instance. The OPERATION column of this view displays the type of rebalancing operation and the STATE column displays the status of the operation. The STATE column also shows whether the operation is queued or running.

The V$ASM_DISK view displays the information about every disk discovered by the ASM instance.

The V$ASM_CLIENT view displays the information about the database instances using a disk group that is managed by the ASM instance.

The V$ASM_SESSION view is an invalid view and does not exist in Oracle.

Reference:
1. Oracle University – Oracle Database 10g: New Features for Administrators – Automatic Storage Management

2. OTN – http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/dynviews_1021.htm#REFRN30173

These questions are derived from the Self Test Software Practice Test for Oracle exam #1Z0-040: Oracle Database 10g: New Features for Administrators.