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 Received on Thu Aug 24 2000 - 07:14:01 CDT