Re: monitor temporary locally managed tablespace?

Ed Wong wrote:
>
> 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.

dba_temp_files
v$tempfile
v$sort_segment

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"