Hi Norman,

>       (SELECT VALUE
>         FROM v$parameter
>       WHERE NAME = 'db_block_size') * SUM (a.blocks) / 1024
> used_mb

if I'm not completely wrong this should by used_Kb (not used_mb)
alternatively ...
WHERE NAME = 'db_block_size') * SUM (a.blocks) / (1024 * 1024) used_mb

Regards,
Jaromir




--
http://www.freelists.org/webpage/oracle-l