?
Solved

How to calculate oracle database size

Posted on 2003-03-20
5
Medium Priority
?
8,260 Views
Last Modified: 2007-12-19
what is conecpt of calculating database size
0
Comment
Question by:sameerasawant
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 

Accepted Solution

by:
Ferran earned 400 total points
ID: 8172771
The size of the datafiles (no redo, no tempfiles) can be calculated as shown:

TEST1>col format total 9999999999999
TEST1>select sum(bytes) total from dba_data_files;

         TOTAL
--------------
   68346175488


This give you the size including indexes, free space, etc.

If you want to know the "data" size, try to export full the database and look on the export file size.

I hope this helps.

Ferran
0
 
LVL 9

Expert Comment

by:konektor
ID: 8173115
select sum(bytes) from dba_data_files - how many does your datafiles take place in operating system
select sum(bytes) from dba_segments - allocated data (but not fully used by data)
select sum(bytes) from dba_free_space - datafiles are larger than data stored in it - this is unused space in datafiles
0
 

Expert Comment

by:Printaporn
ID: 8178180
Addition from Ferran's
select sum(bytes/1024) total from dba_data_files;
for the size in Kbytes.

HTH

       
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question