Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 
Script Download
 


Oracle Capacity planning and  Sizing Spreadsheets

Intelligent Oracle capacity planning spreadsheets and table sizing methods.

               $19.95

            Buy it Now!

 


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!

 

Key Features

* Get fast Oracle tablespace sizing computations.

* See Oracle table sizing rules and index sizing spreadsheets.

* Get a framework for Oracle capacity planning.

* Get SGA sizing calculations for capacity planning.

* Includes a RAID configuration spreadsheet.

* Get calculations for proper sizing of LOB columns

* An indispensable tool for Oracle capacity planning

   

 Copyright © 1996 -2011 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks