On Thu, Jun 10, 2021 at 4:06 AM Ayub Khan <ayub(dot)hp(at)gmail(dot)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
>