某oracle数据库cursor: mutex X分析报告
SQL> select to_char(SAMPLE_TIME,'yyyymmdd hh24mi') ,event ,count(*) from dba_hist_active_sess_history
2 where instance_number = 2
3 and
4 SAMPLE_TIME
5 between to_timestamp('2022-01-22 09:30:00','yyyy-mm-dd hh24:mi:ss') and
6 to_timestamp('2022-01-22 10:30:00','yyyy-mm-dd hh24:mi:ss')
7 group by to_char(SAMPLE_TIME,'yyyymmdd hh24mi') ,event order by to_char(SAMPLE_TIME,'yyyymmdd hh24mi') ,event desc;
TO_CHAR(SAMPL EVENT COUNT(*)
------------- ---------------------------------------- ----------
20220122 0930 10
20220122 0930 enq: TX - row lock contention 36
20220122 0930 db file sequential read 2
20220122 0931 11
20220122 0931 log file parallel write 1
20220122 0931 gc cr block busy 1
20220122 0931 enq: TX - row lock contention 36
20220122 0931 enq: IV - contention 1
20220122 0931 db file sequential read 2
20220122 0931 control file sequential read 2
20220122 0932 9
20220122 0932 gc cr disk read 3
20220122 0932 gc cr block busy 1
20220122 0932 enq: TX - row lock contention 35
20220122 0932 db file sequential read 2
20220122 0932 acknowledge over PGA limit 1
20220122 0933 11
20220122 0933 enq: TX - row lock contention 36
20220122 0933 db file sequential read 3
20220122 0934 8
20220122 0934 log file sync 1
20220122 0934 gc cr disk read 1
20220122 0934 enq: TX - row lock contention 36
20220122 0934 db file sequential read 3
20220122 0935 8
20220122 0935 enq: TX - row lock contention 30
20220122 0935 db file sequential read 4
20220122 0935 ASM file metadata operation 1
20220122 0936 10
20220122 0936 enq: TX - row lock contention 36
20220122 0936 db file sequential read 4
20220122 0937 10
20220122 0937 enq: TX - row lock contention 36
20220122 0937 db file sequential read 2
20220122 0937 ASM file metadata operation 1
20220122 0938 11
20220122 0938 gc cr multi block request 1
20220122 0938 enq: TX - row lock contention 35
20220122 0938 db file sequential read 1
20220122 0939 10
20220122 0939 gc cr block 2-way 2
20220122 0939 enq: TX - row lock contention 36
20220122 0939 enq: IV - contention 1
20220122 0939 db file sequential read 1
20220122 0940 15
20220122 0940 gc current grant 2-way 1
20220122 0940 enq: TX - row lock contention 36
20220122 0940 db file sequential read 1
20220122 0941 11
20220122 0941 row cache lock 1
20220122 0941 enq: TX - row lock contention 36
20220122 0942 14
20220122 0942 enq: TX - row lock contention 36
20220122 0942 db file sequential read 1
20220122 0942 control file sequential read 2
20220122 0943 13
20220122 0943 enq: TX - row lock contention 36
20220122 0943 db file sequential read 1
20220122 0944 11
20220122 0944 gc cr block busy 1
20220122 0944 enq: TX - row lock contention 35
20220122 0944 db file sequential read 1
20220122 0945 9
20220122 0945 enq: TX - row lock contention 36
20220122 0945 enq: IV - contention 1
20220122 0946 7
20220122 0946 enq: TX - row lock contention 36
20220122 0947 6
20220122 0947 enq: TX - row lock contention 36
20220122 0948 8
20220122 0948 enq: TX - row lock contention 36
20220122 0949 7
20220122 0949 enq: TX - row lock contention 36
20220122 0950 8
20220122 0950 gc cr block busy 1
20220122 0950 enq: TX - row lock contention 35
20220122 0951 7
20220122 0951 enq: TX - row lock contention 30
20220122 0952 10
20220122 0952 enq: TX - row lock contention 36
20220122 0952 control file sequential read 1
20220122 0953 8
20220122 0953 enq: TX - row lock contention 36
20220122 0953 ASM file metadata operation 1
20220122 0954 7
20220122 0954 enq: TX - row lock contention 36
20220122 0955 7
20220122 0955 gc cr block 2-way 1
20220122 0955 enq: TX - row lock contention 36
20220122 0956 14
20220122 0956 log file parallel write 1
20220122 0956 enq: TX - row lock contention 36
20220122 0956 ASM file metadata operation 1
20220122 0957 10
20220122 0957 log file sync 1
20220122 0957 gc cr block busy 2
20220122 0957 enq: TX - row lock contention 35
20220122 0958 10
20220122 0958 gc cr block 2-way 2
20220122 0958 enq: TX - row lock contention 36
20220122 0959 10
20220122 0959 gc cr block busy 1
20220122 0959 enq: TX - row lock contention 36
20220122 0959 IMR slave acknowledgement msg 1
20220122 1000 14
20220122 1000 gc current block busy 1
20220122 1000 enq: TX - row lock contention 36
20220122 1000 control file sequential read 1
20220122 1001 11
20220122 1001 gc current block busy 1
