• From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
  • To: <Yavor_Ivanov@xxxxxxxx>, "Oracle Mailing List" <ORACLE-L@xxxxxxxxxxxxx>, <oracle.tutorials@xxxxxxxxx>
  • Date: Tue, 18 Oct 2005 10:49:25 -0400

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

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.


On Tue, 18 Oct 2005 11:42:50 +0300, computer centre
<compute@xxxxxxxxxxxxxxx> wrote:

> I have a doubt. Plz do reply. We have an Oracle 10g R1 db running
> we have 5 datafiles of 2 gb each. Now we use Oracle Forms as front
> 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
> 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.
> --


Other related posts: