Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] wait time on stat

RE: [Q] wait time on stat

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 28 Jan 2004 22:44:26 -0800
Message-ID: <F001.005DE4D2.20040128224426@fatcity.com> 





"Defaulty Windows installation..." Hehehe....;-)




-----Original Message-----

From:	Mladen Gogala [mailto:mgogala_at_adelphia.net]
Sent:	Wed 1/28/2004 8:54 PM
To:	Multiple recipients of list ORACLE-L
Cc:	
Subject:	Re: [Q] wait time on stat




Defaulty Windows installation usually creates log files of 20M. The  
person who posted the problem explicitely mentioned Windows platform.
Size of 20M is so small that the database will start to checkpoint
like crazy when you start using it for real. The number that I gave
is my rule of thumb. It's not to big to frighten the boss (alltogether
just a gig or two) and it's big enough to solve checkpointing problem.
This rule of thumb  number is derived from experience. Yes, of course,
I am guessing. There is not enough information to investigate the
problem. I believe that he was asking us to guess. I did.



On 01/28/2004 08:14:25 PM, Jared Still wrote:


> How did you determine the size of the logs?

> 

> Or are you just guessing that they are significantly

> less than 250m?

> 

> Could just be a very busy database that needs redo

> and controlfile on faster disk.

> 

> Jared

> 

> On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:

> > Increase redo logs to 250M each. You're checkpointing.

> >

> >

> > On 01/28/2004 03:09:26 PM, dba1 mcc wrote:

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

> > >

> >

> > --

> > Mladen Gogala

> > Oracle DBA

> > --

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

> 

> --

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

> --

> Author: Jared Still

>   INET: jkstill_at_cybcon.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).

>


-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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: Bobak, Mark
  INET: Mark.Bobak_at_il.proquest.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 Thu Jan 29 2004 - 00:44:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US