On Thu, Jun 10, 2021 at 4:06 AM Ayub Khan <ayub.hp@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.