July 22, 2014 archive

New Parameters in 11.2.0.4

I am working towards upgrading databases from 11.2.0.3 to 11.2.0.4. This should go smoothly, right? Well after I upgraded a development database, I got a call about a slow performing query. In all of the 11.2.0.3 databases, the query runs in about 50 seconds. In the 11.2.0.4 databases, the query runs in 4 minutes. The …

Continue reading