Re: TEMP tablespace not Freeing the space
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 23 Jun 2006 16:16:38 +0200 (CEST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
