Estos scripts retornan el tamaño de las Bases de Datos incluyendo data, temp, controlfile, redos.
#---Tamano-en-MB-#
SELECT a.data_size_mb
, b.temp_size_mb
, c.redo_size_mb
, d.controlfile_size_mb,
a.data_size_mb
+ b.temp_size_mb
+ c.redo_size_mb
+ d.controlfile_size_mb "total_size in MB"
FROM (SELECT SUM (BYTES) / 1024 / 1024 data_size_mb
FROM dba_data_files) a,
(SELECT NVL (SUM (BYTES), 0) / 1024 / 1024 temp_size_mb
FROM dba_temp_files) b,
(SELECT SUM (BYTES) / 1024 / 1024 redo_size_mb
FROM SYS.v_$log) c,
(SELECT SUM (block_size * file_size_blks)/1024/1024 controlfile_size_mb
FROM v$controlfile) d;
DATA_SIZE_MB TEMP_SIZE_MB REDO_SIZE_MB CONTROLFILE_SIZE_MB total_size in MB
------------ ------------ ------------ ------------------- ----------------
381448 20735.9922 1500 57.75 403741.742
#---Tamano-en-GB-#
SELECT a.data_size_gb
, b.temp_size_gb
, c.redo_size_gb
, d.controlfile_size_gb,
a.data_size_gb
+ b.temp_size_gb
+ c.redo_size_gb
+ d.controlfile_size_gb "total_size in MB"
FROM (SELECT SUM (BYTES) / 1024 / 1024 /1024 data_size_gb
FROM dba_data_files) a,
(SELECT NVL (SUM (BYTES), 0) / 1024 / 1024/1024 temp_size_gb
FROM dba_temp_files) b,
(SELECT SUM (BYTES) / 1024 / 1024/1024 redo_size_gb
FROM SYS.v_$log) c,
(SELECT SUM (block_size * file_size_blks)/1024/1024/1024 controlfile_size_gb
FROM v$controlfile) d;
DATA_SIZE_GB TEMP_SIZE_GB REDO_SIZE_GB CONTROLFILE_SIZE_GB total_size in MB
------------ ------------ ------------ ------------------- ----------------
372.507813 20.2499924 1.46484375 .056396484 394.279045
