SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------ ---------- ----------
1 DATA NORMAL 28662 24814
2 RECOV NORMAL 24568 24090
3 DATA2 HIGH 12282 11820
SQL>
114 Oracle Database 11g DBA Handbook
Note that the disk group DATA is still normal redundancy, even though it has three failure
groups. However, the I/O performance of select statements against objects in the DATA disk group
is improved due to additional copies of extents available in the disk group.
Other disk group alter commands are listed in Table 4-6.
EM Database Control and ASM Disk Groups
The EM Database Control can also be used to administer disk groups. For a database that uses
ASM disk groups, the link Disk Groups under the Administration tab brings you to a login page for
the ASM instance shown in Figure 4-20. Remember that authentication for an ASM instance uses
operating system authentication only. Figure 4-21 shows the home page for the ASM instance.
After authentication with the ASM instance, you can perform the same operations that you
performed earlier in this chapter at the command line??”mounting and dismounting disk groups,
adding disk groups, adding or deleting disk group members, and so forth. Figure 4-22 shows the ASM
administration page, whereas Figure 4-23 shows the statistics and options for the disk group DATA.
ALTER DISKGROUP Command Description
alter diskgroup .
Pages:
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219