new datafile immediately fragmented

-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 Received on Fri Jun 15 2007 - 15:13:28 CDT