RE: DATAFILE??

Interesting...I would have thought is was the same, always.
Good to know one has options, but tuning/designing an app at this level
would be rather scary and probably ill fated.

Thanks,

Chris Marquez
Oracle DBA


-----Original Message-----
From: Kennedy, Jim [mailto:jim_kennedy@xxxxxxxxxx] 
Sent: Tuesday, October 18, 2005 12:41 PM
To: Marquez, Chris; Yavor_Ivanov@xxxxxxxx; Oracle Mailing List;
oracle.tutorials@xxxxxxxxx
Subject: 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Tuesday, October 18, 2005 7:49 AM
To: Yavor_Ivanov@xxxxxxxx; Oracle Mailing List;
oracle.tutorials@xxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yavor Ivanov
Sent: Tuesday, October 18, 2005 5:23 AM
To: Oracle Mailing List; oracle.tutorials@xxxxxxxxx
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@xxxxxxxxxxxxxxx> 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

Other related posts: