Re: new datafile immediately fragmented

  • From: "LS Cheng" <exriscer@xxxxxxxxx>
  • To: dag@xxxxxxxxxxxxxxx
  • Date: Sun, 17 Jun 2007 10:02:45 +0200

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@xxxxxxxxxxxxxxx> 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-

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



Other related posts: