Home » RDBMS Server » Server Administration » Database Sizing
Database Sizing [message #445801] Thu, 04 March 2010 03:47 Go to next message
gera.divya
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)?

Report message to a moderator

Re: Database Sizing [message #445813 is a reply to message #445801] Thu, 04 March 2010 04:13 Go to previous message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
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).

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 27 14:20:36 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.