Home » RDBMS Server » Server Administration » Difference between V$parameter and V$parameter2 (Oracle 10g ,Windows XP)
Difference between V$parameter and V$parameter2 [message #357581] Wed, 05 November 2008 23:12 Go to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi All,
Can you please tell me the Difference between V$parameter and V$parameter2 ?
I browsed the net for quite a while, but they say that V$parameter shows list of parameters currently in effect.
the same definition is given for V$parameter2 as well..
So why have two views then?
Re: Difference between V$parameter and V$parameter2 [message #357582 is a reply to message #357581] Wed, 05 November 2008 23:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SQL> select value from v$parameter where name='control_files';
VALUE
----------------------------------------------------------------------------------------------------------
E:\ORACLE\BASES\MIKA\CONTROL1.CTL, E:\ORACLE\ARCHIVES\MIKA\CONTROL2.CTL, E:\ORACLE\FLASH\MIKA\CONTROL3.CTL

1 row selected.

SQL> select value from v$parameter2 where name='control_files';
VALUE
----------------------------------------------------------------------------------------------------------
E:\ORACLE\BASES\MIKA\CONTROL1.CTL
E:\ORACLE\ARCHIVES\MIKA\CONTROL2.CTL
E:\ORACLE\FLASH\MIKA\CONTROL3.CTL

3 rows selected.

Regards
Michel
Re: Difference between V$parameter and V$parameter2 [message #357587 is a reply to message #357582] Wed, 05 November 2008 23:43 Go to previous messageGo to next message
oracle_me
Messages: 59
Registered: March 2008
Member
Hi Michel,
Thanks for your promptness!
So I think that all the parameter names in both the views are the same.. the only difference as you pointed out is with respect to control files.
It is one line in v$parameter and three liens in V$parameter2.
any reason why it is like this..
and why do we need two views then ???? Confused

[Updated on: Thu, 06 November 2008 00:14]

Report message to a moderator

Re: Difference between V$parameter and V$parameter2 [message #357616 is a reply to message #357587] Thu, 06 November 2008 01:09 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There are other list parameters.
Why 2 views? Some prefer having a list, some prefer having several values.
Choose your prefered way.

Regards
Michel
Previous Topic: Log Destination
Next Topic: Global Temporary Tablespace
Goto Forum:
  


Current Time: Tue Dec 03 05:17:41 CST 2024