-
How to change the SGA_TARGET and SGA_MAX_SIZE in Oracle XE
I wnat to change SGA_TARGET and SGA_MAX_SIZE in Oracle XE but i ma getting this error when i am trying to start the database.
SQL> alter system set SGA_TARGET=1024M scope=spfile;
System altered.
SQL> alter system set SGA_MAX_SIZE=1024M scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-44412: XE edition memory parameter invalid or not specified
SQL>
Please tell me how to resolve this issue.Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|