<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ciyu2310的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ciyu2310</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ciyu2310]]></copyright><item><title><![CDATA[Rman 定时删除归档日志]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220386</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220386</guid><author>ciyu2310</author><pubDate>Thu, 23 Mar 2017 21:41:50 +0800</pubDate><description><![CDATA[1、下面的命令用于校验归档日志的有效性，列出无效的归档日志，以及以何种方式清除归档日志，列出几种常用的: 
crosscheck archivelog all;             ...]]></description><category></category></item><item><title><![CDATA[RAC环境下chmod -R 777 /u01 会发生什么？]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220388</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220388</guid><author>ciyu2310</author><pubDate>Wed, 22 Mar 2017 21:46:48 +0800</pubDate><description><![CDATA[RAC环境下chmod -R 777 /u01 会发生什么？

会导致宕机
                                                            
            ...]]></description><category></category></item><item><title><![CDATA[FTP 大文件上传优化]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220400</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220400</guid><author>ciyu2310</author><pubDate>Wed, 22 Mar 2017 21:38:17 +0800</pubDate><description><![CDATA[优化方案思路：通过tar把大文件切分成多个100m大小的文件，然后通过多进程上传。
	
		
			脚本如下：
		
	
#!/bin/bash
#############################...]]></description><category></category></item><item><title><![CDATA[oracle update 死锁实验]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220385</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220385</guid><author>ciyu2310</author><pubDate>Tue, 31 Mar 2015 17:02:52 +0800</pubDate><description><![CDATA[oracle update 死锁实验


1、创建两张表，并插入一条相同的数据。脚本如下：
SQL&gt; CREATE TABLE TEST1 (ID NUMBER,msg VARCHAR2(100));
Tabl...]]></description><category></category></item><item><title><![CDATA[在11.2.0.3中使用自定义聚合函数EN_CONCAT与EN_CONCAT_DISTINCT替换WMSYS.WM_CONTACT]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220381</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220381</guid><author>ciyu2310</author><pubDate>Thu, 04 Jul 2013 21:48:46 +0800</pubDate><description><![CDATA[有一个项目使用的是Oracle 11.2.0.3 版本，有一条sql使用了WMSYS.WM_CONTACT，发现执行报错，最终发现原因是由于在10.2.0.5与11.2.0.3WMSYS....]]></description><category></category></item><item><title><![CDATA[buffer cache深度分析及性能调整]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220376</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220376</guid><author>ciyu2310</author><pubDate>Thu, 11 Oct 2012 15:56:45 +0800</pubDate><description><![CDATA[buffer cache深度分析及性能调整

1.buffer cache的概念

用最简单的语言来描述oracle数据库的本质，其实就是能够用磁盘上的一堆文件来存储数据，并提供了各种各样的手段对这些数据进行管理。作...]]></description><category></category></item><item><title><![CDATA[Oracle中的Trace文件]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220366</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220366</guid><author>ciyu2310</author><pubDate>Thu, 11 Oct 2012 15:56:17 +0800</pubDate><description><![CDATA[Oracle中的Trace文件 如果一个系统的执行效率比较低，一个比较好的方法是通过跟踪用户的会话并且使用tkprof工具使用排序功能格式化输出，从而找出有问题的SQL语句。 例如首先从os上利用top命令找到当前占用cpu资源...]]></description><category></category></item><item><title><![CDATA[ALL_PARAMETERS]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220422</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220422</guid><author>ciyu2310</author><pubDate>Mon, 08 Oct 2012 13:31:10 +0800</pubDate><description><![CDATA[CREATE VIEW ALL_PARAMETERSAS SELECT I.KSPPINM NAME, I.KSPPDESC DESCRIPTION, CV.KSPPSTVL ...]]></description><category></category></item><item><title><![CDATA[PLSQL Developer常用设置及快捷键]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220394</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220394</guid><author>ciyu2310</author><pubDate>Thu, 27 Sep 2012 12:02:09 +0800</pubDate><description><![CDATA[PLSQL Developer常用设置及快捷键 1、登录后默认自动选中My Objects （已验证可用） 默认情况下，PLSQL Developer登录后，Brower里会选择All objects，如果你登录的用户是db...]]></description><category></category></item><item><title><![CDATA[Oracle临时表用法的经验心得]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220383</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220383</guid><author>ciyu2310</author><pubDate>Mon, 24 Sep 2012 14:57:16 +0800</pubDate><description><![CDATA[Oracle临时表用法的经验心得　 我们目前所使用的 Oracle 是作为数据库支撑平台的实际应用，可以说其数据量还是算的上比较庞大的系统，即表的数据量一般情况下都是在百万级以上的数据量。　　当然在 Oracle 中创建分区是...]]></description><category></category></item><item><title><![CDATA[SQL中使用WITH AS提高性能]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220387</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220387</guid><author>ciyu2310</author><pubDate>Mon, 24 Sep 2012 14:56:28 +0800</pubDate><description><![CDATA[SQL中使用WITH AS提高性能摘要：本文结合笔者实际的工作情况，说明了如何使用with as改写存储过程，从而大幅提高SQL的运行时间。本文首先交代了案例的起因，随后简单介绍了WITH AS的含义，最后基于实际工作，使用了一...]]></description><category></category></item><item><title><![CDATA[oracle异常错误处理 (转)]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220390</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220390</guid><author>ciyu2310</author><pubDate>Fri, 21 Sep 2012 13:26:24 +0800</pubDate><description><![CDATA[oracle异常错误处理 5.1 异常处理概念5.1.1 预定义的异常处理5.1.2 非预定义的异常处理5.1.3 用户自定义的异常处理5.1.4 用户定义的异常处理5.2 异常错误传播5.2.1 在执行部分引发异常错误5.2...]]></description><category></category></item><item><title><![CDATA[11G  MEMORY_TARGET 参数]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220380</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220380</guid><author>ciyu2310</author><pubDate>Fri, 21 Sep 2012 13:23:26 +0800</pubDate><description><![CDATA[11g MEMORY_TARGET 参数对SGA 和PGA的影响-----------------------------------------11g中新增MEMORY_MAX_TARGET参数，此参数一出现就如在10g中第一...]]></description><category></category></item><item><title><![CDATA[Oracle中的for和while循环]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220378</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220378</guid><author>ciyu2310</author><pubDate>Fri, 21 Sep 2012 13:18:02 +0800</pubDate><description><![CDATA[Normal
  0
  
  
  
  7.8 磅
  0
  2
  
  false
  false
  false
  
  EN-US
  ...]]></description><category></category></item><item><title><![CDATA[oracle事务隔离级别]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220374</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220374</guid><author>ciyu2310</author><pubDate>Mon, 17 Sep 2012 23:31:42 +0800</pubDate><description><![CDATA[通过学习









Read committed
This is the default transaction isolation level. Each query executed b...]]></description><category></category></item><item><title><![CDATA[V$SQL_SHARED_CURSOR 视图实验]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220371</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220371</guid><author>ciyu2310</author><pubDate>Sun, 09 Sep 2012 17:51:26 +0800</pubDate><description><![CDATA[V$SQL_SHARED_CURSOR 视图全实验
一、V$SQL_SHARED_CURSOR 数据结构
V$SQL_SHARED_CURSOR explains why a particular child cursor ...]]></description><category></category></item><item><title><![CDATA[父游标、子游标及共享游标]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220367</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220367</guid><author>ciyu2310</author><pubDate>Sun, 09 Sep 2012 16:55:17 +0800</pubDate><description><![CDATA[父游标、子游标及共享游标
游标是数据库领域较为复杂的一个概念，因为游标包含了shared cursor和session cursor。两者有其不同的概念，也有不同的表现形式。共享游标的概念易于与SQL语句中定义的游标相混淆。本...]]></description><category></category></item><item><title><![CDATA[Authid Current_User的使用]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220382</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220382</guid><author>ciyu2310</author><pubDate>Thu, 06 Sep 2012 00:03:15 +0800</pubDate><description><![CDATA[Authid Current_User 的使用 
在开发过程中，会遇到用户拥有的role权限在存储过程中是不可用的，遇到这种情况，经常采用一般需要显示授权，如：grant create table to user gran...]]></description><category></category></item><item><title><![CDATA[Oracle 11g新特性之自适应游标与计划管理]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220379</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220379</guid><author>ciyu2310</author><pubDate>Mon, 03 Sep 2012 22:49:11 +0800</pubDate><description><![CDATA[任何SQL语句优化引擎的核心是判定获得SQL语句目标数据的最廉价和最有效的访问路径的能力，使用绑定变量可以限制需要存储在库缓存中返回相似结果集的SQL语句游标的数量。本文介绍Oracle 11g中的新特性 – 自适应游标共享 –...]]></description><category></category></item><item><title><![CDATA[expdp\impdp及exp\imp]]></title><link>https://blog.youkuaiyun.com/ciyu2310/article/details/100220362</link><guid>https://blog.youkuaiyun.com/ciyu2310/article/details/100220362</guid><author>ciyu2310</author><pubDate>Mon, 03 Sep 2012 09:35:13 +0800</pubDate><description><![CDATA[expdp介绍EXPDP命令行选项1. ATTACH该选项用于在客户会话与已存在导出作用之间建立关联.语法如下ATTACH=[schema_name.]job_nameSchema_name用于指定方案名,job_name用于指...]]></description><category></category></item></channel></rss>