One or two sessions waiting for library cache lock for long time(in
days). Most of the time the session waiting for library cache lock is
trying to parse (based on v$sql.sql_text) a SQL statement. Everyday we
identify the session and kill the session in both oracle and unix.
There are two databases with 2 node OPS and all 4 nodes has the same
config. The library cache lock is always on the Node-1 of the 1st
database from application A1.
Java application is connecting to the database using connection
pool(OCI client). There are 3 connection pools for 3 different
applications.
Version 8.1.7.3
Could someone through light on this?
