<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[小糖点东京购]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/iteye_2002</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; iteye_2002]]></copyright><item><title><![CDATA[oracle 优化相关的文章]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82650123</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82650123</guid><author>iteye_2002</author><pubDate>Fri, 08 Apr 2016 18:01:30 +0800</pubDate><description><![CDATA[
先占个位置，之后再翻译
 
http://www.oracle.com/technetwork/jp/database/articles/tsushima/tsm09-1598259-ja.html
导致索引不被使用的SQL写法
 
http://tryerror.net/tryerror/wordpress/post-223
Hint写法
...]]></description><category></category></item><item><title><![CDATA[处理大量数据时HashSet比ArrayList有显著性能提高]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82648987</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82648987</guid><author>iteye_2002</author><pubDate>Fri, 18 Mar 2016 12:44:25 +0800</pubDate><description><![CDATA[
package testLocal;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;

public class TestHashSet {

    private static final Simp...]]></description><category></category></item><item><title><![CDATA[LIKE索引，以及全文检索索引]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82643490</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82643490</guid><author>iteye_2002</author><pubDate>Sun, 15 Nov 2015 05:40:13 +0800</pubDate><description><![CDATA[
有空再翻译
通常、Oracle Databaseからデータを検索する際に、文章の途中の文言を検索条件にする場合には、LIKEキーワードを条件指定しているかと思います。
（例） Like 検索SQL&amp;gt; select * from doc where text like '%東京購%' ;

Like検索での中間一致・後方一致の場合（%で始まる条件の時）は索引（INDEX）は使われませ...]]></description><category></category></item><item><title><![CDATA[一些查询TABLESPACE的sql]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82640772</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82640772</guid><author>iteye_2002</author><pubDate>Tue, 15 Sep 2015 19:46:21 +0800</pubDate><description><![CDATA[
原文：http://www.asahi-net.or.jp/~KJ5K-OJM/tech/oracle/db/sql/USER/tablespace.html

# 表領域のサイズを拡張する
 
 表領域にデータファイルを追加しサイズを拡張する
 
        ALTER TABLESPACE tablespace_name ADD DATAFILE filespec SIZE...]]></description><category></category></item><item><title><![CDATA[利用LinkedHashMap生成缓存类]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82639970</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82639970</guid><author>iteye_2002</author><pubDate>Tue, 01 Sep 2015 19:45:04 +0800</pubDate><description><![CDATA[
1. LRU缓存
LRU是Least Recently Used 近期最少使用算法
 
import java.util.LinkedHashMap;
import java.util.Map;

public class LRUCache&amp;lt;K, V&amp;gt; extends LinkedHashMap&amp;lt;K, V&amp;gt; {
	private static final ...]]></description><category></category></item><item><title><![CDATA[JAVA BigDecimal精确计算的世界里没有四舍五入。。。]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82611720</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82611720</guid><author>iteye_2002</author><pubDate>Thu, 25 Dec 2014 17:07:12 +0800</pubDate><description><![CDATA[
对于BigDecimal来说，四舍六入是肯定的，没什么好说的，
但是如果需要做处理的小数位刚好是5，那就看下面的例子吧
 
import java.math.BigDecimal;


public class TestBigDecimal {

	/**
	 * @param args
	 */
	public static void main(String[] arg...]]></description><category></category></item><item><title><![CDATA[struts2.3.x  用validation框架做客户端验证]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82479077</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82479077</guid><author>iteye_2002</author><pubDate>Fri, 22 Feb 2013 16:46:37 +0800</pubDate><description><![CDATA[
首先，XXXXAction-validation.xml里的XML头文件要用新的，否则会报错
 
&amp;lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&amp;gt;

&amp;lt;!DOCTYPE validators PUBLIC 
    &quot;-//Apache Struts//XWork Validator 1.0.2//EN&quot; 
    &quot;http://st...]]></description><category></category></item><item><title><![CDATA[Spring annotation 自动注入（Service,DAO）]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82478679</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82478679</guid><author>iteye_2002</author><pubDate>Wed, 20 Feb 2013 17:49:32 +0800</pubDate><description><![CDATA[
基本上就是用@Component提示Spring生成bean的实例，用@Resource把该bean中用到的其他bean注入（射）进去。。。 好处就是你不用再写spring配置文件了，不用再写set方法了。。。
@Component 相当于&amp;lt;bean id=&quot;xxxx&quot; class=&quot;XXXXX.XXXXX&quot; /&amp;gt;@Resource 相当于&amp;lt;bean&amp;gt;↓使用到的其他对...]]></description><category></category></item><item><title><![CDATA[java连接oracle数据库 返回一个单例连接]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82400013</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82400013</guid><author>iteye_2002</author><pubDate>Tue, 14 Aug 2012 16:46:02 +0800</pubDate><description><![CDATA[import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.PropertyResourceBundle;
import java.util.ResourceBundle;


public class ConnectionCreat...]]></description><category></category></item><item><title><![CDATA[plsql 块一个小例子（循环更新，游标使用）]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82271262</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82271262</guid><author>iteye_2002</author><pubDate>Wed, 25 Jan 2012 14:10:50 +0800</pubDate><description><![CDATA[set echo off
set termout on
set serveroutput on size 10000
set lines 120
set pages 20000
set trimspool on

DECLARE 
	CURSOR C_DR_OPERATION_LOG 
	IS
	    SELECT
	            OPERATION_LOG_NO...]]></description><category></category></item><item><title><![CDATA[sqlplus 生成csv 文件]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82271261</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82271261</guid><author>iteye_2002</author><pubDate>Wed, 25 Jan 2012 14:09:14 +0800</pubDate><description><![CDATA[set echo off             --コンソールメッセージ非表示
set linesize 1000     --列数
set pagesize 0        --不分页
set trimspool on      --SPOOLファイルの行末のスペースを無効
set pause off          --相当于自动回车
set termout off      ...]]></description><category></category></item><item><title><![CDATA[List to Map]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82163991</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82163991</guid><author>iteye_2002</author><pubDate>Fri, 07 Oct 2011 12:56:53 +0800</pubDate><description><![CDATA[/**
* &amp;lt;p&amp;gt;将List变为Map&amp;lt;/p&amp;gt;
* @param list
* @param &amp;lt;V&amp;gt; list的项目
* @param keyField 作为Map的项目
* @return 变换成的Map
* @throws Exception keyField项目没有找到的话，抛出异常
*/
private &amp;lt;V&amp;gt; Map&amp;lt;...]]></description><category></category></item><item><title><![CDATA[ZIP文件解压缩]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82161533</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82161533</guid><author>iteye_2002</author><pubDate>Thu, 29 Sep 2011 16:00:22 +0800</pubDate><description><![CDATA[	public void unZip(File file, String unzipFolder) throws IOException {

		byte b[] = new byte[2048];
		int length;

		ZipFile zipFile = new ZipFile(file, &quot;MS932&quot;);
		@SuppressWarnings(&quot;rawtypes&quot;...]]></description><category></category></item><item><title><![CDATA[最简单的struts2例子]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/82063097</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/82063097</guid><author>iteye_2002</author><pubDate>Mon, 09 May 2011 18:27:38 +0800</pubDate><description><![CDATA[1，先下载struts2的包，google一下
2，建一个动态WEB工程，本例叫test
3，导入最低限度的所需的包，从struts2自带的struts2-blank例子里找（struts-2.2.1.1\apps\struts2-blank\WEB-INF\lib）,导入后就是下面这个样子

 
4，编辑web.xml
&amp;lt;?xml version=&quot;1.0&quot; encoding=...]]></description><category></category></item><item><title><![CDATA[Struts+spring的例子2（源自北京尚学堂教程）]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/81995643</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/81995643</guid><author>iteye_2002</author><pubDate>Mon, 03 Jan 2011 00:55:11 +0800</pubDate><description><![CDATA[ spring+struts的集成(第二种集成方案)
spring+struts的集成(第二种集成方案)
原理：将业务逻辑对象通过spring注入到Action中，从而避免了在Action类中的直接代码查询
1、spring和struts依赖库配置
	* 配置struts
		--拷贝struts类库和jstl类库
		--修改web.xml文件来配置ActionServlet
		...]]></description><category></category></item><item><title><![CDATA[Struts+spring的例子1（源自北京尚学堂教程）]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/81995635</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/81995635</guid><author>iteye_2002</author><pubDate>Sun, 02 Jan 2011 23:43:16 +0800</pubDate><description><![CDATA[ spring+struts的集成(第一种集成方案)
spring+struts的集成(第一种集成方案)
原理：在Action中取得BeanFactory对象，然后通过BeanFactory获取业务逻辑对象
1、spring和struts依赖库配置
	* 配置struts
		--拷贝struts类库和jstl类库
		--修改web.xml文件来配置ActionServlet
		...]]></description><category></category></item><item><title><![CDATA[Flashback间接恢复被删除的tablespace]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/81927183</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/81927183</guid><author>iteye_2002</author><pubDate>Mon, 13 Sep 2010 11:36:53 +0800</pubDate><description><![CDATA[前提，数据库处于archivelog mode
场景如下：
1.开启flashback 
SQL&amp;gt; startup mount
ORACLE instance started.
Total System Global Area  536870912 bytes
Fixed Size                  1262812 bytes
Variable Size    ...]]></description><category></category></item><item><title><![CDATA[得到tablespace使用率的脚本]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/81897387</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/81897387</guid><author>iteye_2002</author><pubDate>Thu, 29 Jul 2010 09:58:51 +0800</pubDate><description><![CDATA[用PLSQL procedure:
CREATE OR REPLACE PROCEDURE GET_TABLESPACE_USAGE (
        m_limit in number default 0
)
AS
BEGIN
    DECLARE
         RunDate      date;
         DatabaseName v$database.nam...]]></description><category></category></item><item><title><![CDATA[Logminer使用方法（10.2.0）]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/81895356</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/81895356</guid><author>iteye_2002</author><pubDate>Thu, 22 Jul 2010 19:02:08 +0800</pubDate><description><![CDATA[


1.  dict_from_online_catalog mode



dict_from_online_catalog具体操作又分为两种：分析online redo logfile，分析archived logfile.

 
 

1.1  
分析online redo logfile

 
准备数据

 建表
create table test_...]]></description><category></category></item><item><title><![CDATA[如何从control file中找到DBID和DBNAME]]></title><link>https://blog.youkuaiyun.com/iteye_2002/article/details/81892064</link><guid>https://blog.youkuaiyun.com/iteye_2002/article/details/81892064</guid><author>iteye_2002</author><pubDate>Tue, 13 Jul 2010 01:40:33 +0800</pubDate><description><![CDATA[第一次在JavaEye写博客，真紧张啊！
  



场景如下：

[ 给定一个坏掉的control file，如何从中找出DBID和DBNAME ] 



方法1： 使用BBED(block browser edit)，dump出control file,从中寻找dbid,dbname






1.1 配置bbed





1.1.1 安装...]]></description><category></category></item></channel></rss>