library cache pin wait

From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Fri, 3 Oct 2008 21:49:40 -0400
Message-ID: <f30139790810031849y51897a1o53f2be3056e27093@mail.gmail.com>


I recompiled a package. It compiled successfully.

The package has several procedures. Each has 1 large insert select. The all select from the same table, but insert to different tables.

This has happened to me before.

  1. I run the package with 1 procedure from 1 session.
  2. i try to run the same package with a different procedure in another sessions.

The second procedure waits with a library cache wait until the first sessions completes and exits. (I am nohupping this, so I dont know if the exit is required, it is in the script).

any ideas?

the code is NOT being recompiled. When I look at dba_blockers, I don't see any blocking lockers. i am looking at the wait on the second session. I know the package is not running by.
1. I have dbms_application_info calls inside the package and I do not see these in v$session
2. I check v$sess_io and no IO is incrementing for this session.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 03 2008 - 20:49:40 CDT

Original text of this message