RE: OPS waits
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" 5from stats$event n1 6where n1.event_count 0 7order by n1.time_waited desc; Event Name Count Total TimeAvg Time - - - SQL*Net message from client5997869 22790881838 row cache lock 51420 1009555 19.63 buffer busy due to global cache 125239984724 7.86 PX Idle Wait 3034592902195.42 enqueue 39427558395 14.16 global cache cr request 224608251426 1.12 global cache lock null to x 55634240560 4.32 latch free 170235172573 1.01 global cache lock open x 46776124447 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).
RE: OPS waits
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" 5from stats$event n1 6where n1.event_count 0 7order by n1.time_waited desc; Event Name Count Total TimeAvg Time - - - SQL*Net message from client5997869 22790881838 row cache lock 51420 1009555 19.63 buffer busy due to global cache 125239984724 7.86 PX Idle Wait 3034592902195.42 enqueue 39427558395 14.16 global cache cr request 224608251426 1.12 global cache lock null to x 55634240560 4.32 latch free 170235172573 1.01 global cache lock open x 46776124447 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).