Re: Extent Allocation among Multiple Datafiles ?

I might be wrong but I have tried a scenario where I have a single tablespace composed of two different datafiles ( inital and next set to 4K, pctincrease set to 50) It seems to me it grabbed the extents in a round-robin way when I checked the dba_extents. I have tried on a Windows machine so it might not be true when it comes other OS. I am not really certain. Thanks

In article <39B98379.D0FA697D_at_navisent.com>,   William Dangren <wdangren_at_navisent.com> wrote:
> Oracle does NOT strip extents. It uses the free list to find the
 first
> available blocks. Your extents will be made up of several free
 blocks,
> depending on your block size and the size of the extent. You can
 create
> datafiles that are purposely smaller then the table to manually strip
 it
> (Create a special tablespace for the table). Or use a RAID device to
> automatically strip it. And you definitely should spread your
 datafile
> on different devices. Once your system is up and running use
 utlbstate
> and utlestat to see which data files are hit the most. Then you can
> move the highest hit files onto separate drives. If you need more
> detail please email me. Hope this helps.
>
> Bill
>
> --
> William Dangren
> Navis Enterprises
> 407.348.6401
> 800.219.0207
>
>

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.