When is Oracle statement not serializable?
Track
Development & Middleware
Date and time
Friday, 16. October 2015., 09:40
Room
Hall 5 Apartmants
Duration
30'
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
About speaker
Zlatko Sirotić, author
Zlatko Sirotić, univ.spec.inf., is working in IT for more than 30 years, mainly in ISTRA TECH d.o.o., Pula. He is using Oracle software tools (database, Designer CASE, Forms 4GL, Reports, JDeveloper IDE, Java) for over 20 years. He published expert papers for conferences (HrOUG, CASE, KOM, "Hotelska kuća"), in magazines ("Mreža", "InfoTrend", "Ugostiteljstvo i turizam") and some of his programming solutions were published on the web pages of Quest and Oracle companies.
HrOUG.hr
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! Follow @HrOUG_2015Best Sponsor
Better Sponsor
Good Sponsor
Media Sponsor
