wait

Wait events provide insight into why a session is waiting and the resources it is waiting for. Some common wait events include: db file sequential read db file scattered read latch: cache buffers chains log file sync library cache: load into buffer The impact of wait events can vary depending on the type of wait…