Re: problems with dba_free_space and stuff

From: Daniel B. Bikle <dbikle_at_cco.caltech.edu>
Date: 4 Oct 1993 02:35:37 GMT
Message-ID: <28o25pINN9jf_at_gap.caltech.edu>

johnsona_at_ashley.cofc.edu writes:

> A select from dba_free_space returns an internal oracle error (sorry,
> can't remember it now. I can get it tho)
> My other temporary tablespace is invisible to the RDBMS. (i.e. an attempt
> to alter user temporary tablespace TMP_SPACE_2 says TMP_SPACE_2 DNE, however,
> is certainly see it with select * from dba_tablespaces)
 

>alan johnson
>(johnsona_at_ashley.cofc.edu)

alan,

I saw a similar problem way back in 1990 on 6.0.24 (I think) The problem was the rdbms went into an infinite loop when doing certain outer joins.

try out this view which has no outer join:

drop view bikle_free_space
/

create view bikle_free_space

    (TABLESPACE_NAME, FILE_ID, BLOCK_ID,      BYTES, BLOCKS)
as
select ts.name, f.file#, f.block#,

       f.length * ts.blocksize, f.length from sys.fet$ f, sys.ts$ ts
where f.ts# = ts.ts#
/

-Dan

---

Daniel B. Bikle
Independent Oracle Consultant
dbikle_at_alumni.caltech.edu
415/854-9542
P.O. BOX 'D'
MENLO PARK CA 94026

---

Received on Mon Oct 04 1993 - 03:35:37 CET