web analytics
Skip to primary content
Skip to secondary content

MemoSoup

Mix of the things I always forget

MemoSoup

Main menu

  • Home
  • About
  • Links

Tag Archives: asm

Oracle: information about ASM

Posted on 02/10/2009 by bigspoon
Reply

Get the information about ASM disks:


select GROUP_NUMBER, DISK_NUMBER, TOTAL_MB/1024 GB, NAME from v$asm_disk;

Get the information about ASM diskgroups (including used space and the free space):


select GROUP_NUMBER, NAME, TOTAL_MB/1024 TOTAL_GB, FREE_MB/1024 FREE_GB from v$asm_diskgroup;

Posted in Oracle | Tagged asm, diskgroup, Oracle | Leave a reply

Archives

  • March 2021
  • February 2016
  • February 2013
  • December 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • July 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009

Meta

  • Log in
Proudly powered by WordPress