Useful queries on site

Useful quries

SELECT * FROM ( 
SELECT 
OWNER, SEGMENT_NAME, BYTES/1024/1024 SIZE_MB 
FROM 
DBA_SEGMENTS 
WHERE 
SEGMENT_TYPE = 'TABLE' 
AND tablespace_name = 'HIST_DATA' 

ORDER BY 
BYTES/1024/1024 DESC ) WHERE ROWNUM <= 10;


select df.tablespace_name "Tablespace", 
totalusedspace "Used MB", 
(df.totalspace - tu.totalusedspace) "Free MB", 
df.totalspace "Total MB", 
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) 
"Pct. Free" 
from 
(select tablespace_name, 
round(sum(bytes) / 1048576) TotalSpace 
from dba_data_files 
group by tablespace_name) df, 
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name 
from dba_segments 
group by tablespace_name) tu 
where df.tablespace_name = tu.tablespace_name ;