|
150 19380 2907006
--//奇怪的是,测试实际上测试1反而慢一点.从这个测试可以看出,如果如果应用真有大量语句出现cursor争用,通过打散语句的执行,
--//可能未必能提高执行效率.
--//test1的awr报表:
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 1681 20-Mar-19 09:53:01 27 1.2
End Snap: 1682 20-Mar-19 09:56:23 28 1.2
Elapsed: 3.37 (mins)
DB Time: 497.85 (mins)
...
Top 10 Foreground Events by Total Wait Time
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tota Wait % DB
Event Waits Time Avg(ms) time Wait Class
------------------------------ ------------ ---- ------- ------ ----------
latch: shared pool 233,755 18.6 79 62.2 Concurrenc
DB CPU 4751 15.9
library cache: mutex X 828 13.7 17 .0 Concurrenc
cursor: pin S wait on X 68 1.4 20 .0 Concurrenc
library cache load lock 94 1.1 12 .0 Concurrenc
lo |