| |
GeekInterview.com > Tech FAQs > Oracle > Database Administration
| Print | |
Question: 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?
|
| October 10, 2007 06:38:10 |
#2 |
| Sridhar.K |
Member Since: Visitor Total Comments: N/A |
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;
|
| |
Back To Question | |
