Home » Server Options » RAC & Failsafe » How to manual transport user session from a node to another node in RAC?
How to manual transport user session from a node to another node in RAC? [message #303603] Sat, 01 March 2008 00:52 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

There are 2 node in Oracle RAC.

Node 1:

SQL> select count(sid) from v$session where username='FBDB';

COUNT(SID)
----------
336

Node 2:

SQL> select count(sid) from v$session where username='FBDB';

COUNT(SID)
----------
86

The loading of the node 1 is too heavy. I want to transport some user session to node 2 and decrease node 1 loading. For this, how to do??? Give me some direction.

Thanks.

Re: How to manual transport user session from a node to another node in RAC? [message #303619 is a reply to message #303603] Sat, 01 March 2008 03:25 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
You cannot. If a user is connected to an instance it will remain connected to that instance until it logs off or fail-over to a surviving node.

Possible workarounds:
- SHUTDOWN TRANSACTIONAL to fail-over connections to other nodes
- Change the service (for example, change load balancing goal). See DBMS_SERVICE.
Previous Topic: How to disable oracle autostart function in RAC?
Next Topic: May somebody send me document for installing Oracle10g RAC in Solaris?
Goto Forum:
  


Current Time: Thu Mar 28 07:04:38 CDT 2024