Performance problem in custom transaction
We have a custom transaction for checking the roles related to an transaction.
We have the same copy of the program in DEE, QAS and PRD(obvious).
The catch is in DEE the transaction runs very slow, whereas in QAS and PRD the transaction is normal.
In the debugger mode i found in DEE while accessing AGR_1016 it takes an long time.
I checked the indexes, tables and extents and noticed that in DEE the extents, size and the table size(physical size) is more than in PRD.
Whereas, the records are more in PRD and less in DEE.
Please guide me on what all checks i can perform to find out where exactly the problem is?