| RAC and its behaviour [message #567299] |
Wed, 26 September 2012 06:12  |
 |
piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa
|
Senior Member |
|
|
Hi,
i did some test with my RAC environment (2 nodes, 10g).
i am using TAF, and users connect with PRECONNECT method and SELECT option.
so teorethically if i invoke something like this on the first node:
where test contains 3 milions rows, and simulate crash of this node. my session will be reconnected on the other one and select will be reinvoked.
and this behaves in my enviromnent as i suspected.
-------------------
but second test was with procedure. i know that DML reinvoking is not supported in RAC so i even didnt try to do this but i thought that maybe procedures execution could be reinvoked in RAC.
lets try this exemplary procedure:
create or replace procedure dotest is
v1 date;
begin
for i in 1..1000000 loop
select sysdate into v1 from dual;
end loop;
end dotest;
when i do:
and crash node on which this procedure was executed, the session hangs and nothing happens. i thought that maybe some ORA will be displayed but during such simulation nothing happened.
is it normal behavior that RAC is not reinvoking procedures after node crash?
thanks
|
|
|
|
| Re: RAC and its behaviour [message #570520 is a reply to message #567299] |
Sun, 11 November 2012 16:52  |
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
|
Senior Member |
|
|
|
Procedure execution does not failover. As stated in the Oracle documentation for SELECT failover, only simple select statements fail over.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
