Home » RDBMS Server » Server Administration » Changing SGA_MAX_SIZE
Changing SGA_MAX_SIZE [message #197558] |
Wed, 11 October 2006 15:15 |
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
|
|
|
Goto Forum:
Current Time: Thu Mar 28 04:19:40 CDT 2024
|