Jon,
well your script also gives me the same busy file. and I am showing the physical reads
also, see my script below. I can see from my script, the same busy data file as I see
from yours, it is just that I have to compare the 2 figures, that is f.phyrds,
f.phywrts. From my script I get :-
/u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/users01.dbf 995671 14940
/u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/system01.dbf 116510 271329
which shows the order of busy from least to the max. and the difference between the 2
f.phyrds, f.phywrts, shows me.
>From your script I get:-
/u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/users01.dbf
1002657 71.61
/u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/system01.dbf
387046 27.64
So I think I am okay then???
rgds,
raja
--
On Tue, 24 Jul 2001 18:20:43
Jon Walthour wrote:
>Raja:
>
>Your query is on the right track, but it only accounts for the physical
>writes, not the physical reads. Try the attached script.
>
>Jon Walthour
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Tuesday, July 24, 2001 9:50 PM
>
>
>> Hello all,
>>
>> If I want to know which data files are the busiest, can I assume that from
>the following query:-
>>
>> SELECT SUBSTR(name, 1, 128), f.phyrds, f.phywrts
>> FROM v$datafile d, v$filestat f
>> WHERE f.file# = d.file#
>> ORDER BY phywrts
>>
>> If there is vast difference between the physical reads and physical
>writes, then that particular data file would be the busiest? Is this true?
>>
>> rgds,
>>
>> raja
>>
>>
>> Get 250 color business cards for FREE!
>> http://businesscards.lycos.com/vp/fastpath/
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Viraj Luthra
>> INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).