YRC (you recall correctly) -- TAF does not work for program units (i.e. PL/SQL), DML (i.e. INSERT, UPDATE, DELETE, SELECT ... FOR UPDATE), DDL (i.e. CREATE, ALTER, DROP, TRUNCATE, GRANT, REVOKE, etc), but only for idle sessions and SELECT statements...
Yechiel Adar wrote:
IIRC (and I mean a big if) - TAF works only for select statements. Adar Yechiel Rechovot, Israel Ujang Jaenudin wrote:all,I have a simple procedure which contain only select statement and print a result. when executing that procedure let say on node 1 (RAC - 3 nodes), and I shutdown abort on node 1 (failover simulatiion),I got ORA-25408 consistently.session successfully failedover to other node, but the execution of procedure is stopped.Is it expected behavior or a bug?? i found bug no. 6767933 so far... thanks for your sharing... -- regards ujang-- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l