This one is really strange. We are running peoplesoft on Oracle 11Gr2 on
Linux x86_64. Periodically we get ORA-3113 errors (network disconnect) from
one of our queries running from the app server to the database. It appears
to happen when histograms are not present on the table. When they are
present, the problem rarely, if ever occurs. Can anyone give us idea why
this may be happening? MOS noticed the correlation, but no one has figured
out the cause, or a true fix. I am planning on setting
_OPTIM_PEEK_USER_BINDS=FALSE and see what difference that makes, but best
case, that would only keep the problem from happening, not show us a cause.
We also get a ORA-3137 TTC protocol internal error, but that appears to be
on the app server side caused by the ORA-3113.

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
postedSep 29, '10 at 6:51p
activeSep 29, '10 at 6:51p

1 user in discussion

Andrew Kerber: 1 post



site design / logo © 2023 Grokbase