08 2014 档案
摘要:Java堆内存被划分为新生代和年老代两部分,新生代主要使用复制和标记-清除垃圾回收算法,年老代主要使用标记-整理垃圾回收算法,因此java虚拟中针对新生代和年老代分别提供了多种不同的垃圾收集器,JDK1.6中Sun HotSpot虚拟机的垃圾收集器如下:图中如果两个垃圾收集器直接有连线,则表明这两个...
阅读全文
摘要:from http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables007.htm#ADMIN11678In any database system, it is occasionally necessary to modify the ...
阅读全文
摘要:from http://avdeo.com/2012/10/28/redefining-tables-online-oracle-11g/Introduction:One of the many challenges that we face in production environment is...
阅读全文
摘要:from http://octodecillion.com/blog/tomcat7-change-root-app/The default application of a fresh install of Tomcat 7 is ROOT. You want to remove it and u...
阅读全文
摘要:refference:http://www.dba-oracle.com/t_dbms_redefinition_example.htmhttp://www.dba-oracle.com/t_dbms_redefinition.htmThe Oracle online table reorganiz...
阅读全文
摘要:转自http://freewind.me/blog/20111023/479.html我有一个程序,里面有大量的synchronized关键字。我怀疑它们导致的多线程竞争影响了程序的性能。但不知道如何去检测,总不能只凭自己的猜测就去修改它们,万一改到最后发现不是它们的问题,岂不浪费了。用什么工具来测...
阅读全文
摘要:转自http://freewind.me/blog/20111023/482.html刚才在群里介绍了JVisualVM的功能,sungod问:”它能检测到线程死锁吗”所以我专门写了一个简单的死锁程序,看看jvisualvm的反应。这里我考虑的是一种简单的死锁情况:线程1拿到了a的锁,准备拿b的锁;...
阅读全文
摘要:转自http://freewind.me/blog/20111023/491.html使用System.nanoTime()来测量代码的运行时间,但是在使用过程中发现,有时候居然得到了负值,怎么回事?代码如下:public static void main(String[] args) throws...
阅读全文
摘要:JVM最大创建线程数量由JVM堆内存大小、线程的Stack内存大小、系统最大可创建线程数(Java线程的实现是基于底层系统的线程机制来实现的,Windows下_beginthreadex,Linux下pthread_create)三个方面影响。具体如下:-Xms 最小堆内存-Xmx 最大堆内存-Xs...
阅读全文
摘要:此问题在项目中被发现,经查看JDK源码(JDK1.6),String类的public String substring(int beginIndex, int endIndex)的实现让我很意外。想重现这个场景很容易,请看代码。[java] view plaincopyimportjava.util...
阅读全文
摘要:JAVA内存模型对于我们平时开发的业务应用来说,内存应该是访问速度最快的存储设备,对于频繁访问的数据,我们总是习惯把它们放到内存缓存中,有句话不是说么,缓存就像是清凉油,哪里有问题就抹一抹。但是CPU的运算速度比起内存的访问速度还要快几个量级,为了平衡这个差距,于是就专门为CPU引入了高速缓存,频繁...
阅读全文
摘要:转自http://www.cnblogs.com/dennisit/archive/2013/01/01/2841603.htmlLog4j组件构成Log4j由三个重要的组件构成:1.日志信息的优先级(Logger)2.日志信息的输出目的地(Appender)3.日志信息的输出格式(Layout)。...
阅读全文
摘要:由于对float或double 的使用不当,可能会出现精度丢失的问题。问题大概情况可以通过如下代码理解:[java] view plaincopyprint?publicclassFloatDoubleTest{publicstaticvoidmain(String[]args){floatf=20...
阅读全文
摘要:--聚合函数和排名函数都支持OVER()子句--注意区别聚合函数和GROUP BY组合的分组统计SELECTorderid,custid,val,SUM(val)OVER()AStotalvalueFROMSales.OrderValues;10248 85 440.00 1265793.221...
阅读全文
摘要:GROUP BYgroups the result set into summary rows by provided columns. For example, consider below data which contains sales figures by region.GroupName...
阅读全文
摘要:By usingGROUPING SETS()we can specify multiple groupings in a single query.GROUPING SETS()generates the result by producing aUNION ALLset of the resul...
阅读全文
摘要:This is the script I am using to analyze SQL performance. It major contains one SQL only. It can show below information if available. And you can shoo...
阅读全文
摘要:from http://askdba.org/weblog/2008/03/hw-enqueue-contention-with-lob/DefinitionEnqueues are local locks that serialize access to various resources. En...
阅读全文
摘要:There’s at least one bug related to the performance overhead of SQL Baseline Capture and ASH is less than clear with recursive SQLFirst up – apologies...
阅读全文
摘要:from http://www.oracle-scripts.net/moving-tables-and-indexes/REM ################################################REM # Creator: Vincent FenollREM # Cr...
阅读全文
摘要:I was recently reminded of the chaos that can be caused by an unindexed foreign key column when there are corresponding updates or deletes from the pa...
阅读全文
摘要:from http://www.confio.com/logicalread/solving-oracle-enq-tm-contention-wait-events/#.U9msvPmvWy4Recently, I was assisting one of our customers of Ign...
阅读全文
摘要:SummaryThedb file sequential readwait event means that Oracle is waiting while doing asingle-block I/O read. This is the case when reading an index.Li...
阅读全文
摘要:from http://www.oracle-base.com/articles/11g/segment-creation-on-demand-11gr2.phpBasic UsageSegment creation on demand, or deferred segment creation a...
阅读全文