Re: Database Capacity Management

From: Austin Hackett <hacketta_57_at_me.com>
Date: Thu, 04 Oct 2012 20:06:05 +0100
Message-id: <B7E8C476-B99C-4C8B-9775-A856385F39B0_at_me.com>



Hi Nilesh

There seems to be precious little Oracle specific information available on the web. I am aware of the following presentations:

http://www.google.co.uk/url?sa=t&rct=j&q=oracle%20capacity%20planning%20&source=web&cd=6&cad=rja&ved=0CEgQFjAF&url=http%3A%2F%2Fwww.processdox.com%2FDocuments%2F6340592-Oracle-Database-Capacity-Planning.pdf&ei=l9ptUJmBOYGV0QX504HACQ&usg=AFQjCNHu_6LvUQFz8x9c5Ol75s7hkg4QYA

http://www.docstoc.com/docs/97623840/Performance-and-Capacity-Trend----Independent-Oracle-Users-Group

I suppose the sky is the limit with this stuff, but I've found a good way of pulling something basic together is via the DBA_HIST_SYSMETRIC_SUMMARY AWR view (need to be licensed for the diagnostics and tuning pack).

Refer to slide 55 of this presentation for an example query (a big thank you to the guys at CERN for this!):

http://www.google.co.uk/url?sa=t&rct=j&q=cern%20capacity%20planning%20query&source=web&cd=1&ved=0CCMQFjAA&url=http%3A%2F%2Findico.cern.ch%2FgetFile.py%2Faccess%3FcontribId%3D10%26sessionId%3D6%26resId%3D1%26materialId%3Dslides%26confId%3D20080&ei=itttULSbDOjQ0QWjz4GoCQ&usg=AFQjCNH6LDcCQq_wP54849EKvJlW_wdR6Q&cad=rja

You can use Excel and ODBC to graph your chosen metrics.

Hope that helps

Austin

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 04 2012 - 21:06:05 CEST

Original text of this message