Performance Oracle DB Connections

[pda...@gmail.com]

Hello-

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.

Loop {

   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!

[Yamuna Reddy]

hi 

       u done this task.i have some issue can you please help me