Hi Andrey

Thanks again for taking a look at this.

I am still very much interested in doing the object level analysis for all databases at the Enterprise Manager repository level.

But at present we are using a package to this and deploying it in each and every database

-----Original Message-----
From: Andrey Goryunov <[address removed]>
Date: 2010/05/23 09:24:00
To: [address removed]
Cc:
Subject: Re: Re: Re: [Sydney-Oracle] storage capacity planning

Hi Hrishikesh,

I think there is no such information to show space allocation for tables in GC by default.
But it can be gathered by user-defined metrics with enabled collection for historical analysis.

Cheers,
Andrey

On 22 May 2010 22:17, Hrishikesh Samant <[address removed]> wrote:

Hi Andrey

Thank you for taking time out and responding to this.

In 10.2.0.4 and 10.2.0.5 GC i have found that there is no drill down capability to find out for example which tables in the tablespace have contributed to the growth.

Is there a way to collect table growth also from Grid control centrally

-----Original Message-----
From: Andrey Goryunov <[address removed]>
Date: 2010/04/24 07:51:10
To: [address removed]
Cc:
Subject: Re: Re: [Sydney-Oracle] storage capacity planning

Hi Hrishikesh,

I would definitely go with use of GC to that type of project since all infromation
being saved in repository and you can use different metrics that already there
for CPU, tablespaces, data files etc.

There is already report to get information for tablespace usage over a month
that uses mgmt$metric_daily so you can easily modify it to go across all targets
that you want to use

Data periodically deleted out of mgmt tables so you can take it before it erased
and used for reports cover longer periods of time.

It sounds legal enoug! h for me, since you can develop you own servlets, fetchlets, etc
even you own plug-ins to monitor dif! ferent applications and databases
and for them you can create tables that you need.

In GC 11 there is even data exchange hub that allows to send data to external systems
so at some stage it can be used either.


Cheers
Andrey Goryunov

On 24 April 2010 02:17, Hrishikesh Samant <[address removed]> wrote:

Hi Paul/Nuno

Thanks for taking time out and responding the project where i am working needs a capacity planning script and a report.

What i understood till now from the talk (since my client is remote and does not communicate often to me )that he needs to project storage growth rates for the databases monthly quarterly/yearly and order storage from the vendor he needs input from me.

Nuno's idea gave me a brief overview of how to do things.

But i am still trying to grapple with the problem of deploying such a script on 100's of servers as that would be a nightmare .Client i know has grid control in place and i was thinking of utilizing grid controls UDM to run the metric collection script and persist the results to repository db (is this legal ?)

There is a interesting twist though i have a written document from some other gentleman from the higher up in the client side whose defination of capacity management is al en compasse and which says

Predict resources like CPU,Memory,Storage to support my workload and maintain my performance levels and this makes me nervous as all my carrier i have always tuned reactively and never done anything that predicts.I dont know how to do this

It would be great if i could have a look at your work Paul to see how you gone about acheiving what you have done and even produced these fantastic graphs.

Would be wonderful if you have a blog or something or just simply host your code on sourceforge so people can have a look at your stuff.

 

 

 

-----Original Message-----
From: Paul Peterson <[address removed]>
Date: 2010/04/23 12:27:22
To: Hrishikesh Samant <[address removed]>
Cc: [address removed]
Subject: Re: [Sydney-Oracle] storage capacity planning

Hi Hrishikesh,

What level of capacity planning system are you looking for? I built a Capacity Planning system in my last position that I could help you implement. Features included:

• Oracle tablespace data collection
• Oracle sort usage data collection

• Unix filesystem data collection
• Windows data file collection
• Networker backup data collection
• Network switch CPU usage data collection

These data sets were graphed on a web site using up to six months of historical data. For Oracle, Unix and Windows data the following was graphed:

• Total space available
• Space used
• 90 moving averages for total space and space used

The Networker data was graphed by volume backed up, for each day and the weekend with 90 day moving averages.

In my past position I was an Oracle DBA who also wore the hats of Capacity Planning Manager and Backup Administrator. I developed this system over a period of ~4 years.

I have attached an example Networker Volume Graph from before the 90 day averages were added:

I have the scripts and the database schema to recreate the system tailored to your requirements. The system was initially developed on Solaris and later ported to Linux, so is not tied to a particular platform, though part of the system are specific to my last position as it ties into their central inventory system.

If you would like to investigate this further, please let me know and we can set up a time to discuss this further.

Regards,

Paul Peterson.

On 20 Apr 2010, at 23:56, Hrishikesh Samant wrote:

Hi

I would like to know what commercial off the shelf product or inhouse scripts do you use for storage capacity planning for
projecting storage requirements.

If anybody is using inhouse scripts would it be possible to share those.

regards




--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
http://www.sydneyoracle.com.au/
This message was sent by Hrishikesh Samant ([address removed]) from Sydney Oracle Meetup.
To learn more about Hrishikesh Samant, visit his/her member profile: http://www.sydneyoracle.com.au/members/10480264/
To unsubscribe or to update your mailing list setting! ! s, click here: http://www.sydneyoracle.com.au/settings/
Meetup, PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]

!

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Hrishikesh Samant ([address removed]) from Sydney Oracle Meetup.
To learn more about Hrishikesh Samant, visit his/her member profile

To unsubscribe or to update your mailing list settings, click here

Meetup, PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Andrey Goryunov ([address removed]) from Sydney Oracle Meetup.
To learn more about Andrey Goryunov, visit his/her member profile
To unsubscribe or to update your mailing l! ist settings, cl! ick here

Meetup, PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]



--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Hrishikesh Samant ([address removed]) from Sydney Oracle Meetup.
To learn more about Hrishikesh Samant, visit his/her member profile
To unsubscribe or to update your mailing list settings, click! here

Meetup, PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]

--
Sincerely,
Andrey Goryunov.




--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Andrey Goryunov ([address removed]) from Sydney Oracle Meetup.
To learn more about Andrey Goryunov, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here

Meetup, PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]



--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Hrishikesh Samant ([address removed]) from Sydney Oracle Meetup.
To learn more about Hrishikesh Samant, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here

Meetup, PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]