parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Aug 27th, 2007

 

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

Sridhar.K

• Oct 15th, 2007

 

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;

sumer77

 Profile Answers by sumer77 

• Mar 22nd, 2009

 

Sum of bytes from dba_extents will provide the database size.