Slow select statement diagnosis
This is an older application we just moved from Solaris 10 running Oracle 10 to Linux 5.8 running Oracle 11.2.0.2. The problem existed on both server and both DBs. So I am trying to isolate the problem at the very least. I would think this would rule out any O/S issues. Here is the query it is running for the last 24 hours. Of note this is a persistent connection used by the application. I have changed some of the values as this is a production system and I did not want to post real data.