Click on this link to be redirected to the Scripts section. Some of my favorite tools I’ve created are the following:
ASH and AWR Mining
- r2toolkit – a regression analysis tool for Oracle workload performance
- AWR Tableau Toolkit – create your own performance data warehouse and easily characterize the workload, CPU, IO of the entire cluster (30 instances) with months of perf data in less than 1 hour
- I no longer update this toolkit. This served as a version 1 of a more comprehensive tool called eAdam which I started with Carlos Sierra (the main developer), Frits Hoogland, and Randy Johnson at Enkitec.
- run_awr-quickextract – set of scripts used for Performance Tuning, Capacity Planning and Sizing
- This doesn’t create a warehouse, all you need is to consolidate the CSV files and you’re good to go. I use this a lot for performance firefighting or one time sizing engagements.
- gvash_to_csv – pulls the ASH data every 10 mins, very useful for historical instrumentation of your active data guard environment
Consolidation, Sizing, and Capacity Planning
- Provisioning Worksheet – The worksheet is designed to help define the resource provisioning of an Oracle database consolidation project. This tool will help you answer the question – how many databases can I run on my Database Machine? With the configuration and performance data that is gathered from the customer databases the tool will show you the utilization of the CPU, Memory, and Storage when these databases are migrated to Exadata. With this vital information the project team will have an informed decision and the flexibility to move around the resources to ensure balanced utilization. The tool works around the basic capacity planning formula Utilization = Requirements / Capacity. For massive consolidations (25 to 100+ databases) we use the web version called ESP which is currently an internal use only tool
- oriontoolkit – an automated Orion and collectl runs for OLTP and DSS
- IOsaturationtoolkit-v2 – a benchmark tool to validate the database IO performance from the Orion and Calibrate IO runs
- updated 20120511: the version 2 now contains a section for doing IORM test cases and some cool smart scan monitoring scripts
- cell_iops.sh – a “sort of” end to end Exadata IO monitoring script, see the script for README
Investigations and WhitePapers
- Mining the AWR repository for Capacity Planning and Visualization
- AAS investigation and the CPU Wait metric
- OEM12c Consolidation Planner quick notes and comparison to Enkitec’s Provisioning Worksheet (link1, link2, link3)
- Exadata Consolidation Success Story
- Where did my CPU go?