| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: error in the output
select 'data',trunc(sum(bytes)/(1024*1024)) mb
from dba_data_files
union all
select 'temp',trunc(sum(bytes)/(1024*1024)) mb
from dba_temp_files
union all
select 'redo',trunc(sum(bytes*members)/(1024*1024)) mb
from v$log
/
that's for 10.1. I don't have access to any 8.1.7 databases.
-bdbafh Received on Fri Apr 28 2006 - 11:36:31 CDT
 |
 |