Tue, 24 May 2011 10:54:00 GMTJUST DO IThttp://blog.csdn.net/blogrss.aspx?username=kj110http://blog.csdn.net/kj110/archive/2011/05/24/6443179.aspx333<img src="http://www1.feedsky.com/t1/514622743/kj110/csdn.net/s.gif?r=http://blog.csdn.net/kj110/archive/2011/05/24/6443179.aspx" border="0" height="0" width="0" style="position:absolute" />Tue, 24 May 2011 18:54:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2011/05/24/6443179.aspx骄阳似火http://blog.csdn.net/kj110/archive/2011/05/24/6443179.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/514622743/1205539http://blog.csdn.net/kj110/archive/2011/05/20/6435256.aspx333<img src="http://www1.feedsky.com/t1/513582271/kj110/csdn.net/s.gif?r=http://blog.csdn.net/kj110/archive/2011/05/20/6435256.aspx" border="0" height="0" width="0" style="position:absolute" />Fri, 20 May 2011 18:02:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2011/05/20/6435256.aspx骄阳似火http://blog.csdn.net/kj110/archive/2011/05/20/6435256.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513582271/1205539http://blog.csdn.net/kj110/archive/2011/05/19/6432827.aspxwww<img src="http://www1.feedsky.com/t1/513163620/kj110/csdn.net/s.gif?r=http://blog.csdn.net/kj110/archive/2011/05/19/6432827.aspx" border="0" height="0" width="0" style="position:absolute" />Thu, 19 May 2011 18:34:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2011/05/19/6432827.aspx骄阳似火http://blog.csdn.net/kj110/archive/2011/05/19/6432827.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163620/1205539http://blog.csdn.net/kj110/archive/2011/02/09/6175824.aspx如果我们按照示例想得到每个部门薪水值最高的雇员的纪录，可以有四种方法实现：<img src="http://www1.feedsky.com/t1/513163621/kj110/csdn.net/s.gif?r=http://blog.csdn.net/kj110/archive/2011/02/09/6175824.aspx" border="0" height="0" width="0" style="position:absolute" />Wed, 09 Feb 2011 17:29:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2011/02/09/6175824.aspx骄阳似火http://blog.csdn.net/kj110/archive/2011/02/09/6175824.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163621/1205539http://blog.csdn.net/kj110/archive/2011/01/14/6139384.aspxOrchadmin is a command line utility provided by datastage to research on data sets. The general callable format is : $orchadmin [options] [descriptor file]<img src="http://www1.feedsky.com/t1/513163622/kj110/csdn.net/s.gif?r=http://blog.csdn.net/kj110/archive/2011/01/14/6139384.aspx" border="0" height="0" width="0" style="position:absolute" />Fri, 14 Jan 2011 16:35:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2011/01/14/6139384.aspx骄阳似火http://blog.csdn.net/kj110/archive/2011/01/14/6139384.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163622/1205539http://blog.csdn.net/kj110/archive/2010/10/22/5959482.aspx1File and identifiers named according to standards2Header documented with copyright, overview and amendment history3Comments added on amendment history and around code4Use of Transformer Stages avoided if there are more than 500,000 records5Use of multiple Transformer Stages where the logic can be combined into a<img src="http://www1.feedsky.com/t1/513163623/kj110/csdn.net/s.gif?r=http://blog.csdn.net/kj110/archive/2010/10/22/5959482.aspx" border="0" height="0" width="0" style="position:absolute" />Fri, 22 Oct 2010 17:23:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2010/10/22/5959482.aspx骄阳似火http://blog.csdn.net/kj110/archive/2010/10/22/5959482.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163623/1205539http://blog.csdn.net/kj110/archive/2008/08/28/2844203.aspx1. /*+ALL_ROWS*/<br />表明对语句块选择基于开销的优化方法,并获得最佳吞吐量,使资源消耗最小化.<br />例如:<br />SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT'; <br />2. /*+FIRST_ROWS*/<br />表明对语句块选择基于开销的优化方法,并获得最佳响应时间,使资源消耗最小化.<br />例如:<br />SELECT /*+FIRST_ROWS*/ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT';<br /><br />3. /*+CHOOSE*/<br />表明如果数据字典中有访问表的统计信息,将基于开销的优化方法,并获得最佳的吞吐量;<br />表明如果数据字典中没有访问表的统计信息,将基于规则开销的优化方法;<br />例如:<br />SELECT /*+CHOOSE*/ EMP_NO,EMP_NAM,DAT_IN FROM BSEMPMS WHERE EMP_NO='SCOTT';<br /><br />4. /Thu, 28 Aug 2008 15:57:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2008/08/28/2844203.aspx骄阳似火http://blog.csdn.net/kj110/archive/2008/08/28/2844203.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163624/1205539http://blog.csdn.net/kj110/archive/2008/07/28/2725919.aspx一：分析函数over Oracle从8.1.6开始提供分析函数，分析函数用于计算基于组的某种聚合值，它和聚合函数的不同之处是 对于每个组返回多行，而聚合函数对于每个组只返回一行。Mon, 28 Jul 2008 17:13:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2008/07/28/2725919.aspx骄阳似火http://blog.csdn.net/kj110/archive/2008/07/28/2725919.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163625/1205539http://blog.csdn.net/kj110/archive/2008/03/06/2154361.aspx成交量指的是在一定的交易时间内某种商品期货在交易所成交的合约数量。在国内期货市场，计算成交量采用买入与卖出量两者之和。Thu, 06 Mar 2008 16:07:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2008/03/06/2154361.aspx骄阳似火http://blog.csdn.net/kj110/archive/2008/03/06/2154361.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163626/1205539http://blog.csdn.net/kj110/archive/2007/11/06/1869014.aspx常用的性能监控命令 机器性能优化主要从四个方面去考虑：CPU，内存，磁盘I/O，网络。 1， CPU sar命令Tue, 06 Nov 2007 10:09:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/11/06/1869014.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/11/06/1869014.aspxhttp://blog.csdn.net/kj110/feed.aspxcsdn.net/kj110/~1205564/513163627/1205539