<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuicheng7243</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuicheng7243]]></copyright><item><title><![CDATA[sys和system用户、sysdba和sysoper系统权限、dba角色的区别]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435836</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435836</guid><author>cuicheng7243</author><pubDate>Thu, 02 Aug 2012 17:21:44 +0800</pubDate><description><![CDATA[一、    sys和system用户的区别（1）最重要的区别，存储的数据的重要性不同     【sys】所有oracle的数据字典的基本和视图都存放在sys用户中，这些基表和视图对于oracle的运行是至关重要的，由数据库自己维...]]></description><category></category></item><item><title><![CDATA[显示某月的每一天日期]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435879</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435879</guid><author>cuicheng7243</author><pubDate>Wed, 01 Aug 2012 10:52:47 +0800</pubDate><description><![CDATA[今天遇到客户需求，要显示每月的每一天的数据，哪怕那天没有数据也要显示出来日期，客户的需求是一朵奇葩，不过正是这些奇葩提高了自身的技能：代码如下：select to_char(to_date('&amp;month','yyyym...]]></description><category></category></item><item><title><![CDATA[DBWR和LGWR在什么情况下执行写]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435847</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435847</guid><author>cuicheng7243</author><pubDate>Mon, 30 Jul 2012 17:41:24 +0800</pubDate><description><![CDATA[DBWR执行写情况：①没有可用的缓冲区情况②脏缓冲区过多③遇到三秒超时④遇到检查点LGWR 执行写情况①执行COMMIT②超过日志缓冲区1/3或者超过1M③DBWR正要执行写之前细心的人会发现为什么很多人会对LGWR的写情况增加...]]></description><category></category></item><item><title><![CDATA[移动表空间的数据文件]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435830</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435830</guid><author>cuicheng7243</author><pubDate>Tue, 17 Jul 2012 22:36:19 +0800</pubDate><description><![CDATA[如果把所有的数据文件都放在同一个磁盘上，最终会带来I/O的瓶颈，以及数据的不安全性。因此应该把数据文件分散在不同的磁盘，这样对于性能和安全将会有提升。下面来做一个移动表空间的数据文件的实验：1、首先要使该数据文件所在的表空间of...]]></description><category></category></item><item><title><![CDATA[Oracle分页例子：]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435821</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435821</guid><author>cuicheng7243</author><pubDate>Sat, 14 Jul 2012 11:21:49 +0800</pubDate><description><![CDATA[对于一些网站搜索或者BBS经常会要求分页显示，为了快速显示出第一页的信息，需要加first_rows(n)来快速显示最前面的几行数据。实例：select/*+first_rows(10)*/ *from (select/*+fi...]]></description><category></category></item><item><title><![CDATA[Oracle优化器（RBO与CBO）]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435996</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435996</guid><author>cuicheng7243</author><pubDate>Sun, 08 Jul 2012 12:14:58 +0800</pubDate><description><![CDATA[Oracle的优化器有两种，基于规则的优化器（RBO）和基于代价的优化器（CBO）。在8i之前，Oracle使用的是RBO（Rule Based Optimizer,基于规则的优化器），他的执行非常简单，就是在优化器里面嵌入15...]]></description><category></category></item><item><title><![CDATA[Oracle append Hint(四)]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435857</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435857</guid><author>cuicheng7243</author><pubDate>Thu, 05 Jul 2012 00:19:23 +0800</pubDate><description><![CDATA[既然直接加载会产生少量的redo，那么再加入并行会并行的往表中插入数据，肯定速度会更快，即:insert/*+append parallel(t,4)*/ into tselect * from t1;到底结果是不是这样呢？请看...]]></description><category></category></item><item><title><![CDATA[Oracle append Hint(三)]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435895</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435895</guid><author>cuicheng7243</author><pubDate>Wed, 04 Jul 2012 22:44:29 +0800</pubDate><description><![CDATA[如果一个表上有索引，那么直接加载又会是什么情况呢？产生的redo量跟传统加载又相差多少呢？例子： sys@ORCL&gt; create table t 2 as3 select * from dba_objects where...]]></description><category></category></item><item><title><![CDATA[Oracle append Hint(二)]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435877</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435877</guid><author>cuicheng7243</author><pubDate>Wed, 04 Jul 2012 00:06:51 +0800</pubDate><description><![CDATA[很多人都认为使用直接加载可以大量减少redo的产生量，实际上直接加载并非在任何时候都能减少redo的产生。如果对象实在LOGGING模式下，直接加载并不能显著的减少日志量。看一个例子：sys@ORCL&gt; create ta...]]></description><category></category></item><item><title><![CDATA[Oracle append Hint(一)]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435820</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435820</guid><author>cuicheng7243</author><pubDate>Tue, 03 Jul 2012 23:43:42 +0800</pubDate><description><![CDATA[在执行数据插入或数据加载时，可以通过append Hint的方式进行数据库直接加载，可以在insert的SQL语句里面使用append，比如：insert/*+append*/ into t select * from dba_...]]></description><category></category></item><item><title><![CDATA[hextoraw函数和rawtohex函数]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435882</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435882</guid><author>cuicheng7243</author><pubDate>Fri, 22 Jun 2012 18:17:02 +0800</pubDate><description><![CDATA[介绍下两个函数的作用：hextoraw()：十六进制字符串转换为raw；rawtohex()：将raw串转换为十六进制；先来看下hextoraw()函数，当出现比f大的字母时(以a最小z最大)就会报错：正确结果：sys@ORCL...]]></description><category></category></item><item><title><![CDATA[Oracle instr函数]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435843</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435843</guid><author>cuicheng7243</author><pubDate>Tue, 19 Jun 2012 21:30:50 +0800</pubDate><description><![CDATA[今天在群里面有人问到instr的用法，下面我也来总结一下吧语法如下：　　instr( string1, string2 [, start_position [, nth_appearance ] ] )　　参数分析：　　stri...]]></description><category></category></item><item><title><![CDATA[Oracle Sequence中Cache与NoCache的区别]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435828</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435828</guid><author>cuicheng7243</author><pubDate>Sun, 17 Jun 2012 10:04:12 +0800</pubDate><description><![CDATA[Oracle在创建序列（sequence）时有个参数你可以选择cache或者nocache，下面来讲一下两者的区别：先来看下创建sequence的语句：create sequence SEQ_ID minvalue 1 maxv...]]></description><category></category></item><item><title><![CDATA[undo表空间居高不下和enq: US - contention]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435814</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435814</guid><author>cuicheng7243</author><pubDate>Sat, 16 Jun 2012 12:29:48 +0800</pubDate><description><![CDATA[这几天遇到一个错误，我也不知道算不算错误吧，因为没有报错，只是在那突然的短短2分钟内表的操作突然降低了，导致了该软件重新启动。查看alert日志没有报错，而是在ASH里找到了TOP SQL框有一个这样的错误，使我百思不得其解。查...]]></description><category></category></item><item><title><![CDATA[误删数据文件]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435842</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435842</guid><author>cuicheng7243</author><pubDate>Sat, 16 Jun 2012 11:37:22 +0800</pubDate><description><![CDATA[前几天做了一个感觉很迷惑的实验，步骤如下：sys@ORCL&gt; col name format a30sys@ORCL&gt; select file#,ts#,name from v$datafile;     FILE#...]]></description><category></category></item><item><title><![CDATA[Oracle多版本和读一致性]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435825</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435825</guid><author>cuicheng7243</author><pubDate>Wed, 13 Jun 2012 16:26:12 +0800</pubDate><description><![CDATA[对于以Oracle后台的开发人员了解Oracle多版本和一致读尤其重要，因为它在很大程度上提升了数据库的并行操作。如果对并发了解的不够，通常会遇到以下几种情况：1、破坏了数据的完整性2、随着用户数的增多，应用的运行速度减慢3、不...]]></description><category></category></item><item><title><![CDATA[Oracle同义词的使用]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435835</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100435835</guid><author>cuicheng7243</author><pubDate>Wed, 13 Jun 2012 14:02:54 +0800</pubDate><description><![CDATA[今天看书，突然想到了同义词，于是就产生了2个问题：1、如何查看同义词是public还是private;2、对public和private同义词是否可以重名？于是针对这两个问题做了个实验：首先对scott赋予创建同义词的权限：sy...]]></description><category></category></item><item><title><![CDATA[数据库和实例]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100510074</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100510074</guid><author>cuicheng7243</author><pubDate>Wed, 13 Jun 2012 13:58:31 +0800</pubDate><description><![CDATA[这篇文章跟数据库开发有什么关系呢？我感觉呢只从字面上看确实没有什么关系，可是了解的话跟大牛讨论时他们最起码不会被鄙视、面试时可能也会有用。如果你再深入的钻研下去你就会发现里面的内容好“丰满”。作为一个菜鸟（指本人）以前跟别人讨...]]></description><category></category></item><item><title><![CDATA[数据库开发之绑定变量 .]]></title><link>https://blog.youkuaiyun.com/cuicheng7243/article/details/100436018</link><guid>https://blog.youkuaiyun.com/cuicheng7243/article/details/100436018</guid><author>cuicheng7243</author><pubDate>Wed, 13 Jun 2012 13:56:23 +0800</pubDate><description><![CDATA[对于每个程序开发人员来说，数据库的知识都是或多或少的了解些，都能编写一些SQL语句，即使不会也可以使用一些工具来生成SQL语句，因此数据库在很多时候被认为是没有必要研究的。随着系统使用人数增加，系统也遇到了瓶颈，于是开发人员高呼...]]></description><category></category></item></channel></rss>