<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuizhela6794的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuizhela6794</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuizhela6794]]></copyright><item><title><![CDATA[ORACLE锁机制解读]]></title><link>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440187</link><guid>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440187</guid><author>cuizhela6794</author><pubDate>Tue, 18 Dec 2012 15:44:52 +0800</pubDate><description><![CDATA[Oracle数据库的锁类型根据保护的对象不同，Oracle数据库锁可以分为以下几大类：DML锁（datalocks，数据锁），用于保护数据的完整性；DDL锁（dictionarylocks，字典锁），用于保护数据库对象的结构...]]></description><category></category></item><item><title><![CDATA[根据一个表创建另一个表]]></title><link>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440243</link><guid>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440243</guid><author>cuizhela6794</author><pubDate>Sun, 16 Dec 2012 18:56:42 +0800</pubDate><description><![CDATA[今天在群里有一个人问一个问题就是根据一个表生成另一个表，我想我刚学pl/sql就想用pl/sql写出来练练手
			
			表t 有两个字段（a varchar2(2),b number(2,2)) 里面有数据是（A,1)...]]></description><category></category></item><item><title><![CDATA[PL/SQL优化工具profiler]]></title><link>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440186</link><guid>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440186</guid><author>cuizhela6794</author><pubDate>Tue, 11 Dec 2012 16:31:11 +0800</pubDate><description><![CDATA[profiler的脚本放在$ORACLE_HOME/rdbms/admin下面有proftab.sql和profload.sql俩脚本。首先在系统用户下安装profload.sql脚本，然后在要测试的PL/SQL的用户下安装pr...]]></description><category></category></item><item><title><![CDATA[ORACLE 高级分组 rollup，cube]]></title><link>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440190</link><guid>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440190</guid><author>cuizhela6794</author><pubDate>Mon, 10 Dec 2012 15:50:36 +0800</pubDate><description><![CDATA[高级分组rollup,cube操作该实验的目的是掌握高级分组的语法，理解高级分组的工作原理·组函数中的集合操作·ROLLUP分组按部门分组SQL&gt; select deptno,sum(sal) from emp ...]]></description><category></category></item><item><title><![CDATA[undo表空间]]></title><link>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440234</link><guid>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440234</guid><author>cuizhela6794</author><pubDate>Tue, 20 Nov 2012 10:26:52 +0800</pubDate><description><![CDATA[看到对undo比较好的介绍，拿来收藏了。
			
			UNDO 表空间用于存放UNDO数据,当执行DML操作(INSERT,UPDATE和DELETE)时,oracle会将这些操作的旧数据写入到UNDO段,在 oracle...]]></description><category></category></item><item><title><![CDATA[常用的监控数据库sql]]></title><link>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440184</link><guid>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440184</guid><author>cuizhela6794</author><pubDate>Mon, 19 Nov 2012 22:12:12 +0800</pubDate><description><![CDATA[1. 监控事例的等待  select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "T...]]></description><category></category></item><item><title><![CDATA[ORACLE dba常用语句]]></title><link>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440251</link><guid>https://blog.youkuaiyun.com/cuizhela6794/article/details/100440251</guid><author>cuizhela6794</author><pubDate>Sat, 17 Nov 2012 09:31:10 +0800</pubDate><description><![CDATA[1、查看表空间的名称及大小select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_sizefrom dba_tablespaces t, dba_data_f...]]></description><category></category></item></channel></rss>