<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[csdn7755的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/csdn7755</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; csdn7755]]></copyright><item><title><![CDATA[oracle优化--表优化（临时表）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241301</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241301</guid><author>csdn7755</author><pubDate>Wed, 15 Aug 2018 00:12:43 +0800</pubDate><description><![CDATA[一、创建临时表与普通表





SQL&gt; CREATE GLOBAL TEMPORARY TABLE TMP_TEST ON COMMIT PRESERVE ROWS AS SELECT * FROM e...]]></description><category></category></item><item><title><![CDATA[oracle优化--表优化（宽表与父子表关联性能差异）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241279</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241279</guid><author>csdn7755</author><pubDate>Mon, 13 Aug 2018 15:54:38 +0800</pubDate><description><![CDATA[一、创建宽表并写入数据





SQL&gt; create table test


 2 (


 3 id number,


 4 co11 varchar2(2000),...]]></description><category></category></item><item><title><![CDATA[oracle优化--表优化（char VS varchar2）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241277</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241277</guid><author>csdn7755</author><pubDate>Fri, 10 Aug 2018 09:30:26 +0800</pubDate><description><![CDATA[实验结论：








1、char和varchar2占用的磁盘空间相同；




2、char与varchar2皆会产生行迁移；




3、char与varchar2产生...]]></description><category></category></item><item><title><![CDATA[oracle优化--表优化（行链接、迁移的影响与优化）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241296</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241296</guid><author>csdn7755</author><pubDate>Thu, 09 Aug 2018 11:40:52 +0800</pubDate><description><![CDATA[一、实验环境准备







SQL&gt; create table t_pctfree_tmp


 2 (


 3 id number,


 4 name var...]]></description><category></category></item><item><title><![CDATA[oracle优化--表优化（行链接产生实验）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241276</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241276</guid><author>csdn7755</author><pubDate>Wed, 08 Aug 2018 15:09:34 +0800</pubDate><description><![CDATA[一、通过一次插入一笔大于基本块大小（8K）的数据，制造一笔有行链接但没有行迁移的数据






SQL&gt; insert into t_pctfree values (10002,dbms_random....]]></description><category></category></item><item><title><![CDATA[oracle优化--表优化（行迁移产生实验）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241275</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241275</guid><author>csdn7755</author><pubDate>Tue, 07 Aug 2018 15:12:43 +0800</pubDate><description><![CDATA[1、建立实验表




create table t_pctfree


  (


  id number,


  name varchar2(2000),


 ...]]></description><category></category></item><item><title><![CDATA[oracle优化--表优化（pctfree参数）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241311</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241311</guid><author>csdn7755</author><pubDate>Mon, 06 Aug 2018 16:24:03 +0800</pubDate><description><![CDATA[试验结论：



1、当一张表自建立后只有新增基本不更新时（如存放历史记录的表），可以将pctfree参数尽量调低，这样表数据存储空间以及全表扫描时消耗都会更低；


2、但当表存在大量的update操作时，p...]]></description><category></category></item><item><title><![CDATA[oracle数据库CPU过高问题定位、分析（总结）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241280</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241280</guid><author>csdn7755</author><pubDate>Fri, 03 Aug 2018 14:02:38 +0800</pubDate><description><![CDATA[一、为ASH、AWR、ADDM、SPA分别开启会话，并使用会话跟踪：






--ASH





altersessionsetevents'10046tracenameco...]]></description><category></category></item><item><title><![CDATA[oracle数据库CPU过高问题定位、分析（五）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100241273</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100241273</guid><author>csdn7755</author><pubDate>Thu, 02 Aug 2018 13:36:51 +0800</pubDate><description><![CDATA[一、执行一条sql查询无索引的大表，使服务器一核CPU使用近100%


SQL&gt;select*fromscott.t3wherename=dbms_random.string('u',10);
...]]></description><category></category></item><item><title><![CDATA[oracle数据库CPU过高问题定位、分析（四）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100196718</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100196718</guid><author>csdn7755</author><pubDate>Wed, 01 Aug 2018 10:17:40 +0800</pubDate><description><![CDATA[一、通过top命令可以看到会话PID19237占用大量的CPU


Tasks:233total,2running,231sleeping,0stopped,0zombie
Cpu0...]]></description><category></category></item><item><title><![CDATA[oracle数据库CPU过高问题定位、分析（三）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100196726</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100196726</guid><author>csdn7755</author><pubDate>Tue, 31 Jul 2018 13:37:34 +0800</pubDate><description><![CDATA[一、环境准备






1、查看当前快照情况





SQL&gt;selectmax(snap_id)fromdba_hist_snapshots;...]]></description><category></category></item><item><title><![CDATA[oracle数据库CPU过高问题定位、分析（二）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100196721</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100196721</guid><author>csdn7755</author><pubDate>Mon, 30 Jul 2018 16:10:11 +0800</pubDate><description><![CDATA[一、




ASH










颗粒度最细最常用的诊断工具，通常当问题刚发生时，即可立即根据生成的ash报告诊断问题





下文示例为当问题出现后，查看最近5...]]></description><category></category></item><item><title><![CDATA[oracle数据库CPU过高问题定位、分析（一）]]></title><link>https://blog.youkuaiyun.com/csdn7755/article/details/100196716</link><guid>https://blog.youkuaiyun.com/csdn7755/article/details/100196716</guid><author>csdn7755</author><pubDate>Fri, 27 Jul 2018 11:22:08 +0800</pubDate><description><![CDATA[top-00:05:18up21:37,7users,loadaverage:0.54,0.17,0.14
Tasks:236total,3running,233sleeping,...]]></description><category></category></item></channel></rss>