|
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!
|
