In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Friday, December 18, 2009

v$ASM view, Automatic Storage Management views

The following v$ASM views describe the structure and components of ASM:

v$ASM_ALIAS
This view displays all system and user-defined aliases. There is one row for every alias present in every diskgroup mounted by the ASM instance. The RDBMS instance displays no rows in this view.

V$ASM_ATTRIBUTE
This Oracle Database 11g view displays one row for each ASM attribute defined. Theseattributes are listed when they are defined in CREATE DISKGROUP or ALTER DISKGROUP statements. DISK_REPAIR_TIMER is an example of an attribute.

V$ASM_CLIENT
This view displays one row for each RDBMS instance that has an opened ASM diskgroup.

V$ASM_DISK
This view contains specifics about all disks discovered by the ASM isntance, including mount status, disk state, and size. There is one row for every disk discovered by the ASM instance.

V$ASM_DISK_IOSTAT
This displays information about disk I/O statistics for each ASM Client. If this view is queried from the database instance, only the rows for that instance are shown.

V$ASM_DISK_STAT
This view contains similar content as the v$ASM_DISK, except v$ASM_DISK_STAT reads disk information from cache and thus performs no disk discovery. Thsi view is primarily used form quick acces to the disk information without the overhead of disk discovery.

V$ASM_DISKGROUP
This view displays one row for every ASM diskgroup discovered by the ASM instance on the node.

V$ASM_DISKGROUP_STAT
This view contains all the similar view contents as the v$ASM_DISKGROUP, except that v$ASM_DISK_STAT reads disk information from the cache and thus performs no disk discovery. This view is primarily used for quick access to the diskgroup information without the overhead of disk discovery.

V$ASM_FILE
This view displays information about ASM files. There is one row for every ASM file in every diskgroup mounted by the ASM instance. In a RDBMS instance, V$ASM_FILE displays no row.

V$ASM_OPERATION
This view describes the progress of an influx ASM rebalance operation. In a RDBMS instance, v$ASM_OPERATION displays no rows.

V$ASM_TEMPLATE
This view contains information on user and system-defined templated. v$ASM_TEMPLATE displays one row for every template present in every diskgroup mounted by the ASM instance. In a RDBMS instance, v$ASM_TEMPLATE displays one row for every template present in every diskgroup mounted by the ASM instance with which the RDBMS instance communicates.

thats it,

regards,
rajeshkumar g

No comments:

 
Share/Bookmark