Insert Using Bind and JDBC Thin Client Due Slow With Library Cache Lock
(Doc ID 2369968.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- Insert using bind and JDBC Thin Client, performs slowly
- AWR and ASH report shows waits on enq: TX - row lock contention and library cache latch
- Hanganalyze shows following functions:
kkscsSearchChildList <- kksfbc <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!