Re: analyze command, monitor space/extents

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