OPS waits

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Mon, 16 Apr 2001 07:45:41 -0700
Message-ID: <F001.002EA1CA.20010416074052@fatcity.com>

O.P.S. Setup in Benchmark Runs :-

2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6 3rd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6

Transaction Volume - ALL the Following 4 Sets Fired CONCURRENTLY(At the SAME Time) :-
1) From 1st Digital APP Server (Digital) onto 1st DB Server - 9,000 Transactions using 350 Concurrent Processes fired 2) From 1st APP Server (Digital) onto 2nd DB Server - 9,000 Transactions using 350 Concurrent Processes fired
3) From 2nd APP Server ( SUN )onto 1st DB Server - 7,000 Transactions using 250 Concurrent Processes fired
4) From 3rd SUN APP Server ( SUN ) onto 2nd DB Server - 7,000 Transactions using 250 Concurrent Processes fired

TOTAL = 16,000 Transactions Fired on EACH DB Server using 600 Concurrent processes
Grand Total (Overall Picture)= 32,000 Transactions using 1200 Concurrent Processes

report.txt :-

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            5997869     227908818            38
row cache lock                           51420       1009555         19.63
buffer busy due to global cache         125239        984724          7.86
PX Idle Wait                              3034        592902        195.42
enqueue                                  39427        558395         14.16
global cache cr request                 224608        251426          1.12
global cache lock null to x              55634        240560          4.32
latch free                              170235        172573          1.01
global cache lock open x                 46776        124447          2.66

Qs. Do these Waits' VALUES seem Excessive ? If so What may be Done to Overcome them ?

--

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

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infy.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 Apr 16 2001 - 09:45:41 CDT