hot spot
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
buffer busy waits 14,097 2,446 174 29.3 Concurrenc
CPU time 1,422 17.0
enq: TX - index contention 3,862 1,082 280 12.9 Concurrenc
log file sync 570,885 1,021 2 12.2 Commit
db file sequential read 178,351 542 3 6.5 User I/O
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ----- ----------- ------- ---------
buffer busy waits 14,097 13 2,446 174 0.0
enq: TX - index contention 3,862 2 1,082 280 0.0
Owner Tablespace Object Name Obj.Type Row Lock Waits % of Capture
ACSSPROD ACSS_IDX03 ACSS_ORDER_HEADER_PK INDEX 3,425 43.62
ACSSPROD ACSS_IDX03 ACSS_ORDER_HEADER_ST INDEX 883 11.25
ACSSPROD ACSS_IDX03 ACSS_ORDER_HEADER_DT INDEX 682 8.69
Buffer
Tablespace Subobject Obj. Busy % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
trac1 I_DMP_CR_D trac1_ID INDEX 8,624 64.39
trac1 I_DMP_CR_D trac1_DCS_ADD_DATE CS_P201110 INDEX 3,276 24.46
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-709547/ ，如需转载，请注明出处，否则将追究法律责任。
