Performance problem in custom transaction

[Former Member]

Hi,

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?

Regards,

Siddhartha.

[Former Member]

TO be raised in someother forum

[Former Member]

Hi,

What database are you running? It sounds like that's where the issue is, if it's a table with a lot of changes a table reorg might be in order (especially with older databases). You should probably close this message and open another one in the relevant DB forum.

Michael

[Former Member]

Thanks micheal.

I shall do open this message on the SAP on Oracle forum as the db is Oracle 10.2.0.4.

Regards,

siddhartha.