Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SET ISOLATION TO DIRTY READ

389987May 6 2003 — edited May 6 2003
hi,

how to convert the informix statement SET ISOLATION TO DIRTY READ to ORACLE.
Regards,
Gopu

Comments

JustinCave
Don't. Oracle doesn't support an isolation level of dirty read-- it will only allow you to read committed data. The reason the dirty read isolation level exists is that in most databases, writers block readers, so you can reduce lock contention by allowing dirty reads. Since Oracle will never block readers, there's no benefit to this isolation level, so Oracle doesn't support it.

Justin
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 3 2003
Added on May 6 2003
#general-database-discussions
1 comment
323 views