Yes, my bad.
V$INSTANCE returns only one row even with OPS/RAC (in 8.0 and above). That's normal since it has "... where inst_id = USERENV('Instance')" condition built in. What I was reealy talking about was view GV$INSTANCE - this lists all the instances that have database mounted.
Sorry for the confusion.




Reply With Quote