No question at this time
DBA Top 10
1 M. Cadot 10800
2 A. Kavsek 10100
3 B. Vroman 4800
4 P. Wisse 4200
5 J. Schnackenberg 2900
6 J. PĂ©ran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48515
Total active users1426
Act. users last 24h5
Act. users last hour0
Registered user hits last week153
Registered user hits last month718
Go up

Minimal memory pool values
Next thread: recreate pdb
Prev thread: Managing shared memory caused by ORA-04031

Message Score Author Date
Hi, Are there minimal values to be set for shar...... Lauri Sep 10, 2019, 14:53
Hi, minimum size for particular pool (DB_CACHE_...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Sep 10, 2019, 15:31
Hi, Oups, I forgat this is part of the installa...... Lauri Sep 10, 2019, 16:18

Follow up by mail Click here


Subject: Minimal memory pool values
Author: Lauri, Netherlands
Date: Sep 10, 2019, 14:53, 301 days ago
Os info: Linux x86 64bit
Oracle info: 12c and higher
Message: Hi,

Are there minimal values to be set for shared_pool_size, streams_pool_size, java_pool_size, large_pool_size when AMM is not used?

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

Subject: Re: Minimal memory pool values
Author: Ales Kavsek, Slovenia
Date: Sep 10, 2019, 15:31, 301 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

minimum size for particular pool (DB_CACHE_SIZE, LARGE_POOL_SIZE, SHARED_POOL_SIZE, JAVA_POOL_SIZE) is documented in Database Reference Guide (->Initialization parameters).

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-Minimal memory pool values
Author: Lauri, Netherlands
Date: Sep 10, 2019, 16:18, 301 days ago
Message: Hi,

Oups, I forgat this is part of the installation/reference.
Didn't do it for a long time.
I have found it at (at least a way to determine it): https://docs.oracle.com/database/121/REFRN/E41527-27.pdf

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