Database Administration - How can be determine the size of the database?

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 81 of 231

How can be determine the size of the database?

You can query dba_data_files and dba_temp_files

Total Answers and Comments: 6

Last Update: April 28, 2009

Sponsored Links

Best Rated Answer

—

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

August 24, 2005 08:36:12

Shrikant Pande

RE: How can be determine the size of the database?

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

Is this answer useful? Yes | No

February 17, 2006 08:11:02

rajat dey

RE: How can be determine the size of the database?

select sum(bytes)/1024/1024 from v_$datafile

select sum(bytes)/1024/1024 from v_$logfile

will give u the total size of the database

Is this answer useful? Yes | No

March 10, 2006 18:29:43

samarem

Member Since: January 2006 Contribution: 5

RE: How can be determine the size of the database?

select (select sum(bytes/1024/1024/1024) from v$datafile) +( select sum(bytes/1024/1024/1024) from v$tempfile) + (select sum(bytes/1024/1024/1024) from v$log) Size of Database in GB from dual

Nitin Singhal

DBA(LGEIL)

Is this answer useful? Yes | No

June 20, 2006 04:14:13

Ravi Prakash Pichika

RE: How can be determine the size of the database?

SQL>SELECT SUM(BYTES)/1024/1024 FROM DBA_DATA_FILES;

SQL>ed

1 SELECT a+b+c DBSIZE from

2 (SELECT SUM(BYTES)/1024/1024 a FROM DBA_TEMP_FILES)

3 (SELECT SUM(BYTES)/1024/1024 b FROM V$LOG)

4 (SELECT SUM(BYTES)/1024/1024 c FROM DBA_DATA_FILES)

SQL> /

DBSIZE

450444.43

Is this answer useful? Yes | No

July 29, 2006 06:28:43

cmanne

Member Since: January 2006 Contribution: 49

RE: How can be determine the size of the database?

At oracle level query data files + tempfiles

At OS level use df -k or du -h

Is this answer useful? Yes | No

April 28, 2009 07:58:41

gvishalsoft

Member Since: November 2007 Contribution: 3

RE: How can be determine the size of the database?

select substr(to_char(sum(bytes)/1024/1024 '999 999 999.99') 1 15) "TOTALMB" substr(to_char(sum(bytes)/1024/1024/1024 '999 999.99') 1 11) "TOTALGB" from dba_data_files;

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank