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

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.