<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[battlehawk]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/battlehawk</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; battlehawk]]></copyright><item><title><![CDATA[Unsupported major.minor version 50.0]]></title><link>https://blog.csdn.net/battlehawk/article/details/38533563</link><guid>https://blog.csdn.net/battlehawk/article/details/38533563</guid><author>battlehawk</author><pubDate>Wed, 13 Aug 2014 11:23:57 +0800</pubDate><description><![CDATA[以下摘自Oracle

****************************************************************************************************************************************

Symptoms
error    java.lang.UnsupportedClassV]]></description><category></category></item><item><title><![CDATA[Oracle Java Stored Procedure调用Unix shell]]></title><link>https://blog.csdn.net/battlehawk/article/details/8641579</link><guid>https://blog.csdn.net/battlehawk/article/details/8641579</guid><author>battlehawk</author><pubDate>Wed, 06 Mar 2013 13:22:44 +0800</pubDate><description><![CDATA[援引：Doc ID 109095.1
首先，在数据库端创建调用Unix shell的java类，用Runtime.getRuntime().exec()实现
1.
CREATE OR REPLACE JAVA SOURCE NAMED "CaptureStream" as 
import java.util.*;
import java.io.*;

class CaptureStr]]></description><category></category></item><item><title><![CDATA[12 SQL自动调优]]></title><link>https://blog.csdn.net/battlehawk/article/details/5727292</link><guid>https://blog.csdn.net/battlehawk/article/details/5727292</guid><author>battlehawk</author><pubDate>Sun, 11 Jul 2010 18:10:00 +0800</pubDate><description><![CDATA[12.1
SQL自动调优概述12.1.1优化器模式1.普通模式对于大部分的SQL语句都会产生一个合理的执行计划。普通模式下，优化器执行操作有一个严格的时间限制，一般在几百毫秒内就必须找到一个很好的执行计划。2.调优模式优化模式下，优化器需要执行额外的分析工作，检验在普通模式下产生的执行计划是否可以得到改进，查询优化器的输出结果不是一个执行计划，而是一系列动作，以及生成一个显著优异计划的理由和预期收益。在调优模式下，优化器能使用数分钟来优化一个单一SQL语句。每次调用自动调优优化器都需要耗费大量的时间和资源]]></description><category></category></item><item><title><![CDATA[11 SQL调优概述]]></title><link>https://blog.csdn.net/battlehawk/article/details/5522200</link><guid>https://blog.csdn.net/battlehawk/article/details/5522200</guid><author>battlehawk</author><pubDate>Fri, 23 Apr 2010 20:41:00 +0800</pubDate><description><![CDATA[11.3调优程序/减轻负载如果期望减轻数据库服务器整体的CPU或者I/O负载，可通过以下步骤确定资源密集型的SQL语句：1.选择在应用程序的处理高峰期检测。2.在以上周期内，收集操作系统及Oracle统计信息。需要收集的Oracle统计信息至少包括文件的I/O（通过视图V$FILESTAT），系统统计信息（V$SYSSTAT），以及SQL统计信息（V$SQLAREA, V$SQ]]></description><category></category></item><item><title><![CDATA[10 使用性能视图调优]]></title><link>https://blog.csdn.net/battlehawk/article/details/5510886</link><guid>https://blog.csdn.net/battlehawk/article/details/5510886</guid><author>battlehawk</author><pubDate>Wed, 21 Apr 2010 12:50:00 +0800</pubDate><description><![CDATA[ 10.2.3表的等待事件及其潜在的原因<table class="FormalWide" style="width: 100%;" title="Wait Events and Potential Causes" dir="ltr" border="1" cellspacing="0" cellpadding="3" frame="hsides" rules="groups" sum]]></description><category></category></item><item><title><![CDATA[7 内存设置]]></title><link>https://blog.csdn.net/battlehawk/article/details/5498787</link><guid>https://blog.csdn.net/battlehawk/article/details/5498787</guid><author>battlehawk</author><pubDate>Sun, 18 Apr 2010 11:41:00 +0800</pubDate><description><![CDATA[7.2 1.高速缓存命中率的计算（Buffer Cache hit ratio）SELECT NAME, VALUEFROM V$SYSSTATWHERE NAME IN (db block gets, consistent gets, physical reads)计算公式：1－(physical reads/(consistent gets+db block g]]></description><category></category></item><item><title><![CDATA[7.5 PGA Memory Management]]></title><link>https://blog.csdn.net/battlehawk/article/details/5493346</link><guid>https://blog.csdn.net/battlehawk/article/details/5493346</guid><author>battlehawk</author><pubDate>Fri, 16 Apr 2010 13:39:00 +0800</pubDate><description><![CDATA[设置一个新的数据库实例初始化参数时，为变量PGA_AGGREGATE_TARGET设定一个适当的值是很难准确知道的，可以通过以下三个步骤设置1：首先为PGA_AGGREGATE_TARGET做一个评估，它的大小可参考SGA的值，一般为其大小的20％，不过这个值对于一个大型决策支撑系统（DSS）来说的话，还是太小。2：数据库实例运行一个代表性的工作量，并且监视其性能，使用oracle收集的P]]></description><category></category></item><item><title><![CDATA[7.3 large pool]]></title><link>https://blog.csdn.net/battlehawk/article/details/5482996</link><guid>https://blog.csdn.net/battlehawk/article/details/5482996</guid><author>battlehawk</author><pubDate>Tue, 13 Apr 2010 22:34:00 +0800</pubDate><description><![CDATA[Performance tuning guide chapter7 oracle建议用大型池（large pool）为共享服务器（shared server）相关的用户全局区域（User Global Area）分配空间，而不是使用共享池（shared pool），因为如果使用共享池分配，则导致用于library cache及dictionary cache的共享池内存下降。将]]></description><category></category></item><item><title><![CDATA[Concept]]></title><link>https://blog.csdn.net/battlehawk/article/details/5471401</link><guid>https://blog.csdn.net/battlehawk/article/details/5471401</guid><author>battlehawk</author><pubDate>Sat, 10 Apr 2010 22:02:00 +0800</pubDate><description><![CDATA[chapter 2 Data blocks,Extents,and Segments 以下sql语句需要临时段create indexselect...order byselect...distinctselect...group byselect...unionselect...intersectselect...minus建议为库创建临时表空间 ]]></description><category></category></item><item><title><![CDATA[Performance Tuning Guide]]></title><link>https://blog.csdn.net/battlehawk/article/details/5471283</link><guid>https://blog.csdn.net/battlehawk/article/details/5471283</guid><author>battlehawk</author><pubDate>Sat, 10 Apr 2010 21:16:00 +0800</pubDate><description><![CDATA[文中注释处以符号"*"加章节数字标记，具体在章节最后统一详细说明。 chapter 6  Automatic performance diagnostics Sql语句中尽量不要直接使用具体变量值进行操作，否则这些sql语句将不被其他用户共享，这样将导致增加额外的并且很耗费数据库时间的硬解析(*6-1)。例如，查询语句类似下面select * from employees]]></description><category></category></item><item><title><![CDATA[两种分页SQL效率比较]]></title><link>https://blog.csdn.net/battlehawk/article/details/5405374</link><guid>https://blog.csdn.net/battlehawk/article/details/5405374</guid><author>battlehawk</author><pubDate>Mon, 22 Mar 2010 18:21:00 +0800</pubDate><description><![CDATA[数据库版本：Oracle9i R9.2.0.6 两种方案：1.select * from (select a.*,rownum rn from (select * from table) a)where rn10;2.select * from (select a.*,rownum rn from (select * from table) a where ro]]></description><category></category></item><item><title><![CDATA[java练习题]]></title><link>https://blog.csdn.net/battlehawk/article/details/5405145</link><guid>https://blog.csdn.net/battlehawk/article/details/5405145</guid><author>battlehawk</author><pubDate>Mon, 22 Mar 2010 17:13:00 +0800</pubDate><description><![CDATA[1.编写一个截取字符串的函数，输入为一个字符串和字节数，输出为按字节截取的字符串。 但是要保证汉字不被截半个，如“我ABC”4，应该截为“我AB”，输入“我ABC汉DEF”，6，应该输出为“我ABC”而不是“我ABC+汉的半个”.    public static String subStringByByte(String str,int byteLenth){        if]]></description><category></category></item><item><title><![CDATA[10g doc]]></title><link>https://blog.csdn.net/battlehawk/article/details/5391071</link><guid>https://blog.csdn.net/battlehawk/article/details/5391071</guid><author>battlehawk</author><pubDate>Wed, 17 Mar 2010 23:40:00 +0800</pubDate><description><![CDATA[Concept http://blog.csdn.net/battlehawk/archive/2010/04/10/5471401.aspxPerformance tuning guide http://blog.csdn.net/battlehawk/archive/2010/04/10/5471283.aspx]]></description><category></category></item><item><title><![CDATA[Unable to install breakpoint in...]]></title><link>https://blog.csdn.net/battlehawk/article/details/5373651</link><guid>https://blog.csdn.net/battlehawk/article/details/5373651</guid><author>battlehawk</author><pubDate>Fri, 12 Mar 2010 13:28:00 +0800</pubDate><description><![CDATA[1.window-->preference-->java-->installed jres中jre使用jdk中的。2.项目的properties中java build path-->libraries-->jre system library选择alternate jre，选择刚刚设置的jre即可。 ]]></description><category></category></item><item><title><![CDATA[IE7 iframe自适应高度]]></title><link>https://blog.csdn.net/battlehawk/article/details/5346292</link><guid>https://blog.csdn.net/battlehawk/article/details/5346292</guid><author>battlehawk</author><pubDate>Thu, 04 Mar 2010 15:56:00 +0800</pubDate><description><![CDATA[					...					<iframe id="left" style="WIDTH: 100%;"				name="left" src="a.html" mce_src="a.html" frameborder="0"  scrolling="yes">										<iframe name="right" id="right" style="w]]></description><category></category></item><item><title><![CDATA[window.close()在firefox中的类似办法]]></title><link>https://blog.csdn.net/battlehawk/article/details/5321021</link><guid>https://blog.csdn.net/battlehawk/article/details/5321021</guid><author>battlehawk</author><pubDate>Tue, 23 Feb 2010 23:39:00 +0800</pubDate><description><![CDATA[前提：此页面是新打开页面例如：a页面代码firefox window.close()b页面代码如下function close(){  window.opener = null;  window.open(,_self);  window.close();}    ]]></description><category></category></item><item><title><![CDATA[AXIS 1.4生成 WebService Client]]></title><link>https://blog.csdn.net/battlehawk/article/details/5318186</link><guid>https://blog.csdn.net/battlehawk/article/details/5318186</guid><author>battlehawk</author><pubDate>Mon, 22 Feb 2010 23:59:00 +0800</pubDate><description><![CDATA[axis 1.4下载地址：http://www.apache.org/dyn/closer.cgi/ws/axis/1_4 将以下包加入classpathaxis.jar;axis-ant.jar;commons-discovery-0.2.jar;commons-logging-1.0.4.jar;jaxrpc.jar;log4j-1.2.8.jar;]]></description><category></category></item><item><title><![CDATA[%836%843%827%F40%832%EB5是什么编码]]></title><link>https://blog.csdn.net/battlehawk/article/details/5303632</link><guid>https://blog.csdn.net/battlehawk/article/details/5303632</guid><author>battlehawk</author><pubDate>Tue, 09 Feb 2010 22:17:00 +0800</pubDate><description><![CDATA[WindowsXP 简体中文操作系统中firefox3.0.1地址栏中直接输入한국어(韩国语)查询http://www.google.cn/search?hl=zh-CN&source=hp&q=한국어&btnG=Google+%CB%D1%CB%F7&aq=f&oq=查询完成后地址栏url会变为http://www.google.cn/search?hl=zh-CN&sour]]></description><category></category></item><item><title><![CDATA[firefox中使用window.createPopup的问题]]></title><link>https://blog.csdn.net/battlehawk/article/details/5301656</link><guid>https://blog.csdn.net/battlehawk/article/details/5301656</guid><author>battlehawk</author><pubDate>Tue, 09 Feb 2010 11:22:00 +0800</pubDate><description><![CDATA[火狐中使用window.createPopup()，兼容ie的解决办法：if (!window.createPopup) {	var __createPopup = function() {		var SetElementStyles = function( element, styleDict ) {			var style = element.style ;			for (]]></description><category></category></item><item><title><![CDATA[按位或“|”在多选中的应用]]></title><link>https://blog.csdn.net/battlehawk/article/details/5271327</link><guid>https://blog.csdn.net/battlehawk/article/details/5271327</guid><author>battlehawk</author><pubDate>Fri, 29 Jan 2010 23:15:00 +0800</pubDate><description><![CDATA[假定有这样一个问题，请从下列选项中选择个人爱好（多选）选项包括：1.爬山2.音乐3.看书4.写作5.唱歌6.打游戏7.上网问题：如何使用1个整数来确定用户所选的爱好？首先，按位或运算的结果是：1|1=11|0=10|1=10|0=0我将上面七个选项分别赋予一个2的倍数，把这个值暂]]></description><category></category></item></channel></rss>