Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: monitor temporary locally managed tablespace?

Re: monitor temporary locally managed tablespace?

From: Yong Huang <yong321_at_yahoo.com>
Date: 11 Jun 2003 21:44:39 -0700
Message-ID: <b3cb12d6.0306112044.3b4f6f08@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US