{"id":1447,"date":"2015-11-04T10:55:39","date_gmt":"2015-11-04T10:55:39","guid":{"rendered":"http:\/\/www.istratech.hr\/en\/?p=1447"},"modified":"2021-07-15T12:33:31","modified_gmt":"2021-07-15T12:33:31","slug":"when-isnt-an-oracle-command-serialisable","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/","title":{"rendered":"When isn&#8217;t an Oracle command serialisable?"},"content":{"rendered":"<p style=\"text-align: center;\"><strong>ABSTRACT<\/strong><\/p>\n<p>Oracle transaction is NOT serializable by default, because the default is ISOLATION LEVEL READ COMMITED.<br \/>\nIf we want the transaction to be serializable, we must explicitly state SET TRANSACTION ISOLATION LEVEL SERIALIZABLE.<br \/>\nUnlike the transaction, Oracle SELECT and DML statements are by default serializable (statement-level read consistency).<br \/>\nThis means that the statement does not see anything that was created after it starts, even if it is COMMIT-ed.<br \/>\nThe lecture will show the exceptions, which can create data inconsistencies.<\/p>\n<div class=\"more\"><a href=\"http:\/\/www.istratech.hr\/wp-content\/uploads\/2015\/11\/HrOUG_2015_2_Sirotic.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>ABSTRACT 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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_themeisle_gutenberg_block_has_review":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[172,330,327],"tags":[],"class_list":["post-1447","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-conferences","category-hroug-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>When isn&#039;t an Oracle command serialisable? &#8211; Istra Tech<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"When isn&#039;t an Oracle command serialisable? &#8211; Istra Tech\" \/>\n<meta property=\"og:description\" content=\"ABSTRACT 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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-04T10:55:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-15T12:33:31+00:00\" \/>\n<meta name=\"author\" content=\"Istratech Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Istratech Admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"When isn&#8217;t an Oracle command serialisable?\",\"datePublished\":\"2015-11-04T10:55:39+00:00\",\"dateModified\":\"2021-07-15T12:33:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/\"},\"wordCount\":90,\"commentCount\":0,\"articleSection\":[\"Blog\",\"Conferences\",\"HrOUG\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/\",\"name\":\"When isn't an Oracle command serialisable? &#8211; Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2015-11-04T10:55:39+00:00\",\"dateModified\":\"2021-07-15T12:33:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/when-isnt-an-oracle-command-serialisable\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"When isn&#8217;t an Oracle command serialisable?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/\",\"name\":\"Istra Tech\",\"description\":\"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\",\"name\":\"Istratech Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"caption\":\"Istratech Admin\"},\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/author\\\/istratech_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"When isn't an Oracle command serialisable? &#8211; Istra Tech","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/","og_locale":"en_US","og_type":"article","og_title":"When isn't an Oracle command serialisable? &#8211; Istra Tech","og_description":"ABSTRACT 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 [&hellip;]","og_url":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/","og_site_name":"Istra Tech","article_published_time":"2015-11-04T10:55:39+00:00","article_modified_time":"2021-07-15T12:33:31+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"When isn&#8217;t an Oracle command serialisable?","datePublished":"2015-11-04T10:55:39+00:00","dateModified":"2021-07-15T12:33:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/"},"wordCount":90,"commentCount":0,"articleSection":["Blog","Conferences","HrOUG"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/","url":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/","name":"When isn't an Oracle command serialisable? &#8211; Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2015-11-04T10:55:39+00:00","dateModified":"2021-07-15T12:33:31+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/when-isnt-an-oracle-command-serialisable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"When isn&#8217;t an Oracle command serialisable?"}]},{"@type":"WebSite","@id":"https:\/\/www.istratech.hr\/en\/#website","url":"https:\/\/www.istratech.hr\/en\/","name":"Istra Tech","description":"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.istratech.hr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d","name":"Istratech Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","caption":"Istratech Admin"},"url":"https:\/\/www.istratech.hr\/en\/author\/istratech_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/1447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/comments?post=1447"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/1447\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=1447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=1447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=1447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}