Database Administration (MOSC)

MOSC Banner

Where is the default values for a session parameter stored

edited Jun 18, 2018 4:56PM in Database Administration (MOSC) 14 commentsAnswered
I need to write a stored procedure that will check the V$PARAMETER table to see if the default values of a parameter is used and if not, to change the values to the default values. I can determine if the parameter is not the default from the ISDEFAULT column, but what Oracle object stores the default values for a parameter. I've Goolged and found nothing. It has to be stored in a DBA/V$ or some other table just don't know which one.

Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center