Thu, 28 Aug 2008 15:57:00 GMTJUST DO IThttp://blog.csdn.net/kj110/http://blog.csdn.net/kj110/archive/2008/08/28/2844203.aspxhttp://blog.csdn.net/kj110/comments/2844203.aspx0http://blog.csdn.net/kj110/comments/commentRss/2844203.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=28442031. /*+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. /<img src ="http://blog.csdn.net/kj110/aggbug/2844203.aspx" width = "1" height = "1" />Thu, 28 Aug 2008 23:57:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2008/08/28/2844203.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2008/08/28/2844203.aspx骄阳似火http://blog.csdn.net/kj110/archive/2008/07/28/2725919.aspxhttp://blog.csdn.net/kj110/comments/2725919.aspx0http://blog.csdn.net/kj110/comments/commentRss/2725919.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2725919一：分析函数over Oracle从8.1.6开始提供分析函数，分析函数用于计算基于组的某种聚合值，它和聚合函数的不同之处是 对于每个组返回多行，而聚合函数对于每个组只返回一行。 <img src ="http://blog.csdn.net/kj110/aggbug/2725919.aspx" width = "1" height = "1" />Tue, 29 Jul 2008 01:13:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2008/07/28/2725919.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2008/07/28/2725919.aspx骄阳似火http://blog.csdn.net/kj110/archive/2008/03/06/2154361.aspxhttp://blog.csdn.net/kj110/comments/2154361.aspx0http://blog.csdn.net/kj110/comments/commentRss/2154361.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2154361成交量指的是在一定的交易时间内某种商品期货在交易所成交的合约数量。在国内期货市场，计算成交量采用买入与卖出量两者之和。<img src ="http://blog.csdn.net/kj110/aggbug/2154361.aspx" width = "1" height = "1" />Fri, 07 Mar 2008 00:07:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2008/03/06/2154361.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2008/03/06/2154361.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/11/06/1869014.aspxhttp://blog.csdn.net/kj110/comments/1869014.aspx0http://blog.csdn.net/kj110/comments/commentRss/1869014.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1869014常用的性能监控命令 机器性能优化主要从四个方面去考虑：CPU，内存，磁盘I/O，网络。 1， CPU sar命令 <img src ="http://blog.csdn.net/kj110/aggbug/1869014.aspx" width = "1" height = "1" />Tue, 06 Nov 2007 18:09:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/11/06/1869014.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2007/11/06/1869014.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/09/26/1801236.aspxhttp://blog.csdn.net/kj110/comments/1801236.aspx0http://blog.csdn.net/kj110/comments/commentRss/1801236.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1801236truncate是oracle中独有的关键字吧！它的作用是清空一个表格，在删除数据方面，其与delete有一些区别，以便自己记住： <img src ="http://blog.csdn.net/kj110/aggbug/1801236.aspx" width = "1" height = "1" />Wed, 26 Sep 2007 19:06:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/09/26/1801236.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2007/09/26/1801236.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/09/26/1801231.aspxhttp://blog.csdn.net/kj110/comments/1801231.aspx0http://blog.csdn.net/kj110/comments/commentRss/1801231.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1801231Oracle USERENV和sys_context <img src ="http://blog.csdn.net/kj110/aggbug/1801231.aspx" width = "1" height = "1" />Wed, 26 Sep 2007 19:04:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/09/26/1801231.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2007/09/26/1801231.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/06/04/1637265.aspxhttp://blog.csdn.net/kj110/comments/1637265.aspx0http://blog.csdn.net/kj110/comments/commentRss/1637265.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1637265硬件环境: RP8400 + VA7400 + DS2405 + LTO LIBRARY +HP FC SWITCH 8B OS : HP UNIX 11I 软件环境: SANMGR + HP OMNIBACK <img src ="http://blog.csdn.net/kj110/aggbug/1637265.aspx" width = "1" height = "1" />Mon, 04 Jun 2007 19:11:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/06/04/1637265.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2007/06/04/1637265.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/05/23/1621981.aspxhttp://blog.csdn.net/kj110/comments/1621981.aspx0http://blog.csdn.net/kj110/comments/commentRss/1621981.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1621981chmod +x p_welltool_place.sh //为当前用户添加权限awk -F"||" '{ print NF }' $filename //检查抽数结果<img src ="http://blog.csdn.net/kj110/aggbug/1621981.aspx" width = "1" height = "1" />Wed, 23 May 2007 18:06:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/05/23/1621981.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2007/05/23/1621981.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/04/28/1588684.aspxhttp://blog.csdn.net/kj110/comments/1588684.aspx0http://blog.csdn.net/kj110/comments/commentRss/1588684.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1588684常用的 regular expression <img src ="http://blog.csdn.net/kj110/aggbug/1588684.aspx" width = "1" height = "1" />Sat, 28 Apr 2007 22:08:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/04/28/1588684.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2007/04/28/1588684.aspx骄阳似火http://blog.csdn.net/kj110/archive/2007/04/28/1588682.aspxhttp://blog.csdn.net/kj110/comments/1588682.aspx0http://blog.csdn.net/kj110/comments/commentRss/1588682.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1588682sed awk grep 习题练习 <img src ="http://blog.csdn.net/kj110/aggbug/1588682.aspx" width = "1" height = "1" />Sat, 28 Apr 2007 22:07:00 +0800骄阳似火http://blog.csdn.net/kj110/archive/2007/04/28/1588682.aspx#Feedbackhttp://blog.csdn.net/kj110/archive/2007/04/28/1588682.aspx骄阳似火