Database Administration - how to estimate size of database?

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 118 of 226

how to estimate size of database?

Total Answers and Comments: 3

Last Update: March 07, 2007 Asked by: PARTHA SINHA

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 25, 2007 10:53:20

Reenu

RE: how to estimate size of database?

You have add bytes in these 2 views DBA_FREE_SPACE (free space in db) DBA_segments(used space in db)

Is this answer useful? Yes | No

March 06, 2007 11:25:16

ram

RE: how to estimate size of database?

select sum(bytes/1024/1024/1024) from dba_data_files

Is this answer useful? Yes | No

March 07, 2007 01:29:03

prati

RE: how to estimate size of database?

select sum ( bytes) from dba_data_files ;
select sum(bytes) from v$log;
select sum ( bytes ) from dba_temp_files ;
Total sum of all the three will give the database size .

Is this answer useful? Yes | No

Go To Top