Re: analyze command, monitor space/extents

replace max(extent) with max(bytes)
Sorry

Sybrand Bakker, Oracle DBA

Ray Stell <stellr_at_stell.cns.vt.edu> wrote in message news:88kb7k$lgr$1_at_solaris.cc.vt.edu...
> Sybrand Bakker (postbus_at_sybrandb.demon.nl) wrote:
>
>
> thanks for your help in cutting through all this.
> Remember, I'm trying to draw a roadmap in a mine field.
> (boss says, "you go be the dba, good luck, don't screw up")
>
>
> : not able to extent
> : select segment_name, next_extent
> : from dba_segments s
> : where next_extent >
> : (select max(extent)
> : from dba_free_space f
> : where f.tablespace_name = s.tablespace_name)
>
>
> This last script seems in error, there is no extent
> in dba_free_space.
>
> SQL> describe dba_free_space
> Name Null? Type
> ------------------------------- -------- ----
> TABLESPACE_NAME NOT NULL VARCHAR2(30)
> FILE_ID NOT NULL NUMBER
> BLOCK_ID NOT NULL NUMBER
> BYTES NUMBER
> BLOCKS NOT NULL NUMBER
>
>
Received on Sat Feb 19 2000 - 00:40:46 CST