Re: Extent Allocation among Multiple Datafiles ?

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