Skip to Main Content
Forums

Oracle Database Express Edition (XE)

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!

Setting the right amount to MEMORY_TARGET

John_S_MNov 25 2020 — edited Nov 25 2020

Hi,
The system RAM size is 2GB
after installing 18c Express edition successfully. I connected to the DB successfully.
Seeing the parameter SGA:
sga_max_size 616M
sga_target 616M
I executed the command:
ALTER SYSTEM SET MEMORY_TARGET = 2G SCOPE = SPFILE
it altered
After shutdown and startup, I get this error:
image.pngPlease let me know if I made a mistake and how I could rectify this.
Thank you.
John
This post has been answered by Billy Verreynne on Nov 30 2020
Jump to Answer
Comments
Post Details
Added on Nov 25 2020
#xe
8 comments
2,423 views
1 mention