<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congqingm32098的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congqingm32098</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congqingm32098]]></copyright><item><title><![CDATA[CheckPoints and RBA]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470308</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470308</guid><author>congqingm32098</author><pubDate>Tue, 15 Dec 2009 09:41:22 +0800</pubDate><description><![CDATA[摘录了一位大师对oracle 中checkpoints的理解，和RBA的深刻理解!!!
I really wouldn't classify Oracle as having different types of checkp...]]></description><category></category></item><item><title><![CDATA[Oracle tablespace 常用操作]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470304</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470304</guid><author>congqingm32098</author><pubDate>Sun, 13 Dec 2009 19:29:36 +0800</pubDate><description><![CDATA[Oracle Tablespaces

Version 11.1





General

Data Dictionary Objects




Tablespaces
ts$...]]></description><category></category></item><item><title><![CDATA[利用DBMS_XPLAN包获取SQL执行计划]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470312</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470312</guid><author>congqingm32098</author><pubDate>Thu, 10 Dec 2009 17:20:05 +0800</pubDate><description><![CDATA[Oracle默认安装没有创建DBMS_XPLAN包，我们必须手工安装
aplm@ORCLDEV&gt; conn /as sysdba 
aplm@ORCLDEV&gt; @$OR...]]></description><category></category></item><item><title><![CDATA[Ora-14551问题求助,怎么能在查询语句中执行DML语句]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470302</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470302</guid><author>congqingm32098</author><pubDate>Mon, 16 Nov 2009 10:24:29 +0800</pubDate><description><![CDATA[今天用 select aplm.f_ss_get_seqid('P01',null,null,null) from dual ;
语句执行一个函数取值问题，结果报了ORA-14551: cannot perform. a ...]]></description><category></category></item><item><title><![CDATA[Insert into return 语句的使用]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470305</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470305</guid><author>congqingm32098</author><pubDate>Wed, 11 Nov 2009 11:23:54 +0800</pubDate><description><![CDATA[insert into return 语句在插入一条数据以后，返回某个字段的值非常方便，
下面演示：
SQL&gt; drop table test;drop table testORA-00942: table o...]]></description><category></category></item><item><title><![CDATA[SQL解析的过程]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470301</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470301</guid><author>congqingm32098</author><pubDate>Tue, 10 Nov 2009 21:03:08 +0800</pubDate><description><![CDATA[sql在解析阶段主要完成以下一个步骤：
（1） 包含VPD的约束条件 
（2） 语法，语义以及访问权限的检查 
 这一步不仅确认sql语句是否正确书写，而且要确认这个算起来语句引用的对象是否都存在，并...]]></description><category></category></item><item><title><![CDATA[游标的另一种写法]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470303</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470303</guid><author>congqingm32098</author><pubDate>Mon, 09 Nov 2009 20:46:15 +0800</pubDate><description><![CDATA[今天读了oracle性能诊断艺术，发现游标的另一种写法
declarel_name emp.last_name%type :='HARTSTEIN';l_empno emp.EMPLOYEE_ID%type;l_curs...]]></description><category></category></item><item><title><![CDATA[LINUX随身指南-重温linux常用命令]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100510444</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100510444</guid><author>congqingm32098</author><pubDate>Sun, 08 Nov 2009 22:06:31 +0800</pubDate><description><![CDATA[今天看了LINUX随身指南这本书，复习了linux中的一些常用命令！！！！
见附件！！！
                                                            
       ...]]></description><category></category></item><item><title><![CDATA[CURSOR_SHARING 参数副作用]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470314</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470314</guid><author>congqingm32098</author><pubDate>Sat, 07 Nov 2009 22:32:17 +0800</pubDate><description><![CDATA[1. 与优化器有关的问题: cursor_sharing 将从查询中删除所有的字符和数字常数，优化器能够使用的信息将更少，这可能导致不同的查询方案。 2. 与查询输出有关的问题: 一个查询得到的列的长度出乎意料的改变 3...]]></description><category></category></item><item><title><![CDATA[绑定变量对性能的影响]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470311</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470311</guid><author>congqingm32098</author><pubDate>Fri, 06 Nov 2009 22:21:59 +0800</pubDate><description><![CDATA[declarel_number number;beginfor i in 1 .. 10000loopl_number:=dbms_random.random;execute immediate 'insert into t v...]]></description><category></category></item><item><title><![CDATA[rsh方式访问配互信关系]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470374</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470374</guid><author>congqingm32098</author><pubDate>Thu, 05 Nov 2009 22:51:55 +0800</pubDate><description><![CDATA[今天项目中用到linux中rsh方式调用远程一台linux机器中的shell脚本。
机器一： 10.90.172.11SteelTrade-app
机器二： 10.90.172.12SteelTrade-db
问题...]]></description><category></category></item><item><title><![CDATA[查看表空间使用情况]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470300</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470300</guid><author>congqingm32098</author><pubDate>Wed, 04 Nov 2009 21:47:11 +0800</pubDate><description><![CDATA[col tablespace_name format a10;select f.tablespace_name,a.total,u.used,f.free,round((u.used/a.total)*100) "% used"...]]></description><category></category></item><item><title><![CDATA[表空间复制]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470330</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470330</guid><author>congqingm32098</author><pubDate>Mon, 02 Nov 2009 20:33:54 +0800</pubDate><description><![CDATA[利用exp，imp完成表空间的复制
步骤如下:
(1) 将要转化的表空间设为只读状态SQL&gt; alter tablespace tts_ex1 read only;Tablespace altered.SQL&gt;...]]></description><category></category></item><item><title><![CDATA[EXP各种参数的使用]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470298</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470298</guid><author>congqingm32098</author><pubDate>Sun, 01 Nov 2009 23:08:55 +0800</pubDate><description><![CDATA[1. EXP和IMP的最有用的用途 1&gt; 检查冲突 2&gt; 提取DDL 3&gt; 克隆模式(fromuser,touser) 4&gt; 传输表空间 5&gt; 重构实例 6&gt; 在平台之...]]></description><category></category></item><item><title><![CDATA[Impdp TABLE_EXISTS_ACTION参数使用]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470299</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470299</guid><author>congqingm32098</author><pubDate>Sat, 31 Oct 2009 23:15:10 +0800</pubDate><description><![CDATA[impdp hr SCHEMAS=hr DIRECTORY=dump_dir DUMPFILE=expschema.dmp EXCLUDE=CONSTRAINT,REF_CONSTRAINT,INDEX TABLE_EXIST...]]></description><category></category></item><item><title><![CDATA[ora-38760 ：此数据库无法启用闪回数据库]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470296</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470296</guid><author>congqingm32098</author><pubDate>Fri, 30 Oct 2009 23:03:56 +0800</pubDate><description><![CDATA[我的解决方法：SQL&gt; alter database flashback off;
数据库已更改。
SQL&gt; alter database open;
数据库已更改。
SQL&gt; shutdown imm...]]></description><category></category></item><item><title><![CDATA[基于函数的索引（序）]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470297</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470297</guid><author>congqingm32098</author><pubDate>Thu, 29 Oct 2009 23:14:23 +0800</pubDate><description><![CDATA[分析表的语句analyze table tt compute statisticsfor tablefor all indexed columnsfor all indexes/所有的索引对DML语句都有影响。在Oracle8i...]]></description><category></category></item><item><title><![CDATA[位图索引研究]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470295</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470295</guid><author>congqingm32098</author><pubDate>Wed, 28 Oct 2009 23:42:54 +0800</pubDate><description><![CDATA[位图索引用来存储有单个索引码条目的许多行的指针，而在B*Tree 结构中，索引码和表中的行是一一对应，在位图索引中，索引的条目是非常少的，每个条目指向许多行，在B*Tree索引中，是一对一的，一个索引条目指向一行。创建表EMP，...]]></description><category></category></item><item><title><![CDATA[索引压缩（三）]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470293</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470293</guid><author>congqingm32098</author><pubDate>Tue, 27 Oct 2009 21:14:08 +0800</pubDate><description><![CDATA[compress1 只压缩索引列的第一列 compress2 压缩两列，看看压缩两列和一列在使用空间上有多大区别 SQL&gt; drop index t_idx_2 ;
索引已删除。SQL&gt; create i...]]></description><category></category></item><item><title><![CDATA[基于函数的索引]]></title><link>https://blog.youkuaiyun.com/congqingm32098/article/details/100470292</link><guid>https://blog.youkuaiyun.com/congqingm32098/article/details/100470292</guid><author>congqingm32098</author><pubDate>Mon, 26 Oct 2009 21:13:21 +0800</pubDate><description><![CDATA[基于函数的索引 create index T_IDX_UPPER on t (upper(object_name)); SQL&gt; select object_name from t where upper(obj...]]></description><category></category></item></channel></rss>