RE: Waits on enqueue , latch free

Sorry

APP Server = 4 CPUs , 4 GB RAM
DB Server = 4 CPUs , 3 GB RAM

> -----Original Message-----
> From: Johnson, George [SMTP:GJohnson_at_GAM.COM]
> Sent: Thursday, August 24, 2000 9:16 PM
> To: VIVEK_SHARMA; 'ORACLE-L_at_fatcity.com'
> Subject: RE: Waits on enqueue , latch free
>
>
> I believe _spin_count can only be 1 on single CPU and max of 2048 on
> multiple CPU boxes. Steve Adams has an excellent script tune_spin_count on
> his IXORA website that allows you to "play" with different spin count
> settings and measure the effect it might have.
>
> Gj
>
>
> -----Original Message-----
> From: VIVEK_SHARMA [mailto:vivek_sharma_at_inf.com]
> Sent: Thu 24 Aug 2000 13:14
> To: 'oracledba_at_quickdoc.co.uk'; 'ORACLE-L_at_fatcity.com'
> Subject: Waits on enqueue , latch free
>
>
> Increased init.ora parameters :-
> enqueue_resources = 100,000
> spin_count = 3000
>
> Still Waits on Enqueues & latch free NOT Coming Down .
> Should enqueue_resources be increased to 200,000 ? Are there any MAX
> values
> for enqueue_resources & spin_count ?
>
> 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 10498010 198098543 18.87
> enqueue 1599079 38666819 24.18
> latch free 4661835 1303777 .28
> SQL*Net more data from client 64609 485681 7.52
> log file sync 174167 36283 .21
> db file scattered read 252359 17996 .07
> library cache pin 1951 8616 4.42
> db file sequential read 546273 4402 .01
> buffer busy waits 44575 3229 .07
> free buffer waits 727 2733 3.76
>
>
> NOTE 20,000 Transactions Primarily OLTP in nature fired as part of a
> Benchmark Programusing 500 Concurrent users having Corresponding Oracle
> session processes over an SQL*Net
>
> ORACLE 7.3.4.5.0
> Digital Unix 4.0 G
> log_simultaneous_copies = 2*CPU_COUNT = 8
> shared_pool_size kept to bare minimum = 130 MB
> shared_pool_reserved_size = 10 MB
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Thu Aug 24 2000 - 11:47:13 CDT