create table t (processed_flag varchar(1));<\/p>\n\n\n\n
\ncreate bitmap index t_idx on t(processed_flag);\n\n<\/p>\n\n\n\n
From Tom Kyte “Expert Oracle Database Architecture – 3rd Edition”<\/p>\n\n\n\n
insert into t values (‘N’);<\/p>\n\n\n\n
declare
\n pragma autonomous_transaction;
\nbegin
\n insert into t values (‘N’);
\n commit;
\nend;
\n\/<\/p>\n\n\n\n
declare
\n*
\nERROR at line 1:
\nORA-00060: deadlock detected while waiting for resource
\nORA-06512: at line 4<\/p>\n","protected":false},"excerpt":{"rendered":"
create table t (processed_flag varchar(1)); create bitmap index t_idx on t(processed_flag); From Tom Kyte “Expert Oracle Database Architecture – 3rd Edition” insert into t values (‘N’); declare pragma autonomous_transaction; begin insert into t values (‘N’); commit; end; \/ declare * ERROR at line 1: ORA-00060: deadlock detected while waiting for resource ORA-06512: at line 4<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1436","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n