library cache lock
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 4 Apr 2005 10:43:49 -0500
Hi:
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?
Thanks
-Sami
--
//www.freelists.org/webpage/oracle-l
Other related posts:
