My current development system is NT and i need to move the content to Live environment in linux . i would like to know how to estimate the size of the database and create accrodingly in Live environment.
Printable View
My current development system is NT and i need to move the content to Live environment in linux . i would like to know how to estimate the size of the database and create accrodingly in Live environment.
select (((sum(blocks)*db_block_size)/1024)/1024)/1024 "Total database space (in GB)" from
dba_segments .
hope this helps.
You can also use the following query.
select sum(bytes/1024/1024/1024) 'DB_SIZE'
from dba_segment;
There is an excellent section in Appendix A of the Oracle8 Administrator's Guide that discusses appropriately estimating space requirements for tables, indexes and clusters.
well summing segments size wont give you the size of database rather the space you need to store all associated datafiles, if you have tables that stores in 10K but it´s store in a segment of 10M then the size of the database would be 10M rather 10K just an example
Why not Analyze all tables and indexes then you can sum the actual blocks used.
Select 'Analyze table '||owner||'.'||table_name||' compute statistics; ' from dba_tables where owner not in ('SYS','SYSTEM') ;
Spool the output and then run it.
Do the same for all indexes.