【Eclipse Memory Analyzer】java heap dump文件分析示例

已于 2025-02-27 13:06:39 修改
阅读量8.4k 收藏 21
点赞数 21
CC 4.0 BY-SA版权
分类专栏： # Java 后端 运维 文章标签： java idea MemoryAnalyzer Java dump文件分析 内存溢出原因分析 堆内存溢出 OutOfMemory
于 2023-12-15 20:45:57 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/jjk_02027/article/details/135024648

问题：服务器java应用内存溢出。

文件：java_pid20.hprof  
大小：2.36G

目的：(在不关联具体项目代码的条件下)找出内存溢出原因


# 由于时间关系，只有精华部分，目的只是需要的时候做个引导

1、下载工具Memory Analyzer

https://projects.eclipse.org/projects/tools.mat/downloads

 

2、打开hprof文件

可直接拖进去，工具会自动Parsing heap dump 文件

3、选择分析动作

勾第一个就行，如果之前打开过有分析报告可选第三个
单击确认后会自动出来Leak Suspects（问题原因猜疑结果）

4、定位异常信息

一般第3步出的Leak Suspects 能基本定出问题相关的类及方法（这时还不是最精准的）
位置：Overview-》Reports-》Leak Suspects

如：
Keywords  
  java.lang.Object[]
  org.postgresql.core.v3.QueryExecutorImpl.processResults(Lorg/postgresql/core/ResultHandler;I)V
  QueryExecutorImpl.java:2252

5、点当前Leak Suspects页面下面的Thread Detail

能看到Thead Stack, 从中定位精准的方法：
如：
  at com.sun.proxy.$Proxy241.query***OrderList(Ljava/util/Map;)Ljava/util/List; ()
  at com.***.service.DetailServiceImpl.query***OrderList(Ljava/lang/String;)Ljava/lang/String; (Det**ServiceImpl.java:374)
  
对应的示例：

Thead Stack：
 http-nio-8888-exec-22
  at org.postgresql.core.PGStream.receiveTupleV3()Lorg/postgresql/core/Tuple; (PGStream.java:561)
  at org.postgresql.core.v3.QueryExecutorImpl.processResults(Lorg/postgresql/core/ResultHandler;I)V (QueryExecutorImpl.java:2252)
  at org.postgresql.core.v3.QueryExecutorImpl.execute(Lorg/postgresql/core/Query;Lorg/postgresql/core/ParameterList;Lorg/postgresql/core/ResultHandler;III)V (QueryExecutorImpl.java:323)
  at org.postgresql.jdbc.PgStatement.executeInternal(Lorg/postgresql/core/CachedQuery;Lorg/postgresql/core/ParameterList;I)V (PgStatement.java:481)
  at org.postgresql.jdbc.PgStatement.execute(Lorg/postgresql/core/CachedQuery;Lorg/postgresql/core/ParameterList;I)V (PgStatement.java:401)
  at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(I)Z (PgPreparedStatement.java:164)
  at org.postgresql.jdbc.PgPreparedStatement.execute()Z (PgPreparedStatement.java:153)
  at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(Lcom/alibaba/druid/proxy/jdbc/PreparedStatementProxy;)Z (FilterChainImpl.java:3409)
  at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(Lcom/alibaba/druid/filter/FilterChain;Lcom/alibaba/druid/proxy/jdbc/PreparedStatementProxy;)Z (FilterEventAdapter.java:440)
  at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(Lcom/alibaba/druid/proxy/jdbc/PreparedStatementProxy;)Z (FilterChainImpl.java:3407)
  at com.alibaba.druid.filter.FilterAdapter.preparedStatement_execute(Lcom/alibaba/druid/filter/FilterChain;Lcom/alibaba/druid/proxy/jdbc/PreparedStatementProxy;)Z (FilterAdapter.java:1081)
  at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(Lcom/alibaba/druid/proxy/jdbc/PreparedStatementProxy;)Z (FilterChainImpl.java:3407)
  at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute()Z (PreparedStatementProxyImpl.java:167)
  at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute()Z (DruidPooledPreparedStatement.java:497)
  at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(Ljava/sql/Statement;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List; (PreparedStatementHandler.java:56)
  at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(Ljava/sql/Statement;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List; (RoutingStatementHandler.java:70)
  at sun.reflect.GeneratedMethodAccessor55.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ()
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (Method.java:498)
  at org.apache.ibatis.plugin.Plugin.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (Plugin.java:59)
  at com.sun.proxy.$Proxy266.query(Ljava/sql/Statement;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List; ()
  at sun.reflect.GeneratedMethodAccessor55.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ()
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (Method.java:498)
  at org.apache.ibatis.plugin.Plugin.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (Plugin.java:59)
  at com.sun.proxy.$Proxy266.query(Ljava/sql/Statement;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List; ()
  at sun.reflect.GeneratedMethodAccessor55.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ()
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (Method.java:498)
  at org.apache.ibatis.plugin.Plugin.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (Plugin.java:59)
  at com.sun.proxy.$Proxy266.query(Ljava/sql/Statement;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List; ()
  at org.apache.ibatis.executor.SimpleExecutor.doQuery(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List; (SimpleExecutor.java:57)
  at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/cache/CacheKey;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List; (BaseExecutor.java:267)
  at org.apache.ibatis.executor.BaseExecutor.query(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/cache/CacheKey;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List; (BaseExecutor.java:141)
  at org.apache.ibatis.executor.CachingExecutor.query(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/cache/CacheKey;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List; (CachingExecutor.java:105)
  at org.apache.ibatis.executor.CachingExecutor.query(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List; (CachingExecutor.java:81)
  at sun.reflect.GeneratedMethodAccessor56.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ()
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (Method.java:498)
  at org.apache.ibatis.plugin.Invocation.proceed()Ljava/lang/Object; (Invocation.java:46)
  at com.al.***.nosql.cache.ibatis.QueryCachingExecutorPlugin.intercept(Lorg/apache/ibatis/plugin/Invocation;)Ljava/lang/Object; (QueryCachingExecutorPlugin.java:114)
  at org.apache.ibatis.plugin.Plugin.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (Plugin.java:57)
  at com.sun.proxy.$Proxy265.query(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List; ()
  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Ljava/lang/String;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;)Ljava/util/List; (DefaultSqlSession.java:101)
  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List; (DefaultSqlSession.java:95)
  at sun.reflect.GeneratedMethodAccessor61.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ()
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (Method.java:498)
  at com.al.persistence.ExtSqlSessionTemplate$SqlSessionInterceptor.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (ExtSqlSessionTemplate.java:190)
  at com.sun.proxy.$Proxy48.selectList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List; ()
  at com.al.persistence.ExtSqlSessionTemplate.selectList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List; (ExtSqlSessionTemplate.java:92)
  at org.apache.ibatis.binding.MapperMethod.executeForMany([Ljava/lang/Object;)Ljava/lang/Object; (MapperMethod.java:124)
  at org.apache.ibatis.binding.MapperMethod.execute([Ljava/lang/Object;)Ljava/lang/Object; (MapperMethod.java:90)
  at org.apache.ibatis.binding.MapperProxy.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (MapperProxy.java:40)
  at com.sun.proxy.$Proxy240.query***OrderList(Ljava/util/Map;)Ljava/util/List; ()
  at com.***.***.sodetail.query.bmo.So***OrderQueryBMOImpl.query***OrderList(Ljava/util/Map;)Ljava/util/List; (So***OrderQueryBMOImpl.java:38)
  at com.***.***.sodetail.query.smo.impl.So***OrderQuerySMOImpl.query***OrderList(Ljava/util/Map;)Ljava/util/List; (So***OrderQuerySMOImpl.java:71)
  at sun.reflect.GeneratedMethodAccessor2351.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ()
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (Method.java:498)
  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (AopUtils.java:318)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint()Ljava/lang/Object; (ReflectiveMethodInvocation.java:183)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed()Ljava/lang/Object; (ReflectiveMethodInvocation.java:150)
  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Lorg/aop***liance/intercept/MethodInvocation;)Ljava/lang/Object; (TransactionInterceptor.java:110)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed()Ljava/lang/Object; (ReflectiveMethodInvocation.java:172)
  at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(Lorg/aop***liance/intercept/MethodInvocation;)Ljava/lang/Object; (ExposeInvocationInterceptor.java:90)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed()Ljava/lang/Object; (ReflectiveMethodInvocation.java:172)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object; (JdkDynamicAopProxy.java:202)
  at com.sun.proxy.$Proxy241.query***OrderList(Ljava/util/Map;)Ljava/util/List; ()
  at com.***.***.intf.service.DetailServiceImpl.query***OrderList(Ljava/lang/String;)Ljava/lang/String; (DetailServiceImpl.java:374)
  at sun.reflect.GeneratedMethodAccessor2350.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ()
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (Method.java:498)
  at org.springframework.httpservice.DefHttpServiceMethodHander.invoke(Ljava/lang/Object;Ljava/lang/Object;)Lorg/springframework/httpservice/ResultDecrator; (DefHttpServiceMethodHander.java:16)
  at org.springframework.httpservice.DefHttpService.handleService(Ljava/lang/String;Ljava/lang/String;Ljava/lang/Object;Lorg/springframework/httpservice/RequestFacade;)Ljava/lang/Object; (DefHttpService.java:100)
  at org.springframework.httpservice.HttpServiceExporter.handleRequest(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V (HttpServiceExporter.java:65)
  at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljava/lang/Object;)Lorg/springframework/web/servlet/ModelAndView; (HttpRequestHandlerAdapter.java:49)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V (DispatcherServlet.java:923)
  at org.springframework.web.servlet.DispatcherServlet.doService(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V (DispatcherServlet.java:852)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V (FrameworkServlet.java:882)
  at org.springframework.web.servlet.FrameworkServlet.doPost(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V (FrameworkServlet.java:789)
  at javax.servlet.http.HttpServlet.service(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V (HttpServlet.java:661)
  at javax.servlet.http.HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (HttpServlet.java:742)
  at org.apache.cat***ina.core.ApplicationFilterChain.intern***DoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:231)
  at org.apache.cat***ina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Ljavax/servlet/FilterChain;)V (WsFilter.java:52)
  at org.apache.cat***ina.core.ApplicationFilterChain.intern***DoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:193)
  at org.apache.cat***ina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:166)
  at com.***.nosql.cache.web.ClearCacheInThread.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Ljavax/servlet/FilterChain;)V (ClearCacheInThread.java:31)
  at org.apache.cat***ina.core.ApplicationFilterChain.intern***DoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:193)
  at org.apache.cat***ina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:166)
  at com.linkage.***.web.filter.CharsetEncodeFilter.doFilterIntern***(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljavax/servlet/FilterChain;)V (CharsetEncodeFilter.java:41)
  at com.linkage.***.web.filter.OnceRequestFilter.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Ljavax/servlet/FilterChain;)V (OnceRequestFilter.java:45)
  at org.apache.cat***ina.core.ApplicationFilterChain.intern***DoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:193)
  at org.apache.cat***ina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V (ApplicationFilterChain.java:166)
  at org.apache.cat***ina.core.StandardWrapperV***ve.invoke(Lorg/apache/cat***ina/connector/Request;Lorg/apache/cat***ina/connector/Response;)V (StandardWrapperV***ve.java:199)
  at org.apache.cat***ina.core.StandardContextV***ve.invoke(Lorg/apache/cat***ina/connector/Request;Lorg/apache/cat***ina/connector/Response;)V (StandardContextV***ve.java:96)
  at org.apache.cat***ina.authenticator.AuthenticatorBase.invoke(Lorg/apache/cat***ina/connector/Request;Lorg/apache/cat***ina/connector/Response;)V (AuthenticatorBase.java:493)
  at org.apache.cat***ina.core.StandardHostV***ve.invoke(Lorg/apache/cat***ina/connector/Request;Lorg/apache/cat***ina/connector/Response;)V (StandardHostV***ve.java:137)
  at org.apache.cat***ina.v***ves.ErrorReportV***ve.invoke(Lorg/apache/cat***ina/connector/Request;Lorg/apache/cat***ina/connector/Response;)V (ErrorReportV***ve.java:81)
  at org.apache.cat***ina.v***ves.AbstractAccessLogV***ve.invoke(Lorg/apache/cat***ina/connector/Request;Lorg/apache/cat***ina/connector/Response;)V (AbstractAccessLogV***ve.java:660)
  at org.apache.cat***ina.core.StandardEngineV***ve.invoke(Lorg/apache/cat***ina/connector/Request;Lorg/apache/cat***ina/connector/Response;)V (StandardEngineV***ve.java:87)
  at org.apache.cat***ina.connector.CoyoteAdapter.service(Lorg/apache/coyote/Request;Lorg/apache/coyote/Response;)V (CoyoteAdapter.java:343)
  at org.apache.coyote.http11.Http11Processor.service(Lorg/apache/tomcat/util/net/SocketWrapperBase;)Lorg/apache/tomcat/util/net/AbstractEndpoint$Handler$SocketState; (Http11Processor.java:798)
  at org.apache.coyote.AbstractProcessorLight.process(Lorg/apache/tomcat/util/net/SocketWrapperBase;Lorg/apache/tomcat/util/net/SocketEvent;)Lorg/apache/tomcat/util/net/AbstractEndpoint$Handler$SocketState; (AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Lorg/apache/tomcat/util/net/SocketWrapperBase;Lorg/apache/tomcat/util/net/SocketEvent;)Lorg/apache/tomcat/util/net/AbstractEndpoint$Handler$SocketState; (AbstractProtocol.java:808)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun()V (NioEndpoint.java:1498)
  at org.apache.tomcat.util.net.SocketProcessorBase.run()V (SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(Ljava/util/concurrent/ThreadPoolExecutor$Worker;)V (ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run()V (ThreadPoolExecutor.java:624)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run()V (TaskThread.java:61)
  at java.lang.Thread.run()V (Thread.java:748)

6、看Top Consumers

Overview-》Actions-》Top Consumers

7、Biggest Objects

点第一行（出来菜单）--》Java Basics-》Thread Overview and Stacks

8、展开第一行-》找到Numeric最多的那行再展开
一般可以看到前面几行包含 第 4 步中类：QueryExecutorImpl 关键字


这里注意：
   1、当前页面的堆栈信息列表就像平常打印的异常堆栈一样，最前面的是最底层的方法。
   2、可以看到Numeric最大的行在前面3行中
   3、不要展开Numeric最大的行，因为不需要，而且会很卡
   4、一般按默认排序的情况下展开第一个空Numeric上面的那行就行了
   5、本文示例（第一个空Numeric上面的那行）展开后可以看到  preperedQuery
 

9、 preperedQuery下面key的值为问题对应的sql，右键copy出来如下：

select co.***_***_id as ***OrderId,
        co.***_so_number as ***SoNumber,
        co.staff_id staffId,
        (select s.staff_name from staff s where s.staff_id = co.staff_id) staffName,
        to_char(co.accept_time, 'YYYY-MM-DD HH24:mm:ss') acceptTime,
        co.status_cd statusCd,
        (select os.name from ***_status os where os.status_cd = co.status_cd) statusName,
        to_char(co.status_date, 'YYYY-MM-DD HH24:mm:ss') statusDt,
        co.c***_id c***Id,
        (select c***_name from c*** c where c.c***_id = co.c***_id) c***Name,
        (select ***_number from *** where ***_id = co.***_id) ***Number,
        (select name from *** c1 where c1.***_id = co.***_id) ***Name
        from ***omer_*** co
        where 1=1
    and co.dist***_id = cast(? as DECIMAL)

图示：

10、 preperedParameters下面paramValues的值为sql对应的参数

本示例只有一个参数，参数值为：100000031

图示：

本示例内存溢出的原因：该sql查询结果数据量过大导致。
解决方案：分页查询、增加条件分批查询等。

总结完毕！

最后，感谢朋友燕的分享～

 

其他分析工具

JProfiles


https://www.ej-technologies.com/download/jprofiler/files

 

VisualVM


https://visualvm.github.io/download.html

 

 

【项目实战】通用Web内存优化策略：使用 Eclipse MAT（Memory Analyzer Tool）分析堆转储文件以定位内存泄漏点的详细步骤
本本本添哥
04-27 160
总结问题：通过以上分析，总结出可能存在内存泄漏的对象和相关的代码位置。修复代码：根据总结的问题，对代码进行修改。例如，如果发现某个缓存Map未及时清理，那么在合适的时机添加清理逻辑；如果发现数据库连接未关闭，确保在使用完后及时关闭连接。
JVM常用工具中jmap实现手动进行堆转储(heap dump文件)并使用MAT(Memory Analyzer Tool)进行堆分析-内存消耗分析
BADAO_LIUMANG_QIZHI的博客
07-19 1689
上面讲了jmap的简单使用。下面记录其常用功能，实现堆转储离线文件，并通过三方工具进行可视化查看和分析。性能监控之常见 Java Heap Dump 方法dump heap是诊断与内存相关的问题的重要手段，例如：内存泄漏、垃圾回收问题和java.lang.OutOfMemoryError。同时也是优化内存消耗的重要手段。有非常多的工具可以dump heap，以及分析转储文件，例如：visualVM、Eclipse MAT和 Heap Hero等等。
Eclipse Memory Analyzer (MAT) 相关配置调整
最新发布
weixin_42547014的博客
06-19 366
的版本依旧提示 jdk 版本过低，打开MAT的安装目录，在配置文件。解析内存快照的时候提示内存溢出错误，修改MAT安装目录中的。中添加配置指向JDK即可。
Eclipse memory analyzer
09-08
附上Eclipse Memory Analysis的安装和使用方法地址： https://blog.youkuaiyun.com/wizard_rp/article/details/73266194
JavaCore/HeapDump文件及其分析方法
diekanjing2679的博客
12-08 1626
产生时间Java程序运行时，有时会产生JavaCore及HeapDump文件，它一般发生于Java程序遇到致命问题的情况下。 有时致命问题发生后，Java应用不会死掉，还能继续运行； 但有时致命问题发生，Java进程会死掉；为了能够保留Java应用发生致命错误前的运行状态，JVM在死掉前产生两个文件，分别为JavaCore及HeapDump文件。有何区别JavaCore是关于CPU...
使用 Eclipse Memory Analyzer 进行堆转储文件分析
在实验室——宅出一片未来
12-26 1026
转自IBM DEVELOPER WORKS 对于大型 JAVA 应用程序来说，再精细的测试也难以堵住所有的漏洞，即便我们在测试阶段进行了大量卓有成效的工作，很多问题还是会在生产环境下暴露出来，并且很难在测试环境中进行重现。JVM 能够记录下问题发生时系统的部分运行状态，并将其存储在堆转储 (Heap Dump) 文件中，从而为我们分析和诊断问题提供了重要的依据。 通常内存泄露分析被认为是一...
Java Heap dump文件分析工具jhat简介
热门推荐
铁锚的优快云博客
11-24 5万+
jhat 是Java堆分析工具(Java heap Analyzes Tool). 在JDK6u7之后成为标配. 使用该命令需要有一定的Java开发经验. jhat 命令解析Java堆转储文件,并启动一个 web server. 然后用浏览器来查看/浏览 dump 出来的 heap. jhat 命令支持预先设计的查询, 比如显示某个类的所有实例. 还支持 对象查询语言(OQL, Object Query Language)。 OQL有点类似SQL,专门用来查询堆转储。 OQL相关的帮助信息可以在 jhat
java分析内存泄露工具_Eclipse Memory Analyzer（Java内存泄漏分析工具）
weixin_35059431的博客
02-13 1063
概述一个大型的Java项目也许从开发到测试结束并未发现一些大的问题，但是在生产环境中还是会出现一些非常棘手的问题，如内存泄漏，遇到这样的问题对于一个经验尚浅的开发人员来说难度非常大，好的一点是JVM 能够记录下问题发生时系统的部分运行状态，并将其存储在堆转储 (Heap Dump) 文件中，从而为我们分析和诊断问题提供了重要的依据。接下来介绍的一个工具是 Eclipse Memory Analyz...
Eclipse Memory Analyzer使用技巧
qq_35485206的博客
12-20 4401
分析和了解应用程序的内存使用情况是一项具有挑战性的操作。细微的 logic 错误可能导致侦听器永远不会被处理，最终导致可怕的 OutOfMemory 错误。即使您的应用程序正确处理了所有未使用的对象，它仍可能需要比所需多 10 倍或 100 倍的内存。幸运的是，Eclipse Memory Analyzer (MAT) 可...
eclipse安装memory analyzer工具分析堆转储信息
feinifi的博客
11-17 1469
Memory Analyzer Tools简称mat，eclipse上的安装，有两种办法，有一种直接在Help->Eclipse Marketplace，在弹出框里面，可以搜索memory，出来的工具里面就会有Memory Analyzer，点击install即可。这种方式有一个好处，就是不用关心mat与eclipse的版本对应关系。 还有一种安装方式，就是通过Help->Install New Software，在这个安装向导里面，需要指定mat下载地址，一般而言，我们需...
Eclipse Memory Analyzer
07-17
Eclipse Memory Analyzer：用来检查java内存泄露的工具，版本：1.5.0.x86
javacore\heapdump文件分析工具
07-29
websphere javacore与heapdump文件分析工具，jca是javacore分析工具，ha是heapdump分析工具,需要用jdk1.6打开
heapdump分析工具HeapAnalyzer
02-10
heapdump分析工具------HeapAnalyzer： 2014年1月最新发布 用法： 在命令行执行 java -Xmx500m -jar ha453.jar
Eclipse Memory Analyzer（MAT）
Meng_000000的博客
05-23 5718
1.Eclipse Memory Analyzer（简称MAT）是一个功能丰富且操作简单的JVM Heap Dump分析工具，可以用来辅助发现内存泄漏减少内存占用。 点击下载 2.简单使用 2.1.启动之后打开 File - Open Heap Dump… 菜单，然后选择生成的Heap DUmp文件，选择 “Leak Suspects Report”，然后点击 “Finish” 按钮。 2.2.操作完成之后会显示如图所示界面 1.问题出现的原因是：main线程（线程号为：0xf6560000）中有一个局
Eclipse Memory Analyzer分析内存使用总结
Harry的博客
02-18 1万+
前言 内存泄露和内存溢出的区别：内存泄露从老年代的增长情况看是缓慢上升的， 最终达到老年代上限才会导致溢出，有些内存泄露可能需要很长的时间发生， 所以说内存泄露更隐蔽， 不像内存溢出那样容易暴露(内存溢出直接抛出OOM)， 而且内存长时间得不到释放会导致服务性能越来越差、gc时间变长、响应变慢： 1. 安装 在Eclipse help -> Eclipse Marketplace下搜索Memory: 按照操作流程安装完成，重启Eclipse. 2. 利用MAT分析内存堆 获取Hea.
Java-heap dump 文件分析
qq_43406318的博客
07-06 2385
Java-heap 分析，内存优化，代码优化
Eclipse Memory Analysis的安装和使用
Yampery
06-15 1万+
Eclipse Memory Analysis的安装和使用。
【Eclipse MAT 】Eclipse Memory Analyzer Tool 使用进阶
ooooooooooooooxiaosu的博客
01-27 2058
尽管Java虚拟机可以帮我们对内存进行回收，但是其回收的是Java虚拟机不再引用的对象。很多时候我们使用系统的IO流，Cursor，Receiver如果不及时释放，就会导致内存泄漏，这些场景是常见的，一般开发人员也都能够避免。但是，很多时候内存泄漏的现象不是很明显，比如内部类，Handler相关的使用导致的内存泄漏，或者你使用了第三方library的一些引用，比较消耗资源，但又不是像系统资源那样会引起你足够的注意去手动释放它们。
评论 8
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

飞火流星02027

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值