set lines 200 pages 200
set timing on
select to_char(sum(bytes) / 1024 / 1024,'9G999G999D9') "Tamanho MB"
from ( select sum(bytes) bytes
from
dba_data_files
union all
select
sum(bytes) bytes
from
dba_temp_files
union all
select
sum(bytes * members)
from
v\$log
union all
select
sum(block_size * file_size_blks)
from
v$controlfile
);
Nenhum comentário:
Postar um comentário