Question on 'Group by' and 'Sum'

[steeve123]

Use this select instead:

SELECT A.TABLESPACE_NAME TABLESPACE,
ROUND(A.BYTES/1048576,1) MB_TOTAL,
ROUND(NVL(B.BYTES/1048576, 0), 1) MB_USILISE,
ROUND(((NVL(B.BYTES,0) * 100) / A.BYTES), 1) "UTILISATION(%)"
FROM (select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) A,
(select tablespace_name,
sum(bytes) bytes
from dba_extents
group by tablespace_name) B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME (+)
ORDER BY 1;


Steeve Bisson
EMail: [email protected]