Datasheet

30 Chapter 1

Using Oracle ASM
TABLE 1.4 ASMCMD Commands (continued )
View Name In ASM Instance In Database
V$ASM_DISK This view describes each
disk that was discovered by
the ASM instance. All disks
are reported, even those not
assigned to disk groups.
This view describes each disk
that is assigned to a database.
Note that discovery will occur
each time you query this
view. This can have perfor-
mance impacts.
V$ASM_DISKGROUP_STAT This view is equivalent to the
V$ASM_DISKGROUP view.
This view contains a single
row for each ASM disk group
that is mounted by the local
ASM instance. No discovery
will occur when this view is
queried.
V$ASM_FILE Displays each ASM file con-
tained in the ASM instance.
Not used in a database
instance.
V$ASM_DISK_STAT This view is equivalent to the
V$ASM_DISK view.
This view describes each disk
that is assigned to a database.
No discovery will occur when
this view is queried.
V$ASM_TEMPLATE Displays each ASM tem-
plate contained in the ASM
instance by disk group.
Not used in a database
instance.
V$ASM_ALIAS Displays each alias con-
tained in the ASM instance
by disk group.
Not used in a database
instance.
V$ASM_OPERATION Displays each long-running
operation occurring on the
ASM instance.
Not used in a database
instance.
V$ASM_CLIENT Displays each database that
is using at least one disk
group managed by the ASM
instance.
Not used in a database
instance.
95134c01.indd 30 1/28/09 9:43:44 AM