• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by cwbe-wdepoorter · Oct 23, 2012 at 02:23 PM ·

Hibernate list method

Hi

I have a customer that has quite a few long running transactions (>10seconds). When I try to troubleshoot these delays using dynaTrace, I can see that by far most of the time is spent in the List method of the hibernate framework (org.hibernate.impl.SessionImpl.List).

Does anyone know what this means exactly ? Any possible causes ? I spoke to the application owners but they have no idea what can cause this.

I have also attached a screenshot for example.

Kind regards
Wesley

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

3 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by cwbe-wdepoorter · Oct 23, 2012 at 04:46 PM

Thanks both for the replies !

Kind regards
Wesley

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Andreas G. · Oct 23, 2012 at 04:36 PM

Hi Wesley

If the application uses Hibernate the application code itself needs to iterate through the objects stored by Hibernate. There are different APIs in Hibernate that interact with the underlying database. "list" is just one of the methods that retrieves objects from the DB that are later mapped to the Java Objects. So - "list" might not be called directly by the developers as they are interacting with the Mapped Java Objects -but - as we can see with dynaTrace - this is where most of your time is spent when this data is retrieved from the DB.

Please check out the following excellent articles from Alois regarding Hibernate Performance Optimizations - they should help understand on what can go wrong and what to optimize:

  • Part I - Session Cache
  • Part II: Query Cache
  • Part III: Second Level Cache

Andi

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Christopher A. · Oct 23, 2012 at 02:41 PM

Hello Wesley,

We don't see any auto-sensors: are you in a heavily-loaded production environment?
FYI, the list method is used in Hibernate to query the database: it sometimes calls the cache to get the results and performs other kind of things before doing the actual DB call (such as parameters validation). You should maybe work on the auto-sensors to try to get more data about what is going exactly within this method.

Chris

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A