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.
.
 FollowUps:
 Re: diskgroup calculations
 From: Mark D Powell
 Re: diskgroup calculations
 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):
Relevant Pages
