Re: Transparent Session Migration?

Jeremy,

Thanks. Now it makes much more sense. I think this feature is very 
useful in this case:

(1) Connections have long duration, and
(2) There're lots of connections, or a few connections but they're 
all CPU or memory (but not I/O) intensive.

I would not make use of this feature to automatically shutdown or 
startup an instance when it detects significant load change. If I'm 
given say 4 nodes, why would I keep some down unless I want to do 
some maintenance work? I guess I can save a little on electricity 
bill, but I'd rather do it manually.

BTW, Martin mentioned v$tsm_sessions. It always has some data in it, 
even on non-RAC. This view is mentioned in the new view section of 
the Reference Guide but has no detailed description.

Yong Huang
 

--- On Mon, 5/25/09, Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx> wrote:

> http://download.oracle.com/docs/cd/B14117_01/server.101/b10750/chapter1.htm#sthref230
> Resonance: Reduces costs of operating databases by
> ... 
> Transparent Session Migration: Automatically migrates sessions,
> including all state, from one instance to another, with no impact on
> end-users. Rebalances sessions across instances for load balancing, and
> in preparation for deprovisioning an instance.



      
--
http://www.freelists.org/webpage/oracle-l

Other related posts: