Securing Oracle distributed transactions against network failures -

-

i synchronizing table in local database data table on database on opposite side of earth using distributed transactions. networks connected through vpn on internet. of time works fine, when connection disrupted during active transaction, lock preventing job running again. cannot kill locking session. trying returns "ora-00031: session marked kill" , not killed before cycle local database.

the sync job basically

cursor trans_cursor     select col_a, col_b, col_c      remote_mastertable@my_link      updated null;      begin       trans in trans_cursor loop          insert local_mastertable           (col_a, col_b, col_c)         values           (trans.col_a, trans.col_b, trans.col_c);          insert local_detailstable (col_a, col_d, col_e)       select col_a, col_d, col_e       remote_detailstable@my_link       col_a = trans.col_a;      update remote_mastertable@my_link set updated = 1 col_a = trans.col_a;       end loop;     end;

any ideas make sync operation more tolerant network dropouts appreciated. use oracle standard edition one, no enterprise features available.

tia søren

first off, need roll own replication solution? oracle provides technologies streams designed allow replicate data changes 1 system reliably without depending on database link being available. minimizes amount of code have write , amount of maintenance have perform.

assuming application need configured way, oracle have use two-phase commit protocol ensure distributed transaction happens atomically. sounds transactions being left in in-doubt state. should able see information in-doubt transactions in dba_2pc_pending view. should able manually handle in-doubt transaction.


Comments

Post a Comment

Popular posts from this blog

Javascript line number mapping -

-
magically formatted comments change reported line number of javascript errors in browsers; this: //@line n "f" n line number , f file name. unfortunately, //@line appears ungoogleable. know there documentation on feature, , browsers support it? (i found references here , here .) from can find available in mozilla based browsers. it using js_setoptions command can turn these options on or off depending on values passed. https://developer.mozilla.org/en/js_setoptions
Read more

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

php - Mysql PK and FK char(36) vs int(10) -

-
i have read mysql can handle indexes , searches better if tables keys integers rather char(36) uuid's. is worth converting int(10)? note: use 1 server , have have plans use multiple databases concurrently therefore removing 1 of big reasons using uuid. our tables innodb if makes difference. thanks in advance. usually rdbms can handle integer keys pk more efficient, other datatypes. reason how build index column, yes: long dont require string (or other typed) keys, should use integers. however: char(36) , int(10) far away being equal, because int(10) much smaller, char(36). dont know, if require many different keys, should keep in mind. update, complete last paragraph: int(10) 32-bit, char(36) 36 - ^byte^ (= 288-bit). not mean, int consumes less space, means, char(36) has 4 times more different keys.
Read more