|
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:
- 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.
- 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.
- SGA sizing spreadsheet
– This is used with information from the table and index
spreadsheets to help configure the SGA size.
- 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.
- 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!
|
