Hi All,
I have a very strange problem ( at least for me ) with a package run in production Environment.
The package was installed into application schema, and in the same schema for all tables that are in the same tablespace.
The customer has reported a performance slowdown of it, but if i test it in my PR env and :
- if I run the query outside of package, it run very fast
- if I install the package in my personal schema and run it, it run very fast
- if I run the package, installed on application schema, it is very slow!!!!
what is the difference between these three methods?
thank you in advance,
Diego