No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

Soving library cache lock cursor
Next thread: Number of thread associated with DOP
Prev thread: High CPU for a simple queery

Message Score Author Date
Hi, I have found the following arctice regading...... Lauri Nov 25, 2019, 16:42
Hi Lauri, Ales himself warned about articles wi...... Philip Wisse Nov 26, 2019, 09:14
Hi Philip, Thanks, I was aware of some possible...... Lauri Nov 26, 2019, 12:14

Follow up by mail Click here


Subject: Soving library cache lock cursor
Author: Lauri, Netherlands
Date: Nov 25, 2019, 16:42, 185 days ago
Os info: Linux x86 64bit
Oracle info: 12c and higher
Error info: n/a
Message: Hi,

I have found the following arctice regading "library cache lock cursor":
One of the cause mentioned is "Automatic Shared Memory Management".
Does someone encountered that situation, having to disable Automatic Shared Memory Management?
If yes, what is the mechanism behind?

Thanks and Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Soving library cache lock cursor
Author: Philip Wisse, Netherlands
Date: Nov 26, 2019, 09:14, 184 days ago
Message: Hi Lauri,

Ales himself warned about articles without 4 digit version information or timestamp:
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=93807

The most sophisticated way to let Oracle manage the instance memory is AMM (Automatic Memory Manegement).
AMM uses memory_target and memory_max_size.
Now there might be circumstances where you have to fall back to ASMM: Doc ID 1952395.1
ASMM uses sga_target and pga_aggregate_taget (don't set memory target).

So it's more like the other way around ;-)

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Soving library cache lock cursor
Author: Lauri, Netherlands
Date: Nov 26, 2019, 12:14, 184 days ago
Message: Hi Philip,

Thanks, I was aware of some possible situations as some sites do not use this feature.
But, what's the relation with the link you pointed out?

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here