Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: monitor temporary locally managed tablespace?
ewong_at_mail.com (Ed Wong) wrote in message news:<a5ae1554.0306101518.48d0971_at_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!
Look at v$temp_space_header. The columns are bytes_free and blocks_free.
Yong Huang Received on Wed Jun 11 2003 - 23:44:39 CDT