Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ADF Library page takes huge time to load.

PrakashCApr 18 2022

Hi,
I am struggling to find the slowness cause for the jsff page rendered from library taskflow (only one large page is called depending on some variable). The page takes more that 20 seconds to generate & sometimes takes even longer. The WebLogic admins have observed one fact.- As the sessions go up, the rendering gets slower.
Earlier, we though it could be firewall or the network issue. But there is nothing clearly traced out yet.
It is also hard to pin point the time when the application suddenly got slow. The database queries do not seem to be running slow
Locally, when I run from my desktop, the rendering is quick, even if I connect to production database.
I will appreciate suggestions on how we could proceed in resolving this issue.

JDeveloper version user - 12.2.1.3
Weblogic version 12.2.1.3

Regards,
Prakash

Comments

Timo Hahn

This kind of problem is hard to track. For us, it's impossible as we don't see anything. For you, it's very hard too. My advice is to look at the GC (garbage collection) on the server. Track this over time and try to find out, if high GC times are corresponding with slow response times.
What exactly do you mean by 'if session go up'?
Do you see a linear increase for rendering the page?
Have you checked the number of active sessions?
What about activation/passivation of sessions?

Timo

PrakashC

Hi Timo,
Thank you for you response.
with 'Session going up' , I did mean active session.
activation & passivization setting have not been changed from the default.
If I have correctly understood from the Admins, with 2-3 active sessions the response time is not so bad. It gets worse when the active sessions go above 15.
Just in case if this additional info helps.
the DB connection settings on the Weblogic are as follow
Initial Capicity 20
Maximum Capacity 250
Minimum Capacity 20
Statement Cache Type : LRU
Statement Cache Size 10

We have a schedule to restart the managed-server once a week. Not sure, but just my thought, if GC was an issue, then the response would have been fast at-least for couple of days after the restart. However, this is not something that is observed.

Regards,
Prakash

Shay Shmeltzer-Oracle

You might want to use the ADF logger to track the exact activities happening when the page load:
Using the ADF Logger
and
https://blogs.oracle.com/groundside/post/adventures-in-adf-logging-part-5 (and the 4 previous posts in this series).

dvohra21

Clearly it is a resource (CPU and RAM) usage issue - more the sessions less the resource allocated to each session, which causes slowness. Get a higher resource system.

PrakashC

Thank you Shay, Deepak.
I will go through the suggested link & try out.
Regards,
Prakash

PrakashC

Hi Shay,
I tried to do the Analyze logs as documented by Duncan Mills. However, I could not find any delays in the Query response. I also tried to investigate into the diagnostic logs. I do not see any wait in the logging.
I then tried to add a custom phase-listener to check which phase is taking the longest. I see that even on my local, there is lot of time spent between "prepareRender" and "jsfRenderResponse". It is taking 7 seconds (without FINEST logging) even on my local.

Regards,
Prakash

1 - 6

Post Details

Added on Apr 18 2022
6 comments
435 views