November 30 2013

查看ASM磁盘空间使用情况

sck_node1@oracle:/home/oracle>su – grid
grid’s Password:
sck_node1@grid:/home/grid>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 30 12:03:51 2014

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>  select group_number,name,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB
———— —————————— ———- ———-
1 SCKDATA                           3072000     943408

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
sck_node1@grid:/home/grid>asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576   3072000   943408                0          943408              0             Y  SCKDATA/



Copyright 2019. All rights reserved.

Posted 2013年11月30日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *