How to change the SGA_TARGET and SGA_MAX_SIZE in Oracle XE

I am just looking back into my posts and realized that adding sga_max_size in pfile is not required. My apologies and please ignore my previous post.

Thanks,

This may help you.

http://forums.oracle.com/forums/thre...sageID=3753756

make sure your SGA + PGA is not exceeding more than 1GB.

Thanks,

SQL> startup pfile=C:\oraclexe\app\oracle\product\10.2.0\server\database\initXE.ora
ORA-44412: XE edition memory parameter invalid or not specified
ORA-01078: failure in processing system parameters
SQL>


This is two parameter in initXE.ora that is changed according to your instruction.

*.sga_max_size=1048576000
*.sga_target=1048576000

Thanks and sorry for my previous reply.

I followed your instruction

make sure your SGA + PGA is not exceeding more than 1GB.

and its works.Once again thanks for solving this issue.

Glad to hear that your issue has been resolved. Thanks for updating the forum.

Thanks,