2 Replies Latest reply: Jul 5, 2013 6:15 AM by Vistech(SI) RSS

    Performance slows down when moving from stage to test schema within same instance with same database table and objects

    Vistech(SI)

      We have created a stage schema and tested application which is working fine when we are moving it to another schema for further testing ( This schema is created using same scripts which were used to create objects in staging schema) the performanc of application (Developed in .NET) slows down drastically

       

      Some of the store procedures we have checked at Databse/SQLdeveloper level are giving almost same performance but at Application level there is lot of difference

       

      Can you please help

       

      We are using Oracke 11g Database