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

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. Received on Fri Aug 08 2003 - 20:20:36 CDT