This issue can be closed.
After discussion with developers -
He has decided to add a script in his code to "execute imediate analyze table compute statistics".
This has solved the issue.. Not occurred since last 3-4 months.
This thread can be closed.
Thanks for all your support.