V$PARAMETER和V$PARAMETER2， V$SYSTEM_PARAMETER和V$SYSTEM_PARAMETER2

前两天，看到有人讨论这几个视图的区别，也查看了一下。除了值不同，还有一个特点。XXX2里面，control_files是分开的，一个文件一行，而XXX里面，就一行，几个文件拼接在一起。

 

在V$PARAMETER， V$SYSTEM_PARAMETER中：

NAME                TYPE VALUE
------------- ---------- --------------------------------------------------------------------------------
control_files          2 /u01/app/oracle/oradata/xxxx/control01.ctl
control_files          2 /u01/app/oracle/oradata/xxxx/control02.ctl
control_files          2 /u01/app/oracle/oradata/xxxx/control03.ctl

 

在V$PARAMETER2， V$SYSTEM_PARAMETER2中：

NAME                TYPE VALUE
------------- ---------- --------------------------------------------------------------------------------
control_files          2 /u01/app/oracle/oradata/xxxx/control01.ctl, /u01/app/oracle/oradata/xxxx/contr

再看看定义：

V$PARAMETER displays information about the initialization parameters that are currently in effect for the session. A new session inherits parameter values from the instance-wide values displayed by the V$SYSTEM_PARAMETER view.

 

V$PARAMETER2 displays information about the initialization parameters that are currently in effect for the session, with each list parameter value appearing as a row in the view. A new session inherits parameter values from the instance-wide values displayed in the V$SYSTEM_PARAMETER2 view.