Re: data files the busiest

From: Viraj Luthra <viraj999_at_lycos.com>
Date: Tue, 24 Jul 2001 19:23:49 -0700
Message-ID: <F001.003540A8.20010724192541@fatcity.com>

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" <ORACLE-L_at_fatcity.com>

>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: viraj999_at_lycos.com

>>

>> 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: ListGuru_at_fatcity.com (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: viraj999_at_lycos.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Jul 24 2001 - 21:23:49 CDT