Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sga_target

happy10319Jun 4 2020 — edited Jun 5 2020

Hi,

On 11.2.0.4 on AIX

Currently we have:

sga_target 0

pastedImage_1.png

And

On physical server:

free memory = 1378 MB

Do we have enough memory to set sga_target to 1Gb running:

SQL>ALTER SYSTEM SET sga_target=1G SCOPE=SPFILE;

pastedImage_0.png

Thank you.

This post has been answered by Arsalan Dehghanisariyarghan on Jun 5 2020
Jump to Answer
Comments
Post Details
Added on Jun 4 2020
23 comments
964 views