This chapter contains information about using dynamic views to display Oracle Automatic Storage Management (Oracle ASM), Oracle Automatic Storage Management Cluster File System (Oracle ACFS), and Oracle ASM Dynamic Volume Manager (Oracle ADVM) information.
Asm Extension - List of programs that can open.asm files. Fvp.exe, File Viewer Plus, File Viewer Plus, Sharpened Productions, open, Low.
See Also:
Oracle Database Reference for information about all of the V$ASM*
dynamic performance viewsViews Containing Oracle ASM Disk Group Information
You can use the views in Table 6-1 to obtain information about Oracle ASM disk groups.
The
V$ASM_ALIAS
, V$ASM_CLIENT
, V$ASM_DISK
, V$ASM_DISK_IOSTAT
, V$ASM_DISK_STAT
, V$ASM_DISKGROUP
, V$ASM_DISKGROUP_STAT
, V$ASM_FILE
, V$ASM_TEMPLATE
, V$ASM_USER
, V$ASM_USERGROUP
, and V$ASM_USERGROUP_MEMBER
are accessible from both the Oracle ASM and database instances.Table 6-1 Oracle ASM dynamic views for disk group information
View | Description |
---|---|
V$ASM_ALIAS | Contains one row for every alias present in every disk group mounted by the Oracle ASM instance. |
V$ASM_ATTRIBUTE | Displays one row for each attribute defined. In addition to attributes specified by CREATE DISKGROUP and ALTER DISKGROUP statements, the view may show other attributes that are created automatically. Attributes are only displayed for disk groups where COMPATIBLE.ASM is set to 11.1 or higher. |
V$ASM_CLIENT | In an Oracle ASM instance, identifies databases using disk groups managed by the Oracle ASM instance. In an Oracle Database instance, contains information about the Oracle ASM instance if the database has any open Oracle ASM files. |
V$ASM_DISK | Contains one row for every disk discovered by the Oracle ASM instance, including disks that are not part of any disk group. This view performs disk discovery every time it is queried. |
V$ASM_DISK_IOSTAT | Displays information about disk I/O statistics for each Oracle ASM client. In an Oracle Database instance, only the rows for that instance are shown. |
V$ASM_DISK_STAT | Contains the same columns as V$ASM_DISK , but to reduce overhead, does not perform a discovery when it is queried. It only returns information about any disks that are part of mounted disk groups in the storage system. To see all disks, use V$ASM_DISK instead. |
V$ASM_DISKGROUP | Describes a disk group (number, name, size related info, state, and redundancy type). This view performs disk discovery every time it is queried. |
V$ASM_DISKGROUP_STAT | Contains the same columns as V$ASM_DISKGROUP , but to reduce overhead, does not perform a discovery when it is queried. It does not return information about any disks that are part of mounted disk groups in the storage system. To see all disks, use V$ASM_DISKGROUP instead. |
V$ASM_FILE | Contains one row for every Oracle ASM file in every disk group mounted by the Oracle ASM instance. |
V$ASM_OPERATION | In an Oracle ASM instance, contains one row for every active Oracle ASM long running operation executing in the Oracle ASM instance. In an Oracle Database instance, contains no rows. |
V$ASM_TEMPLATE | Contains one row for every template present in every disk group mounted by the Oracle ASM instance. |
V$ASM_USER | Contains the effective operating system user names of connected database instances and names of file owners. |
V$ASM_USERGROUP | Contains the creator for each Oracle ASM File Access Control group. |
V$ASM_USERGROUP_MEMBER | Contains the members for each Oracle ASM File Access Control group. |
When querying V$ASM views, note that the value of the disk group number is not a static value. When a disk group is mounted, a disk group number is chosen. This number may change across disk group mounts. A disk group number is not recorded in any persistent structure, but the current value can be viewed in the
GROUP_NUMBER
column of the V$ASM views.An example of the use of the
V$ASM_ATTRIBUTE
and V$ASM_DISKGROUP
views is shown in Example 6-1. The COMPATIBLE.ASM
value must be set to 11.1 or higher for the disk group to display in the V$ASM_ATTRIBUTE
view output. Attributes that are designated as read-only (Y
) can only be set during disk group creation.Example 6-1 Viewing disk group attributes with V$ASM_ATTRIBUTE
You can view the compatibility for a disk group with the
V$ASM_DISKGROUP
view, as shown in Example 6-2.Example 6-2 Viewing the compatibility of a disk group with V$ASM_DISKGROUP
An example of the use of the
V$ASM_DISK
and V$ASM_DISKGROUP
views is shown in Example 6-3. This example displays the disks associated with a disk group, plus the mount status and state of the disks.Example 6-3 Viewing disks in disk groups with V$ASM_DISK
An example of the use of the
V$ASM_CLIENT
and V$ASM_DISKGROUP
views on an Oracle ASM instance is shown in Example 6-4. This example displays disk groups with information about the connected database client instances.Example 6-4 Viewing disk group clients with V$ASM_CLIENT
Viewing Oracle ASM File Access Control Information
You can view information about Oracle ASM File Access Control in the columns of the
V$ASM_USER
, V$ASM_USERGROUP
, V$ASM_USERGROUP_MEMBER
, and V$ASM_FILE
views.Example 6-5 shows information about Oracle ASM File Access Control users displayed in the
V$ASM_USER
view.Example 6-5 Viewing Oracle ASM File Access Control information with V$ASM_USER
Example 6-6 shows information about Oracle ASM File Access Control user groups displayed in the
V$ASM_USERGROUP
view.Example 6-6 Viewing Oracle ASM File Access Control information with V$ASM_USERGROUP
Example 6-7 shows information about Oracle ASM File Access Control user groups and members displayed in the
V$ASM_USERGROUP_MEMBER
view.Example 6-7 Viewing Oracle ASM File Access Control information with V$ASM_USERGROUP_MEMBER
Example 6-8 shows information about Oracle ASM File Access Control file permissions displayed in the
V$ASM_FILE
view.Example 6-8 Viewing Oracle ASM File Access Control information with V$ASM_FILE
For more information about Oracle ASM File Access Control, see 'Managing Oracle ASM File Access Control for Disk Groups'.
Viewing Disk Region Information
Information about Intelligent Data Placement is displayed in the columns of the
V$ASM_DISK
, V$ASM_DISK_IOSTAT
, V$ASM_FILE
, and V$ASM_TEMPLATE
views.Example 6-9 shows queries for Intelligent Data Placement information in the
PRIMARY_REGION
and MIRROR_REGION
columns of the V$ASM_FILE
view.Example 6-9 Viewing Intelligent Data Placement information with V$ASM_FILE
Example 6-10 displays Intelligent Data Placement information in the
PRIMARY_REGION
and MIRROR_REGION
columns of the V$ASM_TEMPLATE
view.Example 6-10 Viewing Intelligent Data Placement information with V$ASM_TEMPLATE
For information about setting Intelligent Data Placement, see 'Intelligent Data Placement'.
Views Containing Oracle ACFS Information
You can use the views in Table 6-2 to obtain information about Oracle Automatic Storage Management Cluster File System (Oracle ACFS). These views are accessible from the Oracle ASM instance.
Table 6-2 Oracle ASM dynamic views for Oracle ACFS information
View | Description |
---|---|
V$ASM_ACFS_ENCRYPTION_INFO | Contains encryption information for each Oracle ACFS file system. |
V$ASM_ACFS_SECURITY_INFO | Contains security realm information for each Oracle ACFS file system. |
V$ASM_ACFSSNAPSHOTS | Contains snapshot information for every mounted Oracle ACFS file system. |
V$ASM_ACFSVOLUMES | Contains information about mounted Oracle ACFS volumes, correlated with V$ASM_FILESYSTEM . |
V$ASM_FILESYSTEM | Contains columns that display information for every mounted Oracle ACFS file system. |
V$ASM_VOLUME | Contains information about each Oracle ADVM volume that is a member of an Oracle ASM instance. |
V$ASM_VOLUME_STAT | Contains information about statistics for each Oracle ADVM volume. |
Example 6-11 shows information displayed from the
V$ASM_ACFS_ENCRYPTION_INFO
view. The FS_NAME
column contains the mount point. The VOL_DEVICE
contains the name of the Oracle ADVM device.Example 6-11 Viewing encryption information in V$ASM_ACFS_ENCRYPTION_INFO
See Also:
Oracle Database Reference for information about the V$ASM_ACFS_ENCRYPTION_INFO
viewExample 6-12 shows information displayed from the
V$ASM_ACFS_SECURITY_INFO
view. The FS_NAME
column contains the mount point. The VOL_DEVICE
contains the name of the Oracle ADVM device.Example 6-12 Viewing security information in V$ASM_ACFS_SECURITY_INFO
See Also:
Oracle Database Reference for information about the V$ASM_ACFS_SECURITY_INFO
viewExample 6-13 shows information displayed from the
V$ASM_ACFSSNAPSHOTS
view. The FS_NAME
column contains the mount point. The VOL_DEVICE
contains the name of the Oracle ADVM device.Example 6-13 Viewing snapshot information in V$ASM_ACFSSNAPSHOTS
See Also:
Oracle Database Reference for information about the V$ASM_ACFSSNAPSHOTS
viewExample 6-14 shows information displayed from the
V$ASM_VACFSOLUMES
view. The PRIMARY_VOL
column contains TRUE
if the volume is the primary volume for the file system.Example 6-14 Viewing volume information with V$ASM_ACFSVOLUMES
See Also:
Oracle Database Reference for information about the V$ASM_ACFSVOLUMES
viewExample 6-15 shows information displayed from the
V$ASM_FILESYSTEM
view.The
STATE
column contains the status of the file system, either AVAILABLE
or OFFLINE
. An offline file system can only be dismounted; other attempts at access result in errors. Offline means that either the Oracle ASM instance is down, the disk group has been forced dismounted, or less commonly, a metadata I/O failure occurred or serious metadata corruption was detected. With a metadata I/O failure, the file system is also marked as corrupt.The
CORRUPT
column indicates whether the file system needs the fsck
or acfschkdsk
command run on it. See 'fsck' and 'acfschkdsk'.Example 6-15 Viewing volume information with V$ASM_FILESYSTEM
See Also:
Oracle Database Reference for information about the V$ASM_FILESYSTEM
viewExample 6-16 shows information displayed from the
V$ASM_VOLUME
view for volumes contained in the DATA
disk group.Example 6-16 Viewing volume information with V$ASM_VOLUME
See Also:
Oracle Database Reference for information about the V$ASM_VOLUME
viewExample 6-16 shows information displayed from the
V$ASM_VOLUME_STAT
view for volumes contained in the DATA
disk group. The BYTES_READ
column contains the total number of bytes read for the volume. The BYTES_WRITTEN
column contains the total number of bytes written for the volume.Example 6-17 Viewing volume information with V$ASM_VOLUME_STAT
See Also:
Oracle Database Reference for information about the V$ASM_VOLUME_STAT
view