Reliable capacity planning for Oracle

Determining the future size of Oracle tables, the size of Oracle indexes, and the overall tablespace size is a formidable challenge which depends on many factors:

- Your blocksize (db_block_size) - How many rows will fit into a data block?

- Your PCTFREE - At what point do you move a data block off of the freelist?

- Your average row length - What is your avg_row_len in dba_tables?

- How are you implementing your freelists (i.e. using ASSM (bitmap freelists))?

- And many, many other internal factors that effects the total size of tablespaces, tables and indexes.

Oracle capacity planning generally involves these decisions

- Get tablespace sizing computations.

- See Oracle table sizing rules and index sizing spreadsheets.

- Get a framework for Oracle capacity planning.

- Get SGA sizing calculations.

Most professionals create spreadsheets for accurate Oracle capacity planning but they are quite complex and time-consuming.  Mike Ault has a great set of capacity planning spreadsheets for Oracle:

www.rampant-books.com/download_sizing_spreadsheets.htm

For complete details, see my book "Oracle Tuning: The Definitive Reference":

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm

*****************************************

Ignite for SQL Server and Oracle.

Performance tuning based on wait time information has proven itself to be the best practice for Oracle.  Now Confio Software has expanded their Igniter Suite to include SQL Server Wait-Time analysis as well.  Igniter Suite users can continuously monitor and get insight into the SQL wait times and how to resolve them for Oracle and SQL Server, with DB2 right around the corner.   This tool is simple to install, get a free trial and be solving problems in 30 minutes.  

 www.confio.com/ora2

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 800-766-1884 for details, and check-out our on-site Oracle training catalog:

http://www.dba-oracle.com/bc-catalog.pdf