Difference b/w V$PARAMETER & V$PARAMETER2 [message #488810] |
Tue, 11 January 2011 04:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|