Re: dba_free_space missing a tablespace???

Good points, but the tbs could be a temporary type tablespace temporary tablespace don't show up in

    v$datafile
    dba_data_files
    dba_free_space
but do show up in

    dba_tablespaces
    v$tempfile
    dba_temp_files

I haven't played with the temporary files that much. Finding free space in them doesn't seem totally straight forward. Currently I'm using the v$sort_segment, but would be currious as to what other people use to monitor the space in the temporary files.

Best
Kyle

In article <94pr6e$rlv$1_at_nnrp1.deja.com>,   yong321_at_yahoo.com wrote:
> It simply means you don't have free space in that tablespace.
>
> It's not true that read only tablespaces or locally managed
 tablespaces
> will not show in dba_free_space.
>
> Yong Huang
> yong321_at_yahoo.com
>
> In article <94n56a$g95$1_at_nnrp1.deja.com>,
> Ed Stevens <ed.stevens_at_home.com> wrote:
> > Here's an odd one. I SELECT DISTINCT TABLSPACE_NAME from 3
 different
> > views: dba_tablespaces, dba_data_files, and dba_free_space. I
 should
> > get the same results, but look at the following, and you'll see that
> > dba_free_space returned one less tablespace name . . . .
> >
> > SQL> select tablespace_name
> > 2 from dba_tablespaces
> > 3 order by tablespace_name;
> >
> > TABLESPACE_NAME
> > ------------------------------
> > APHDTATS
> > APHIDXTS
> > APHRB1TS
> > APHRB2TS
> > APHTMPTS
> > SYSTEM
> >
> > 6 rows selected.
> >
> > SQL> select distinct tablespace_name
> > 2 from dba_data_files
> > 3 order by tablespace_name;
> >
> > TABLESPACE_NAME
> > ------------------------------
> > APHDTATS
> > APHIDXTS
> > APHRB1TS
> > APHRB2TS
> > APHTMPTS
> > SYSTEM
> >
> > 6 rows selected.
> >
> > SQL> select distinct tablespace_name
> > 2 from dba_free_space
> > 3 order by tablespace_name;
> >
> > TABLESPACE_NAME
> > ------------------------------
> > APHDTATS
> > APHIDXTS
> > APHRB2TS
> > APHTMPTS
> > SYSTEM
> >
> > 5 rows selected.
> >
> > SQL> spool off
> >
> > --
> > - Ed Stevens
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 13:05:24 CST