Re: diskgroup calculations
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 16 Jan 2009 10:02:51 -0800 (PST)
Message-ID: <67df5196-aa8f-4b01-8422-c17d3224fc32_at_r15g2000prd.googlegroups.com>
On Jan 14, 7:06 pm, just_real <jth..._at_gmail.com> wrote:
> 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.
Date: Fri, 16 Jan 2009 10:02:51 -0800 (PST)
Message-ID: <67df5196-aa8f-4b01-8422-c17d3224fc32_at_r15g2000prd.googlegroups.com>
On Jan 14, 7:06 pm, just_real <jth..._at_gmail.com> wrote:
> 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.
This was also posted to the server forum and was answered there:
http://groups.google.com/group/comp.databases.oracle.server/browse_frm/thread/6335db4098ab7090?hl=en
- Mark D Powell --