Database Memory & 4030/4031 (MOSC)

MOSC Banner

Memory allocation

edited Apr 12, 2016 8:31PM in Database Memory & 4030/4031 (MOSC) 11 commentsAnswered

Hi Guys,

We have 11.2.0.3 database with Application 12.1.3 (Linux 5.6), We allocated sga_max_size for 10gb and total memory allocated for this server 62GB, not allocated for sga_target.

My question is, we have set the open_cursors values 700, it was increased it max limit and sometimes getting "ORA-1000" in application logs and not able to connect the application for new user.

Please check the below memory allocation and let me guide if I can increase the any part.

NAME_SIZE_MB

---------------------------------------------------------------------------

Fixed SGA Size = 2.1341094970703125

Redo Buffers = 16.140625

Buffer Cache Size = 448

Shared Pool Size = 3136

Large Pool Size = 32

Java Pool Size = 192

Streams Pool Size = 64

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center