From: EnderW <ender29@my-deja.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Extent Allocation among Multiple Datafiles ?
Date: Sun, 10 Sep 2000 03:23:22 GMT
Organization: Deja.com - Before you buy.
Lines: 43
Message-ID: <8peuqs$7pc$1@nnrp1.deja.com>
References: <8p7207$9rf$1@nnrp1.deja.com> <39B98379.D0FA697D@navisent.com>
NNTP-Posting-Host: 24.128.210.239
X-Article-Creation-Date: Sun Sep 10 03:23:22 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98; MSNIA)
X-Http-Proxy: 1.1 x61.deja.com:80 (Squid/1.1.22) for client 24.128.210.239
X-MyDeja-Info: XMYDJUIDender29


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@navisent.com>,
  William Dangren <wdangren@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.