Oracle AWR Analysis Toolkit (v1.7)
====================================

Complete instructions: https://pureinstall.wooldata.com/oracle/
Submit captured data:  https://pureinstall.wooldata.com/upload/
Questions:             support@wooldata.com

What's in this bundle
---------------------

1. AWR-Generator.sql
   Bulk-creates AWR HTML reports for every snapshot in a chosen window.
   Run on each node of every instance (RAC + non-RAC).
   Slightly modified from flashdba's open-source version:
   https://github.com/flashdba/scripts

2. oracle-sizing.sql
   Per-database sizing: data files + temp + redo + controlfile, plus
   Fast Recovery Area (FRA) usage. Prints to screen and writes
   db_capacity_fra_report.csv.
   Run on each instance.

3. flashback_estimate.sql
   Captures Flashback footprint via v$flashback_database_log.
   Run on each instance using Flashback.

4. asm_diskgroup_capacity.sql
   ASM disk group capacity, redundancy, and utilization. Prints to
   screen and writes asm_diskgroup_capacity.csv.
   Run as SYSASM on each ASM instance.

5. encryption_detail.sql
   Per-segment encryption inventory: TDE state, algorithm, segment
   type, count, and total MB. Writes encryption_capacity_report.csv.
   Run on each instance.

6. compression_details.sql       (Exadata + HCC only)
   Per-table and per-partition compression state and size. Writes
   compressed_data_capacity.csv.
   Used to project de-compressed footprint when moving off Exadata.

7. Oracle Analysis Test Kit.docx
   The full customer-facing instructional document. Use this if you'd
   rather follow the guided document than the web page.


Quick start
-----------

For each Oracle instance / node:

  sqlplus user/pass@instance
  SQL> @AWR-Generator.sql        -- prompts for snap window
  SQL> @awr-generate.sql         -- runs the generator output
  SQL> @oracle-sizing.sql
  SQL> @flashback_estimate.sql
  SQL> @encryption_detail.sql
  -- Exadata only:
  SQL> @compression_details.sql

For each ASM instance:

  sqlplus / as sysasm
  SQL> @asm_diskgroup_capacity.sql

Save outputs into a folder named after the instance, then zip and
upload at https://pureinstall.wooldata.com/upload/

Minimum coverage: 30 days of hourly snapshots, every node. AWR licensing
required.
