Recently i tried to increase the memory_max_target in Spfile as well through cmd.But After restart the instance it shows "ORA-47500: XE edition memory parameter invalid or not specified".I couldn't start the instance,but later i started by create SPfile from pfile.why this error comes after change the memory?Should i need enterprise edition??


1 Answer 1


XE is limited to 1 GB, you can not increase its memory.

Oracle Database XE RAM Limitation

The maximum amount of RAM that an Oracle Database XE database uses cannot exceed 1 gigabyte, even if more is available.

  • Yes.we need enterprise edition.i think enterprise edition have limition of up to 2 GB.
    – luvking
    Jan 15, 2017 at 2:41
  • EE has no 2GB limit.
    – eckes
    May 31, 2019 at 13:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.