Feature request or enhancement

For feature requests or enhancements, provide this information, please:

Which use case/requirement will be addressed by the proposed feature?

Oracle connector using Infinispan cache. Recently, ticket DBZ-7192 added support for abandoned transaction after time threshold. There are 2 minor enhancements

• when iterating the ISPN cache, the close is not correctly called (ISPN iterator requires that per doc)
• there is no metric to see number of abandoned transaction. There is a list but that cannot be processed through Prometheus. So new metric `debezium.oracle:name=null,type=connector-metrics,attribute=AbandonedTransactionCount` will be published