• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8265
  • Last Modified:

How to calculate oracle database size

what is conecpt of calculating database size
0
sameerasawant
Asked:
sameerasawant
1 Solution
 
FerranCommented:
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
 
konektorCommented:
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
 
PrintapornCommented:
Addition from Ferran's
select sum(bytes/1024) total from dba_data_files;
for the size in Kbytes.

HTH

       
0

Featured Post

Independent Software Vendors: 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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now