First page Back Continue Last page Graphics

V$PARAMETER2

V$PARAMETER2
- SAME as V$PARAMETER
- EXCEPT it contains ORDINAL column
- Multiple rows for ordinal-type parameters such as control_files

Notes:

The example above shows the use of the ORDINAL column from the V$PARAMETER2 view. The ORDINAL column shows the order for a value that is contained in a list of values for a single parameter. An example is with the CONTROL_FILES parameter. If you follow the recommendation to have more than one control file then you will have multiple values assigned to this parameter in your init.ora file.

Assuming init.ora contains:
control_files=('c:\oracle\oradata\ora91\control01.ctl',
'c:\oracle\oradata\ora91\control02.ctl')

The v$parameter file does not reveal the ordinal value:
SQL> select name, value from v$parameter
2 where name = 'control_files';

NAME VALUE
-------------- ------------------------------------------------------
control_file c:\oracle\oradata\ora91\control01.ctl, c:\oracle\oradata\ora91\control02.ctl
1 row selected.