Re: new datafile immediately fragmented

Hi

You are probably using Locally Managed Tablespace with Uniform Size Extents (which happens to be 28MB?).

Thanks

--
LSC


On 6/15/07, Doug Gernaat <dag_at_its.msstate.edu> wrote:


>

> -db is 10.2.0.2...

>

> - got a segment wanting to extend... needs 50M

> - biggest extent in dba_free_space is 28M

> - i add a 250M datafile to ts

> - biggest extent in dba_free_space is still 28M

> - select bytes from dba_free_space for newly created datafile

>        BYTES

> ----------

>   29360128

>   29360128

>   29360128

>   29360128

>   29360128

>   29360128

>   29360128

>   29360128

>   27197440

>

> 9 rows selected.

>

> - there is my 250M fragmented

> - any ideas why i can't get my one 250M extent?

> - have tried this in multiple tablespaces with same result

> - creating a new ts looks fine... one extent sized properly in

> dba_free_space

> - dbms_space_admin was used to migrate all dict managed ts to local when

>   moving from 9i to 10g a while back(didn't do ts reorgs)

>

> thanks

> -doug-

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>


--
http://www.freelists.org/webpage/oracle-l