如果Oracle数据库是源数据库,要确保设置大约10000个打开的游标。
Make sure your have around 10000 open cursors setting for the Oracle database if that is the source.
不可重复的读取:A 1中重新打开的游标检索a 2对符合资格的行的更新。
Non-repeatable reads: The reopened cursor in A1 retrieves updates of A2 on qualifying rows.
默认情况下,AUTOCOMMIT处于启用状态,并且所有数据修改过程都将导致执行一次提交操作——该操作在默认情况下将关闭所有打开的游标。
By default, the AUTOCOMMIT mode is on, and any data-modification process causes a commit operation to be performed - which, by default, closes any open cursors.
应用推荐