使用sqlplus查询asm信息

v$asm_disk //查询asm disk信息

[grid@11grac1 ~]$ sqlplus sys/grid as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 3 15:33:33 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 Real Application Clusters and Automatic Storage Management options

SQL> col path format a20

SQL> select group_number,name,path,state from v$asm_disk order by group_number;


GROUP_NUMBER NAME    PATHSTATE
------------ ------------------------------ -------------------- --------
  1 CRS_0001    /dev/asm-diskc NORMAL
  1 CRS_0000    /dev/asm-diskb NORMAL
  1 CRS_0002    /dev/asm-diskd NORMAL
  2 DATADG_0000   /dev/asm-diske NORMAL
  2 DATADG_0001   /dev/asm-diskf NORMAL
  3 FRADG_0000    /dev/asm-diskg NORMAL


6 rows selected.

v$pwfile_users //查询用户信息

SQL> desc v$pwfile_users
 Name   Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME    VARCHAR2(30)
 SYSDBA    VARCHAR2(5)
 SYSOPER    VARCHAR2(5)
 SYSASM    VARCHAR2(5)


SQL> select * from v$pwfile_users;


USERNAME       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS       TRUE  TRUE  TRUE
ASMSNMP       TRUE  FALSE FALSE
LMY       TRUE  FALSE FALSE