Re: ASM DISKGROUP INFORMATION

From: goran bogdanovic <goran00_at_gmail.com>
Date: Thu, 12 Dec 2013 11:22:06 +0100
Message-ID: <CAGyPXK6Xb+Ey4WmfK-RvDv6W+zKA8yXyyt7S0wLbNGH9S+Sk1Q_at_mail.gmail.com>

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

Received on Thu Dec 12 2013 - 11:22:06 CET