Tag Archives: troubleshoot

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

ORA-29702 – Starting RAC instance in non-rac mode

Today I was trying to create a simple database to troubleshoot one issue. It happens I was using an old server which had CRS and ASM installed and used by an old database. While my test database was not meant … Continue reading

Posted in Oracle, Other Blogs | Tagged , , , , | Leave a comment