Version: 10.2.0.4, 11.2
This is what documentation says about BASIC and PRECONNECT
http://download.oracle.com/docs/cd/B28359_01/network.111/b28316/advcfg.htm#i471200
basic: Set to establish connections at failover time. This option requires almost no work on the backup server until failover time.
preconnect: Set to pre-established connections. This provides faster failover but requires that the backup instance be able to support all connections from every supported instance.
So, if i configure PRECONNECT for a client, then for every session created by that session a backup session is created (Preconnected) to another node. That means , if the client creates 100 sessions to NODE1 , then another 100 backup sessions will be connected to Node2 (backup instance). Right?
Will these Preconnected sessions appear in v$session of the backup instance ? If so, how can i determine if an entry in V$SESSION is actually a backup session (Preconnected)?