any one could you pls provide teh script for
how to find
1. The actual database size
2.Database size estimation
Printable View
any one could you pls provide teh script for
how to find
1. The actual database size
2.Database size estimation
select sum(bytes) from dba_data_files
will give u the current size of your db. Extimate is something which you have to plan based on your application and the growth which u expect on the DB. Hope that helps.
Cheers
select sum(a.bytes),sum(b.bytes),substr(c.value,1,10) ,
(((sum(a.bytes)+sum(b.bytes)+c.value)/1024)/1024)/1024 total
from v$log a,v$datafile b,v$parameter c
where c.name='shared_pool_size'
group by c.value
/
Hi Suresh,
Try this link
http://dbasupport.com/forums/showthr...threadid=14113
Regards,
Hi Suresh,
Maybe this script will be handy for admin purposes.
select a.tablespace_name,
a.ts_size_in_MB,
b.ts_free_space,
round(((a.ts_size_in_MB-b.ts_free_space)/a.ts_size_in_MB)* 100,2) percentage
from (select tablespace_name,
round(sum(bytes)/(1024*1024)) ts_size_in_MB
from dba_data_files
group by tablespace_name) a,
(select tablespace_name,
round(sum(bytes)/(1024*1024)) ts_free_space
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name (+)
order by b.ts_free_space
tycho