RE: DATAFILE??

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: Tuesday, October 18, 2005 7:49 AM
To: Yavor_Ivanov_at_stemo.bg; Oracle Mailing List; oracle.tutorials_at_gmail.com
Subject: RE: DATAFILE??

I don't know...thought about it, never cared to investigate, never *needed* to know.
But what is Oracle algorithm for disbursing data amongst available datafiles?

I do know that in every shop I've been, if someone (more experienced DBA) accidentally adds a datafile they would just resize it to very small size...the inexperienced DBA (I've done it too) drops that datafiile leaving a hole.

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yavor Ivanov Sent: Tuesday, October 18, 2005 5:23 AM
To: Oracle Mailing List; oracle.tutorials_at_gmail.com Subject: Re: DATAFILE??

        I guess you are trying to do some load-balansinag and the 5 datafiles are on diferent storage groups? Because I cannot think of another case when datafile matters.

        So I *think* is is possible to track down the datafile by rowid, but is is quite hard work. But even if you find out where do you insert, you do not have _any_ control over this. And since it is only for looking purposes, you may use v$filestat.

	Rgds,
	Yavor
	

On Tue, 18 Oct 2005 11:42:50 +0300, computer centre <compute_at_ponyneedles.com> wrote:

> Hi TO ALL
>
> I have a doubt. Plz do reply. We have an Oracle 10g R1 db running
here.
> we have 5 datafiles of 2 gb each. Now we use Oracle Forms as front
end.
> Now as the daily transactions carry on i want to know how the data is
> stored in the database? I mean in which file out of the 5. Is it done
> randomly?
> Is there any query r method to find out in which datafile the data is
> stored.
> All the files r online. ???
>
> Plz do reply
>
> Thank You
>
> Imran Mohajir
> NIIPL.
>
>
> DISCLAIMER:
> This message and any attachment(s) contained here are information that

> is confidential, proprietary to Needle Industries (India) Private
> Limitied and its customers, privileged or otherwise protected by law.

> The information is solely intended for the individual or the entitiy
> it is addressed to. If you are not intended recipient of this
> message, you are not authorized to read, forward, print, retain, copy
> or disseminate this message or any part of it. If you have received
> this e-mail in error, please notifiy the sender immediately by return
> e-mail and delete it from your computer. Although precautions have
> been taken to ensure no viruses are present in this mail, Needle
> Industries (India) Private Limited cannot accept responsibility for
> any loss or damage arising from the use of this e-mail or attachments.
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l