Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5648

Improve LogMiner query performance by reducing REGEXP_LIKE disjunctions

    XMLWordPrintable

Details

    Description

      The Oracle connector presently takes every schema and table include value and builds a REGEXP_LIKE predicate for each entry. This can lead to poor performance when a large number of tables or schemas are being specified. We should look to build this expression using a singular REGEXP_LIKE predicate for schema include/excludes and one for table include/excludes or pulling this logic into the connector's Java code for better performance.

      Attachments

        Issue Links

          causes

          Bug - A problem that impairs or prevents the functions of the product. DBZ-6125 Offsets are not advanced in a CDB deployment with low frequency of changes to PDB

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed

          Task - Represents a small unit of work that is not end-user facing. DBZ-6318 Remove outdated information about SYS user accounts with Oracle

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Closed
          is related to

          Feature Request - Feature requests from customers and/or users DBZ-6254 Introduce LogMiner query filtering modes

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Bug - A problem that impairs or prevents the functions of the product. DBZ-3971 Lag from source too high in Debezium Oracle

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Open

          Bug - A problem that impairs or prevents the functions of the product. DBZ-4470 The debezium-connector-oracle quite slow

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Open

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: