Re: TEMP tablespace not Freeing the space

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