<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congshi5749的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congshi5749</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congshi5749]]></copyright><item><title><![CDATA[tkprof_oracle之工具]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369215</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369215</guid><author>congshi5749</author><pubDate>Wed, 24 Aug 2011 11:22:33 +0800</pubDate><description><![CDATA[Tkprof工具可用来格式化sql trace产生的文件，让你更容易看懂trace的内容
用法：
tkprof tracefile outputfile [explain= ] [table= ] [prin...]]></description><category></category></item><item><title><![CDATA[Oracle中TO_DATE格式 --转]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369218</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369218</guid><author>congshi5749</author><pubDate>Thu, 23 Jun 2011 10:13:42 +0800</pubDate><description><![CDATA[TO_DATE格式(以时间:2007-11-02 13:45:25为例)  Year:  yy two digits 两位年 显示值:07...]]></description><category></category></item><item><title><![CDATA[Linux Top 命令详解--转]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369217</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369217</guid><author>congshi5749</author><pubDate>Mon, 20 Jun 2011 10:48:44 +0800</pubDate><description><![CDATA[Linux Top 命令详解 收藏  
 TOP命令是Linux下常用的性能分析工具，能够实时显示系统中各个进程的资源占用状况。 TOP是一个动态显示过程,即可以通过用户按键来不断刷新当前...]]></description><category></category></item><item><title><![CDATA[8个DBA最常用的监控Oracle数据库的常用shell脚本--转]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369212</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369212</guid><author>congshi5749</author><pubDate>Fri, 13 May 2011 14:44:23 +0800</pubDate><description><![CDATA[一．8个重要的脚本来监控Oracle数据库： 1.检查实例的可用性 2.检查监听器的可用性 3.检查alert日志文件中的错误信息4.在存放log文件的地方满以前清空旧的log文件 5.分析table和index以获得更好的性能...]]></description><category></category></item><item><title><![CDATA[SQL*PLUS命令的使用大全]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369350</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369350</guid><author>congshi5749</author><pubDate>Fri, 06 May 2011 10:42:41 +0800</pubDate><description><![CDATA[1. 执行一个SQL脚本文件  
SQL&gt;@ 
2. 对当前的输入进行编辑   
 SQL&gt;edit
3. 重新运行上一次运行的sql语句   
 SQL&gt;/
4. 将显示的内容...]]></description><category></category></item><item><title><![CDATA[Oracle AWR--转]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369211</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369211</guid><author>congshi5749</author><pubDate>Wed, 04 May 2011 21:09:31 +0800</pubDate><description><![CDATA[Oracle Database 10g提供了一个显著改进的工具：自动工作负载信息库（AWR：Automatic Workload Repository）。Oracle建议用户用这个取代Statspack。AWR实质上是一...]]></description><category></category></item><item><title><![CDATA[oracle中三种join方法的比较]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369357</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369357</guid><author>congshi5749</author><pubDate>Tue, 03 May 2011 16:15:12 +0800</pubDate><description><![CDATA[一.三种join方法的定义及适用情况1.Nested loop join:  outer table中的每一行与inner table中的相应记录join,类似一个嵌套的循环。  适用于outer table(有的地...]]></description><category></category></item><item><title><![CDATA[oracle in 和 exists的区别]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369306</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369306</guid><author>congshi5749</author><pubDate>Tue, 03 May 2011 15:37:50 +0800</pubDate><description><![CDATA[in 是把外表和内表作hash join,而exits是对外表作loop,每次loop再对内表进行查询。如果子查询得出的结果集记录较少，主查询中的表较大且又有索引时应该用in，反之，如果外层的主查询记录较少，子查询中的表大且又有...]]></description><category></category></item><item><title><![CDATA[数据表的连接]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369242</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369242</guid><author>congshi5749</author><pubDate>Mon, 02 May 2011 17:07:05 +0800</pubDate><description><![CDATA[数据表的连接有：1.内连接（自然连接）：只有两个表相匹配的行才能在结果集中出现。 select a.studentno,a.studentname,b.classname from stu...]]></description><category></category></item><item><title><![CDATA[复合查询操作]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369207</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369207</guid><author>congshi5749</author><pubDate>Mon, 02 May 2011 16:02:39 +0800</pubDate><description><![CDATA[1.UNION ALL：返回两个查询语句的所有行，不排序2.UNION：返回两个查询语句所有不重复的行，排序3.INTERSECT：返回两个查询语句的交集，排序4.MINUS：返回在第一个查询语句中，但不在第二个查询语句中的集合...]]></description><category></category></item><item><title><![CDATA[PL/SQL中显式游标的使用]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369206</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369206</guid><author>congshi5749</author><pubDate>Sat, 30 Apr 2011 14:48:02 +0800</pubDate><description><![CDATA[1.DECLARE v_locid NUMBER := 1700; CURSOR c_emp_cursor IS SELECT employee_id,last_name FROM employee...]]></description><category></category></item><item><title><![CDATA[SQL组函数]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369203</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369203</guid><author>congshi5749</author><pubDate>Fri, 29 Apr 2011 17:22:24 +0800</pubDate><description><![CDATA[1.组函数 COUNT(*):将返回满足WHERE条件子句中记录的个数； COUNT(expr):计算出符合表达式expr的所有的非空行的个数 SUM():返回某一列的所有数值的和； AVG():...]]></description><category></category></item><item><title><![CDATA[SQl  单行函数]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369360</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369360</guid><author>congshi5749</author><pubDate>Fri, 29 Apr 2011 16:41:48 +0800</pubDate><description><![CDATA[一.SQL中的函数分为单行函数和多行(聚合)函数。 单行函数的输入是一行，每行返回一个结果，可以被嵌套，输入参数可以是一个列的名字，可以是表达式，也可以是一个常数。 二.单行函数包括：（1）汇总函数；（2）日期与时间函...]]></description><category></category></item><item><title><![CDATA[优化排序操作（2）]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369197</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369197</guid><author>congshi5749</author><pubDate>Fri, 29 Apr 2011 10:47:01 +0800</pubDate><description><![CDATA[1.PGA自动内存管理方式2.利用动态性能视图调优：v$pgastat，v$sql_workerea_histogram(记录在不同工作区大小范围内，分别执行最优多少次，一次读取硬盘多少次，多次读取硬盘多少...]]></description><category></category></item><item><title><![CDATA[SQL优化]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369201</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369201</guid><author>congshi5749</author><pubDate>Fri, 29 Apr 2011 10:45:52 +0800</pubDate><description><![CDATA[1.对于批处理，优化器的目标是获得最大的吞吐量；
2.对于交互式应用，优化器的目标是获得最佳响应时间；
3.优化器的行为受以下三种情况控制：（1）初始化参数OPTIMIZER_MODE；（2）S...]]></description><category></category></item><item><title><![CDATA[SQL 学习笔记]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369202</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369202</guid><author>congshi5749</author><pubDate>Wed, 27 Apr 2011 17:03:52 +0800</pubDate><description><![CDATA[第七章 使用子查询

1.可以使用括号把子查询括起来；
2.子查询返回结果为单行的称为单行子查询，=,&gt;,&gt;=,；
3.子查询返回结果为多行的称为多行子查询，IN, ANY, ALL；
4.子查询返回...]]></description><category></category></item><item><title><![CDATA[oracle sql性能优化（二）-----转]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369264</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369264</guid><author>congshi5749</author><pubDate>Wed, 20 Apr 2011 14:55:58 +0800</pubDate><description><![CDATA[一、 先介绍一下oracle的SGA：数据库的系统全局区，SGA主要由三部分构成：共享池、数据缓冲区、日志缓冲区。
1、 共享池又由两部分构成：共享SQL区和数据字典缓冲区。共享SQL区专门存放用户SQL命令，oracle使用...]]></description><category></category></item><item><title><![CDATA[oracle sql性能优化（一）-----转]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369194</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369194</guid><author>congshi5749</author><pubDate>Wed, 20 Apr 2011 14:43:31 +0800</pubDate><description><![CDATA[1. 选用适合的ORACLE优化器2. 访问Table的方式3. 共享SQL语句4. 选择最有效率的表名顺序5. WHERE子句中的连接顺序．6. SELECT子句中避免使用"*"7. 减少访问数据库的次数8. 使用DECO...]]></description><category></category></item><item><title><![CDATA[oracle 基本元素---转]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369199</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369199</guid><author>congshi5749</author><pubDate>Tue, 19 Apr 2011 11:33:53 +0800</pubDate><description><![CDATA[Oracle方案——SQL Server 数据库一般在实现一个软件工程项目时，用户习惯于把数据存储在一个集中的对象中。比如：在SQL Server中，针对一个项目，我们一般创建一个数据库但是在Oracle中一...]]></description><category></category></item><item><title><![CDATA[从此开始记录我的Oracle DBA成长轨迹]]></title><link>https://blog.youkuaiyun.com/congshi5749/article/details/100369195</link><guid>https://blog.youkuaiyun.com/congshi5749/article/details/100369195</guid><author>congshi5749</author><pubDate>Sun, 17 Apr 2011 15:34:28 +0800</pubDate><description><![CDATA[从此开始记录我的Oracle DBA成长轨迹，今天先立个起点。。。。。待续
                                                            
               ...]]></description><category></category></item></channel></rss>