I'm temporarily looking after an Oracle 9.2 database and have been
asked to resize and redistribute the SGA following an increase in RAM
on the box.
I increased the SGA max size to 4 GB throught Enterprise Manager and
restarted the database and the SGA resized to 4 GB. However, very
shortly after the whole box was rebooted and when the database came
back up it's size had gone back to what it was before the resize (1
GB). Having looked into this there doesn't seem to be an spfile
present.
What is the relationship between making settings in a pfile and
compiling it to an spfile and making changes through the Enterprise
Manager GUI? Has the change in SGA size been lost because there is no
spfile? Are changes made through EM saved to the spfile?
Thanks in advance
Received on Mon Feb 19 2007 - 08:32:16 CST
