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

Home -> Community -> Mailing Lists -> Oracle-L -> Waits on log file sync

Waits on log file sync

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Fri, 8 Sep 2000 18:05:43 +0530
Message-Id: <10613.116501@fatcity.com>


As part of Benchmarking Runs , there Exist WAITS on log file sync

log_buffer_size = 4 MB
log_checkpoint_interval value Greater than Redo file Size to Cause Checkpointing
only on log Switch
log switch happening every 10 minutes

Transactions primarily OLTP in nature

NOTE - Previously though there were NO such waits Online Redo logs Exist on RAID 0+1
Can NOT Change Commit Frequency either

SVRMGR> Rem System wide wait events for non-background processes (PMON,
SVRMGR> Rem SMON, etc).  Times are in hundreths of seconds.  Each one of
SVRMGR> Rem these is a context switch which costs CPU time.  By looking at
SVRMGR> Rem the Total Time you can often determine what is the bottleneck
SVRMGR> Rem that processes are waiting for.  This shows the total time spent
SVRMGR> Rem waiting for a specific event and the average time per wait on
SVRMGR> Rem that event.
SVRMGR> select  n1.event "Event Name",
     2>         n1.event_count "Count",
     3>         n1.time_waited "Total Time",
     4>         round(n1.time_waited/n1.event_count, 2) "Avg Time"
     5>    from stats$event n1
     6>    where n1.event_count > 0
     7>    order by n1.time_waited desc;
Event Name                       Count         Total Time    Avg Time
-------------------------------- ------------- ------------- -------------
SQL*Net message from client           17736895     174027138          9.81
log file sync                           493066      16768066         34.01
latch free                            10635868       8429387           .79
row cache lock                           20006       4551336         227.5
enqueue                                 464758       4371312          9.41
buffer busy waits                        73994       2303119         31.13
library cache pin                        26423        866739          32.8
Received on Fri Sep 08 2000 - 07:35:43 CDT

Original text of this message

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