My Oracle Support Banner

Pro*C Application Hangs Waiting For 'SQL*NET MORE DATA FROM CLIENT' (Doc ID 2323046.1)

Last updated on JANUARY 22, 2020

Applies to:

Oracle Net Services - Version and later
Precompilers - Version and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.


Pro*C application hangs with "SQL*Net more data from client". 

Intermittently the application sessions appear to be hanged

callstack trace:

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ksdxdmp
<- ksdxfdmp <- ksdxcb <- sspuser <- sighandler <- read
<- snttread <- nttfprd <- nsbasic_brc <- nsbrecv <- nioqrc
<- opikndf2 <- kpnxbicbk <- ttcGetSendInfo <- ttcacs <- ttcdrv
<- nioqwa <- upirtrc <- kpurcsc <- kpuexec <- kpnexe
<- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start

Current Wait Stack:
0: waiting for 'SQL*Net more data from client' <=============
driver id=0x54435000, #bytes=0x1, =0x0
wait_id=26222 seq_num=26223 snap_id=1
wait times: snap=2822 min 59 sec, exc=2822 min 59 sec, total=2822 min
59 sec
wait times: max=infinite, heur=2822 min 59 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x5a0
Wait State:
fixed_waits=0 flags=0x2a boundary=0xa926d1f8/0
Session Wait History:
elapsed time of 0.000012 sec since current wait
0: waited for 'SQL*Net message to dblink'



 Database upgraded to including the environment/server is changed


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.