-
编辑 删除
jdbc row-prefetch 导致内存溢出
程序员反映说读取一个大对象时内存溢出故障现象是在rs.execute时就已经溢出了，还没到rs.getblob什么的之前分析jdbc时知道jdbc有fetch size，想到可能还会有prefetch让程序员设置相关jdbc参数再试，果然如此记录...
-
编辑 删除
特殊的游标泄漏问题
[php] con = DriverManager.getConnection(url);//获取数据库的元数据 dma =con.getMetaData();//将数据库中的表的名称转储出来 &nb...
-
编辑 删除
Avoiding fragmentation for ibm jvm
For a large Java? application, such as WebSphere? Application Server, the default kCluster space (for an introduction to kCluster, see Pinned clusters) might not be sufficient to allocate all classblo...
-
编辑 删除
Some basic heap sizing problems of ibm jvm
For the majority of applications, the default settings work well. The heap expands until it reaches a steady state, then remains in that state, which should give a heap occupancy (the amount of...
-
编辑 删除
minimum heap size for ibm jvm
When you have established the maximum heap size that you need, you might want to set the minimum heap size to the same value; for example, -Xms 512M -Xmx 512M. Using the same values is not usually a g...
-
编辑 删除
Frequently asked questions about the Garbage Collector
What are default values for the native stack (-Xss) and Java stack (-Xoss)? The Native stack size is machine-dependent, because it is based on the platform's C stack usage. The Java stack size is 400...
-
编辑 删除
Dynamic Sampling 两种方式的利弊
There are two ways to use dynamic sampling: TheOPTIMIZER_DYNAMIC_SAMPLING parameter can be set at the databaseinstance level and can also be overridden at the session level with theALTER SESSION co...
-
编辑 删除
我的SQL调优公式T＝S/V
比较愚钝，从事调优工作这么些年，处理过的性能问题也不少，也就总结出这么个公式来S指sql所需访问的资源总量，V指sql单位时间所能访问的资源量，T自然就是SQL执行所需时间了这个公式很简单，调优的目标是减少T...
