<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ghostgant的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ghostgant</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ghostgant]]></copyright><item><title><![CDATA[Spring test TestController 一直不行，没报任何错误]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/17677009</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/17677009</guid><author>ghostgant</author><pubDate>Mon, 30 Dec 2013 11:09:46 +0800</pubDate><description><![CDATA[import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.http.MediaType;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
impo]]></description><category></category></item><item><title><![CDATA[java PreparedStatement需要关闭，不然会内存溢出]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/16860927</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/16860927</guid><author>ghostgant</author><pubDate>Thu, 21 Nov 2013 14:40:38 +0800</pubDate><description><![CDATA[第三方的数据库连接池，使用的时候，获取到Connection之后，使用完成，调用的关闭方法（close()） ，并没有将Connection关闭，只是放回到连接池中，如果调用的这个方法，而没有手动关闭PreparedStatement等，则这个PreparedStatement并没有关闭，这样会使得开发的程序内存急速增长，java的内存回收机制可能跟不上速度，最终造成Out of memory E]]></description><category></category></item><item><title><![CDATA[TCP & UDP 传输层协议区别]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/10848309</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/10848309</guid><author>ghostgant</author><pubDate>Sun, 01 Sep 2013 20:55:13 +0800</pubDate><description><![CDATA[TCP（Transmission Control Protocol，传输控制协议）是基于连接的协议，也就是说，在正式收发数据前，必须和对方建立可靠的连接。一个TCP连接必须要经过三次“对话”才能建立起来，其中的过程非常复杂，我们这里只做简单、形象的介绍，你只要做到能够理解这个过程即可。我们来看看这三次对话的简单过程：主机A向主机B发出连接请求数据包：“我想给你发数据，可以吗？”，这是第一次对话；主]]></description><category></category></item><item><title><![CDATA[五类互联网地址划分]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/10474059</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/10474059</guid><author>ghostgant</author><pubDate>Wed, 28 Aug 2013 21:51:10 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[如何避免“中间人”攻击]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/10418319</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/10418319</guid><author>ghostgant</author><pubDate>Tue, 27 Aug 2013 22:38:21 +0800</pubDate><description><![CDATA[所谓“中间人”工具，就是假冒服务器，接收客户端请求，并且和服务器通讯
 
那么怎么解决这种不安全因数呢，第一种方式就是对数据进行加密：
 
采用基于密匙的安全验证
 
需要依靠密匙，也就是你必须为自己创建一对密匙，并把公用密匙放在需要访问的服务器上。如果你要连接到SSH服务器上，客户端软件就会向服务器发出请求，请求用你的密匙进行安全验证。服务器收到请求之后，先在该服务器上你的主目录下寻]]></description><category></category></item><item><title><![CDATA[JVM之AccessController访问控制器]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/9413991</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/9413991</guid><author>ghostgant</author><pubDate>Mon, 22 Jul 2013 21:53:47 +0800</pubDate><description><![CDATA[package com.shine.jarsigner;

import com.shine.jarsigner.friend.Friend;
import com.shine.jarsigner.stranger.Stranger;


public class Example2c {

	public static void main(String[] args) {
		]]></description><category></category></item><item><title><![CDATA[jvm-jarsigner 使用示例]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/9327037</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/9327037</guid><author>ghostgant</author><pubDate>Sun, 14 Jul 2013 22:48:37 +0800</pubDate><description><![CDATA[package com.shine.jarsigner.stranger;

import java.security.AccessController;
import java.security.PrivilegedAction;

import com.shine.jarsigner.doer.Doer;

public class Stranger implements Doe]]></description><category></category></item><item><title><![CDATA[JVM 代码签名和认证]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/9325491</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/9325491</guid><author>ghostgant</author><pubDate>Sun, 14 Jul 2013 18:28:27 +0800</pubDate><description><![CDATA[JVM 对CLASS文件进行签名：

 
JVM 验签过程：]]></description><category></category></item><item><title><![CDATA[mozilla原代码编译]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/8897972</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/8897972</guid><author>ghostgant</author><pubDate>Tue, 07 May 2013 23:48:18 +0800</pubDate><description><![CDATA[参考文档：https://developer.mozilla.org/en-US/docs/Simple_Firefox_build


Hardware requirements


Mozilla takes time to build. You need a development-class system:

A fast processor, ideally with s]]></description><category></category></item><item><title><![CDATA[汇编：DEBUG常用指令集]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/8689267</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/8689267</guid><author>ghostgant</author><pubDate>Mon, 18 Mar 2013 21:49:51 +0800</pubDate><description><![CDATA[DEBUG常用指令集：
1、查看、修改CPU中寄存器的内容：R命令
2、查看内存中的内容：D命令
3、修改内存中的内容：E命令(可以写入数据、指令，在内存中没有区别)
4、将内存中的内容解释为机器指令和对应的汇编指令：U命令
5、执行CS:IP指向的内存单元出的指令：T命令
6、以汇编指令的形式向内存中写入指令：A命令]]></description><category></category></item><item><title><![CDATA[Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 Conntect by 问题]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/8180258</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/8180258</guid><author>ghostgant</author><pubDate>Tue, 13 Nov 2012 20:49:04 +0800</pubDate><description><![CDATA[SQL：1、connect by 最常见的写法
select SYS_CONNECT_BY_PATH(sal, ',')
  from (select sal,
               ROW_NUMBER() over(PARTITION BY deptno ORDER BY sal) rn,
               ROW_NUMBER() over(PARTITION B]]></description><category></category></item><item><title><![CDATA[Oracle 游标越大，打开的越慢，可以的话，游标定义只需要用到的列]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7624926</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7624926</guid><author>ghostgant</author><pubDate>Fri, 01 Jun 2012 23:41:20 +0800</pubDate><description><![CDATA[也是300万数据的一张表：
--只游标定义一列
declare
    cursor cur_3 is select a.cert_type from ea_cust.cust_info a;
    type t_table is table of varchar2(100);
    c_table t_table;
    to_cust_id varchar2(100);]]></description><category></category></item><item><title><![CDATA[对300万一张表数据，用游标进行循环，不同写法的效率比较]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7624907</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7624907</guid><author>ghostgant</author><pubDate>Fri, 01 Jun 2012 23:27:42 +0800</pubDate><description><![CDATA[1、显示游标
declare
    cursor cur_2 is select a.cust_name from ea_cust.cust_info a;
    cust_id varchar2(100);
    
begin
    open cur_2;
    loop
        fetch cur_2 into cust_id;
        exit w]]></description><category></category></item><item><title><![CDATA[Oracle 对300万表进行删除数据完，导致表的高水位]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7611684</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7611684</guid><author>ghostgant</author><pubDate>Tue, 29 May 2012 10:17:19 +0800</pubDate><description><![CDATA[如何判断是否是表高水位问题：
1、对300万表进行删除数据完，导致表的高水位
2、truncate table 报外键引用，其实关联的外键引用一句删除
3、SELECT * FROM DBA_SEGMENTS WHERE OWNER = 'XXXX' AND SEGMENT_NAME = 'XXXX' ，如果HEADER_BLOCK很大
基本可以确定高水位问题；
 
解决高水位有两种：]]></description><category></category></item><item><title><![CDATA[关于Oracle dbms_stats.gather_table_stats]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7596577</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7596577</guid><author>ghostgant</author><pubDate>Wed, 23 May 2012 23:51:32 +0800</pubDate><description><![CDATA[作用:DBMS_STATS.GATHER_TABLE_STATS统计表,列,索引的统计信息.
DBMS_STATS.GATHER_TABLE_STATS的语法如下:
DBMS_STATS.GATHER_TABLE_STATS (   ownname          VARCHAR2,     tabname          VARCHAR2,     partname         VA]]></description><category></category></item><item><title><![CDATA[Linux 修改IP和网关]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7585039</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7585039</guid><author>ghostgant</author><pubDate>Sun, 20 May 2012 16:46:24 +0800</pubDate><description><![CDATA[直接用命令行修改网关地址：
引用
# vi /etc/sysconfig/network
引用
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=localhost.localdomain
GATEWAY=192.168.0.1
2007-9-26 10:50 
如何更改LINUX的IP地址？
ifconfig eth0 新ip
然后编辑]]></description><category></category></item><item><title><![CDATA[关于rlwrap的使用--Oracle Linux]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7584752</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7584752</guid><author>ghostgant</author><pubDate>Sun, 20 May 2012 14:11:55 +0800</pubDate><description><![CDATA[rlwrap 可以用来支持oracle下sqlplus历史命令的回调功能，提高效率。 
1、  下载
从http://utopia.knoware.nl/~hlub/uck/rlwrap/下载rlwrap-0.37.tar.gz，然后上传到
/tmp 目录下。
 
2、  解压缩安装
[root@localhosttmp]# tar -zxvf rlwrap-0.37.tar.gz]]></description><category></category></item><item><title><![CDATA[关于table logging 和 archive log 两个参数对归档日志起到的作用]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7582541</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7582541</guid><author>ghostgant</author><pubDate>Sat, 19 May 2012 11:22:48 +0800</pubDate><description><![CDATA[一 非归档模式下
D:>sqlplus "/ as sysdba"
数据库版本为9.2.0.1.0
SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 8月 14 10:20:39 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.



连接到:]]></description><category></category></item><item><title><![CDATA[Oracle runstats_pkg 过程性能比较]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7563063</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7563063</guid><author>ghostgant</author><pubDate>Sun, 13 May 2012 21:29:57 +0800</pubDate><description><![CDATA[① create view stats as select a.value,'stats'||b.name from v$mystat a,v$statname b where a.statistic#=b.statistic# union
       select 'latch'||name name,gets from v$latch;
       上面是创建stats视图；

②]]></description><category></category></item><item><title><![CDATA[Oracle TKPROF统计信息工具]]></title><link>https://blog.youkuaiyun.com/ghostgant/article/details/7562441</link><guid>https://blog.youkuaiyun.com/ghostgant/article/details/7562441</guid><author>ghostgant</author><pubDate>Sun, 13 May 2012 16:18:04 +0800</pubDate><description><![CDATA[TKPROF使用步骤
1.设置参数文件
设置三个参数timed_staticstices user_dump_dest max_dump_file_size
timed_staticstices 用于启动或禁止对定时统计信息（如CUP时间、占用时间），以及动态性能表中多种统计信息的收集功能
alter session set timed_statistics true;
alter sy]]></description><category></category></item></channel></rss>