O Script abaixo é utilizado para verificar o tamanho da base de dados:
SELECT 'Database Tamanho' "*****"
,ROUND(SUM(ROUND(SUM(NVL(fs.bytes/1024/1024,0)))) /
SUM(ROUND(SUM(NVL(fs.bytes/1024/1024,0))) + ROUND(df.bytes/1024/
1024 - SUM(NVL(fs.bytes/1024/1024,0)))) * 100, 0) "%Livre"
,ROUND(SUM(ROUND(df.bytes/1024/1024 - SUM(NVL(fs.bytes/1024/
1024,0)))) / SUM(ROUND(SUM(NVL(fs.bytes/1024/1024,0))) +
ROUND(df.bytes/1024/1024 - SUM(NVL(fs.bytes/1024/1024,0)))) * 100,
0) "%Usado"
,SUM(ROUND(SUM(NVL(fs.bytes/1024/1024,0)))) "Mb Livre"
,SUM(ROUND(df.bytes/1024/1024
- SUM(NVL(fs.bytes/1024/1024,0)))) "Mb Usado"
,SUM(ROUND(SUM(NVL(fs.bytes/1024/1024,0))) + ROUND(df.bytes/1024/
1024
- SUM(NVL(fs.bytes/1024/1024,0)))) "Tamanho"
FROM dba_free_space fs, dba_data_files df
WHERE fs.file_id(+) = df.file_id
GROUP BY df.tablespace_name, df.file_id, df.bytes,
df.autoextensible
ORDER BY df.file_id;
***** %Livre %Usado Mb Free Mb Usado Size
------------- ---------- ---------- ---------- ---------- ---------- ----------
Database Size 17 83 49005 242745 291750
