Re: Database Capacity Management
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:
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-lReceived on Thu Oct 04 2012 - 21:06:05 CEST