# diskgroup calculations

*From*: just_real <jthlcf@xxxxxxxxx>*Date*: Wed, 14 Jan 2009 16:06:40 -0800 (PST)

Hi

I am using this query to display the size of the diskgroups in Oracle

and manually adding the figures up to get the total size of the

diskgroup.

select b.instance_name, a.LABEL,a.NAME,a.TOTAL_MB,a.GROUP_NUMBER from v

$asm_disk a, v$asm_client b where a.group_number = b.group_number;

The question I have is:

1. Is there a better way to work out the calculations of total

diskgroup size?

2. The above query only works if the diskgroup is managed by ASM. What

would I be doing if there is no ASM? What would I have to change in

the query above?

Thank you.

.

**Follow-Ups**:**Re: diskgroup calculations***From:*Mark D Powell

- Prev by Date:
**Re: renumbering the data in a column?** - Next by Date:
**Snapshot log problem** - Previous by thread:
**renumbering the data in a column?** - Next by thread:
**Re: diskgroup calculations** - Index(es):