From oracle-l-bounce@freelists.org Thu Oct 20 09:29:38 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9KETAQQ022260 for ; Thu, 20 Oct 2005 09:29:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9KESmvX022145 for ; Thu, 20 Oct 2005 09:28:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C10E208B67; Thu, 20 Oct 2005 09:28:32 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05856-08; Thu, 20 Oct 2005 09:28:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8EA982089E8; Thu, 20 Oct 2005 09:28:31 -0500 (EST) x-mimeole: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D582.3A821BB5" Subject: RE: DATAFILE?? Date: Thu, 20 Oct 2005 07:23:52 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DATAFILE?? Thread-Index: AcXVYTRFwJN/rULaRg6CK11f2K9r5QAILE/v From: "Kennedy, Jim" To: "Niall Litchfield" Cc: , , "Oracle Mailing List" , X-OriginalArrivalTime: 20 Oct 2005 14:26:15.0802 (UTC) FILETIME=[3ABF7DA0:01C5D582] X-archive-position: 27243 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jim_kennedy@mentor.com Precedence: normal Reply-To: jim_kennedy@mentor.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------_=_NextPart_001_01C5D582.3A821BB5 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Interesting that they changed it. Looks like they changed it from 9i. = Good to know. Probably better they did. Jim -----Original Message----- From: Niall Litchfield [mailto:niall.litchfield@gmail.com] Sent: Thu 10/20/2005 3:29 AM To: Kennedy, Jim Cc: cmarquez@collegeboard.org; Yavor_Ivanov@stemo.bg; Oracle Mailing = List; oracle.tutorials@gmail.com Subject: Re: DATAFILE?? =20 On 10/18/05, oracle-l-bounce@freelists.org = wrote: > > The best way to find out is to try it. You will probably find that it > depends. If you use a LMT and do uniform extents then it will do it by > concatenation. (fill up the first file then move on to the 2nd etc.). > If you create an LMT and do automatic extents then it is different. It > does it by striping. The first extent goes in the first file, the 2nd > in the 2nd file... > > You can see this by setting up a small test. > Jim Unfortunately, if you run the test you'll find that your assertion = isn't correct on 10gR1 :) 1 create tablespace demo 2 datafile 'c:\temp\demo01.dbf' size 10m,'c:\temp\demo02.dbf' size 10m 3* extent management local uniform size 128k USER @ orcl>/ Tablespace created. USER @ orcl>create table t1(c1 number); create table t1(c1 number) * ERROR at line 1: ORA-00955: name is already used by an existing object USER @ orcl>create table demo(c1 number); Table created. USER @ orcl>drop table demo; Table dropped. USER @ orcl>create table demo(c1 number) 2 tablespace demo; Table created. USER @ orcl>alter table demo allocate extent; Table altered. USER @ orcl>alter table demo allocate extent; Table altered. USER @ orcl>alter table demo allocate extent; Table altered. USER @ orcl>alter table demo allocate extent; Table altered. USER @ orcl>alter table demo allocate extent; Table altered. USER@ orcl>alter table demo allocate extent; Table altered. USER @ orcl>select file_id,count(*) 2 from dba_extents 3 where segment_name=3D'DEMO' 4 group by file_id; FILE_ID COUNT(*) ---------- ---------- 9 4 10 3 2 rows selected. -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ------_=_NextPart_001_01C5D582.3A821BB5 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: DATAFILE??

Interesting that they changed it.  Looks like = they changed it from 9i.  Good to know.  Probably better they = did.
Jim


-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield@gmail.= com]
Sent: Thu 10/20/2005 3:29 AM
To: Kennedy, Jim
Cc: cmarquez@collegeboard.org; Yavor_Ivanov@stemo.bg; Oracle Mailing = List; oracle.tutorials@gmail.com
Subject: Re: DATAFILE??

On 10/18/05, oracle-l-bounce@freelists.org = <oracle-l-bounce@freelists.org>
wrote:
>
> The best way to find out is to try it. You will probably find that = it
> depends. If you use a LMT and do uniform extents then it will do it = by
> concatenation. (fill up the first file then move on to the 2nd = etc.).
> If you create an LMT and do automatic extents then it is different. = It
> does it by striping. The first extent goes in the first file, the = 2nd
> in the 2nd file...
>
> You can see this by setting up a small test.
> Jim

 Unfortunately, if you run the test you'll find that your assertion = isn't
correct on 10gR1 :)


1 create tablespace demo
2 datafile 'c:\temp\demo01.dbf' size 10m,'c:\temp\demo02.dbf' size = 10m
3* extent management local uniform size 128k
USER @ orcl>/

Tablespace created.

USER @ orcl>create table t1(c1 number);
create table t1(c1 number)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


USER @ orcl>create table demo(c1 number);

Table created.

USER @ orcl>drop table demo;

Table dropped.

USER @ orcl>create table demo(c1 number)
2 tablespace demo;

Table created.

USER @ orcl>alter table demo allocate extent;

Table altered.

USER @ orcl>alter table demo allocate extent;

Table altered.

USER @ orcl>alter table demo allocate extent;

Table altered.

USER @ orcl>alter table demo allocate extent;

Table altered.

USER @ orcl>alter table demo allocate extent;

Table altered.

USER@ orcl>alter table demo allocate extent;

Table altered.

USER @ orcl>select file_id,count(*)
2 from dba_extents
3 where segment_name=3D'DEMO'
4 group by file_id;

FILE_ID COUNT(*)
---------- ----------
9 4
10 3

2 rows selected.

   --
Niall Litchfield
Oracle DBA
http://www.niall.litc= hfield.dial.pipex.com

------_=_NextPart_001_01C5D582.3A821BB5-- -- http://www.freelists.org/webpage/oracle-l