Arquivo da categoria: ENQUEUE

O evento “log file sync waits” está entre os 5 maiores

Question: I have “log file sync waits” in my top-5 timed events.  How do I tune to reduce the log file sync wait events? Answer: The log file sync wait occurs at the end of a transaction and the database writer (DBWR) must wait … Continuar lendo

Publicado em ENQUEUE, I/O TUNING, WAIT EVENTS | Marcado com , | Deixe um comentário

Oracle enqueues

1. What are Oracle enqueues? Oracle enqueues are locks at database level that coordinate parallel access to Oracle resources such as objects or data records. For example, enqueues are responsible for several transactions not being able to change the same data record … Continuar lendo

Publicado em ENQUEUE, PLSQL TUNING, TRACE | Marcado com , | Deixe um comentário