pregunta de eventos

chemian
21 de Febrero del 2006
Hola,

Alguien podria decirme que significan estos dos eventos:

- log file sync
- control file parallel write

Muchas gracias.

chemian
21 de Febrero del 2006
perdonar, ya se que se podia buscar en google y no preguntar aqui, pero tenia prisa y lo he preguntado mientras buscaba la respuesta.

Ya lo he encontrado.
Por si le interesa a alguien:

- The control file parallel write Oracle metric event occurs while the session is writing physical blocks to all controlfiles. This happens when:

the session starts a controlfile transaction (to make sure that the controlfiles are up to date in case the session crashes before committing the controlfile transaction)
the session commits a transaction to a controlfile
changing a generic entry in the controlfile, the new value is being written to all controlfiles

- log file sync is a client wait event. It is the wait event your clients wait on
when they say "commit". It is the wait for LGWR to actually write their redo to
disk and return back to them. You can "tune" this by making lgwr faster (no
raid 5 for example) and committing less frequently and generating less redo
(BULK operations generate less redo than row by row do)


gracias.