Tag Archives: undo

Eventual bad performance for a query with a good plan

The user calls complaining that a recurrent report, which usually completes in 15-20 minutes, is running for a few hours now. You request some more information from the user about the report and its database session, and start troubleshooting: Servers … Continue reading

Posted in Oracle, Performance | Tagged , , , , , , , | 2 Comments