Thursday, March 6, 2014

ASM Dynamic Performance Views


The ASM instance hosts memory-based metadata tables presented as dynamic performance views.
  • Is accessed by ASM utilities to retrieve metadata-only information using the SQL language
  • Contains many dedicated ASM-related views such as: 
V$ASM_ALIAS    V$ASM_ATTRIBUTE  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_OPERATION  V$ASM_TEMPLATE  V$ASM_ACFSVOLUME
V$ASM_FILESYSTEM
  

The V$ASM_* views exist in both ASM and database instances. The rows returned will vary.

No comments:

Post a Comment