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

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


      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