[oracle-cdc]Optimized slow oracle real-time synchronization

[weAreFriendYo]

#https://github.com/ververica/flink-cdc-connectors/issues/1999 To solve the problem of slow real-time oracle synchronization, add a table name as a query condition, improving query efficiency and reducing memory usage

[e-mhui]

:+1: This PR can improve the speed of querying tableid, but the select operation during the snapshot is still slow.

[superfive666]

Any updates on this issue bug? Encountered the same slowness issue for oracle with large number of tables.

[yuxiqian]

Thanks @weAreFriendYo for the great work! Before this PR could be merged, could you please rebase it with latest master branch?

[github-actions[bot]]

This pull request has been automatically marked as stale because it has not had recent activity for 60 days. It will be closed in 30 days if no further activity occurs.