> 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 - 23:56:37 CDT
