Avg global enqueue get time (ms)
I noticed Avg global enqueue get time (ms) is 214.5. This is as high as I have seen this and what does it mean? The following flush times are also really high:
Avg global cache cr block flush time (ms): 15.7
Avg global cache current block flush time (ms): 12.9
Avg message sent queue time is showing 942.0 ms
Here are top events: Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
cursor: pin S wait on X 414 16,367 39535 88.4 Concurrenc
kksfbc child completion 44 1,799 40887 9.7 Other
DB CPU 240 1.3
IPC send completion sync 77,702 25 0 .1 Other
external table write 2,434,678 20 0 .1 User I/O
The users are stating that everything is now running many times slower than what we saw in the lab. I verified the interconnect is going across the private interfaces (not public). What else should I be looking at?
Thanks in advance!!