This sql is hanging
I need help. The Developer is telling me that this sql is hanguing again.
Oralce Database Entrprise Edition version 10.2.0.4 - PeopleTools version 8.47.14
Yesterday I implement a profile, then kill the os spid and the Developer finished with Sucess the instance.
Now they are asking e to do this again.
Do you know what is happening in here?
Process
AP_PSTPYMNT
Process Instance: 2553695
SID: 232
SQL_HASH_VALUE: 2713383249
SQL_ID: 75p85t6hvpwaj
SELECT 'X' FROM PS_PST_PYMT_TAO31 PST , PS_VOUCHER_LINE VLN , PS
_PYMNT_VCHR_WTHD WTHD WHERE PST.PROCESS_INSTANCE = 2553695 AND P
ST.BUSINESS_UNIT = VLN.BUSINESS_UNIT AND PST.VOUCHER_ID = VLN.VO