Re: help: How could I find the free space info for temporary tablespace, tempfile

On Sat, 09 Aug 2003 01:20:36 GMT, joe bayer <@hotmail.com> wrote:

> We are using oracle 9.2 on linux
>
> We used to use dba_data_files/dba_free_space to calculate how much
> percentage a tablespace is free.
>
> But now we have temporary tablespace using tempfile, I found
> dba_temp_files, but there is no dba_temp_free_space.
>
> Could someone tell me how do you calculate how much of a temporary
> tablespace is free?
>
> Thanks for your help.
>

Well, hopefully none of it is. Otherwise you've oversized the tablespace.

Point is, temporary tablespaces use up all the space (in the sense of allocating extents or, as they're more properly known, temporary segments). Those segments then merely get re-used by subsequent sorts. But the space itself is never freed, because the segments are never de-allocated (until shutdown, anyway).

Hence the lack of a temp_free_space view: there won't be any.

~QM Received on Fri Aug 08 2003 - 20:27:17 CDT