Loading...

XML

Word

Printable

Type: Enhancement
Resolution: Done
Priority: Major
Fix Version/s: 1.9.8.Final, 2.0.1.Final, 2.1.0.Alpha1
Affects Version/s: 1.9.6.Final, 2.0.0.Beta2
Component/s: oracle-connector
Labels:
None

Blocked:
False
Blocked Reason:
None
Ready:
False
Target Release:

2.1.4.GA
Git Pull Request:
https://github.com/debezium/debezium/pull/3938

SFDC Cases Counter:
SFDC Cases Open:
SFDC Cases Links:

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.

causes

DBZ-6125 Offsets are not advanced in a CDB deployment with low frequency of changes to PDB

Closed

DBZ-6318 Remove outdated information about SYS user accounts with Oracle

Closed

is related to

DBZ-6254 Introduce LogMiner query filtering modes

Closed

DBZ-3971 Lag from source too high in Debezium Oracle

Open

DBZ-4470 The debezium-connector-oracle quite slow

Open

Assignee:: Chris Cranford

Reporter:: Chris Cranford

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Created:: 2022/09/23 6:54 PM

Updated:: 2023/04/17 3:22 PM

Resolved:: 2022/11/10 6:26 AM

Details

Description

Attachments

Issue Links

Activity

People

Dates