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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
