Which two can be used to monitor the rebalancing?

You just added an ASM disk to the DATA diskgroup.
Which two can be used to monitor the rebalancing?

A.
ams_cmd lsop

B.
v$asm_disk

C.
v$asm_operation

D.
v$asm_diskgroup

E.
v$session_longops

F.
amscmd lsdg

Explanation:

C: Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the
operation is complete before returning. Query the V$ASM_OPERATION view to monitor the status of this operation.
D: Verify that the rebalance is waiting:
SQL> select * from v$asm_operation
where group_number = (select GROUP_NUMBER from v$asm_diskgroup where NAME=’BDT’);
https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm

Show Hint

← Previous question

Next question →

Leave a Reply 15

edge

For me should be A and C

for C check here

https://docs.oracle.com/database/121/OSTMG/GUID-2D0BE995-BF3A-4A11-9C06-6F0E22FC77DF.htm#OSTMG94391

Regards

ziad abuqasem

C,D CORRECT
A WRONG NO COMMAND ASM_CMD its ASMCMD

edge

Hi Ziad

Yes you are probably right : C,D

Thanks

joseformiga

But the correct command is: asmcmd, NOT asm_cmd. Right ?

Ziad

yes asmcmd

WGCM

depends on what you means by “monitor”…

Managing Oracle ASM with ASMCMD

lsdg [–suppressheader] [-g] [–discovery] [pattern]

Attribute Name – Description
State – State of the disk group. Values include BROKEN, CONNECTED,
DISMOUNTED, MOUNTED, QUIESCING, and UNKNOWN.
Type – Disk group redundancy (NORMAL, HIGH, EXTERNAL).
Rebal – Y if a rebalance operation is in progress.
…

May be that “C” and “F” is correct!

Xxdd

B and C.

WGCM

Today, in the Exam, this question does not apper “ASM_CMD lsop” but, “asmcmd lsop”! In this case, “A” and “C”!

Amit

Hi all,

Could anyone please share what would be the correct answer to the below question:

Examine this command:

SQL> ALTER TABLESPACE TBS1 ADD DATAFILE ‘+DATA(new template)/ORCL/USERS/mytab.dbf’ SIZE 100M;

Which two statements are required for this command to succeed? (Choose two.)

A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(new template).
B. new template must be defined for the +DATA disk group.
C. Existing data files inTBS1must also use the same template.
D. The +DATA disk group should not be part of Flex ASM.
E. User-defined subdirectories ORCL and USERS must already exist.

Thanks for your time

Amit

Amit

Hello everyone,

I cleared the exam Oracle Database 12c: RAC and Grid Infrastructure Administration on April 22nd 2017

Thanks,
Amit