Posted by dbtan on 3月 24th, 2017 前言
entity manager未关闭造成的影响
spring jpa version:1.10.1
底层hibernate: 5.1.0
场景
某些情况需要自行写sql,然后就用到了EntityManager, 用完之后没有显示的close(==|||)
上线后大量请求超时,偶尔有那么几个请求会快
问题定位
首先确定不是数据库正在的查询慢,目前量还很小,然后找到sql去数据库查询系统确认,查
... ...
<阅读全文>
Posted by dbtan on 9月 15th, 2010 How To Automate Cleanup Of Dead Connections And INACTIVE Sessions [ID 206007.1] Modified 25-JUN-2009 Type HOWTO Status PUBLISHED
PURPOSE
------- This note explains the difference between a dead connection and an
INACTIVE session in v$session
... ...
<阅读全文>
Posted by dbtan on 10月 25th, 2009 今天打算启用一下Oracle Database 11g的Database Control,但提示如下: [[email protected]: ~]$emctl status dbconsoleOC4J Configuration issue. /oracle/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_test7_ccdb not found. 马上来看一下相应目录下,是否有OC4J_DBConsole_test7_ccdb呢? [[email protected]: ~/product/
... ...
<阅读全文>
Posted by dbtan on 9月 8th, 2009 在EXP导出时,出现EXP-00091报错: . . exporting table FRIEND.............. &
... ...
<阅读全文>
Recent Comments