OraFAQ Forum: Server Administration » Difference between V$parameter and V$parameter2

Home » RDBMS Server » Server Administration » Difference between V$parameter and V$parameter2 (Oracle 10g ,Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between V$parameter and V$parameter2 [message #357581]

Wed, 05 November 2008 23:12

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?

Report message to a moderator

Re: Difference between V$parameter and V$parameter2 [message #357582 is a reply to message #357581]

Wed, 05 November 2008 23:25

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

Report message to a moderator

Re: Difference between V$parameter and V$parameter2 [message #357587 is a reply to message #357582]

Wed, 05 November 2008 23:43

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

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

Report message to a moderator

Previous Topic:	Log Destination
Next Topic:	Global Temporary Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 18:55:51 CST 2024