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

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 11 Aug 2003 13:54:41 GMT
Message-ID: <BeNZa.28557$bo1.8715@news-server.bigpond.net.au>

"joe bayer" <joebayerii(no-spam)@hotmail.com> wrote in message news:E%XYa.576$Z37.222_at_nwrdny03.gnilink.net...
> 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?
>

Hi Joe,

Take a look at V$TEMP_SPACE_HEADER, I think it's what you're after. Some of the other V$TEMP _* views might be of interest too.

Cheers

Richard Received on Mon Aug 11 2003 - 08:54:41 CDT