Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!cycny01.gnilink.net!cyclone1.gnilink.net!spamkiller2.gnilink.net!nwrdny03.gnilink.net.POSTED!53ab2750!not-for-mail
From: "joe bayer" <joebayerii(no-spam)@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: help: How could I find the free space info for temporary tablespace, tempfile
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <E%XYa.576$Z37.222@nwrdny03.gnilink.net>
Date: Sat, 09 Aug 2003 01:20:36 GMT
NNTP-Posting-Host: 141.158.229.77
X-Complaints-To: abuse@verizon.net
X-Trace: nwrdny03.gnilink.net 1060392036 141.158.229.77 (Fri, 08 Aug 2003 21:20:36 EDT)
NNTP-Posting-Date: Fri, 08 Aug 2003 21:20:36 EDT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240155

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.