On Feb 19, 3:32 pm, "Si" <si.dow..._at_gmail.com> wrote:
> 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
OEM has it's own copy of the pfile.
So when you change the pfile through OEM you don't change the pfile on
the db server, but the pfile on the OMS server.
If you change the pfile through OEM, you must remember either stop
using the server pfile or manually sync both.
As this was cumbersome Oracle invented the spfile.
And yes: if you use the spfile, you don't have to worry anymore.
--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Feb 19 2007 - 09:43:26 CST
