Capacity Manager Database Views > Oracle ASM Database Views
   
Version 9.1.01
Oracle ASM Database Views
aps_v_asm_dbclient
The aps_v_asm_dbclient view contains a single row for each ASM database client.
Table 3.45 aps_v_asm_dbclient
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
compatible_version
STRING
Compatibility setting of the database or ASM instance for the selected disk group connection
db_instance_name
STRING
Identifier for the database instance client
db_name
STRING
Unique database name of the database client instance
last_updated
DATE
Date and time last updated
status
STRING
State of the disk group relative to the instance with the following possible values:
CONNECTED - Disk group is in use by the database instance
BROKEN - Database instance lost connectivity to the ASM instance that mounted the disk group
UNKNOWN - Automatic Storage Management instance has never attempted to mount the disk group
DISMOUNTED - Disk group was cleanly dismounted by the ASM instance following a successful mount
MOUNTED - Instance is successfully serving the disk group to its database clients
QUIESCING - CRSCTL utility attempted to dismount a disk group that contains the Oracle Cluster Registry (OCR). The disk group
cannot be dismounted until Cluster Ready Services (CRS) exits, because the disk group contains the OCR.
version
STRING
Software version number of the database or ASM instance for the selected disk group connection
aps_v_asm_dbclient_diskio_log
The aps_v_asm_dbclient_diskio_log has disk IO performance data for each DB client.
Table 3.46 aps_v_asm_dbclient_diskio_log
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
bytes_read
NUMBER
Total number of bytes read from the disk
bytes_written
NUMBER
Total number of bytes written to the disk
cold_bytes_read
NUMBER
Number of bytes read from the cold region on disk
cold_bytes_written
NUMBER
Number of bytes written to the cold region on disk
cold_reads
NUMBER
Number of reads from the cold region on disk
cold_writes
NUMBER
Number of writes to the cold region on disk
db_instance_name
STRING
Identifier for the database instance client
disk_id
NUMBER
Primary key from the view
hot_bytes_read
NUMBER
Number of bytes read from the hot region on disk
hot_bytes_written
NUMBER
Number of bytes written to the hot region on disk
hot_reads
NUMBER
Number of reads from the hot region on disk
hot_writes
NUMBER
Number of writes to the hot region on disk
log_date
DATE
Date and time the log record was created
read_errs
NUMBER
Total number of failed I/O read requests for the disk
read_time
NUMBER
Total I/O time (in seconds) for read requests for the disk if the TIMED_
STATISTICS initialization parameter is set to true (0 if set to false)
reads
NUMBER
Total number of I/O read requests for the disk
write_errs
NUMBER
Total number of failed I/O write requests for the disk
write_time
NUMBER
Total I/O time (in seconds) for write requests for the disk if the TIMED_
STATISTICS initialization parameter is set to true (0 if set to false)
writes
NUMBER
Total number of I/O write requests for the disk
aps_v_asm_disk
The aps_v_asm_disk view has information about database disks.
Table 3.47 aps_v_asm_disk
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
disk_create_date
DATE
Date and time when the disk was added to the disk group
disk_group_id
NUMBER
Primary key from the aps_v_asm_diskgroup view
disk_id
NUMBER
System generated identifier for the Disk
disk_mount_date
DATE
Date and time when the disk was mounted by the first instance
disk_name
STRING
Name of the disk
disk_path
STRING
Operating system path name portion of the name returned by discovery
failgroup
STRING
Name of the failure group containing the disk
failgroup_type
STRING
Type of the failure group with the following possible values:
REGULAR
QUORUM
hash_value
NUMBER
A unique hash value for an ASM disk, computed using the ASM disk
name and the ASM disk group name.
header_status
STRING
Per-instance status of the disk as seen by discovery with the following possible values:
UNKNOWN - ASM disk header has not been read
CANDIDATE - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement
INCOMPATIBLE - Version number in the disk header is not compatible with the ASM software version
PROVISIONED - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement. The PROVISIONED header status is different from the CANDIDATE header status in that PROVISIONED implies that an additional platform-specific action has been taken by an administrator to make the disk available for ASM.
MEMBER - Disk is a member of an existing disk group. No attempt should be made to add the disk to a different disk group. The ALTER DISKGROUP statement will reject such an addition unless overridden with the FORCE option.
FORMER - Disk was once part of a disk group but has been dropped cleanly from the group. It may be added to a new disk group with the ALTER DISKGROUP statement.
CONFLICT - ASM disk was not mounted due to a conflict
FOREIGN - Disk contains data created by an Oracle product other than ASM. This includes datafiles, logfiles, and OCR disks.
label
STRING
Disk label portion of the name returned by discovery
last_updated
DATE
Date and time last updated
library
STRING
Name of the library that discovered the disk
mode_status
STRING
Global status about which kinds of I/O requests are allowed to the disk with the following possible values:
ONLINE - Disk is online and operating normally. Reads and writes are attempted when the disk is mounted. Reads are attempted as part of disk discovery.
OFFLINE - Disk is offline and access to data is not permitted. Reads and writes are not attempted. An offline disk remains logically part of its disk group.
mount_status
STRING
Per-instance status of the disk relative to group mounts with the following possible values:
MISSING - Automatic Storage Management metadata indicates that the disk is known to be part of the Automatic Storage Management (ASM) disk group but no disk in the storage system was found with the indicated name
CLOSED - Disk is present in the storage system but is not being accessed by ASM
OPENED - Disk is present in the storage system and is being accessed by ASM. This is the normal state for disks in a database instance which are part of a Disk Group being actively used by the instance.
CACHED - Disk is present in the storage system and is part of a disk group being accessed by the ASM instance. This is the normal state for disks in an ASM instance which are part of a mounted disk group.
IGNORED - Disk is present in the system but is ignored by ASM because of one of the following:
-- The disk is detected by the system library but is ignored because an ASM library discovered the same disk
-- ASM has determined that the membership claimed by the disk header is no longer valid
CLOSING - ASM is in the process of closing this disk
preferred_read
STRING
Status of the preferred read failure group with the following possible values:
U - Disk group has no preferred read failure group
Y - Disk is a preferred read disk
N - Disk is not a preferred read disk
For a disk group with one or more preferred read failure groups, if the
disk is in one of the preferred read failure groups, the value of this column
is Y; otherwise it is N.
product
STRING
Name of the manufacturer and the name of the product. All disks with the
same product id will have the same performance and reliability characteristics
redundancy
STRING
Hardware redundancy of the disk with the following possible values:
UNKNOWN
UNPROT
MIRROR
PARITY
repair_timer
NUMBER
Seconds remaining until the disk is automatically dropped (0 if not failed)
sector_size
NUMBER
Physical block size (in bytes)
state
STRING
Global state of the disk with respect to the disk group with the following possible values:
UNKNOWN - ASM disk state is not known (typically the disk is not mounted)
NORMAL - Disk is online and operating normally
ADDING - Disk is being added to a disk group, and is pending validation by all instances that have the disk group mounted
DROPPING - Disk has been manually taken offline and space allocation or data access for the disk halts. Rebalancing will commence to relocate data off the disks to other disks in the disk group. Upon completion of the rebalance, the disk is expelled from the group.
HUNG - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped
FORCING - Disk is being removed from the disk group without attempting to offload its data. The data will be recovered from redundant copies, where possible.
DROPPED - Disk has been fully expelled from the disk group
udib
STRING
Unique Device ID portion of the name returned by discovery
voting_file
STRING
Indicates whether the disk contains a voting file (Y) or not (N)
aps_v_asm_disk_log
The aps_v_asm_disk_log has frequently changing data about disks.
Table 3.48 aps_v_asm_disk_log
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
coldusedmb
NUMBER
Number of used megabytes in the cold region
disk_group_id
NUMBER
Primary key from the aps_v_asm_diskgroup view
disk_id
NUMBER
Primary key from the aps_v_asm_disk view
freemb
NUMBER
Unused capacity of the disk (in MiB)
hotusedmb
NUMBER
Number of used megabytes in the hot region
log_date
DATE
Date and time the log record was created
osmb
NUMBER
Size of the disk (in MiB) as reported by the host operating system
totalmb
NUMBER
Total capacity of the disk (in MiB)
aps_v_asm_diskgroup
The aps_v_asm_diskgroup view has one row per disk group.
Table 3.49 aps_v_asm_diskgroup
Column Name
Data Type
Description
allocation_unit_size
NUMBER
Size of the allocation unit (in bytes)
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
block_size
NUMBER
ASM metadata block size (in bytes)
coldusedmb
NUMBER
Number of used megabytes in the cold region
compatibility
STRING
Minimum software version required for an ASM instance to mount this disk group
database_compatibility
STRING
Minimum software version required for a database instance to use files in this disk group
disk_group_id
NUMBER
System generated identifier for the Disk group
disk_group_name
STRING
Name of the disk group
freemb
NUMBER
Unused capacity of the disk group (in MiB)
hotusedmb
NUMBER
Number of used megabytes in the hot region
last_updated
DATE
Date and time last updated
offline_disks
NUMBER
No.of disks in the disk group that are currently offline
required_mirror_freemb
NUMBER
Amount of space that is required to be available in a given disk group in
order to restore redundancy after one or more disk failures. The amount of
space displayed in this column takes mirroring effects into account.
sector_size
NUMBER
Physical block size (in bytes)
state
STRING
State of the disk group relative to the instance with the following possible values:
CONNECTED - Disk group is in use by the database instance
BROKEN - Database instance lost connectivity to the ASM instance that mounted the disk group
UNKNOWN - ASM instance has never attempted to mount the disk group
DISMOUNTED - Disk group was cleanly dismounted by the ASM instance following a successful mount
MOUNTED - Instance is successfully serving the disk group to its database clients
QUIESCING - CRSCTL utility attempted to dismount a disk group that contains the Oracle Cluster Registry (OCR). The disk group cannot be dismounted until Cluster Ready Services (CRS) exits, because the disk group contains the OCR
totalmb
NUMBER
Total capacity of the disk group (in MiB)
type
STRING
Redundancy type for the disk group with the following possible values: EXTERNAL, NORMAL, HIGH
usable_filemb
NUMBER
Amount of free space that can be safely utilized taking mirroring into
account and yet be able to restore redundancy after a disk failure
voting_files
STRING
Indicates whether the disk contains voting files (Y) or not (N)
aps_v_asm_diskgroup_dbclient
The aps_v_asm_diskgroup_dbclient contains the relationship between a disk group and DB client.
Table 3.50 aps_v_asm_diskgroup_dbclient
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
db_instance_name
STRING
Identifier for the database instance client
disk_group_id
NUMBER
Primary key from the aps_v_asm_diskgroup view
last_updated
DATE
Date and time last updated
aps_v_asm_diskio_log
The aps_v_asm_diskio_log has disk IO performance data.
Table 3.51 aps_v_asm_diskio_log
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
bytes_read
NUMBER
Total number of bytes read from the disk
bytes_written
NUMBER
Total number of bytes written to the disk
cold_bytes_read
NUMBER
Number of bytes read from the cold region on disk
cold_bytes_written
NUMBER
Number of bytes written to the cold region on disk
cold_reads
NUMBER
Number of reads from the cold region on disk
cold_writes
NUMBER
Number of writes to the cold region on disk
disk_id
NUMBER
Primary key from the aps_v_asm_disk view
hot_bytes_read
NUMBER
Number of bytes read from the hot region on disk
hot_bytes_written
NUMBER
Number of bytes written to the hot region on disk
hot_reads
NUMBER
Number of reads from the hot region on disk
hot_writes
NUMBER
Number of writes to the hot region on disk
log_date
DATE
Date and time the log record was created
read_errs
NUMBER
Total number of failed I/O read requests for the disk
read_time
NUMBER
Total I/O time (in seconds) for read requests for the disk if the TIMED_
STATISTICS initialization parameter is set to true (0 if set to false)
reads
NUMBER
Total number of I/O read requests for the disk
write_errs
NUMBER
Total number of failed I/O write requests for the disk
write_time
NUMBER
Total I/O time (in seconds) for write requests for the disk if the TIMED_
STATISTICS initialization parameter is set to true (0 if set to false)
writes
NUMBER
Total number of I/O write requests for the disk
aps_v_asm_file
The aps_v_asm_file view has information about files on the physical database.
Table 3.52 aps_v_asm_file
Column Name
Data Type
Description
asm_instance_id
NUMBER
Primary key from the aps_v_asm_instance view
block_size
NUMBER
Block size of the file (in bytes)
blocks
NUMBER
Number of blocks in the file
bytes
NUMBER
Number of bytes in the file
db_name
STRING
Unique database name of the database client instance
disk_group_id
NUMBER
Primary key from the aps_v_asm_diskgroup view
file_creation_date
DATE
Date and time file was created
file_incarnation
NUMBER
Incarnation number for the file (composite primary key)
file_modified_date
DATE
Date and time file was modified
file_name
STRING
Alias name on the combination of file_number and file_incarnation
file_number
NUMBER
Number of the file within the disk group (composite primary key)
file_type_tag
STRING
Type specific information about the file
last_updated
DATE
Date and time last updated
redundancy
STRING
Redundancy of the file with the following possible values:
UNPROT
MIRROR
HIGH
redundancy_lowered
STRING
Indicates whether a file has lower redundancy than what was expected (Y)
or not (N). Redundancy is said to have been lowered for a file when one or
more data extents in that file are not mirrored at the level specified by the
administrator. In case of unprotected files, data extents could be missing
altogether. Another possible value for this column is (U), which means that
it is unknown
space
NUMBER
Number of bytes allocated to the file
striped
STRING
Indicates how the file is striped with the following possible values:
FINE
COARSE
type
STRING
Type of the file. Possible values are as follows:
CONTROLFILE
DATAFILE
ONLINELOG
ARCHIVELOG
TEMPFILE
BACKUPSET
XTRANSPORT
PARAMETERFILE
DATAGUARDCONFIG
FLASHBACK
CHANGETRACKING
DUMPSET
AUTOBACKUP
aps_v_asm_instance
The aps_v_asm_instance view has one row per ASM instance.
Table 3.53 aps_v_asm_instance
Column Name
Data Type
Description
asm_instance_id
NUMBER
System generated identifier for the ASM instance
asm_instance_name
STRING
Name of the ASM instance
host_id
NUMBER
Server on which this ASM runs