Post date: 25-May-2009 12:50:30
1. VIA SQL
[oracle@rc1.myrac.com] # . setasm
[oracle@rc1.myrac.com] # env | grep ORA
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle/product
ORACLE_HOME=/u01/app/oracle/product/asm
[oracle@rc1.myrac.com] # conn
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 25 18:23:55 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select name, state, total_mb, free_mb, usable_file_mb from v$asm_diskgroup;
NAME STATE TOTAL_MB FREE_MB USABLE_FILE_MB
------------------------------ ----------- ---------- ---------- --------------
DATA MOUNTED 40946 28602 14301
FLASH MOUNTED 20473 20139 20139
2. VIA asmcmd utility
[oracle@rc1.myrac.com] # . setasm
[oracle@rc1.myrac.com] # env | grep ORA
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle/product
ORACLE_HOME=/u01/app/oracle/product/asm
[oracle@rc1.myrac.com] # asmcmd lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED NORMAL N N 512 4096 1048576 40946 28602 0 14301 0 DATA/
MOUNTED EXTERN N N 512 4096 1048576 20473 20139 0 20139 0 FLASH/