-
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
Vinit
-
Find the Size of the DB
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
/
Felix
DBA
-
-
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
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
|