Home » RDBMS Server » Server Administration » Database Sizing
Database Sizing [message #445801] Thu, 04 March 2010 03:47 Go to next message
Messages: 1
Registered: March 2010
Junior Member
Hi..i want to create a database.How to i calculate the size of the database?Also, how much storage space is required by oracle datatypes(numeric, varchar2, date etc)?
Re: Database Sizing [message #445813 is a reply to message #445801] Thu, 04 March 2010 04:13 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Administrator's Guide
Chapter 14 Managing Space for Schema Objects
Section Managing Storage Parameters
Section Capacity Planning for Database Objects
Paragraph Capacity Planning for Database Objects
Chapter 15 Managing Tables
Section Guidelines for Managing Tables
Paragraph Estimate Table Size and Plan Accordingly
Chapter 16 Managing Indexes
Section Guidelines for Managing Indexes
Paragraph Estimate Index Size and Set Storage Parameters

Some datatype are fixed length (for instance DATE=7 bytes) other are variable length and depends on your data (for instance NUMBER or VARCHAR2).


Previous Topic: Oracle11G Database startup problem
Next Topic: Session Inactive but running queries
Goto Forum:

Current Time: Tue Oct 25 14:54:07 CDT 2016

Total time taken to generate the page: 0.07256 seconds