what does "resmgr: active threads" mean?
Hi experts,
In a system I recently test, "latch free" event is top 1 wait event in awr-report and "resmgr: active threads" is top 1 in "latch sleep breakdown". So, I think "resmgr: active threads" is the key to solve the "latch free" problem. But It's so sad, I searched everywhere(google, oracle document, metalink), but can't find any information about "resmgr: active threads"???
Is there any body can give me some hint? Thanks very much.
Report Summary
Cache Sizes
BeginEnd
Buffer Cache:40,000M40,000MStd Block Size:8K
Shared Pool Size:22,960M22,960MLog Buffer:10,400K
Load Profile
Per SecondPer Transaction
Redo size:7,490,743.341,960.57
Logical reads:96,930.7625.37
Block changes:22,358.645.85
Physical reads:478.610.13
Physical writes:763.130.20
User calls:20,266.485.30
Parses:89.190.02
Hard parses:0.140.00
Sorts:9.910.00
Logons:1.910.00
Executes:15,915.754.17
Transactions:3,820.69
% Blocks changed per Read:23.07Recursive Call %:17.48
Rollback per transaction %:0.02Rows per Sort:428.76
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %:99.91Redo NoWait %:99.97
Buffer Hit %:99.51In-memory Sort %:100.00
Library Hit %:100.60Soft Parse %:99.84
Execute to Parse %:99.44Latch Hit %:97.80
Parse CPU to Parse Elapsd %:77.15% Non-Parse CPU:99.87
Shared Pool Statistics
BeginEnd
Memory Usage %:11.8511.95
% SQL with executions>1:68.0990.94
% Memory for SQL w/exec>1:68.5990.55
Top 5 Timed Events
EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
latch free3,317,9071,279,3923861,087.1Other
enq: HW - contention101,07270,10369459.6Configuration
buffer busy waits50,8357,9691576.8Concurrency
latch: cache buffers chains196,5186,824355.8Concurrency
latch: session allocation158,9515,876375.0Other
0