ASM DiskGroup Performance Statistics

The V$ASM_DISKGROUP_STAT view provides 12c ASM DiskGroup Performance Statistics for current DiskGroups.

The data is extracted from the X$KFGRP_STAT source table.

————————————————————————-
— File Name : www.vitalsofttech.com/asm-diskgroup-performance-statistics/
— Author : Natik Ameen
— Description : Provides performance statistics for the ASM diskgroups
— Last Modified: 12/07/2014
————————————————————————–

COL name FOR a10;
COL state FOR a10;
COL compatibility FOR a10;
COL type FOR a10;
COL database_compatibility FOR a10;

SELECT *
FROM v$asm_diskgroup_stat;

This view like all other ASM views are available in both the ASM and the Database instance.

The data for this view accessed from the ASM includes information for all databases connected to the ASM instance. When querying the same view from the database it will return data relevant to the database you are connect to.

Here is a list of columns for the V$ASM_DISKGROUP_STAT table.

sqlplus>DESC v$asm_diskgroup_stat;

Name Null? Type
GROUP_NUMBER   NUMBER
NAME   VARCHAR2(30)
SECTOR_SIZE   NUMBER
BLOCK_SIZE   NUMBER
ALLOCATION_UNIT_SIZE   NUMBER
STATE   VARCHAR2(11)
TYPE   VARCHAR2(6)
TOTAL_MB   NUMBER
FREE_MB   NUMBER
HOT_USED_MB   NUMBER
COLD_USED_MB   NUMBER
REQUIRED_MIRROR_FREE_MB   NUMBER
USABLE_FILE_MB   NUMBER
OFFLINE_DISKS   NUMBER
COMPATIBILITY   VARCHAR2(60)
DATABASE_COMPATIBILITY   VARCHAR2(60)
VOTING_FILES   VARCHAR2(1)

Oracle Documents
Automatic Storage Management Administrator’s Guide

Realted Articles
Oracle RAC Articles
Oracle 12c Articles

Leave a Reply

Your email address will not be published.