Re: ASM DISKGROUP INFORMATION

On Thu, Dec 12, 2013 at 3:52 PM, goran bogdanovic <goran00_at_gmail.com> wrote:

> select target_name,
> target_type target_type,
> key_value dg_name,
> max(decode(column_label,'Disk Group Usable Free
> (MB)',maximum,0))/1024 used_space_gb,
> max(decode(column_label,'Disk Group Usable
> (MB)',maximum,0))/1024 alloc_space_gb,
> trunc(rollup_timestamp) stat_timestamp
> from SYSMAN.MGMT$METRIC_DAILY a
> where target_type in ('osm_instance','osm_cluster')
> and column_label in ('Disk Group Usable (MB)','Disk Group
> Usable Free (MB)')
> and rollup_timestamp>=trunc(sysdate-1)
> and trunc(rollup_timestamp)=trunc(sysdate-1)
> and not exists (select 'a' from SYSMAN.MGMT$TARGET_MEMBERS where
> aggregate_target_type='osm_cluster' and member_target_name=a.target_name
> and member_target_type='osm_instance')
> group by target_name,target_type,key_value,rollup_timestamp
>
> Query can be of course improved :-)
> On Dec 12, 2013 10:41 AM, "Nagaraj S" <nagaraj.chk_at_gmail.com> wrote:
>
>> Thanks Goran. Do you have the query for this requirement?
>>
>>
>> On Thu, Dec 12, 2013 at 1:29 PM, goran bogdanovic <goran00_at_gmail.com>wrote:
>>
>>> Or query the repository directly with our friend sqlplus...
>>>
>>> > 12c is the way to go if you have got it set up - just create a report
>>> >
>>> >
>>> >
>>> > john
>>> >
>>> >
>>> >
>>> > From: oracle-l-bounce_at_freelists.org [mailto:
>>> oracle-l-bounce_at_freelists.org] On Behalf Of Nagaraj S
>>> > Sent: 11 December 2013 09:27
>>> > To: oracle-l
>>> > Subject: ASM DISKGROUP INFORMATION
>>> >
>>> >
>>> >
>>> > Dear Gurus,
>>> >
>>> >
>>> >
>>> > I need to get ASM disk group space usage information across 200+
>>> servers. We need this report for capacity planning analysis. Instead of
>>> logging to each individual server is there any way to get disk group
>>> information of all servers using any method?
>>> >
>>> > Please advise me if we can get this information from OEM 12c? Or using
>>> emcli command is it possible?
>>> >
>>> >
>>> >
>>> > -Naga
>>> >
>>> >
>>> > ______________________________________________________________________
>>> > Wm Morrison Supermarkets Plc is registered in England with number
>>> 358949. The registered office of the company is situated at Gain Lane,
>>> Bradford, West Yorkshire BD3 7DL. This email and any attachments are
>>> intended for the addressee(s) only and may be confidential.
>>> >
>>> > If you are not the intended recipient, please inform the sender by
>>> replying to the email that you have received in error and then destroy the
>>> email.
>>> > If you are not the intended recipient, you must not use, disclose,
>>> copy or rely on the email or its attachments in any way.
>>> >
>>> > This email does not constitute a contract in writing for the purposes
>>> of the Law of Property (Miscellaneous Provisions) Act 1989.
>>> >
>>> > Our Standard Terms and Conditions of Purchase, as may be amended from
>>> time to time, apply to any contract that we enter into. The current version
>>> of our Standard Terms and Conditions of Purchase is available at:
>>> http://www.morrisons.co.uk/gscop
>>> >
>>> > Although we have taken steps to ensure the email and its attachments
>>> are virus-free, we cannot guarantee this or accept any responsibility,
>>> > and it is the responsibility of recipients to carry out their own
>>> virus checks.
>>> > ______________________________________________________________________
>>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l