library cache lock

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Mon, 4 Apr 2005 10:43:49 -0500
Message-ID: <f09dd6280504040843621571c5@mail.gmail.com>

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
--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 04 2005 - 11:47:40 CDT