<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[jiehave的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/jiehave</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; jiehave]]></copyright><item><title><![CDATA[eclipse.ini内存设置]]></title><link>https://blog.youkuaiyun.com/jiehave/article/details/18990907</link><guid>https://blog.youkuaiyun.com/jiehave/article/details/18990907</guid><author>jiehave</author><pubDate>Sat, 08 Feb 2014 17:55:30 +0800</pubDate><description><![CDATA[-vmargs -Xms128M -Xmx512M -XX:PermSize=64M -XX:MaxPermSize=128M 
这里有几个问题：
1. 各个参数的含义什么？
2. 为什么有的机器我将-Xmx和-XX:MaxPermSize都设置为512M之后Eclipse可以启动，而有些机器无法启动？
3. 为何将上面的参数写入到eclipse.ini文件Eclipse没有执行对应的设置]]></description><category></category></item><item><title><![CDATA[oracle 体系结构]]></title><link>https://blog.youkuaiyun.com/jiehave/article/details/18989857</link><guid>https://blog.youkuaiyun.com/jiehave/article/details/18989857</guid><author>jiehave</author><pubDate>Sat, 08 Feb 2014 17:25:38 +0800</pubDate><description><![CDATA[三、oracle 体系结构

1、oracle内存由SGA+PGA所构成
2、oracle数据库体系结构
数据库的体系结构是指数据库的组成、工作过程与原理，以及数据在数据库中的组织与管理机制。

 
   
oracle工作原理：
1)、在数据库服务器上启动Oracle实例；
2)、应用程序在客户端的用户进程中运行，启用Oracle网络服务驱动器与服务器建立连接；
3)、服务]]></description><category></category></item><item><title><![CDATA[WHEN T6.START_END_DIFF <= 20 THEN]]></title><link>https://blog.youkuaiyun.com/jiehave/article/details/14449067</link><guid>https://blog.youkuaiyun.com/jiehave/article/details/14449067</guid><author>jiehave</author><pubDate>Thu, 07 Nov 2013 12:27:56 +0800</pubDate><description><![CDATA[小心case when 里面的判断
SELECT T7.XXC_TYPE,
               T7.EVENT_ID,
               DECODE(T7.DIS_END, 0, 1, 0) COL0,
               DECODE(T7.DIS_END, 1, 1, 0) COL1,
               DECODE(T7.DIS_EN]]></description><category></category></item><item><title><![CDATA[行转列技巧一]]></title><link>https://blog.youkuaiyun.com/jiehave/article/details/12022643</link><guid>https://blog.youkuaiyun.com/jiehave/article/details/12022643</guid><author>jiehave</author><pubDate>Wed, 25 Sep 2013 17:29:04 +0800</pubDate><description><![CDATA[--优化前
SELECT * FROM(
    SELECT t.dept_name,t.dept_code,'基本值' RTYPE,SUM(t.zh_basic_value) qn,
      SUM(decode(t.mon,1,t.zh_basic_value)) mon1,
      SUM(decode(t.mon,2,t.zh_basic_value)) mon2,
 ]]></description><category></category></item><item><title><![CDATA[使用merge into 优化update]]></title><link>https://blog.youkuaiyun.com/jiehave/article/details/12001931</link><guid>https://blog.youkuaiyun.com/jiehave/article/details/12001931</guid><author>jiehave</author><pubDate>Wed, 25 Sep 2013 09:57:48 +0800</pubDate><description><![CDATA[MERGE INTO DMS_CRC_EVENT_SD_TRANS t1 
USING DMS_CRC_JL_EVENT_BASIC t2
ON(
   to_char(t2.power_on_time,'yyyy-mm-dd')=to_char(t1.outage_end_time,'yyyy-mm-dd') AND
   to_char(t2.power_off_time,'yyyy-]]></description><category></category></item><item><title><![CDATA[ORA的资源限制的设置]]></title><link>https://blog.youkuaiyun.com/jiehave/article/details/9927337</link><guid>https://blog.youkuaiyun.com/jiehave/article/details/9927337</guid><author>jiehave</author><pubDate>Mon, 12 Aug 2013 15:39:32 +0800</pubDate><description><![CDATA[前两天用了一下Oracle的PROFILE限制用户资源计划的功能，略有心得，简单总结一下。




资源限制包括一下几种：

SQL> SELECT * FROM DBA_PROFILES WHERE PROFILE = 'PRO_1' AND RESOURCE_TYPE = 'KERNEL';

PROFILE RESOURCE_NAME RESOURCE LIMIT
---]]></description><category></category></item><item><title><![CDATA[2013开发DBA、系分考试]]></title><link>https://blog.youkuaiyun.com/jiehave/article/details/9857183</link><guid>https://blog.youkuaiyun.com/jiehave/article/details/9857183</guid><author>jiehave</author><pubDate>Fri, 09 Aug 2013 16:10:28 +0800</pubDate><description><![CDATA[2013开发DBA、系分考试，待更新]]></description><category></category></item></channel></rss>