V7.3.4.5

From: <Charlie_Mengler_at_homedepot.com>
Date: Tue, 25 Feb 2003 14:54:16 -0800
Message-ID: <F001.005594B1.20030225145416@fatcity.com>

bcm_at_MWH.ARES.MWH.COM> /

     FILE# PHYRDS PHYWRTS PHYBLKRD PHYBLKWRT READTIM WRITETIM
---------- ---------- ---------- ---------- ---------- ----------

---

         7 3340334 30904 4567713 30904 362219 1476572

        11 1157340 3912 1270225 3912 151551 122910

        13 2585912 42702 6384251 42702 242112 636283

        20 2451068 5251 2509170 5251 336419 218841

        27 868670 37995 868673 37995 432869 14026129

        32 3596539 97971 3814695 97971 537299 4645681

        35 160846 60689 160846 60689 106501 2257092

        36 397062 33123 397062 33123 110214 947353

        40 2092537 5314 2104019 5314 163361 479852

        42 787569 13478 787570 13478 204421 190629

        55 1991149 39483 4483007 39483 235299 1377869

        58 1720827 103234 1720834 103234 423799 1884931

        59 1809887 11165 2610392 11165 413163 172370

        61 373649 17329 373649 17329 107455 373292

        84 798905 26702 798908 26702 166670 550920

FWIW - File 27 hold less than a half dozen LARGE (128M or greater) indexes.

As can be seen many more READS than WRITES are happening. So why is the time spent doing WRITES is so much larger in many cases than time spent doing reads?

What, if anything, can be done to reduce the WRITE time? For the most part the disk volumes under these files are configured using RAID-1.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Charlie_Mengler_at_HomeDepot.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Feb 25 2003 - 16:54:16 CST