Viewing Volume and ACFS Information


SELECT dg.name AS diskgroup, v.volume_name, v.volume_device, v.mountpath 
FROM V$ASM_DISKGROUP dg, V$ASM_VOLUME v 
WHERE dg.group_number = v.group_number and dg.name = 'DATA';
 
SELECT dg.name AS diskgroup, v.volume_name, v.bytes_read, v.bytes_written
FROM V$ASM_DISKGROUP dg, V$ASM_VOLUME_STAT v 
WHERE dg.group_number = v.group_number and dg.name = 'DATA';
 
SELECT volume_name,size_mb,state,usage,volume_device,mountpath 
FROM v$asm_volume;
SELECT volume_name,reads,writes,read_errs,bytes_read,bytes_written 
FROM v$asm_volume_stat;
 
SELECT fs_name, vol_device, primary_vol, total_mb, free_mb 
FROM V$ASM_ACFSVOLUMES;
 
SELECT fs_name, available_time, block_size, state, corrupt 
FROM V$ASM_FILESYSTEM;
 
select substr(fs_name,1,20) FS,vol_device device,substr (snap_name,1,30) SNAP_NAME,create_time 
from v$asm_acfssnapshots;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: