-
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.
_________________________
Joe Ramsey
Senior Database Administrator
dbaDirect, Inc.
(877)687-3227
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|