Re: tablespace reorg

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: 18 Dec 2006 21:20:29 -0800
Message-ID: <1166505628.970172.136120@80g2000cwy.googlegroups.com>

gazzag wrote:
> aman.oracle.dba wrote:
> > Hello All,
> > Please tell me how to check whether We need to do tablespace reorg or
> > not.
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:6747670113077183818::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1295801859138
According to if tablespace has pctfree 0, there is no need to fragment that.
As well as where we can see

UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUFFFFFFFFFFUUUUUUUFFFFFFUUUUUUUUUUUU

in tablespace
>
> HTH
>
> -g
Received on Mon Dec 18 2006 - 23:20:29 CST