Originally posted by davey23uk
alter system reset PARAMETER scope=spfile sid='*'
That worked Dave. Wonder why you need to set sid though since it's not RAC.

Originally posted by Mr.Hanky
Just out of curiosity, what does it say under ISMODIFIED?

I guess the real question is how and when does V$PARAMETER get refreshed. Or, once it is modified, will it ever show default again if the value is reset to the same number.
ISMODIFIED says FALSE for ALL my parameters. Once I did the reset as Dave suggested, and bounced the db, then ISDEFAULT was set back to TRUE.

Originally posted by Mr.Hanky
http://download-west.oracle.com/doc...ate.htm#1014422
This talks about deleting string parameters. Using '' doesn't work with SORT_AREA_SIZE since it's expecting a number (I tried )

Thanks for everyone's help!

Jodie