On Thu, Jun 10, 2021 at 4:06 AM Ayub Khan <ayub...@gmail.com> wrote: > I did profiling of the application and it seems most of the CPU > consumption is for executing the stored procedure. Attached is the > screenshot of the profile >
That is of your tomcat server? If that is really a profile of your CPU time (rather than wall-clock time) then it seems pretty clear your problem is on the client side, so there isn't much that can be done about it on the database server. Cheers, Jeff >