No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

Managing shared memory caused by ORA-04031
Next thread: Minimal memory pool values
Prev thread: Regd. Bounded Recovery Checkpoint and BR Interval Regd.

Message Score Author Date
Hi, The ORA-04031 indicates a shortage of share...... Lauri Sep 10, 2019, 12:47
Hi, --> MOS 430473.1 - ORA-4031 Common Analysis...... Ales Kavsek Sep 10, 2019, 13:33
Hi Ales, Thanks! But I do not have access to MO...... Lauri Sep 10, 2019, 13:38
Hi, imho, if you need to ask through a differen...... Ales Kavsek Sep 10, 2019, 13:49
Hi, Yes, that's the best I can do. Thanks!... Lauri Sep 10, 2019, 14:18

Follow up by mail Click here


Subject: Managing shared memory caused by ORA-04031
Author: Lauri, Netherlands
Date: Sep 10, 2019, 12:47, 70 days ago
Os info: Linux x86 64bit
Oracle info: 12c and higher
Error info: ORA-04031
Message: Hi,

The ORA-04031 indicates a shortage of shared momory.
Classically, we would increase the Shared Pool. But increasing the Shared Pool means that we need to have this extra memory available.
But this could be caused by memory fragmentation.
Does someone know how to investigate Shared Pool Memory fragmentation?
How to reduce it except from flushing the SGA and resizing it with a lower value?

Thanks by advance for sharing your experience.

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

Subject: Re: Managing shared memory caused by ORA-04031
Author: Ales Kavsek, Slovenia
Date: Sep 10, 2019, 13:33, 70 days ago
Message: Hi,

--> MOS 430473.1 - ORA-4031 Common Analysis/Diagnostic Scripts

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

Subject: Re-Managing shared memory caused by ORA-04031
Author: Lauri, Netherlands
Date: Sep 10, 2019, 13:38, 70 days ago
Message: Hi Ales,

Thanks! But I do not have access to MOS... I need to ask through a different department.
Does someone know if possible to find the diagnostic scripts somewhere?

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

Subject: Re: Re-Managing shared memory caused by ORA-04031
Author: Ales Kavsek, Slovenia
Date: Sep 10, 2019, 13:49, 70 days ago
Message: Hi,

imho, if you need to ask through a different department, then you can as well ask *that* department do deal with ORA-4031. :-)

The link that I posted is just a pointer to *massive* amount of information (videos) regarding ORA-4031, your're good for a week of reading and studying!
It's not just some simple script that'll solve the problem for you...you have to get access to MOS.

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

Subject: Re-Managing shared memory caused by ORA-04031
Author: Lauri, Netherlands
Date: Sep 10, 2019, 14:18, 70 days ago
Message: Hi,

Yes, that's the best I can do.

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