Re: planning and awr

Hi Orlando,

See below resources

1. Read on the PDF here, that talks about capacity planning and sizing. It includes a tool and a sample scenario https://github.com/karlarao/sizing_worksheet
2. You can view my presentations and papers here http://www.slideshare.net/karlarao/presentations, http://www.slideshare.net/karlarao/documents
3. Some of my tools https://karlarao.wordpress.com/scripts-resources/, https://github.com/karlarao
4. And go through the entries under the following topics of my wiki https://karlarao.github.io/karlaraowiki/index.html#OraclePerformance https://karlarao.github.io/karlaraowiki/index.html#Benchmark
   <http://karlarao.tiddlyspot.com/#Benchmark>
   https://karlarao.github.io/karlaraowiki/index.html #%5B%5BCapacity%20Planning%5D%5D
   <http://karlarao.tiddlyspot.com/#%5B%5BCapacity%20Planning%5D%5D>
   https://karlarao.github.io/karlaraowiki/index.html #%5B%5BHardware%20and%20OS%5D%5D
   <http://karlarao.tiddlyspot.com/#%5B%5BHardware%20and%20OS%5D%5D>
   https://karlarao.github.io/karlaraowiki/index.html#PerformanceTools
   <http://karlarao.tiddlyspot.com/#PerformanceTools>
   https://github.com/karlarao/forecast_examples

I recommend you read the books:
• FOP
http://www.amazon.com/Forecasting-Oracle-Performance-Craig-Shallahamer/dp/1590598024/ref=sr_1_1?ie=UTF8&qid=1435948281&sr=8-1&keywords=forecasting+oracle+performance&pebp=1435948282498&perid=16H7PDMSDZYF4PJ4FWET • OPF
http://www.amazon.com/Oracle-Performance-Firefighting-Craig-Shallahamer/dp/0984102302/ref=sr_1_3?ie=UTF8&qid=1435948281&sr=8-3&keywords=forecasting+oracle+performance • TAOS (headroom section)
http://www.amazon.com/Art-Scalability-Architecture-Organizations-Enterprise/dp/0134032802/ref=sr_1_1?ie=UTF8&qid=1435948300&sr=8-1&keywords=the+art+of+scalability • TPOCSA (capacity planning section)
http://www.amazon.com/Practice-Cloud-System-Administration-Distributed/dp/032194318X/ref=sr_1_1?ie=UTF8&qid=1435948307&sr=8-1&keywords=tom+limoncelli • "Cloud Capacity Management" http://www.apress.com/9781430249238 it goes through the end to end capacity service model which is ideal for a big shop (with a lot of hierarchy and bureaucracy) or if you are thinking about implementing database as a service in a large scale. some points are not very detailed but it goes through all the relevant terms/topics. we have done a similar thing in the past for a fortune 100 bank but focuses only on oracle services
• Also join: GCAP google groups
https://groups.google.com/forum/#!forum/guerrilla-capacity-planning

-Karl

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