Re: [Q] wait time on stat

Do you have any LOBs defined with
the nocache nologging attribute ?

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person   who can answer the questions, but the   person who can question the answers -- T. Schick Jr

Next public appearances:
 Jan 29th 2004 UKOUG Unix SIG - v$ and x$  March 2004 Hotsos Symposium - The Burden of Proof  March 2004 Charlotte NC OUG - CBO Tutorial  April 2004 Iceland

One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html ____UK___February
____UK___June

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 28, 2004 8:09 PM

> WE have ORACLE 9.2.0.3 database run under Win2000. I
> run "statspack" and found "Top 5 timed event". Look
> like "control file parallel write " and "redo file
> parallel write " take lots time. How to fix?
>
>
>
>
>
> Top 5 Timed Events
> ~~~~~~~~~~~~~~~~~~
> % Total
> Event
> Waits Time (s) Ela Time
> --------------------------------------------
> ------------ ----------- --------
> control file parallel write
> 5,499 1,141 90.37
> CPU time
> 97 7.70
> log file parallel write
> 1,305 12 .95
> db file parallel write
> 162 6 .44
> log file switch completion
> 10 2 .16
>
> -------------------------------------------------------------
> Wait Events for DB: 9IDEV Instance: 9idev Snaps: 5
> -6
> -> s - second
> -> cs - centisecond - 100th of a second
> -> ms - millisecond - 1000th of a second
> -> us - microsecond - 1000000th of a second
> -> ordered by wait time desc, waits desc (idle events
> last)
>
>
> Avg
>
> Total Wait wait Waits
> Event Waits Timeouts
> Time (s) (ms) /txn
> ---------------------------- ------------ ----------
> ---------- ------ --------
> control file parallel write 5,499 0
> 1,141 207 211.5
> log file parallel write 1,305 1,299
> 12 9 50.2
> db file parallel write 162 0
> 6 34 6.2
> log file switch completion 10 0
> 2 204 0.4
> control file sequential read 3,827 0
> 2 0 147.2
> db file sequential read 176 0
> 1 7 6.8
> direct path write 92 0
> 1 6 3.5
> log file sync 14 0
> 0 33 0.5
> log file single write 20 0
> 0 13 0.8
> log file sequential read 35 0
> 0 6 1.3
> direct path read 92 0
> 0 2 3.5
> SQL*Net break/reset to clien 44 0
> 0 0 1.7
> SQL*Net more data to client 7 0
> 0 0 0.3
> async disk IO 4 0
> 0 0 0.2
> virtual circuit status 6,826 496
> 19,650 2879 262.5
> wakeup time manager 530 530
> 19,179 36187 20.4
> SQL*Net message from client 6,457 0
> 12,084 1871 248.3
> jobq slave wait 402 381
> 1,227 3051 15.5
> SQL*Net message to client 6,458 0
> 0 0 248.4
>
> -------------------------------------------------------------
> Background Wait Events for DB: 9IDEV Instance: 9idev
> Snaps: 5 -6
> -> ordered by wait time desc, waits desc (idle events last)
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
> http://webhosting.yahoo.com/ps/sb/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: dba1 mcc
> INET: mccdba1_at_yahoo.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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).