Home » RDBMS Server » Server Administration » Changing SGA_MAX_SIZE
Changing SGA_MAX_SIZE [message #197558] Wed, 11 October 2006 15:15 Go to previous message
itzac
Messages: 4
Registered: October 2006
Junior Member
I'm using 9i and I'm having a heck of a time finding out how to change the value of sga_max_size. I've tried:

alter system set sga_max_size = 100M scope = SPFILE

It of course won't run if the database is up, but it also doesn't work after a shutdown command. Could someone please spell it out for me from sqlplus login on a running instance as a starting point? Or point me to the pertinent Oracle doc, even. I'd be your best friend forever.

It's very frustrating to know exactly what you want to do and not be able to figure out how to do it.

[Updated on: Wed, 11 October 2006 16:17]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Bigfile Tablespace
Next Topic: Partition Exchange Error On Table With Nested Table
Goto Forum:
  


Current Time: Thu Mar 28 04:19:40 CDT 2024