monitor temporary locally managed tablespace?

From: Ed Wong <ewong_at_mail.com>
Date: 10 Jun 2003 16:18:37 -0700
Message-ID: <a5ae1554.0306101518.48d0971@posting.google.com>

I used to have a script to join a few dba_ views to monitor the size of all tablespaces. Since I switch my temp tablespace to temporary locally managed tablespace using tempfile(instead of datafile) my script does not show temp tablespace anymore. It looks to me dba_free_space doesn't contain temporary lm tablespace. Anyone experience this? Is there any other view I can query? Thanks!

The following shows that temp tablespace is missing in dba_free_space. And yes, I am sure there is free space in the temp tablespace at this moment.

SQL> select tablespace_name, extent_management from dba_tablespaces 2 order by tablespace_name;

TABLESPACE_NAME                EXTENT_MAN


------------------------------ ----------

DRSYS                          LOCAL
RBS                            LOCAL
SYSTEM                         DICTIONARY
TEMP                           LOCAL
PA_DATA                        LOCAL
PA_INDEX                       LOCAL

6 rows selected.

SQL> select distinct tablespace_name from dba_free_space 2 order by tablespace_name;

TABLESPACE_NAME

DRSYS
RBS
SYSTEM
PA_DATA
PA_INDEX 5 rows selected. Received on Tue Jun 10 2003 - 18:18:37 CDT