Database Memory & 4030/4031 (MOSC)

MOSC Banner

Raising MEMORY_MAX_TARGET

edited Jun 12, 2015 11:21AM in Database Memory & 4030/4031 (MOSC) 2 commentsAnswered

We are trying to set the following parameters in the init.ora file for our database. When starting up the database we get an error for the pga_aggregate_target because the memory_target is only 1GB. The Memory_Max_target is also 1GB. When we try to raise the memory_max_target to allow the other parameters more memory, we receive another error saying that we don't have any more memory. The server is Solaris 11 SPARC X64 with 32GB of RAM. When using top command is shows that only 2GB is free. There are only 2 databases on this server and we can't figure out why

Tagged:

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