AWR Review

Dear Team,

We are on 19.28 database version. Yesterday on 17-04-2026 from 15:30 PM IST to 17:00 PM IST, we have faced very slow performance in application. We verified the wait events during the issue.

EVENT                          WAIT_CLASS                                                       SESSION_COUNT

------------------------------ ---------------------------------------------------------------- -------------

cursor: pin S                  Concurrency                                                                 37

latch free                     Other                                                                       19

TCP Socket (KGAS)              Network                                                                     19

latch: cache buffers chains    Concurrency                                                                  6

SQL*Net message to client      Network                                                                      2

PX qref latch                  Other                                                                        1

library cache: mutex X         Concurrency                                                                  1

db file sequential read        User I/O                                                                     1

direct path read               User I/O                                                                     1

But not sure what caused the slowness. Attached the AWR report for review. Can you please kindly share your observations.