How to Increase Oracle SGA
BUT, I never actually gave the commands I used to increase the size.
You can obviously do this easily in Enterprise Manager, and if you need the screenshots on how to do that, let me know, but I just like how quick SQL commands are via SQL*Plus.
So, here they are:
- Shutdown the database
shutdown immediate;
- Start up the database in "nomount" – I like to do a full shutdown
first because I'm a Windows user and full reboots are better than
restarts
startup nomount;
- Run the following sql to increase the SGA_MAX_SIZE parameter to 4GB.
You MIGHT not need to do this, but just remember, you won't be able to
increase the SGA_TARGET parameter to a value higher than the MAX SIZE
parameter
alter system set sga_max_size = 4000M scope=SPFILE;
- Run the following sql to increase the SGA_TARGET parameter
alter system set sga_target = 4000M scope=SPFILE;
- Shutdown the database – see point #2 about why I'm wasting time doing full restarts.
shutdown immediate;
- Startup the database.
startup;
No comments:
Post a Comment