[EMAIL PROTECTED]> /
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: [EMAIL PROTECTED]
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: [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).
