When is Oracle statement not serializable?


Development & Middleware

Date and time

Friday, 16. October 2015., 09:40


Hall 5 Apartmants



Oracle transaction is NOT serializable by default, because the default is ISOLATION LEVEL READ COMMITED. If we want the transaction to be serializable, we must explicitly state SET TRANSACTION ISOLATION LEVEL SERIALIZABLE. Unlike the transaction, Oracle SELECT and DML statements are by default serializable (statement-level read consistency). This means that the statement does not see anything that was created after it starts, even if it is COMMIT-ed. The lecture will show the exceptions, which can create data inconsistencies.

Lecture details

Type: Lecture
Level of difficulty: Detailed
Experience Level: Experienced
Desirable listeners function: Developers , DBA

About speaker


The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Facebook

Follow us on Twitter

Keep yourself up to date with all updates!

Best Sponsor

Better Sponsor

Good Sponsor

Media Sponsor