Repeat the library cache lock wait event in Oracle 11 GB, 11 glibrary

Repeat the library cache lock wait event in Oracle 11 GB, 11 glibrary

From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during business peaks. If a package or complex dependency exists in the process, it can easily lead to library cache lock. Therefore, you should also pay attention to this issue during application development.

Session1:

SQL> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production

SQL> create or replace procedure pining

Is
Begin
Null;
End;
/
SQL> create or replace procedure calling
Is
Begin
Pining;
Dbms_lock.sleep (200 );
End;

/

Session2:

Alter procedure pining compile;

Session3:

Drop procedure pining;

Session4:

SQL> select sid, event, wait_class, seconds_in_wait
2 from v $ session_wait w
3 where w. WAIT_CLASS <> 'idle ';
Sid event WAIT_CLASS
------------------------------------------------------------------------------------------
6 library cache lock Concurrency
132 library cache pin Concurrency
191 SQL * Net message to client Network

ORACLE lock table problems library cache lock

Library cache lock is difficult and simple.
Can I check whether there are any processes in this table that are always in use? If so, Kill the process. If not, analyze it further.

Let's take a look at this article. I hope it will be helpful.
Blog.sina.com.cn/s/blog_788cfb360100wnak.html

How can I identify oracle 11G training?

First, check whether the organization is on the official WDP authorization page of Oracle. Then, check whether the uniform price of Oracle is higher than the uniform price. If the price is higher than the uniform price, it indicates that there is suspicion of charges; the other is to check whether the course schedule is in one breath. If there is a lecture class or something, it means that it may force you to charge twice later. Then, it is to check the qualifications of equipment and lecturers, in fact, it is also good to judge through the Oracle training audition course. For example, I would like to hear it whenever I have time. Although I have never reported any name, I think it is good. It is also a good choice to visit training institutions on the spot. what others say is false. You need to listen more and then make judgments.