Re: PERFORMANCE question?

From: <Jared.Still_at_radisys.com>
Date: Mon, 04 Feb 2002 14:23:19 -0800
Message-ID: <F001.004058A3.20020204142527@fatcity.com>

>From a database that has been up since 12/24/01:

                                                         TIME
                                           TOTAL       WAITED
EVENT NAME                                 WAITS   HUNDREDTHS
----------------------------------- ------------ ------------
log file single write                        165            8
log file switch completion                    88          362
log buffer space                          11,155        3,008
log file sequential read                 127,446       45,125
log file parallel write                2,313,568      108,510
log file sync                          2,250,884      139,874

This is on Win2k, 5 RAID 10's, 1 Gig RAM, 2 CPU's, on a rather busy database.

Just providing it for comparison purposes.

Jared

"Seema Singh" <oracledbam_at_hotmail.com>
Sent by: root_at_fatcity.com
02/04/02 12:01 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        PERFORMANCE question?

Hi
I checked my database and found

EVENT                               TOTAL_WAITS TIME_WAITED
----------------------------------- ----------- -----------
log buffer space                          12264     1094425
log file parallel write                  703116      227568
log file sequential read                 226133       65773
log file single write                       584        1298
log file switch completion                  940       77197
log file sync                            746881     8891791

log file sync value is increasing and waits are high.when i check all ratios
the ratios looks good.What could be problem? Thx
-Seema

Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: oracledbam_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author:
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Mon Feb 04 2002 - 16:23:19 CST