|
g file sync 141 .5 4 .0 Commit
wait list latch free 50 .3 6 .0 Other
enq: SQ - contention 2 0 10 .0 Configurat
library cache lock 2 0 8 .0 Concurrenc
SQL*Net message to client 2,560 0 0 .0 Network
--//出现了latch: shared pool大量争用.反而测试2使用mutex的效率更高.
--//test2的awr报表:
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 1682 20-Mar-19 09:56:23 28 1.2
End Snap: 1683 20-Mar-19 09:59:40 28 1.2
Elapsed: 3.28 (mins)
DB Time: 484.76 (mins)
...
Top 10 Foreground Events by Total Wait Time
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tota Wait % DB
Event Waits Time Avg(ms) time Wait Class
------------------------------ ------------ ---- ------- ------ ----------
cursor: pin S 585,684 12.1 21 41.6 C |