From oracle-l-bounce@freelists.org Tue Oct 18 20:30:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9J1U5XN017433 for ; Tue, 18 Oct 2005 20:30:06 -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 j9J1U0vX017416 for ; Tue, 18 Oct 2005 20:30:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F45820803B; Tue, 18 Oct 2005 20:29:55 -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 12548-06; Tue, 18 Oct 2005 20:29:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D9F06207FC7; Tue, 18 Oct 2005 20:29:54 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=LvdO6Ez0n3+DK0vpld06Zo1n4RwcEoFa6ZG2HC8t7WzIrxyraOmTCxD1Kb977Fk9FlEgs7wTe5BdGkLZPxYCtLN/C+QZxYp7WxR4RxU7kqOME0DafEzaMk4LD3fz3WWFO71+JU3YxY143o+mIWJlw5QGcGeFrn/HHaU+l9+PFBw= Message-ID: <392977e50510181827l68e78099k174c99b9a33dedd4@mail.gmail.com> Date: Wed, 19 Oct 2005 11:27:39 +1000 From: To: MGogala@allegientsystems.com Subject: Re: DATAFILE?? Cc: "Marquez, Chris" , Oracle Mailing List In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25622_5664610.1129685259763" References: X-archive-position: 27162 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjsearle@gmail.com Precedence: normal Reply-To: rjsearle@gmail.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.5 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,NO_REAL_NAME autolearn=no version=2.63 ------=_Part_25622_5664610.1129685259763 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I concur with the references to the fine manuals. But for what it's worth, in 8.1.7 on Solaris, I have noticed that when rebuilding large tables in DM= T (to implement archiving without partitioning [another story]) Oracle is allocating extents in a circular fashion. By that I mean that extent 1 is i= n file 1, extent 2 in file 2, extent 3 in file 3, extent 4 in file 1, extent = 5 in file 2, you get the picture. Extents are allocated slowly over time which suggests to me that an extent is allocated only after the previous extent is full. Makes sense really, given the next extent parameter on CREATE TABLESPACE. Doesn't Oracle then allocate blocks within those extents sequentially? I've never really cared enough to investigate so I have no hard information here except TFM. These are my observations only. It's been a while since I studied the concepts manual so I can't recall exectly what it says on this topic. But I can recall my experiences from testing. So I strongly recommend researching (Oracle, google, forum archives) followed by controlled testing to verify! I consider myself to be very green at oracle admin but I am always suprise= d to see such questions, and when I do I watch closely for the entertaining responses. Mladen never dissappoints, thankyou Mladen! And to others that don't like the RTFM message, remember the old addage, "If you ask a silly question, expect a silly answer!" Yes I know this forum is here to help but often the best advice really is to recommend that the readily available manuals first be consulted. Otherwise this will become th= e place people will turn to for silly questions like "URGENT: CREATE TABLE SPACE or CREATE TABLESPACE" Russell On 10/19/05, Gogala, Mladen wrote: > > WE get it? Who is "we"? The rule says that there are no stupid question. > This is an exception. > > I am glad to help you clarify things. We are glad that you get it. > > -- > > Mladen Gogala > > Ext. 121 > ------------------------------ > > *From:* Marquez, Chris [mailto:cmarquez@collegeboard.org] > *Sent:* Tuesday, October 18, 2005 12:27 PM > *To:* Gogala, Mladen; Oracle Mailing List > *Subject:* RE: DATAFILE?? > > Right, we get it...you can't believe the stupidity of this question. > > ------=_Part_25622_5664610.1129685259763 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
I concur with the references to the fine manuals.  But for what i= t's worth, in 8.1.7 on Solaris, I have noticed that when rebuilding large t= ables in DMT (to implement archiving without partitioning [another story]) = Oracle is allocating extents in a circular fashion.  By that I mean th= at extent 1 is in file 1, extent 2 in file 2, extent 3 in file 3, extent 4 = in file 1, extent 5 in file 2,  you get the picture. =20
 
Extents are allocated slowly over time which suggests to me that an ex= tent is allocated only after the previous extent is full.  Makes sense= really, given the next extent parameter on CREATE TABLESPACE.  Doesn'= t Oracle then allocate blocks within those extents sequentially?  I've= never really cared enough to investigate so I have no hard information her= e except TFM.
 
These are my observations only.  It's been a while since I studie= d the concepts manual so I can't recall exectly what it says on this topic.=   But I can recall my experiences from testing.  
 
So I strongly recommend researching (Oracle, google, forum archiv= es) followed by controlled testing to verify!
 
I consider myself to be very green at oracle admin but I am always sup= rised to see such questions, and when I do I watch closely for the entertai= ning responses.  Mladen never dissappoints, thankyou Mladen!
 
And to others that don't like the RTFM message, remember the old addag= e, "If you ask a silly question, expect a silly answer!"  Ye= s I know this forum is here to help but often the best advice really is to = recommend that the readily available manuals first be consulted.  Othe= rwise this will become the place people will turn to for silly questions li= ke  "URGENT: CREATE TABLE SPACE or CREATE TABLESPACE"

 
Russell
 
 
On 10/19/05, Gogala, Mladen <MGo= gala@allegientsystems.com> wrote:

WE get it? Who is "we"?&n= bsp; The rule says that there are no stupid question. This is an exception.=

I am glad to help you clarify thing= s. We are glad that you get it.

 

--

Mladen Gogala

Ext. 121


From: Marq= uez, Chris [mailto: cmarquez@collegeboard.org]=
Sent: Tuesday, October 18, 2005 12:27 PM
To: Gogala, Mladen; Ora= cle Mailing List
Subject: RE: DATAFILE??

Right, we get it...you can't believe the stupidity of this ques= tion.