Num of records in v$instance

[julian]

Originally posted by jmodic
You can definitely have more than one record returned from V$INSTANCE, but only if you are having paralel server (OPS/RAC) configuration on that database.

Jurij, are you telling him that in OPS/RAC, after you issue

select * from v$instance;

then you will have more than 1 record returned? If so, then this is not true.