EBS R12.1.3
11gR2
OL6
Hi ALL,
We have concurrent a program that is running very long time.
Please share what sql scripts to monitor what this concurrent program is doing, or what table is it accessing now, whether it is doing insert, update, delete, or whether it is locked up, or is it lacking TEMP & ROLLBACK space/segments?
Right now is should be inserting 250,000 rows to an interface table, but does the commit after some more sql process. The commit is at the end of the group/batch of sql's.
How do I check that it is doing insert? I count the table but still no rows since it does not do commit per line.
How do I know what is happening to this program?
Please help...
Kind regards,
jc