Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gateway for Informix: Is there a way to issue a "Set lock mode to wait <n>"

Adam vonNiedaMay 17 2010 — edited May 19 2010
Hi folks,

As the subject says, is there any way to issue that statement? We're having some "Could not do a physical-order read to fetch next row" errors, and one of the suggestions has been to issue that statement. We've run stats on the database, we have table locking set to "row", the only other thing I can think of is to set dirty reads, and I don't want to do that.

Thanks for any insight,

-Adam
This post has been answered by Kgronau-Oracle on May 19 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2010
Added on May 17 2010
2 comments
1,433 views