Friday, January 27, 2012

Oracle parameters

Oracle views:
V$PARAMETER - lists all parameters in current session
V$SPPARAMETER - lists all spfile defined parameters. For all parameters that are not defined in SPFILE, ISSPECIFIED="FALSE'
V$PARAMETER2 - lists all session parameters
V$SYSTEM_PARAMETER - lists all system  parameters that are currently used by instance

No comments:

Post a Comment