How to change the SGA_TARGET and SGA_MAX_SIZE in Oracle XE

[vnktummala]

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,

[vnktummala]

This may help you.

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

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

Thanks,

[ranvijai]

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

[ranvijai]

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.

[vnktummala]

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

Thanks,