Day 2 of performance tuning

Another long night, but there is hope thanks to sophisticated tools like cmd prompt, sqlplus, explain plan and Google (it is just a means to get to AskTom).

It seems that my updates on views could not push predicates because of the use of rownums. As usual found an Ask Tom article that explained it. As usual it took a couple of reads to make its mark. (All my fault!). Changed the statement and everything was back on track.

Why am I updating views? Well it so happens that the views were tables in their previous incarnation and now they are reborn to take part in a grand home-grown auto partitioning scheme.
As most experts would probably put it, those 4 words should never be uttered in the same sentence. Well it is a long story and the database has quieted down so I will have to save it for another day.