Re: planning and awr

  • From: Karl Arao <karlarao@xxxxxxxxx>
  • To: Orlando L <oralrnr@xxxxxxxxx>
  • Date: Tue, 5 Sep 2017 14:21:28 -0400

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

Other related posts: