<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuibi1751</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuibi1751]]></copyright><item><title><![CDATA[EXPLAIN PLAN and SQL*PLUS AUTOTRACE may not generate actual plans]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276199</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276199</guid><author>cuibi1751</author><pubDate>Sun, 25 Nov 2012 11:09:04 +0800</pubDate><description><![CDATA[EXPLAIN PLAN and SQL*PLUS AUTOTRACE may not generate actual plans [ID 1268111.1]Applies to:Oracle Server - Enterpr...]]></description><category></category></item><item><title><![CDATA[Select For update语句浅析]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276193</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276193</guid><author>cuibi1751</author><pubDate>Fri, 23 Nov 2012 00:12:52 +0800</pubDate><description><![CDATA[Select …forupdate语句是我们经常使用手工加锁语句。通常情况下，select语句是不会对数据加锁，妨碍影响其他的DML和DDL操作。同时，在多版本一致读机制的支持下，select语句也不会被其他类型语句所阻碍。借...]]></description><category></category></item><item><title><![CDATA[oracle 联合主键学习]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276189</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276189</guid><author>cuibi1751</author><pubDate>Thu, 08 Nov 2012 10:54:08 +0800</pubDate><description><![CDATA[联合主键的含义联合主键的适用范围
			http://www.cnblogs.com/askjacklin/archive/2012/07/22/2603925.html
			
			
			
			
			
	...]]></description><category></category></item><item><title><![CDATA[Undo的管理]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276196</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276196</guid><author>cuibi1751</author><pubDate>Sat, 03 Nov 2012 18:23:32 +0800</pubDate><description><![CDATA[Undo的生成量，多或者少？
			
			生成量由少至多：1. insert 生成的undo量最少，因为oracle为此需记录的只是要删除的一个rowid。2. update:只记录修改的字节，如只更新了整个数据行中很少的...]]></description><category></category></item><item><title><![CDATA[commit_write参数]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276186</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276186</guid><author>cuibi1751</author><pubDate>Tue, 30 Oct 2012 21:00:45 +0800</pubDate><description><![CDATA[Oracle 10gR2中引人了一个新的参数commit_write, 可以通过调整此参数调整Oracle在Commit时的行为特征.随着web 2.0网站的涌现, 写越来越成为传统的RDBMS数据库的瓶颈, 而lgwr的写一直...]]></description><category></category></item><item><title><![CDATA[关于v$datafile中system表空间的status值始终为system]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276192</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276192</guid><author>cuibi1751</author><pubDate>Wed, 24 Oct 2012 22:26:54 +0800</pubDate><description><![CDATA[在查询数据文件的文件状态时，可以从v$datafile视图中查询。v$datafile视图反映了从控制文件中看到的数据文件的状态。
			
			官方对于V$DATAFILE的解释说明是：This view contains...]]></description><category></category></item><item><title><![CDATA[log buffer及日志管理深入分析及性能调整（七）]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276194</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276194</guid><author>cuibi1751</author><pubDate>Mon, 15 Oct 2012 17:24:27 +0800</pubDate><description><![CDATA[http://space.itpub.net/9842/viewspace-4149513.2.2其他相关的等待事件当进程需要向日志缓冲区里拷贝重做记录时，发现没有足够的可用空间时，则必须等待log buffer ...]]></description><category></category></item><item><title><![CDATA[SHARED_POOL_RESERVED_SIZE参数的设置及作用]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276183</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276183</guid><author>cuibi1751</author><pubDate>Mon, 15 Oct 2012 16:16:30 +0800</pubDate><description><![CDATA[总述：通过本篇笔记总结shared_pool_reserved_size 参数和隐含参数_shared_pool_reserved_min_alloc还有一个参数是需要提及的：shared_pool_reserved_size。...]]></description><category></category></item><item><title><![CDATA[ORA-16014错误解决办法]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276204</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276204</guid><author>cuibi1751</author><pubDate>Fri, 10 Aug 2012 15:55:09 +0800</pubDate><description><![CDATA[1.问题以及解决过程
SQL&gt; select status from v$instance;
STATUS------------MOUNTED
SQL&gt; alter database open;alter d...]]></description><category></category></item><item><title><![CDATA[【罗玄】从锁的角度看rebuild index online和rebuild index]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276190</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276190</guid><author>cuibi1751</author><pubDate>Wed, 30 May 2012 06:49:13 +0800</pubDate><description><![CDATA[众所周知，rebuildindexonline不会阻塞DML操作，而rebulid index却会阻塞DML操作。现在我们来看一下在rebuild index online及rebulid index下的锁os: ...]]></description><category></category></item><item><title><![CDATA[父游标 子游标]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276185</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276185</guid><author>cuibi1751</author><pubDate>Sun, 13 May 2012 12:01:27 +0800</pubDate><description><![CDATA[1.v$sql和v$sqlarea的区别v$sql和v$sqlarea从某种意义上具有父子关系。即v$sqlarea保存的是父游标的sql信息，而v$sql保存的是子游标的sql的信息。在v$sqlarea里面有一列VERSIO...]]></description><category></category></item><item><title><![CDATA[Oracle 优化参数 optimizer_mode 介绍]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276187</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276187</guid><author>cuibi1751</author><pubDate>Sun, 13 May 2012 11:57:51 +0800</pubDate><description><![CDATA[Oracle在执行SQL语句时，有两种优化方法：即基于规则的RBO和基于代价的CBO。在SQL执教的时候，到底采用何种优化方法，就由Oracle参数 optimizer_mode 来决定。SQL&gt; show param...]]></description><category></category></item><item><title><![CDATA[oracle 11gR2，取消用户unlimited tablespace 权限，那么表空间上的quota也会相应取消...]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276184</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276184</guid><author>cuibi1751</author><pubDate>Tue, 13 Mar 2012 00:22:30 +0800</pubDate><description><![CDATA[When Revoking Unlimited Tablespace System Privilege Tablespace Quota Also Removed [ID 1169515.1]





...]]></description><category></category></item><item><title><![CDATA[详解Oracle的unlimited tablespace系统权限]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276178</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276178</guid><author>cuibi1751</author><pubDate>Tue, 13 Mar 2012 00:12:28 +0800</pubDate><description><![CDATA[1.系统权限unlimited tablespace是隐含在dba, resource角色中的一个系统权限. 当用户得到dba或resource的角色时,unlimited tablespace系统权限也隐式受权给用户....]]></description><category></category></item><item><title><![CDATA[Oracle中NLS_LANG的默认值]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276176</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276176</guid><author>cuibi1751</author><pubDate>Sun, 19 Feb 2012 15:02:14 +0800</pubDate><description><![CDATA[export NLS_LANG="AMERICAN_AMERICN.AL32UTF8"export NLS_LANG="CHINESE_CHINA.ZHS16GBK"LanguageLocale IDNLS_LANGEnglis...]]></description><category></category></item><item><title><![CDATA[ORACLE SEQUENCE]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276173</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276173</guid><author>cuibi1751</author><pubDate>Tue, 07 Feb 2012 16:45:55 +0800</pubDate><description><![CDATA[ORACLESEQUENCE(序列)序列是用户创建的数据库对象，他可以有多个用户共享，用来生成唯一的整数。sequence属于某个用户。
序列号的存储和生成与表无关，因此，同一个序列可以用于多个表。但这样会引起应用的很多麻烦...]]></description><category></category></item><item><title><![CDATA[手动删除oracle数据库]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276233</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276233</guid><author>cuibi1751</author><pubDate>Wed, 01 Feb 2012 13:56:24 +0800</pubDate><description><![CDATA[--=====================
-- 手动删除oracle数据库
--=====================

 在很多情况下，或无法使用dbca工具的时候，我们需要手动来删除数据库。对此，可...]]></description><category></category></item><item><title><![CDATA[DataPump Export or Import Fails With ORA-31633 ORA-6512 ORA-955]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276171</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276171</guid><author>cuibi1751</author><pubDate>Fri, 20 Jan 2012 14:02:46 +0800</pubDate><description><![CDATA[DataPump Export or Import Fails With ORA-31633 ORA-6512 ORA-955 (Doc ID 55...]]></description><category></category></item><item><title><![CDATA[UNIX: Do I Need To Use The "oinstall" Group?]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276181</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276181</guid><author>cuibi1751</author><pubDate>Wed, 18 Jan 2012 10:11:53 +0800</pubDate><description><![CDATA[Applies to: Oracle Universal Installer - Version: 11.1.0.6 and later[Release: 11.1 and later ]
PurposeTo discu...]]></description><category></category></item><item><title><![CDATA[ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained.]]></title><link>https://blog.youkuaiyun.com/cuibi1751/article/details/100276175</link><guid>https://blog.youkuaiyun.com/cuibi1751/article/details/100276175</guid><author>cuibi1751</author><pubDate>Tue, 17 Jan 2012 16:31:31 +0800</pubDate><description><![CDATA[ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained. (...]]></description><category></category></item></channel></rss>