There are many possibilities for that.
May be in production database there is more traffic when comparing to ur test db. May be the data is scatterd on production database. May be there are lot of reloads in shared pool area and likewise. The best solution is to tune your database then drill down to ur application.




Reply With Quote