30 septiembre 2006

Abnormal growth of the temporary segment

Happened that the overnight, the TEMP temporary segment of the Oracle database, when running a loading process, the TEMP temporary segment grew to its maximum size without apparent reason.

This problem was solved by running the ANALYZE tables, it appears that the the execution plan (2 days before the ANALYZE was run)  depure
and data load the some tables was the result of the execution plan was not updated.

No hay comentarios.: