<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cjsq82346的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cjsq82346</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cjsq82346]]></copyright><item><title><![CDATA[PGA的实际管理，设置和优化]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251082</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251082</guid><author>cjsq82346</author><pubDate>Tue, 08 Nov 2016 15:35:15 +0800</pubDate><description><![CDATA[调优视图:


	1&gt;V$PGA_TARGET_ADVICE.


	2&gt;V$PGA_TARGET_ADVICE_HISTOGRAM

                              ...]]></description><category></category></item><item><title><![CDATA[建立临时表，临时表空间]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251088</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251088</guid><author>cjsq82346</author><pubDate>Tue, 08 Nov 2016 14:50:04 +0800</pubDate><description><![CDATA[临时表语法：


	


	create global temporary table table1(abc varchar2(100)) on commit delete rows


	


	...]]></description><category></category></item><item><title><![CDATA[数据库表,索引(索引组织表,聚簇表,聚簇索引,)]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251087</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251087</guid><author>cjsq82346</author><pubDate>Tue, 08 Nov 2016 13:56:29 +0800</pubDate><description><![CDATA[IOT:


	索引组织表:


	create table iot_address(a varchar2(100) reference emp(a) on delete cascade,b varchar2(...]]></description><category></category></item><item><title><![CDATA[PL/SQL优化]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251078</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251078</guid><author>cjsq82346</author><pubDate>Mon, 07 Nov 2016 15:01:01 +0800</pubDate><description><![CDATA[优化总体思想:1&gt;建设循环次数,减少单次处理sql需要的时间.


	


	具体措施:


	1&gt;尽量使用rowid来作为循环变量.


	...]]></description><category></category></item><item><title><![CDATA[使用parallel注意事项]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251084</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251084</guid><author>cjsq82346</author><pubDate>Mon, 07 Nov 2016 14:35:06 +0800</pubDate><description><![CDATA[1&gt;所有并行操作在数据分布在多个磁盘的情况下展开,


	 update,delete,merge只能在已经分区的表上才能处理 .


	2&gt;并行度和并行进程之间的关系:(2*并行度 + 1)...]]></description><category></category></item><item><title><![CDATA[Oracle LOB数据类型的处理]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251085</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251085</guid><author>cjsq82346</author><pubDate>Mon, 07 Nov 2016 11:55:34 +0800</pubDate><description><![CDATA[Oracle的Blob字段比较特殊，他比long字段的性能要好很多，可以用来保存例如图片之类的二进制数据。

	写入Blob字段和写入其它类型字段的方式非常不同，因为Blob自身有一个cursor，你必须使用cursor对...]]></description><category></category></item><item><title><![CDATA[中文字符乱码的解决]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251074</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251074</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 23:47:30 +0800</pubDate><description><![CDATA[问题描述：在使用XMLP做报表的过程中，经常会遇到乱码的情况。


	导致乱码的原因有两种：字符集的问题和字体定义的问题。


	字符集引起的乱码 ：一般乱码成不规则性的。


	字体定义引起的乱...]]></description><category></category></item><item><title><![CDATA[Opatch rollback and  opatch -invPtrLoc]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251083</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251083</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 23:38:57 +0800</pubDate><description><![CDATA[解决方法：
$ $ORACLE_HOME/OPatch/opatch apply -invPtrLoc $ORACLE_BASE/../oraInst.loc


	原因是opatch在默认目录下找不到oraIn...]]></description><category></category></item><item><title><![CDATA[LINUX 字体安装]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251081</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251081</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 23:25:03 +0800</pubDate><description><![CDATA[今天接触了 Linux 下字体安装方面的内容，本实验以安装宋体( simsun.ttf ) 为例，

	记录下安装过程。



	



	--1 下载字体 



	 可以在网上下载，也可...]]></description><category></category></item><item><title><![CDATA[编译form ebs12 and wfload]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251077</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251077</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 23:08:51 +0800</pubDate><description><![CDATA[HDMSCFNSCW.fmb
Step 1:Transfer the file(HDMSCFNSCW.fmb) to path: /u01/oracle/PROD/apps/apps_st/appl/au/12.0.0...]]></description><category></category></item><item><title><![CDATA[adoacorectl.sh   Failed]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251080</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251080</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 22:55:53 +0800</pubDate><description><![CDATA[adstrtal.sh start 来启动应用的时候，曾遇到过有些service没有办法启动的问题，日志如下:

Web Application Services OACORE OC4J Instance szxxapp...]]></description><category></category></item><item><title><![CDATA[清除ebs12目录数据]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251079</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251079</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 22:50:23 +0800</pubDate><description><![CDATA[1&gt;临时文件目录
2〉erp日志文件记录
3〉erp报表out目录
4&gt;归档日志。
                                                            
  ...]]></description><category></category></item><item><title><![CDATA[ebs12 sendmail配置]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251075</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251075</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 22:22:17 +0800</pubDate><description><![CDATA[Sendmail邮件配置
	
	
	
	
	
	
		安装包（sendmail-8.13.8-2.el5.i386.rpm,sendmail-cf-8.13.8-2.el5.i386.r...]]></description><category></category></item><item><title><![CDATA[ebs克隆后必须步骤。]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251069</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251069</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 22:06:16 +0800</pubDate><description><![CDATA[1&gt;编译无效的数据对象。
2&gt;修改系统名称。


3&gt;修改环境变量和adautocfg.sh

4&gt;修改icx_parameter
5&gt;修改邮件地址。
6&gt;检查服务器状态...]]></description><category></category></item><item><title><![CDATA[ORACLE EBS INSTALL of ebs12 install packages]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251076</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251076</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 21:46:17 +0800</pubDate><description><![CDATA[package list:
Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 1 of 4) B53824-01 Part 1 of 4...]]></description><category></category></item><item><title><![CDATA[查看历史最多资源]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251072</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251072</guid><author>cjsq82346</author><pubDate>Wed, 22 Jun 2016 21:42:36 +0800</pubDate><description><![CDATA[select * from dba_high_water_mark_statistics;
                                                            
       ...]]></description><category></category></item><item><title><![CDATA[awk命令复习]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251066</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251066</guid><author>cjsq82346</author><pubDate>Tue, 21 Jun 2016 10:50:00 +0800</pubDate><description><![CDATA[awk 用法：awk ' pattern {action} ' 

变量名        含义
ARGC        命令行变元个数
ARGV        命令行变元数...]]></description><category></category></item><item><title><![CDATA[最常用的数据库命令,脚本]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251064</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251064</guid><author>cjsq82346</author><pubDate>Fri, 17 Jun 2016 14:39:21 +0800</pubDate><description><![CDATA[杀进程:


	alter system kill session 'serial number, sesssion number';


	kill -9 process_number;


	增加un...]]></description><category></category></item><item><title><![CDATA[配置恢复目录管理器]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251073</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251073</guid><author>cjsq82346</author><pubDate>Fri, 17 Jun 2016 11:08:04 +0800</pubDate><description><![CDATA[Step by step setup recovery manager:


	1&gt;set ORACLE_SID= orarc


	 sql&gt;connect / as sysdba

...]]></description><category></category></item><item><title><![CDATA[exchange partition]]></title><link>https://blog.youkuaiyun.com/cjsq82346/article/details/100251070</link><guid>https://blog.youkuaiyun.com/cjsq82346/article/details/100251070</guid><author>cjsq82346</author><pubDate>Thu, 16 Jun 2016 17:27:07 +0800</pubDate><description><![CDATA[logfile

	SQL&gt; alter table t_part exchange partition t_p1 with table t_part1;


	Table altered


	

...]]></description><category></category></item></channel></rss>