<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[csp12130的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/csp12130</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; csp12130]]></copyright><item><title><![CDATA[INSERT  ALL 和INSERT FIRST 的区别]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242368</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242368</guid><author>csp12130</author><pubDate>Sun, 14 Sep 2008 10:27:37 +0800</pubDate><description><![CDATA[all应该好理解,first即使条件中记录有交集,数据也是不会有的,从第一个条件开始取数,剩下的数据再和下面的条件进行依次匹配
SQL&gt; create table tmp(col1 number);表已创建。SQL&gt...]]></description><category></category></item><item><title><![CDATA[DDL会提交事务,但,失败的DDL是否也会提交事务呢?]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242319</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242319</guid><author>csp12130</author><pubDate>Mon, 14 Jul 2008 13:53:25 +0800</pubDate><description><![CDATA[SQL&gt; select * from test; A---------------------------------------...]]></description><category></category></item><item><title><![CDATA[Oracle表段中的高水位线HWM]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242323</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242323</guid><author>csp12130</author><pubDate>Mon, 14 Jul 2008 10:46:29 +0800</pubDate><description><![CDATA[在Oracle数据的存储中，可以把存储空间想象为一个水库，数据想象为水库中的水。水库中的水的位置有一条线叫做水位线，在Oracle中，这条线被称为高水位线（High-warter mark, HWM）。在数据库表刚建立的时候，由...]]></description><category></category></item><item><title><![CDATA[startup和shutdown]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242318</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242318</guid><author>csp12130</author><pubDate>Mon, 14 Jul 2008 09:46:29 +0800</pubDate><description><![CDATA[SHUTDOWN有四个参数：NORMAL、TRANSACTIONAL、IMMEDIATE、ABORT。缺省不带任何参数时表示是NORMAL。 SHUTDOWN NORMAL：不允许新的连接、等待会话结束、等待事务结束、做一个检查...]]></description><category></category></item><item><title><![CDATA[小议如果构造数组]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242321</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242321</guid><author>csp12130</author><pubDate>Thu, 10 Jul 2008 09:40:54 +0800</pubDate><description><![CDATA[1、一维数组SQL&gt; set serveroutput onSQL&gt; SQL&gt; declare 2 type tvar_sz is varray(5) of number; 3 var_sz t...]]></description><category></category></item><item><title><![CDATA[OLTP和OLAP的区别]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242317</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242317</guid><author>csp12130</author><pubDate>Tue, 08 Jul 2008 14:41:16 +0800</pubDate><description><![CDATA[OLTP是传统的关系型数据库的主要应用，主要是基本的、日常的事务处理，例如银行交易。OLAP是数据仓库系统的主要应用，支持复杂的分析操作，侧重决策支持，并且提供直观易懂的查询结果。下表列出了OLTP与OLAP之间的比较。 
...]]></description><category></category></item><item><title><![CDATA[Oracle EVENT用法参考列表]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242362</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242362</guid><author>csp12130</author><pubDate>Fri, 04 Jul 2008 10:54:27 +0800</pubDate><description><![CDATA[事件
说明
例子

Event 10013 - Monitor Transaction Recovery
在Startup时跟踪事务恢复
ALTER SESSION SET EVENTS '10013 t...]]></description><category></category></item><item><title><![CDATA[logminer不完整版]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242360</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242360</guid><author>csp12130</author><pubDate>Thu, 03 Jul 2008 16:03:00 +0800</pubDate><description><![CDATA[sys@WX&gt; alter system set utl_file_dir='d:\backup\logminer' scope=spfile;
系统已更改。
sys@WX&gt; shutdown immediate...]]></description><category></category></item><item><title><![CDATA[备用数据库]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242358</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242358</guid><author>csp12130</author><pubDate>Tue, 01 Jul 2008 15:18:52 +0800</pubDate><description><![CDATA[C:\Documents and Settings\guanxg&gt;d:
D:\&gt;cd oraclestandby
D:\oraclestandby&gt;md admin
D:\oraclestandby&gt...]]></description><category></category></item><item><title><![CDATA[Oracle SCN机制解析]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242316</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242316</guid><author>csp12130</author><pubDate>Tue, 01 Jul 2008 09:13:55 +0800</pubDate><description><![CDATA[SCN（System Chang Number）作为oracle中的一个重要机制，在数据恢复、Data Guard、Streams复制、RAC节点间的同步等各个功能中起着重要作用。理解SCN的运作机制，可以帮助你更加深入地了解上...]]></description><category></category></item><item><title><![CDATA[手动复制数据库]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242315</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242315</guid><author>csp12130</author><pubDate>Mon, 30 Jun 2008 18:07:47 +0800</pubDate><description><![CDATA[C:\Documents and Settings\guanxg&gt;d:
D:\&gt;cd oraclebuk
D:\oraclebuk&gt;md admin
D:\oraclebuk&gt;cd admin
D...]]></description><category></category></item><item><title><![CDATA[Oracle分页查询格式]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242356</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242356</guid><author>csp12130</author><pubDate>Thu, 26 Jun 2008 09:52:08 +0800</pubDate><description><![CDATA[看看杨版主的总结。 Oracle分页查询格式（一）：http://yangtingkun.itpub.net/post/468/100278 Oracle分页查询格式（二）：http://yangtingkun.itpu...]]></description><category></category></item><item><title><![CDATA[10046 trace]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242313</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242313</guid><author>csp12130</author><pubDate>Wed, 25 Jun 2008 18:12:42 +0800</pubDate><description><![CDATA[我在日常工作中经常需要用10046跟踪一些进程，为了方便，写了一个可以方便查看trace的小脚本。begin_trace:-----------------------------------------------------...]]></description><category></category></item><item><title><![CDATA[RMAN基本操作代码]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242312</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242312</guid><author>csp12130</author><pubDate>Wed, 25 Jun 2008 17:11:15 +0800</pubDate><description><![CDATA[LINUX&gt; rmanRMAN&gt; connect target /RMAN&gt; connect catalog rman/rman@rmandb;RMAN&gt; create catal...]]></description><category></category></item><item><title><![CDATA[Oracle中，一个Delete操作的流程]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242354</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242354</guid><author>csp12130</author><pubDate>Fri, 20 Jun 2008 12:53:37 +0800</pubDate><description><![CDATA[Oracle中，一个Delete操作的流程
删除(DELETE)
1.Oracle读Block到Buffer Cache(如果该Block在Buffer中不存在)2.在redo log buffer中记录delete操作的细...]]></description><category></category></item><item><title><![CDATA[EXPDP和IMPDP的使用]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242311</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242311</guid><author>csp12130</author><pubDate>Fri, 20 Jun 2008 09:22:56 +0800</pubDate><description><![CDATA[1、create directory dump_dir as 'D:\backup';2、xg_test@WX&gt; select * from dba_directories;3、xg_test@WX&gt; GRANT R...]]></description><category></category></item><item><title><![CDATA[启用Block Change Tracking-10g新特性]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242309</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242309</guid><author>csp12130</author><pubDate>Wed, 18 Jun 2008 16:31:37 +0800</pubDate><description><![CDATA[Block chage tracking是Oracle10g的一个新特性，Block change tracking进程记录自从上一次备份以来数据块的变化，并把这些信息记录在跟踪文件中。RMAN使用这个文件判断增量备份中需要备份...]]></description><category></category></item><item><title><![CDATA[使用dbv和RMAN检查数据文件中的坏块]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242310</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242310</guid><author>csp12130</author><pubDate>Wed, 18 Jun 2008 09:29:45 +0800</pubDate><description><![CDATA[1.使用dbv检查

D:\oradata\eygle&gt;dbv file=EYGLE.DBF blocksize=8192

DBVERIFY: Release 10.1.0.4.0 - Production ...]]></description><category></category></item><item><title><![CDATA[回滚操作、回滚段的理解]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242353</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242353</guid><author>csp12130</author><pubDate>Mon, 16 Jun 2008 17:59:42 +0800</pubDate><description><![CDATA[回滚操作：
oracle里面常用的rollback操作，就是在某处操作中间设置一个点， 然后继续作事情，如果觉得有问题了，就rollback一下，等于那个点后面的操作就都没作。当然如果commit了就没用了。

回滚段：...]]></description><category></category></item><item><title><![CDATA[a pretty simple philosophy]]></title><link>https://blog.youkuaiyun.com/csp12130/article/details/100242303</link><guid>https://blog.youkuaiyun.com/csp12130/article/details/100242303</guid><author>csp12130</author><pubDate>Fri, 13 Jun 2008 13:37:54 +0800</pubDate><description><![CDATA[• You should do it in a single SQL statement if at all possible.• If you cannot do it in a single SQL statement, t...]]></description><category></category></item></channel></rss>