I am using this tool to diff on Oracle tables on different Schema but the same database.
I am using to compare more than 50 tables per execution.
Written unix script to loop through the each plan file and execute the diff command.
java -jar diffkit-app.jar -planfiles <planfile><DBFile>
It takes approximately 5 second for each table.
I would prefer to use the same DB connection for all the table instead creating connection every time to improve the performance.
Is there a way to do it by inputting all the plan files with one execution? Or is there any other way to do it.
Advance thanks your Help!