About the Oracle Capacity Planning spreadsheets

Written by one of the world's most widely-read Oracle DBA experts, this comprehensive Oracle capacity planning spreadsheet collection performs every area of Oracle capacity planning.

These capacity planning spreadsheets have complete data file sizing and tablespace sizing formats, including spreadsheets to size your Oracle tables and indexes.

This capacity planning spreadsheet collection also includes SGA and LOB sizing , plus a STATSPACK-based sizing utility.

If you've ever wanted an easily accessible Oracle capacity planning spreadsheet collection you have to get this download!

Caution - These are extremely powerful undocumented Oracle capacity spreadsheets. They should only be used by a certified Oracle DBA, and after a careful review of spreadsheet sizing and capacity planning assumptions. USE AT YOUR OWN RISK.

The Oracle DBA Capacity planning Spreadsheet Utilities package contains Excel spreadsheets for use in Oracle capacity planning. Included in the package are:

1. Oracle table sizing spreadsheet – This can be used to predict table sizes before a table is created or to predict future growth. By varying blocksize, pctfree and initrans the affects of these parameters on table size can be predicted.  
2. Oracle index sizing spreadsheet – This can be used to predict index sizes before a table is created or to predict future growth. By varying blocksize, pctfree and initrans the affects of these parameters on index size can be predicted.  
3. SGA sizing spreadsheet – This is used with information from the table and index spreadsheets to help configure the SGA size.  
4. Oracle RAID spreadsheet – This is used with data from your IO subsystem to predict the number of disks needed for RAID10 and RAID 5 setups.  
5. COMPARE spreadsheet – This is used with STATSPACK to compare a before and after changes STATSPACK report to show the affect of tuning on the system.

When used together the above spreadsheets make planning an Oracle system easier and more efficient.

A document on the spreadsheet use as well as a whitepaper on sizing with LOBs is also included in the package.

Get your copy and start using this Oracle capacity planning spreadsheet collection now!