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 DMT
(to implement archiving without partitioning [another story]) Oracle is
allocating extents in a circular fashion. By that I mean that 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.
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 suprised
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 the
place people will turn to for silly questions like "URGENT: CREATE TABLE
SPACE or CREATE TABLESPACE"
Russell
On 10/19/05, Gogala, Mladen <MGogala_at_allegientsystems.com> 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_at_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.
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2005 - 20:30:06 CDT
