Database Administration - How do you find the total database size in the database, is there any command to see the database si

GeekInterview.com > Tech FAQs > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 5 of 81

How do you find the total database size in the database, is there any command to see the database size or in os level?
2.can we unload the data by using sql*loader?
3.can we take incremental backup with out taking complete backup?

Total Answers and Comments: 3

Last Update: March 22, 2009 Asked by: IMDAD

Sponsored Links

Best Rated Answer

—

Submitted by: parthokonar1

for ques 1. The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. type the following lines at the SQL-PLUS prompt:

select sum(bytes/1048576) from   dba_extents; 
This will give the total number of Mb used by your database.



  
2. yes but more clarification is needed

 
3. No. First full backup is needed

Above answer was rated as good by the following members:
sumandba

August 27, 2007 02:48:42

parthokonar1

Member Since: October 2006 Contribution: 41

RE: How do you find the total database size in the dat...

for ques 1. The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. type the following lines at the SQL-PLUS prompt:

select sum(bytes/1048576) from dba_extents; 
This will give the total number of Mb used by your database.



 
2. yes but more clarification is needed

 
3. No. First full backup is needed

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 15, 2007 06:38:10

Sridhar.K

RE: How do you find the total database size in the dat...

COLUMN "Total Mb" FORMAT 999 999 999.0
COLUMN "Redo Mb" FORMAT 999 999 999.0
COLUMN "Temp Mb" FORMAT 999 999 999.0
COLUMN "Data Mb" FORMAT 999 999 999.0

Prompt
Prompt "Database Size"

select (select sum(bytes/1048576) from dba_data_files) "Data Mb"
(select NVL(sum(bytes/1048576) 0) from dba_temp_files) "Temp Mb"
(select sum(bytes/1048576)*max(members) from v$log) "Redo Mb"
(select sum(bytes/1048576) from dba_data_files) +
(select NVL(sum(bytes/1048576) 0) from dba_temp_files) +
(select sum(bytes/1048576)*max(members) from v$log) "Total Mb"
from dual;

Is this answer useful? Yes | No

March 22, 2009 12:37:32

sumer77

Member Since: October 2008 Contribution: 4

RE: How do you find the total database size in the database, is there any command to see the database size or in os level?2.can we unload the data by using sql*loader?3.can we take incremental backup with out taking complete backup?

Sum of bytes from dba_extents will provide the database size.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank