The below query will give the size of the Oracle Database completely.
select round((a.data_size+b.temp_size+c.redo_size)/1024/1024/1024,2) "total_size"
from ( select sum(bytes) data_size
from dba_data_files ) a,
( select nvl(sum(bytes),0) temp_size
from dba_temp_files ) b,
( select sum(bytes) redo_size
from sys.v_$log ) c;
Thursday, July 23, 2009
query to find database size completely
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment