This forum is currently locked. You can't register or post questions at this time. (read more)

how to find space usage on ASM

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

sivakumarocp
Advisor
Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

how to find space usage on ASM

Postby sivakumarocp » Mon Apr 23, 2012 4:16 am

Hi Tim,

One of my test RAC environment has four database are running, all datafiles are placed under DATAFILE diskgroup. all four database are separated by database name.
I need to find the size of each database under DATAFILE diskgroup. how can I find it by after login to ASMCMD.

Like in normal Linux/Unix we use du -h . command likewise is there any command to find space usage in ASMCMD.(in both 10g or 11g)
Regards
Sivakumar.A
www.sivakumardba.com

peterx
Senior Member
Posts: 208
Joined: Wed Feb 09, 2011 7:07 am

Re: how to find space usage on ASM

Postby peterx » Mon Apr 23, 2012 4:55 am

hi,

seems, you can use:
http://docs.oracle.com/cd/B19306_01/ser ... m_util.htm

Code: Select all

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    102400    63813                0           63813              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576    102400    99779                0           99779              0             N  FLASH_RECOVERY_AREA/
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  ORA_DATA/
ASMCMD>

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: how to find space usage on ASM

Postby Tim... » Mon Apr 23, 2012 8:54 am

Hi.

The lsdg command would work if you has separate disk groups for each, but the OP said they were all in the DATA dis group, so this would not work for them.

The ASM command line does support a du command, so you can still use that on each directory.

http://docs.oracle.com/cd/B19306_01/ser ... m#BABIDEII

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

sivakumarocp
Advisor
Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: how to find space usage on ASM

Postby sivakumarocp » Mon Apr 23, 2012 1:34 pm

Now I understood clearly
Thanks Tim :)
Regards
Sivakumar.A
www.sivakumardba.com

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: how to find space usage on ASM

Postby Tim... » Mon Apr 23, 2012 3:29 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle RAC and Clusterware”

Who is online

Users browsing this forum: No registered users and 7 guests

cron