Database Administration (MOSC)

MOSC Banner

'SQL*Net break/reset to client'

edited Aug 6, 2018 5:02AM in Database Administration (MOSC) 5 commentsAnswered

Hi,

Oracle version: 10.2.0.4

OS vesrion: SunOS 5.10

I meet a wait 'SQL*Net break/reset to client' when my application $U is inserting a row in database.

I trace de cession and I get this:

=====================

PARSING IN CURSOR #12 len=131 dep=1 uid=0 oct=3 lid=0 tim=52568459508470 hv=1635361899 ad='a505da70'

select /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u  where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

END OF STMT

PARSE #12:c=0,e=70,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=3,tim=52568459508453

BINDS #12:

kkscoacd

Bind#0

  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

  oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center