Check Asm Disks


bash-3.2$ ps -afe | grep smon
 root 823 1 0 Dec 23 ? 142:13 /u02/app/oracle/product/grid/db_1/bin/osysmond.bin
 oracle 19016 1 0 Jun 20 ? 7:03 asm_smon_+ASM1
 oracle 4844 1 0 Dec 22 ? 1:10 ora_smon_AZKKDB1
 oracle 21510 18592 0 15:27:13 pts/2 0:00 grep smon
bash-3.2$ 
bash-3.2$ 
bash-3.2$ sqll
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 27 15:27:14 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> 
SQL> select name from v$database;
NAME
---------
AZKKDB

SQL> set pages 50000 lines 120
SQL> col path for a30
SQL> select disk_number,
 2 mount_status,
 3 header_status,
 4 mode_status,
 5 state,path
 6 from v$asm_disk ;
DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE PATH
----------- ------- ------------ ------- -------- ------------------------------
 0 CACHED MEMBER ONLINE NORMAL /dev/rdsk/emcpower0a
 1 CACHED MEMBER ONLINE NORMAL /dev/rdsk/emcpower1a
 0 CACHED MEMBER ONLINE NORMAL /dev/rdsk/emcpower2a
SQL> set pages 50000 lines 120
SQL> select path,redundancy,total_mb,free_mb,failgroup
 2 from v$asm_disk
 3 where mount_status='CACHED' and header_status='MEMBER' and
 4 mode_status='ONLINE' and state='NORMAL'
 5 order by path;
PATH REDUNDA TOTAL_MB FREE_MB FAILGROUP
------------------------------ ------- ---------- ---------- ------------------------------
/dev/rdsk/emcpower0a UNKNOWN 307140 235583 DATA_0000
/dev/rdsk/emcpower1a UNKNOWN 307140 235607 DATA_0001
/dev/rdsk/emcpower2a UNKNOWN 204752 201573 FRA_0000

SQL> set pages 50000 lines 120
SQL> col path for a15
SQL> select a.path,b.NAME from v$asm_disk a, v$asm_diskgroup b
 2 where a.GROUP_NUMBER=b.GROUP_NUMBER and
 3 a.path like '%raw%' ;
no rows selected
SQL> set pages 50000 lines 120
SQL> col path for a15
SQL> select a.path,b.NAME from v$asm_disk a, v$asm_diskgroup b
 2 where a.GROUP_NUMBER=b.GROUP_NUMBER;
PATH NAME
--------------- ------------------------------
/dev/rdsk/emcpo DATA
wer0a
/dev/rdsk/emcpo DATA
wer1a
/dev/rdsk/emcpo FRA
wer2a

SQL> select
 2 instname,
 3 dbname,
 4 group_number,
 5 failgroup,
 6 disk_number,
 7 reads,
 8 writes
 9 from v$asm_disk_iostat
 10 order by 1,2,3,4,5,6
 11 /
INSTNAME DBNAME GROUP_NUMBER FAILGROUP
---------------------------------------------------------------- -------- ------------ ------------------------------
DISK_NUMBER READS WRITES
----------- ---------- ----------
AZKKDB1 AZKKDB 1 DATA_0000
 0 25109347 5938833
AZKKDB1 AZKKDB 1 DATA_0001
 1 25948365 6987332
AZKKDB1 AZKKDB 2 FRA_0000
 0 24 14607
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: