1

Topic: ORA-04021: Timeout occered while waiting to lock object

Greetings;
Whether it is possible for ORA-04021 to set ? 15 minutes By default hang
PS: DDL_LOCK_TIMEOUT not for this case, if somebody not in course.

2

Re: ORA-04021: Timeout occered while waiting to lock object

_kgl_time_to_wait_for_locks?

3

Re: ORA-04021: Timeout occered while waiting to lock object

Nobody1111;
The pancake, the first link in Google on demand "ORA-04021".

4

Re: ORA-04021: Timeout occered while waiting to lock object

But it like, only in new versions (12)
And in old like as  was 5 mines

5

Re: ORA-04021: Timeout occered while waiting to lock object

Whether

Nobody1111 wrote:

it is possible for ORA-04021 to set ?

Nobody asked a question - what for?
... Whether it is a lot of, whether it is not enough, whether not clear desire wearies.

6

Re: ORA-04021: Timeout occered while waiting to lock object

Ljubomudrov wrote:

_kgl_time_to_wait_for_locks?

Thanks, very likely, it. Ely-paly, viewed parameters with  order by value as viewed...

jan2ary wrote:

Nobody1111;
The pancake, the first link in Google on demand "ORA-04021".

Google, it shows a miscellaneous to different people. At me in the first link anything about value  is not present.

7

Re: ORA-04021: Timeout occered while waiting to lock object

Viewer wrote:

it is passed...
Nobody asked a question - what for?
... Whether it is a lot of, whether it is not enough, whether not clear desire wearies.

On mine, quite clear desires.
For example, I drive on the basis of update and someone  a packet. During the same time someone, for example, the manual, distracts. Then it makes sense to deliver in advance  more that process progonaiz-for nonsense was not interrupted. Or  a packet  which fulfills for 20 minutes.
On the other hand, under the severe constraints defined more to availability it is possible to make secure and deliver  less that session fell off faster and did not hold standing in a queue to a packet after it., Of course, to select more successful time for this purpose. Though reduction is less necessary, to cut down  session it is possible also hands.

8

Re: ORA-04021: Timeout occered while waiting to lock object

2 Nobody1111
Thanks for clarification.
Simply sometimes the answer to "a bare" question causes a reflex as on a tail of sticking out queue - can also to me it is necessary... That give that. smile

9

Re: ORA-04021: Timeout occered while waiting to lock object

I  would not increase
If I  on library cache pin / lock at update setting if I have an indulgence of all to wet (and it, as a rule is and is registered in instructions) at once and I knock down hindering session
Otherwise I knock down the that others not to brake

10

Re: ORA-04021: Timeout occered while waiting to lock object

, it, seemingly, only with restarting  is exposed, what there about alter session to speak... Then not so helps...