This content has been marked as final. Show 2 replies
I raised a SR with oracle support for this issue and got to know that this is actually caused by a bug( Bug no. 9524564) in Oracle RDBMS version 126.96.36.199. This bus was fixed in the 188.8.131.52 Patch Set.
So the solution is, either upgrade to the RDBMS version from 184.108.40.206 to 220.127.116.11 by applying patch set.
or Check with workaround by disabling bind peeking and setting "_fix_control" = '6163564:off' as mentioned in Bug 9524564.
alter session set "_optim_peek_user_binds"=false;
alter session set "_fix_control" = '6163564:off'
thanks for sharing