Originally posted by gandolf989
v$parameter does have a column called isdefault. You can query based on that column and see which parameters are not default.
I think that's the whole point. She's trying to pull v$parameter.isdefault=Y but setting it to the default value still shows isdefault=N because it was "set".