OraFAQ Forum: RAC & Failsafe » RAC and its behaviour

Home » Server Options » RAC & Failsafe » RAC and its behaviour

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

RAC and its behaviour [message #567299]

Wed, 26 September 2012 06:12

piotrtal
Messages: 152
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:

select * from test;

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:

exec dotest;

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

Report message to a moderator