Difference b/w V$PARAMETER & V$PARAMETER2 [message #488810] |
Tue, 11 January 2011 04:57  |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi all,
Need a clarification,
We all know that v$parameter shows the parameter files of current instance.
And v$parameter2 shows the parameter files of the whole Database.
Then when i fire the below command, it shows both of the above mentioned view is having same parameters.
select name from v$parameter
intersect
select name form v$parameter2;
Regards:
Muktha
|
|
|
|
|
|
|
Re: Difference b/w V$PARAMETER & V$PARAMETER2 [message #488819 is a reply to message #488818] |
Tue, 11 January 2011 05:23  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Because both contains: " information about the initialization parameters that are currently in effect for the session", so why should they be different when their purpose is to display the same information?
Regards
Michel
|
|
|