{"id":564,"date":"2023-11-21T17:18:36","date_gmt":"2023-11-21T17:18:36","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?p=564"},"modified":"2023-11-21T17:18:38","modified_gmt":"2023-11-21T17:18:38","slug":"oracle-12c-new-features-06-aq-enhancements","status":"publish","type":"post","link":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/","title":{"rendered":"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS"},"content":{"rendered":"\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ordba.net\/rdbmsimages\/a2.jpg\" alt=\"\"\/><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SrinivasMaddali&nbsp;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Database Advanced Queuing Enhancements<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The following sections describe Oracle Database Advanced Queuing (AQ) improvements.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>JMS Bulk Message Purging<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Streams Advanced Queuing (AQ) JMS uses partitioned tables beginning in Oracle Database 12c Release 1 (12.1). Oracle Java Message Service (JMS) messages are purged by truncating partitions instead of row-at-a-time deletes. This feature provides increased performance and reduced overhead.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>JMS Event-Driven Listener<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">AQ Java Message Service (AQ JMS) listener no longer requires open connections dedicated to listening for new JMS messages. Polling across multiple queues is not required. This feature improves AQ JMS performance and scalability and reduces overhead.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>JMS Message Priorities, Exception Queues, and Expiration<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">AQ JMS supports priorities, exception queues, and message expiration differently than in prior releases. This feature improves AQ JMS performance, reduces overhead, and provides better standards compliance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>JMS Transactional Non-persistent Queues<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this release, AQ JMS supports transactional nonpersistent queues instead of emulating them with persistent queues.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This feature provides AQ JMS with better performance, scalability, reduced overhead, and better standards compliance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Message Forwarding on Oracle RAC<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Advanced Queuing (AQ) on Oracle RAC is now sharded to avoid unnecessary exchange of blocks between instances. Tunable message forwarding is also supported on Oracle RAC. This feature improves AQ performance and scalability.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>AQ Rules Engine Fast Evaluation of SYS_CONTEXT and Other Predicates<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">AQ rules engine has been enhanced to provide faster evaluation of expressions such as BITAND, CEIL, FLOOR, LENGTH, POWER, CONCAT, LOWER, UPPER, INSTR, SYS_CONTEXT, and UID. This feature improves AQ performance and scalability.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Rules Engine Result Cache<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The rules engine introduces a result cache to improve the performance of many commonly used rules. The result cache bypasses the evaluation phase if an expression with the same attributes has already been evaluated. This feature provides performance improvement by caching the results of rule evaluations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sharded Queues for Performance and Scalability<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Streams Advanced Queuing (AQ) now has queue tables that are partitioned. Partitioned tables form part of the foundation to scale and increase performance of AQ, especially on Oracle RAC or Exadata.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Simplified Metadata and Schema<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">AQ now has fewer tables and supports objects to support sharded queues. This feature provides improvement in performance, scalability, and manageability.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS SrinivasMaddali&nbsp; Oracle Database Advanced Queuing Enhancements The following sections describe Oracle Database Advanced Queuing (AQ) improvements. JMS Bulk Message Purging Oracle Streams Advanced Queuing (AQ) JMS uses partitioned tables beginning in Oracle Database 12c Release 1 (12.1). Oracle Java Message Service (JMS) messages are purged by truncating &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/\"> <span class=\"screen-reader-text\">ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":504,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS - Ordba<\/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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS - Ordba\" \/>\n<meta property=\"og:description\" content=\"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS SrinivasMaddali&nbsp; Oracle Database Advanced Queuing Enhancements The following sections describe Oracle Database Advanced Queuing (AQ) improvements. JMS Bulk Message Purging Oracle Streams Advanced Queuing (AQ) JMS uses partitioned tables beginning in Oracle Database 12c Release 1 (12.1). Oracle Java Message Service (JMS) messages are purged by truncating &hellip; ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-21T17:18:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T17:18:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/article-3-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\n\t<meta property=\"og:image:height\" content=\"700\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ordba\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ordba\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/\",\"name\":\"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-21T17:18:36+00:00\",\"dateModified\":\"2023-11-21T17:18:38+00:00\",\"author\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\"},\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\",\"name\":\"ordba\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"caption\":\"ordba\"},\"sameAs\":[\"https:\/\/test.samplewebsitelink.com\/ordba\"],\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS - Ordba","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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/","og_locale":"en_US","og_type":"article","og_title":"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS - Ordba","og_description":"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS SrinivasMaddali&nbsp; Oracle Database Advanced Queuing Enhancements The following sections describe Oracle Database Advanced Queuing (AQ) improvements. JMS Bulk Message Purging Oracle Streams Advanced Queuing (AQ) JMS uses partitioned tables beginning in Oracle Database 12c Release 1 (12.1). Oracle Java Message Service (JMS) messages are purged by truncating &hellip; ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS Read More &raquo;","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/","og_site_name":"Ordba","article_published_time":"2023-11-21T17:18:36+00:00","article_modified_time":"2023-11-21T17:18:38+00:00","og_image":[{"width":700,"height":700,"url":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/article-3-1.jpg","type":"image\/jpeg"}],"author":"ordba","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ordba","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/","name":"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-21T17:18:36+00:00","dateModified":"2023-11-21T17:18:38+00:00","author":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f"},"breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/oracle-12c-new-features-06-aq-enhancements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"ORACLE 12C NEW FEATURES 06 \u2013 AQ ENHANCEMENTS"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f","name":"ordba","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","caption":"ordba"},"sameAs":["https:\/\/test.samplewebsitelink.com\/ordba"],"url":"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=564"}],"version-history":[{"count":1,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/564\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/564\/revisions\/565"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media\/504"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/categories?post=564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/tags?post=564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}