Oracle Database Discussions

Hi Guys,

We are facing this situation where in our Prod environment is getting many many Oracle Locks.
Users are not able to perform their work smoothly and this hits hard during the month ends.

DB Version= 10.2.0.4
Apps Version = 11.5.10.2

I have performed some investigation and found the below:-

- The users perform certain operations and it is during this operation that we start getting Oracle locks frequently.
- This issue cannot be recreated in any lower instance.
- The sessions that are blocking are INACTIVE sessions with module 'ARXCWMAI'.
- The sql that is run is also a select query (does not look like a problem area)
- Trace/tkprof do not have enough information.
- These sessions also tend to lock the table AR.AR_PAYMENT_SCHEDULES_ALL (found from v$locked_object)
- These blocking sessions are killed and thats the temporary solution.

Any ideas or suggestions would be greatly appreciated!

Thanks,
Trith