On Thu, 25 Apr 2002 14:51:12 -0600, Sean M
<smckeownNO_at_BACKSIESearthlink.net> wrote:
>Let me try that again and hope for better formatting:
>
>EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
>-------------------------------------------------- ----------- -------------- ----------- ------------ -----------------
>control file sequential read 22704 0 2356 0 23557437
>control file parallel write 101061 0 37047 0 370471566
>local write wait 5269 0 1394 0 13938999
>log file sequential read 16 0 22 1 218414
>log file single write 22 0 21 1 205190
>log file parallel write 862589 0 134140 0 1341399844
>db file sequential read 492311 0 132453 0 1324526941
>db file scattered read 2532523 0 737136 0 7371357522
>db file parallel write 57412 57412 42 0 417414
>db file parallel read 9 0 19 2 189860
>direct path read 419927 0 567 0 5665134
>direct path write 62802 0 57 0 565830
>
>12 rows selected.
>
>SQL> SQL> 2 3
>MIN(AVGIOTIM) MIN(MAXIORTM) MIN(MAXIOWTM) MAX(AVGIOTIM) MAX(MAXIORTM) MAX(MAXIOWTM)
>------------- ------------- ------------- ------------- ------------- -------------
> -2.142E+09 0 0 2143170914 840044890 840046432
Thanks. I will say that your 'db file sequential read' averages about
1/10 of what I had seen before. One thing I forgot to ask was, what
is you db_file_multiblock_read_count (kind of important for
interpreting the scattered read result)?
Received on Fri Apr 26 2002 - 12:22:16 CDT
