Sql para Monitorar suas Tablespaces

Vai a Dica :

Select d.tablespace_name as Tablespace , sum(d.bytes) as total , sum(f.bytes) as livre

from dba_data_files d

left join dba_free_space f

on d.tablespace_name = f.Tablespace_name

group by d.tablespace_name

Descubra o Tamanho de suas Tabelas

SELECT t.table_name AS "Table Name",
t.num_rows AS "Rows",
t.avg_row_len AS "Avg Row Len",
Trunc((t.blocks * p.value)/1024) AS "Size KB",
t.last_analyzed AS "Last Analyzed"
FROM dba_tables t,
v$parameter p
WHERE t.owner = :powner
AND p.name = 'db_block_size'

ORDER by t.table_name;