<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:admin="http://webns.net/mvcb/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">
<channel>
<title>Oracle Life</title>
<link>http://www.eygle.com/blog/</link>
<description>eygle的Oracle Blog，提供Oracle技术研究及深入探讨，同时记录个人爱好及生活历程。</description>
<language>en</language>
<copyright>Copyright 2009</copyright>
<lastBuildDate>format_name=</lastBuildDate>
<generator>http://www.sixapart.com/movabletype/</generator>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
<creator>eygle@eygle.com</creator>
<admin:errorReportsTo rdf:resource="mailto:eygle@eygle.com" />
<updatePeriod>hourly</updatePeriod>
<updateFrequency>1</updateFrequency>
<updateBase>2007-01-01T12:00+00:00</updateBase>


--------------------------------------------------------------------------------
<image><url>http://www.feedburner.com/fb/images/pub/fb_pwrd.gif</url></image><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/EyglesOracleBlog" type="application/rss+xml" /><feedburner:browserFriendly>This is an XML content feed. It is intended to be viewed in a newsreader or syndicated to another site, subject to copyright and fair use.</feedburner:browserFriendly><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><item>
<title>10.2.0.4 LGWR Trace Warning: Log Write Time</title>
<description>这些信息提示，数据库的日志写出现较长的等待，超过500ms的写出会被记录，一般来说是ＩＯ存在问题，写出缓慢所致。</description>
<link>http://www.eygle.com/archives/2009/11/log_write_time.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/log_write_time.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

今天在客户的环境中，发现ＬＧＷＲ的跟踪文件中包含了如下一些记录：<br /><blockquote>*** 2009-10-19 13:13:51.534<br />Warning: log write time 720ms, size 3KB<br />*** 2009-10-20 10:33:27.372<br />Warning: log write time 510ms, size 2KB<br />*** 2009-10-21 02:00:01.159<br />Warning: log write time 10521085310ms, size 8KB<br />*** 2009-10-22 10:35:57.932<br />Warning: log write time 570ms, size 1KB<br />*** 2009-11-03 10:36:52.851<br />Warning: log write time 610ms, size 2KB<br />*** 2009-11-03 10:36:54.938<br />Warning: log write time 860ms, size 2KB<br />*** 2009-11-12 08:23:25.525<br />Warning: log write time 750ms, size 1KB</blockquote> 这些信息提示，数据库的日志写出现较长的等待，超过500ms的写出会被记录，一般来说是ＩＯ存在问题，写出缓慢所致。<br /><br />检索Metalink，发现这是10.2.0.4中引入的，如果确认硬件没有问题则可以忽略之。<br />注意，在备份时间，凌晨两点，这个LOG写出延时达到了恐怖的数字：10521085310ms<br />事实上不可能是这么长的等待，因此我想这是Oracle诊断输出的一个Debug信息，忘了去掉而已吧。<br /><br />Metaliink Note：601316.1<br /><br />-The End-<br /><br /><br /><img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2007/04/fibre_channel_lgwr.html">光纤通道故障导致数据库崩溃</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2007/03/lgwr_nice_aix.html">LGWR与AIX上的进程优先级</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2005/02/redoaeoeio.html">触发redo写的几个条件</a><br /></li>
</ul></p>



<p><strong>评论数量(5)|<a href="http://www.eygle.com/archives/2009/11/log_write_time.html#comments" title="Comment on: 10.2.0.4 LGWR Trace Warning: Log Write Time">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/log_write_time.html">http://www.eygle.com/archives/2009/11/log_write_time.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/f7FQttoIyHM" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">FAQ</category>

<category domain="http://www.sixapart.com/ns/types#category">Oracle10g/11g</category>


<category domain="http://www.sixapart.com/ns/types#tag">LGWR</category>

<pubDate>Thu, 12 Nov 2009 13:05:24 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>工作日志：闪回查询及scn_to_timestamp</title>
<description>上周在培训期间，一个客户的数据库出了误UPDATE的问题，修改错了数据，请求我帮忙恢复。闪回查询在这类误操作中非常有用，只要发现的及时，数据可以快速的闪回回来，我想这是开发人员也应该掌握的SQL查询。
</description>
<link>http://www.eygle.com/archives/2009/11/scn_to_timestamp.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/scn_to_timestamp.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

上周在培训期间，一个客户的数据库出了误UPDATE的问题，修改错了数据，请求我帮忙恢复。<br /><br />闪回查询在这类误操作中非常有用，只要发现的及时，数据可以快速的闪回回来，我想这是开发人员也应该掌握的SQL查询。<br /><br />记录一下工作日志：<br /><blockquote>SQL&gt; desc lm_mtrp_syn_channelinfo<br />&nbsp;Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Null?&nbsp;&nbsp;&nbsp; Type<br />&nbsp;----------------------------------------- -------- ----------------------------<br />&nbsp;CHANNELID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;SGWID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(50)<br />&nbsp;SERVICETYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(50)<br />&nbsp;SPNUMBER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(50)<br />&nbsp;CMD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(50)<br />&nbsp;CREATETIME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATE<br />&nbsp;MORE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(500)<br /><br />SQL&gt; select count(*) from lm_mtrp_syn_channelinfo;<br /><br />&nbsp; COUNT(*)<br />----------<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21<br /><br />SQL&gt; select dbms_flashback.get_system_change_number from dual;<br /><br />GET_SYSTEM_CHANGE_NUMBER<br />------------------------<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 708677858<br /><br />SQL&gt; select count(*) from lm_mtrp_syn_channelinfo as of scn 708600000;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br /><br />&nbsp; COUNT(*)<br />----------<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21<br /><br />SQL&gt; select count(*) from lm_mtrp_syn_channelinfo as of scn 708000000;<br /><br />&nbsp; COUNT(*)<br />----------<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21<br /><br />SQL&gt; select scn_to_timestamp(708000000) from dual;<br /><br />SCN_TO_TIMESTAMP(708000000)<br />---------------------------------------------------------------------------<br />05-NOV-09 01.37.08.000000000 PM<br /><br />SQL&gt; create table lm_temp as select * from lm_mtrp_syn_channelinfo as of scn 708000000;<br /><br />Table created.<br /></blockquote><br />-The End-<br /><br /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2006/11/oracle11g_database_replay.html">Oracle11g的新特性:Database和SQL重演(replay)</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2006/09/undo_retention_need_change.html">修改默认的undo_retention参数设置</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2005/12/how_to_maintain_10g_recyclebin.html">How to maintain Oracle10g Recyclebin?</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2005/12/oracle10g_flash_recovery_area_space_management.html">Oracle10g New Feature:闪回恢复区空间管理</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2005/09/oracle_10gr2_st_1.html">Oracle 10gR2 Study Notes:New View V$FLASH_RECOVERY_AREA_USAGE</a><br /></li>
</ul></p>



<p><strong>评论数量(3)|<a href="http://www.eygle.com/archives/2009/11/scn_to_timestamp.html#comments" title="Comment on: 工作日志：闪回查询及scn_to_timestamp">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/scn_to_timestamp.html">http://www.eygle.com/archives/2009/11/scn_to_timestamp.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/xXJVpvQnCJs" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">FAQ</category>


<category domain="http://www.sixapart.com/ns/types#tag">Flashback</category>

<pubDate>Wed, 11 Nov 2009 14:28:01 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>PowerPoint不能输入中文 - 令人抓狂的诡异</title>
<description>Google了一下，找到了办法，将微软的拼音输入法从输入法选项里加入进来，好了。</description>
<link>http://www.eygle.com/archives/2009/11/powerpoint_failed_chinese.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/powerpoint_failed_chinese.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

最近有一大堆讲义要准备，晚上回家忽然发现PowerPoint不让我输入中文了。英文是没有问题的。<br /><br />Google了一下，找到了办法，将微软的拼音输入法从输入法选项里加入进来，好了。<br />这是什么TMD逻辑，真是让人抓狂，遂记录之。<br /><br /><br /> <img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2006/12/microsoft_office_2007_pptx.html">体验微软的 Office 2007 新版本</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2006/11/vista_office_2007.html">参加微软的"迎接新纪元"产品发布会</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2006/11/2006q3_china_database_market_share.html">2006年Q3中国数据库市场 Oracle再占首位</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2006/10/outlook_express_rule_backup.html">如何备份OutLook Express的邮件规则</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2006/06/thanks_microsoft.html">以客户为中心 感谢微软</a><br /></li>
</ul></p>



<p><strong>评论数量(6)|<a href="http://www.eygle.com/archives/2009/11/powerpoint_failed_chinese.html#comments" title="Comment on: PowerPoint不能输入中文 - 令人抓狂的诡异">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/powerpoint_failed_chinese.html">http://www.eygle.com/archives/2009/11/powerpoint_failed_chinese.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/4-Jac46k-9I" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Windows</category>


<category domain="http://www.sixapart.com/ns/types#tag">Microsoft</category>

<pubDate>Tue, 10 Nov 2009 23:33:58 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>Oracle 11gR2  Solaris (SPARC) (64-bit) 发布</title>
<description>据说下一个来的将是11gR2 For Solaris X86版本，IBM Aix的版本据说要等到明年了。</description>
<link>http://www.eygle.com/archives/2009/11/oracle_11gr2_so.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/oracle_11gr2_so.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

今天，Oracle 11gR2版本For Solaris Sparc 64位的版本已经发布。<br /><br />现在11gr2已经有以下三个版本了：<br /><br /><span class="boldbodycopy">(11.2.0.1.0)</span><br />
                    <span class="bodycopy"><img src="http://oracleimg.com/admin/images/ocom/download_icon13.gif" alt="Download" align="top" border="0" height="13" width="13" /> 
                    Linux x86&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                    <a href="http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip" name="linuxdatabase_112010_disk1" onclick="youMustAgreePrompt();" class="boldbodylink">Disk 
                    1</a>, <a href="http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip" name="linuxdatabase_112010_disk2" onclick="youMustAgreePrompt();" class="boldbodylink">Disk 
                    2 </a>(2.1 GB) | <a href="http://www.oracle.com/technology/software/products/database/oracle11g/112010_linuxsoft.html" class="boldbodylink">See 
                    All</a> (Including Client, Gateways, Grid Infrastructure, 
                    more)<br />
                    <img src="http://oracleimg.com/admin/images/ocom/download_icon13.gif" alt="Download" align="top" border="0" height="13" width="13" /> 
                    Linux x86-64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                    <a href="http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip" name="linuxx8664database_112010_disk1" onclick="youMustAgreePrompt();" class="boldbodylink">Disk 
                    1</a>, <a href="http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip" name="linuxx8664database_112010_disk2" onclick="youMustAgreePrompt();" class="boldbodylink">Disk 
                    2</a> (2.2 GB) | <a href="http://www.oracle.com/technology/software/products/database/oracle11g/112010_linx8664soft.html" class="boldbodylink">See 
                    All</a> (Including Client, Gateways, Grid Infrastructure, 
                    more)<br />
                    <img src="http://oracleimg.com/admin/images/ocom/download_icon13.gif" alt="Download" align="top" border="0" height="13" width="13" /> 
                    Solaris (SPARC) (64-bit) <a href="http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_1of2.zip" name="sol64database_112010_disk1" onclick="youMustAgreePrompt();" class="boldbodylink">Disk 
                    1</a>, <a href="http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_2of2.zip" name="sol64database_112010_disk2" onclick="youMustAgreePrompt();" class="boldbodylink">Disk 
                    2</a> (2.3 GB) | <a href="http://www.oracle.com/technology/software/products/database/oracle11g/112010_sparc64soft.html" class="boldbodylink">See 
                    All</a> (Including Client, Gateways, Grid Infrastructure, 
                    more) </span><br /><br /><br />据说下一个来的将是11gR2 For Solaris X86版本，IBM Aix的版本据说要等到明年了。<br /><br /><br /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2007/07/oracle11g_whitepaper.html">Oracle Database 11g 的相关文档</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/11/11gr2_dbms_parallel_execute.html">11gR2新特性之- 并行DBMS_PARALLEL_EXECUTE</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/oracle_11gr2_first.html">Oracle 11gR2 安装初体验 - OEL + Oracle</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/2009_sacc_ppt_download.html">2009 系统架构师大会 PPT 下载地址</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/oracle11gr2_upgrade_path.html">Oracle Database 11gR2的升级路径与升级思考</a><br /></li>
</ul></p>



<p><strong>评论数量(6)|<a href="http://www.eygle.com/archives/2009/11/oracle_11gr2_so.html#comments" title="Comment on: Oracle 11gR2  Solaris (SPARC) (64-bit) 发布">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/oracle_11gr2_so.html">http://www.eygle.com/archives/2009/11/oracle_11gr2_so.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/MNJhVKEiUqw" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Download</category>

<category domain="http://www.sixapart.com/ns/types#category">OraNews</category>


<category domain="http://www.sixapart.com/ns/types#tag">Download</category>

<category domain="http://www.sixapart.com/ns/types#tag">Oracle11g</category>

<pubDate>Tue, 10 Nov 2009 13:24:41 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>2009中国软件技术大会 - 深入解析Oracle主题演讲</title>
<description>在这一年中，为很多用户进行了数据库的调整与优化工作，在这些工作中，发现很多不同的系统却面临着很多类似的技术问题，进而将这些问题汇总提升到架构方面，可以发现，很多架构设计上的考虑不周到最后都会导致系统存在严重的瓶颈。</description>
<link>http://www.eygle.com/archives/2009/11/2009_softcon.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/2009_softcon.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

本周，一年一度的中国软件大会将在北京举行，在这个会议上，有我的一个主题演讲。<br /><br />我的演讲时间在周六11月14日，上午10：30，题目定为：<a href="http://www.softcon.cn/calendar.asp"><b>《深入解析Oracle - 数据库架构设计与性能优化实践》</b></a><br /><br />在这一年中，为很多用户进行了数据库的调整与优化工作，在这些工作中，发现很多不同的系统却面临着很多类似的技术问题，进而将这些问题汇总提升到架构方面，可以发现，很多架构设计上的考虑不周到最后都会导致系统存在严重的瓶颈。<br /><br />这也是最近几年很多大型企业在不断进行架构的调整、优化，以实现更好的线性或近似线性扩展性能，甚至开始从Oracle向MYSQL迁移。<br /><br />这个主题就从这些实践与架构上的思考展开。<br /><br /><br /> <img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2008/11/finished_softcon.html">完成软件技术大会《深入解析Oracle》演讲</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/03/song_erricsson_training.html">结束索尼爱立信的数据库培训项目</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/03/dive_into_oracle.html">小记《深入解析Oracle》技术交流会</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/12/oracle_internals_at_it168.html">结束《深入解析Oracle》技术访谈交流会</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/12/it168_30_oracle_internals.html">It168名家讲坛 - 30日下午 《深入解析Oracle》</a><br /></li>
</ul></p>



<p><strong>评论数量(5)|<a href="http://www.eygle.com/archives/2009/11/2009_softcon.html#comments" title="Comment on: 2009中国软件技术大会 - 深入解析Oracle主题演讲">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/2009_softcon.html">http://www.eygle.com/archives/2009/11/2009_softcon.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/fD3Nz2qL-Dw" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Activity</category>

<category domain="http://www.sixapart.com/ns/types#category">OraNews</category>


<category domain="http://www.sixapart.com/ns/types#tag">Lecture</category>

<category domain="http://www.sixapart.com/ns/types#tag">SoftCon</category>

<pubDate>Mon, 09 Nov 2009 11:44:38 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>恩墨科技的第二次培训(2009年11月)圆满结束</title>
<description>10位朋友来自9个省市，五湖四海，最远的来自广西，北京最近雾蒙蒙的天气丝毫没有降低大家的学习热情，虽然一如既往的，我牵扯不休的内容使得课程的发散性不断扩展，可是我想我还是传达出了我的方法、我的思路、我的关于数据库架构的理解与认识。</description>
<link>http://www.eygle.com/archives/2009/11/enmotech_workshop_two.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/enmotech_workshop_two.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

感谢各位朋友的支持与信赖，<a href="http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html">四天的培训</a>圆满落下了帷幕。从11月5日开始，至11月8日结束，4天的时间漫长又短暂，10位朋友来自9个省市，五湖四海，最远的来自广西.<br /><br />北京最近雾蒙蒙的天气丝毫没有降低大家的学习热情，虽然一如既往的，我牵扯不休的内容使得课程的发散性不断扩展，可是我想<b>我还是传达出了我的方法、我的思路、我的关于数据库架构的理解与认识</b>。<br /><br />中午我请大家在太熟悉家常菜聚餐，大家热情交流仿佛老友。<br /><br />以下是这次培训的合影。<br /><br />再次感谢大伙的信任与支持，希望以后能有机会在其他的天涯海角重新聚首：<br /><img alt="IMG_1330_2.JPG" src="http://www.eygle.com/blog/images/IMG_1330_2.JPG" class="mt-image-none" style="" height="525" width="700" /> <div><br /></div><img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /><br />-The End-<br /><br /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html">恩墨科技的第二次培训明日（11.5）开始</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/11/enmotech_redbull.html">恩墨科技签约红牛集团 提供SAP数据库支持服务</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/performance_tuning_workshop_two_coming_soon.html">恩墨科技第二次性能优化培训时间确定</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/training_delay.html">关于恩墨科技第二次培训暂时推迟的通知</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/sap_db_recovery.html">恩墨科技为某企业SAP数据库提供紧急援助服务</a><br /></li>
</ul></p>



<p><strong>评论数量(4)|<a href="http://www.eygle.com/archives/2009/11/enmotech_workshop_two.html#comments" title="Comment on: 恩墨科技的第二次培训(2009年11月)圆满结束">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/enmotech_workshop_two.html">http://www.eygle.com/archives/2009/11/enmotech_workshop_two.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/PbuBxRu0UJE" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Life</category>


<category domain="http://www.sixapart.com/ns/types#tag">enmo</category>

<pubDate>Sun, 08 Nov 2009 18:57:32 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>SAP之ORA-20005: object statistics are locked </title>
<description>在SAP的数据库优化中，当尝试收集一个数据表的数据时，遇到如下错误</description>
<link>http://www.eygle.com/archives/2009/11/sap_stat_locked.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/sap_stat_locked.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

在SAP的数据库优化中，当尝试收集一个数据表的数据时，遇到如下错误：<br /><br /><blockquote>&nbsp;&nbsp;&nbsp; SQL&gt; exec dbms_stats.gather_table_stats('SAPSR','QIN');<br />&nbsp;&nbsp;&nbsp; BEGIN dbms_stats.gather_table_stats('SAPSR3','TRFCQIN'); END;<br /><br />&nbsp;&nbsp;&nbsp; *<br />&nbsp;&nbsp;&nbsp; ERROR at line 1:<br />&nbsp;&nbsp;&nbsp; ORA-20005: object statistics are locked (stattype = ALL)<br />&nbsp;&nbsp;&nbsp; ORA-06512: at "SYS.DBMS_STATS", line 13159<br />&nbsp;&nbsp;&nbsp; ORA-06512: at "SYS.DBMS_STATS", line 13179<br />&nbsp;&nbsp;&nbsp; ORA-06512: at line 1<br /></blockquote><br />这个提示告诉我们，这个表的统计计息被锁定，不允许更新，这是Oracle 10g的一个新特性，允许我们锁定某些对象的统计信息：<br /><br /><blockquote>&nbsp;&nbsp;&nbsp; PROCEDURE LOCK_TABLE_STATS<br />&nbsp;&nbsp;&nbsp;&nbsp; Argument Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In/Out Default?<br />&nbsp;&nbsp;&nbsp;&nbsp; ------------------------------ ----------------------- ------ --------<br />&nbsp;&nbsp;&nbsp;&nbsp; OWNNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; TABNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; STATTYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN&nbsp;&nbsp;&nbsp;&nbsp; DEFAULT<br />&nbsp;&nbsp;&nbsp; PROCEDURE LOCK_PARTITION_STATS<br />&nbsp;&nbsp;&nbsp;&nbsp; Argument Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In/Out Default?<br />&nbsp;&nbsp;&nbsp;&nbsp; ------------------------------ ----------------------- ------ --------<br />&nbsp;&nbsp;&nbsp;&nbsp; OWNNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; TABNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; PARTNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp; PROCEDURE LOCK_SCHEMA_STATS<br />&nbsp;&nbsp;&nbsp;&nbsp; Argument Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In/Out Default?<br />&nbsp;&nbsp;&nbsp;&nbsp; ------------------------------ ----------------------- ------ --------<br />&nbsp;&nbsp;&nbsp;&nbsp; OWNNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; STATTYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN&nbsp;&nbsp;&nbsp;&nbsp; DEFAULT<br /></blockquote><br />当然可以找到相应的解锁过程：<br /><br /><blockquote>&nbsp;&nbsp;&nbsp; PROCEDURE UNLOCK_PARTITION_STATS<br />&nbsp;&nbsp;&nbsp;&nbsp; Argument Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In/Out Default?<br />&nbsp;&nbsp;&nbsp;&nbsp; ------------------------------ ----------------------- ------ --------<br />&nbsp;&nbsp;&nbsp;&nbsp; OWNNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; TABNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; PARTNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp; PROCEDURE UNLOCK_SCHEMA_STATS<br />&nbsp;&nbsp;&nbsp;&nbsp; Argument Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In/Out Default?<br />&nbsp;&nbsp;&nbsp;&nbsp; ------------------------------ ----------------------- ------ --------<br />&nbsp;&nbsp;&nbsp;&nbsp; OWNNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; STATTYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN&nbsp;&nbsp;&nbsp;&nbsp; DEFAULT<br />&nbsp;&nbsp;&nbsp; PROCEDURE UNLOCK_TABLE_STATS<br />&nbsp;&nbsp;&nbsp;&nbsp; Argument Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In/Out Default?<br />&nbsp;&nbsp;&nbsp;&nbsp; ------------------------------ ----------------------- ------ --------<br />&nbsp;&nbsp;&nbsp;&nbsp; OWNNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; TABNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN<br />&nbsp;&nbsp;&nbsp;&nbsp; STATTYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IN&nbsp;&nbsp;&nbsp;&nbsp; DEFAULT<br /></blockquote><br />这些锁定信息可以通过DBA的字典表查看：<br /><br /><blockquote>&nbsp;&nbsp;&nbsp; SQL&gt; desc dba_tab_statistics<br />&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Null?&nbsp;&nbsp;&nbsp; Type<br />&nbsp;&nbsp;&nbsp;&nbsp; ----------------------------------------- -------- ----------------------------<br />&nbsp;&nbsp;&nbsp;&nbsp; OWNER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(30)<br />&nbsp;&nbsp;&nbsp;&nbsp; TABLE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(30)<br />&nbsp;&nbsp;&nbsp;&nbsp; PARTITION_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(30)<br />&nbsp;&nbsp;&nbsp;&nbsp; PARTITION_POSITION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; SUBPARTITION_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(30)<br />&nbsp;&nbsp;&nbsp;&nbsp; SUBPARTITION_POSITION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; OBJECT_TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(12)<br />&nbsp;&nbsp;&nbsp;&nbsp; NUM_ROWS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; BLOCKS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; EMPTY_BLOCKS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; AVG_SPACE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; CHAIN_CNT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; AVG_ROW_LEN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; AVG_SPACE_FREELIST_BLOCKS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; NUM_FREELIST_BLOCKS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; AVG_CACHED_BLOCKS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; AVG_CACHE_HIT_RATIO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; SAMPLE_SIZE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER<br />&nbsp;&nbsp;&nbsp;&nbsp; LAST_ANALYZED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATE<br />&nbsp;&nbsp;&nbsp;&nbsp; GLOBAL_STATS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(3)<br />&nbsp;&nbsp;&nbsp;&nbsp; USER_STATS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(3)<br />&nbsp;&nbsp;&nbsp;&nbsp; STATTYPE_LOCKED&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(5)<br />&nbsp;&nbsp;&nbsp;&nbsp; STALE_STATS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VARCHAR2(3)<br /></blockquote><br />确认一下SAP锁定了哪些信息：<br /><br /><blockquote>&nbsp;&nbsp;&nbsp; SQL&gt; select owner,table_name,num_rows,blocks,avg_space,last_analyzed,stattype_locked<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp; from dba_tab_statistics where STATTYPE_LOCKED is not null and rownum &lt;200;<br /><br />&nbsp;&nbsp;&nbsp; OWNER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLE_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUM_ROWS&nbsp;&nbsp;&nbsp;&nbsp; BLOCKS&nbsp; AVG_SPACE LAST_ANALYZED&nbsp;&nbsp; STATT<br />&nbsp;&nbsp;&nbsp; --------------- ------------------------------ ---------- ---------- ---------- --------------- -----<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AQ_EVENT_TABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AQ_SRVNTFN_TABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYSTEM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEF$_AQCALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYSTEM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DEF$_AQERROR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SCHEDULER$_JOBQTAB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SCHEDULER$_EVENT_QTAB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KUPC$DATAPUMP_QUETAB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AQ$_MEM_MC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALERT_QT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SYS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYS$SERVICE_METRICS_TAB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DDXTF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3579&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 151&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DDXTT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 467&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 244&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ARFCRSTATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3390&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ARFCSDATA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 419227&nbsp;&nbsp;&nbsp;&nbsp; 120000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ARFCSSTATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 331849&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QREFTID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 330878&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRBAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSCLUP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1296545&nbsp;&nbsp;&nbsp;&nbsp; 114389&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSCLUP2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1296545&nbsp;&nbsp;&nbsp;&nbsp; 114389&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSCLUR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1296948&nbsp;&nbsp;&nbsp;&nbsp; 180456&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSCLUR2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1296948&nbsp;&nbsp;&nbsp;&nbsp; 180456&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPERRO2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPERROR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPVERS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1296545&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17745&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPVERS2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1296545&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17745&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TATAF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2952&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 103&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TBTCO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5078&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 244&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 22-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRFCQDATA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71165&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRFCQIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20994&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRFCQOUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 331796&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRFCQSTATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29575&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TRBAT2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPEMAS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 435530&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11369&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPEMAS2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 435530&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11369&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPMAST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 435530&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20041&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br />&nbsp;&nbsp;&nbsp; SAPSR3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SXMSPMAST2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 435530&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20041&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 26-JUN-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL<br /><br />&nbsp;&nbsp;&nbsp; 36 rows selected.<br /></blockquote><br />可以通过简单的测试了解整个功能：<br /><br /><blockquote>&nbsp;&nbsp;&nbsp; SQL&gt; select stattype_locked<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp; from USER_TAB_STATISTICS where table_name='EYGLE';<br /><br />&nbsp;&nbsp;&nbsp; STATT<br />&nbsp;&nbsp;&nbsp; -----<br /><br /><br />&nbsp;&nbsp;&nbsp; SQL&gt; exec dbms_stats.lock_table_stats('EYGLE','EYGLE');<br /><br />&nbsp;&nbsp;&nbsp; PL/SQL procedure successfully completed.<br /><br />&nbsp;&nbsp;&nbsp; SQL&gt; select stattype_locked from USER_TAB_STATISTICS where table_name='EYGLE';<br /><br />&nbsp;&nbsp;&nbsp; STATT<br />&nbsp;&nbsp;&nbsp; -----<br />&nbsp;&nbsp;&nbsp; ALL<br /><br />&nbsp;&nbsp;&nbsp; SQL&gt; exec dbms_stats.gather_table_stats('EYGLE','EYGLE');<br />&nbsp;&nbsp;&nbsp; BEGIN dbms_stats.gather_table_stats(user,'a'); END;<br /><br />&nbsp;&nbsp;&nbsp; *<br />&nbsp;&nbsp;&nbsp; ERROR at line 1:<br />&nbsp;&nbsp;&nbsp; ORA-20005: object statistics are locked (stattype = ALL)<br />&nbsp;&nbsp;&nbsp; ORA-06512: at "SYS.DBMS_STATS", line 13056<br />&nbsp;&nbsp;&nbsp; ORA-06512: at "SYS.DBMS_STATS", line 13076<br />&nbsp;&nbsp;&nbsp; ORA-06512: at line 1<br /><br /><br />&nbsp;&nbsp;&nbsp; SQL&gt; exec dbms_stats.unlock_table_stats('EYGLE','EYGLE');<br /><br />&nbsp;&nbsp;&nbsp; PL/SQL procedure successfully completed.<br /><br />&nbsp;&nbsp;&nbsp; SQL&gt; exec dbms_stats.gather_table_stats('EYGLE','EYGLE');<br /><br />&nbsp;&nbsp;&nbsp; PL/SQL procedure successfully completed.<br /><br />&nbsp;&nbsp;&nbsp; SQL&gt; select stattype_locked from USER_TAB_STATISTICS where table_name='EYGLE';<br /><br />&nbsp;&nbsp;&nbsp; STATT<br />&nbsp;&nbsp;&nbsp; -----<br /></blockquote><br />而在Oracle10g中，这个锁定可能和imp/impdp时制定rows=n的选项有关：<br /><br /><blockquote>&nbsp;&nbsp;&nbsp; Symptoms<br />&nbsp;&nbsp;&nbsp; ---------<br />&nbsp;&nbsp;&nbsp; Either of the following two error messages are signaled:<br />&nbsp;&nbsp;&nbsp; 1. ORA-38029: object statistics are locked<br />&nbsp;&nbsp;&nbsp; 2. ORA-20005: object statistics are locked (stattype = ALL)<br /><br />&nbsp;&nbsp;&nbsp; Cause<br />&nbsp;&nbsp;&nbsp; ---------<br />&nbsp;&nbsp;&nbsp; Possible Cause 1:<br />&nbsp;&nbsp;&nbsp; DBMS_STATS.LOCK_[SCHEMA|TABLE]_STATS has been used to lock statistics on the table.<br /><br />&nbsp;&nbsp;&nbsp; Possible Cause 2:<br />&nbsp;&nbsp;&nbsp; Using import (imp) or data pump import (impdp) to import a table without data results in the table's statistics being locked in 10gR2.<br /><br />&nbsp;&nbsp;&nbsp; Possible Cause 3: <br />&nbsp;&nbsp;&nbsp; After an IMPORT is finished for which ROWS=N, the statistics for all tables imported will be locked.<br />&nbsp;&nbsp;&nbsp; Part Number B14233-04 Database Readme 10g Release 2 (10.2) (39.5 Original Export/Import)<br /><br />&nbsp;&nbsp;&nbsp; Possible Cause 4: If the table is a queue table then the statistics are intended to be empty and locked so that dynamic sampling will be used due to the table's volatility. During an upgrade to 10gR2 statistics on queue tables are deleted and then locked. In 10gR2 when a queue table is created statistics are locked while still empty.<br /><br />&nbsp;&nbsp;&nbsp; Solution<br />&nbsp;&nbsp;&nbsp; ---------<br />&nbsp;&nbsp;&nbsp; If the table is a queue table then the statistics should remain empty and locked so that dynamic sampling is used due to the volatility of queue tables. If the table is not a queue table, unlock the statistics using DBMS_STATS.UNLOCK_[SCHEMA|TABLE]_STATS or gather statistics on the table using DBMS_STATS.GATHER_[SCHEMA|TABLE|INDEX]_STATS and the force=&gt;true parameter.<br /><br />&nbsp;&nbsp;&nbsp; To prevent import (imp) from locking the table's statistics when importing a table without therows (rows=n), use statistics=none. To prevent data pump import (impdp) from locking the table's statistics when importing a table without the rows (content=metadata_only), use exclude=(table_statistics,index_statistics).<br /></blockquote><br />以下是几个网友遇到问题的参考链接：<br />http://space.itpub.net/9252210/viewspace-607376<br />http://space.itpub.net/9252210/viewspace-607297<br />http://yangtingkun.itpub.net/post/468/489433<br /><br />供参考！<br /><br />-The End-<br /><br /><br /> <img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/09/gather_stats_job.html">如何检查GATHER_STATS_JOB任务的执行情况</a><br /></li>
</ul></p>



<p><strong>评论数量(0)|<a href="http://www.eygle.com/archives/2009/11/sap_stat_locked.html#comments" title="Comment on: SAP之ORA-20005: object statistics are locked ">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/sap_stat_locked.html">http://www.eygle.com/archives/2009/11/sap_stat_locked.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/oHDD_IpDDrk" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">FAQ</category>

<category domain="http://www.sixapart.com/ns/types#category">Oracle10g/11g</category>


<category domain="http://www.sixapart.com/ns/types#tag">dbms_stats</category>

<pubDate>Thu, 05 Nov 2009 08:38:56 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>恩墨科技的第二次培训明日（11.5）开始</title>
<description>明天，恩墨科技的第二次培训将要开始了，这是又一次为期4天的培训，希望对参加培训的朋友都是一次愉快的旅程。</description>
<link>http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

明天，恩墨科技的<a href="http://www.eygle.com/archives/2009/08/perftuning_dbdiag_workshop_two.html">第二次培训</a>将要开始了，这是又一次为期4天的培训，希望对参加培训的朋友都是一次愉快的旅程。<br /><br />这次培训有可能是我这个系列培训的最后一场，组织一次培训实为不易，几次想取消这个培训，可是有自上次就一直想听这个课的朋友，还是讲一场，对朋友们算是有个交代。<br /><br />此后，这个课程的精简版，将以一个2天课程的形式由OU（Oracle University）推出，这下我可以省下不少麻烦，OU的销售力量是空前的，据说几天的推广就有十数人报名参加了。<br /><br />OU将这个课程命名为：<br /><b>深入解析Oracle-实战案例模拟与实践30讲<br />Oracle Database Best Practices-<br />30 Trouble Shooting and Tuning Case Studies</b><br /><br />感谢OU May的高效组织与协调，将这个课程这么快就推了出来。预祝明天的培训和之后的培训都能使朋友们受益。<br /><br />-The End-<br /><br /> <img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/10/performance_tuning_workshop_two_coming_soon.html">恩墨科技第二次性能优化培训时间确定</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/08/perftuning_dbdiag_workshop_two.html">恩墨科技第二届Oracle性能优化与诊断案例培训</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/07/performance_tuning_coming_soon.html">恩墨科技Oracle性能优化与诊断案例培训开课</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/07/performance_tuning_db_diag.html">恩墨科技将举行Oracle性能优化与诊断案例培训</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/11/enmotech_workshop_two.html">恩墨科技的第二次培训(2009年11月)圆满结束</a><br /></li>
</ul></p>



<p><strong>评论数量(17)|<a href="http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html#comments" title="Comment on: 恩墨科技的第二次培训明日（11.5）开始">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html">http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/XgfB5mOE3XA" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Life</category>

<category domain="http://www.sixapart.com/ns/types#category">OraNews</category>


<category domain="http://www.sixapart.com/ns/types#tag">enmo</category>

<category domain="http://www.sixapart.com/ns/types#tag">training</category>

<pubDate>Wed, 04 Nov 2009 21:44:14 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>恩墨科技签约红牛集团 提供SAP数据库支持服务</title>
<description>感谢红牛集团选择了恩墨科技作为数据库运维的服务提供商！</description>
<link>http://www.eygle.com/archives/2009/11/enmotech_redbull.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/enmotech_redbull.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="redbull.jpg" src="http://www.eygle.com/blog/images/redbull.jpg" class="mt-image-right" style="margin: 0pt 0pt 20px 20px; float: right;" height="144" width="155" /></span> <div><font style="font-size: 1.5625em;">近</font>期恩墨科技签约红牛集团，为用户提供SAP应用后台数据库的优化及运维支持。<br /><br /><b>红牛功能饮料源于泰国</b>，至今已有40年的行销历史，凭借着卓著的品质和功能，产品行销全球140多个国家与地区，凭借着强劲的实力和信誉，"红牛"创造了非凡的业绩，成为<b>世界销量第一的功能饮料，2006年在全球年销量达40亿罐</b>。<br /><br />1995年12月，"红牛"来到中国，成立了红牛维他命饮料有限公司,1998年，中国红牛公司将总部从深圳迁到北京，增资注册，成为北京市最大的外商投资企业之一。目前，红牛公司在全国各地拥有数十家分公司、代表处和百余个办事处，在国内拥有北京、海南、湖北三家现代化的生产基地，是中国最主要的功能性饮料企业。<br /><br /><b>惠普在2006年开始为红牛公司提供SAP ERP系统的咨询实施服务</b>，完成了销售管理、物料管理、生产制造计划、财务管理模块的实施。<br /><br />随着ERP数据的积累与增加，红牛的系统也面对着一些影响使用的性能问题，为解决这些问题，红牛与恩墨科技达成合作，委托恩墨科技为红牛提供<b>系统优化与数据库运维服务</b>。<br />从软件结构上来说，SAP的系统设计的极为精密，考虑到了很多国内软件没有考虑到的问题，不过在与数据库结合方面，SAP仍然存在很多不足，这也与系统的发展有关。<br /><br />通过对数据库进行全面细致的检查，采取针对性的调整与优化，我们可以大幅提升系统的性能，满足客户对于性能的期望与需要，在最近完成的一个系统优化中，我们成功的将系统的IO吞吐量降低到原来的5%左右，极大的提升了系统的性能与稳定性。<br /><br />感谢红牛集团选择了恩墨科技作为数据库运维的服务提供商！<br /><br /><br /></div></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/11/enmotech_workshop_two.html">恩墨科技的第二次培训(2009年11月)圆满结束</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/11/enmo_tech_workshop_two.html">恩墨科技的第二次培训明日（11.5）开始</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/performance_tuning_workshop_two_coming_soon.html">恩墨科技第二次性能优化培训时间确定</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/training_delay.html">关于恩墨科技第二次培训暂时推迟的通知</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/sap_db_recovery.html">恩墨科技为某企业SAP数据库提供紧急援助服务</a><br /></li>
</ul></p>



<p><strong>评论数量(10)|<a href="http://www.eygle.com/archives/2009/11/enmotech_redbull.html#comments" title="Comment on: 恩墨科技签约红牛集团 提供SAP数据库支持服务">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/enmotech_redbull.html">http://www.eygle.com/archives/2009/11/enmotech_redbull.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/QutlQLnzrXU" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Life</category>


<category domain="http://www.sixapart.com/ns/types#tag">enmo</category>

<pubDate>Wed, 04 Nov 2009 08:19:34 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>备份重于一切 - 记(eygle.com)服务器硬盘故障</title>
<description>借口不能使数据回来，只有加油干活，折腾到现在23：50，终于回复了大部分数据，以后慢慢找补，也趁此机会梳理一下网站内容。</description>
<link>http://www.eygle.com/archives/2009/11/disk_error_crash_mysite.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/disk_error_crash_mysite.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

今天下午，忽然发现网站出现异常，心中蓦然一惊，以为又是被黑客攻击，怎一个惨字了得。<br /><br />登陆服务器检查，心中又是一喜一惊，喜的是不是黑客攻击，惊的是，一块1T的用于存数据的硬盘消失了。大量的错误信息让人当场崩溃：<br /><blockquote>Buffer I/O error on device cciss/c0d1, logical block 3<br />cciss: cmd f7020250 has CHECK CONDITION&nbsp; byte 2 = 0x3<br />Buffer I/O error on device cciss/c0d1, logical block 0<br />cciss: cmd f7020000 has CHECK CONDITION&nbsp; byte 2 = 0x3<br />Buffer I/O error on device cciss/c0d1, logical block 179177296<br />cciss: cmd f7020000 has CHECK CONDITION&nbsp; byte 2 = 0x3<br />Buffer I/O error on device cciss/c0d1, logical block 0<br />cciss: cmd f7020000 has CHECK CONDITION&nbsp; byte 2 = 0x3<br />Buffer I/O error on device cciss/c0d1, logical block 179177317<br />cciss: cmd f7020000 has CHECK CONDITION&nbsp; byte 2 = 0x3<br />Buffer I/O error on device cciss/c0d1, logical block 0<br />cciss: cmd f7020000 has CHECK CONDITION&nbsp; byte 2 = 0x3<br />Buffer I/O error on device cciss/c0d1, logical block 179177296<br /></blockquote>晚上回家开始恢复数据，不停的被Julia数叨：你讲课不总是说<b>备份重于一切</b>么？怎么到自己头上不灵了。<br />我说，其实我不说自己网站的DBA，就如同前几天Tomas kyte说，他不在做自己asktom的DBA一样。<br /><br />借口不能使数据回来，只有加油干活，折腾到现在23：50，终于回复了大部分数据，以后慢慢找补，也趁此机会梳理一下网站内容。<br /><br />当然同时提醒一下大伙，备份终于一切，反反复复的提醒，没完没了的提醒。<br /><br />说到Eygle.com这个小网站，5年间经历了多次黑客攻击和硬件故障，也因此我们永远不能心存侥幸。<br /><br />-The End-<br /><br /><br /><br /> <img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/09/sina_weibo_twitter.html">试用新浪微博 - 后Twitter时代</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/08/nobody_movable_type_periodic.html">Nobody用户定时Movable Type的预约发布功能</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/07/phpmyadmin_wrong_permissions.html">Phpmyadmin:配置文件Wrong permissions</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/10/mtonthisday_plugin.html">增加MT MTOnThisDay插件 - 显示历史记录</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/04/resion_apache_php.html">Resin、Apache、PHP与404错误</a><br /></li>
</ul></p>



<p><strong>评论数量(10)|<a href="http://www.eygle.com/archives/2009/11/disk_error_crash_mysite.html#comments" title="Comment on: 备份重于一切 - 记(eygle.com)服务器硬盘故障">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/disk_error_crash_mysite.html">http://www.eygle.com/archives/2009/11/disk_error_crash_mysite.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/P-Tv1fXua0k" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Life</category>

<category domain="http://www.sixapart.com/ns/types#category">Web</category>


<category domain="http://www.sixapart.com/ns/types#tag">Hanker</category>

<category domain="http://www.sixapart.com/ns/types#tag">Web</category>

<pubDate>Tue, 03 Nov 2009 23:44:57 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>11gR2新特性之- 并行DBMS_PARALLEL_EXECUTE</title>
<description>在2009 Oracle Openworld上，Thomas Kyte在一个关于《The top 10 - No, 11 - New Features of Oracle Database 11g Release 2》的演讲中，提到一个并行执行的新特性，比较感兴趣。</description>
<link>http://www.eygle.com/archives/2009/11/11gr2_dbms_parallel_execute.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/11gr2_dbms_parallel_execute.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

在2009 Oracle Openworld上，<a href="http://tkyte.blogspot.com/">Thomas Kyte</a>在一个关于《The top 10 - No, 11 - New Features of Oracle Database 11g Release 2》的<a href="http://www.ningoo.net/html/2009/oracle_open_world_2009_third_day_2.html">演讲</a>中，提到一个并行执行的新特性，比较感兴趣。<br />（这个PPT目前已经可以下载，下载地址为：<a href="http://asktom.oracle.com/pls/asktom/z?p_url=ASKTOM%2Edownload_file%3Fp_file%3D6646995323761764246&amp;p_cat=OOW_2009.zip&amp;p_company=822925097021874">Top 10</a>，Tom的另外一个<a href="http://asktom.oracle.com/pls/asktom/z?p_url=ASKTOM%2Edownload_file%3Fp_file%3D7109353923237894663&amp;p_cat=11gR2%20Oct%2027%202009.zip&amp;p_company=822925097021874">OOW PPT</a>）<br /><br />这个新特性引入一个Package： <a href="http://asktom.oracle.com/pls/asktom/z?p_url=ASKTOM%2Edownload_file%3Fp_file%3D6646995323761764246&amp;p_cat=OOW_2009.zip&amp;p_company=822925097021874">DBMS_PARALLEL_EXECUTE</a>，通过这个包可以将一个任务调度为并行，而此前我们需要手工来编写程序，通过rowid或者主键还分割，前一段做过大量这个工作，用11gR2，这个工作能简化很多。<br /><br />这个包的典型用法引用如下：<br /><blockquote>DECLARE<br />  l_sql_stmt VARCHAR2(1000);<br />  l_try NUMBER;<br />  l_status NUMBER;<br />BEGIN<br /> <br />  -- Create the TASK<br />  DBMS_PARALLEL_EXECUTE.CREATE_TASK ('mytask');<br /> <br />  -- Chunk the table by ROWID<br />  DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_ROWID('mytask', 'HR', 'EMPLOYEES', true, 100);<br /> <br />  -- Execute the DML in parallel<br />  l_sql_stmt := 'update /*+ ROWID (dda) */ EMPLOYEES e <br />      SET e.salary = e.salary + 10<br />      WHERE rowid BETWEEN :start_id AND :end_id';<br />  DBMS_PARALLEL_EXECUTE.RUN_TASK('mytask', l_sql_stmt, DBMS_SQL.NATIVE,<br />                                 parallel_level =&gt; 10);<br /> <br />  -- If there is an error, RESUME it for at most 2 times.<br />  L_try := 0;<br />  L_status := DBMS_PARALLEL_EXECUTE.TASK_STATUS('mytask');<br />  WHILE(l_try &lt; 2 and L_status != DBMS_PARALLEL_EXECUTE.FINISHED) <br />  LOOP<br />    L_try := l_try + 1;<br />    DBMS_PARALLEL_EXECUTE.RESUME_TASK('mytask');<br />    L_status := DBMS_PARALLEL_EXECUTE.TASK_STATUS('mytask');<br />  END LOOP;<br /> <br />  -- Done with processing; drop the task<br />  DBMS_PARALLEL_EXECUTE.DROP_TASK('mytask');<br />   <br />END;<br />/<br /></blockquote>这是一个好东西，记录在此。<br /><br />-The End-<br /><br /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/11/oracle_11gr2_so.html">Oracle 11gR2  Solaris (SPARC) (64-bit) 发布</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/oracle_11gr2_first.html">Oracle 11gR2 安装初体验 - OEL + Oracle</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/oracle11gr2_upgrade_path.html">Oracle Database 11gR2的升级路径与升级思考</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/11gr2_flash_cache_ssd_support.html">11gR2新特性之二 - Flash Cache 的SSD支持</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/09/11gr2_columnar_compression.html">11gR2新特性之一-列式压缩(Columnar Compression)</a><br /></li>
</ul></p>



<p><strong>评论数量(0)|<a href="http://www.eygle.com/archives/2009/11/11gr2_dbms_parallel_execute.html#comments" title="Comment on: 11gR2新特性之- 并行DBMS_PARALLEL_EXECUTE">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/11gr2_dbms_parallel_execute.html">http://www.eygle.com/archives/2009/11/11gr2_dbms_parallel_execute.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/0X6NQIGpB4A" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">OraNews</category>

<category domain="http://www.sixapart.com/ns/types#category">Oracle10g/11g</category>


<category domain="http://www.sixapart.com/ns/types#tag">Oracle11g</category>

<pubDate>Tue, 03 Nov 2009 08:11:10 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>帝都华盛顿 晤对魏欧林先生 - 令人孺慕之长者</title>
<description>在10月9日，也就是我们在华盛顿的第二天，Julia以前的老板同事请我们一起午餐。
Julia在AIG的上升Judy是一个非常和蔼温和的女士，而Olin先生则是一个令人孺慕的长者，智慧且平易。</description>
<link>http://www.eygle.com/archives/2009/11/lunch_with_wethington.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/lunch_with_wethington.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

在10月9日，也就是我们在华盛顿的第二天，Julia以前的老板同事请我们一起午餐。<br />Julia在AIG的上升Judy是一个非常和蔼温和的女士，而Olin先生则是一个令人孺慕的长者，智慧且平易。<br />对我们来说<span id="ctl00_MainContentPlaceholder_ctl01_ctl00_lblEntry"><a href="http://www.hudong.com/wiki/%E9%AD%8F%E6%AC%A7%E6%9E%97">魏欧林</a>先生一直是一个<a href="http://tequilabombom.spaces.live.com/Blog/cns%219D64B7DC5729DA96%219796.entry">Great man</a></span>，他曾经是AIG中国成员公司主席，而在AIG之前，他的名字一直和一些重要的国家与历史时刻相关联：<br /><blockquote>魏欧林曾历任美国财政部中国事务特使、美国财政部部长顾问、伊拉克巴格达联盟临时管理局经济政策主管、美国财政部国际事务助理国务卿、美国商务部副部长帮办等政府职务。<br /></blockquote>现在Olin先生成立了一家投资公司，名字就叫做：<a href="http://www.dsky.hk/design119.html">魏氏国际</a>（Wethington International LLC），这个公司目前已经在北京运营。午餐时，他们还关注我的小公司，问我的商业计划何在？ 之前他们嘱我拟定一个商业计划，可以考虑投资我的公司，可是我一直拖拉下来，未有一纸之文，实在汗颜。<br /><br />我浏览了Olin先生的履历，实在感叹了一番，究竟我们的一生能够做多少事？留下多少印记呢？究竟怎样奋斗才算得上不虚妄、不虚度呢？也许每个人的答案都不通。<br />Biti和我讨论过中国人的财富价值观，他说听闻过温州的一个年长商人，家财已经以亿计数，然而老人家在听说中国将要开放和某个国家的边陲小镇，仍然奔驰过去，买下一些商铺，静待政策的到来，不仅长途奔波，而且充满警醒。这些人的乐趣已经不在鱼，而在于渔。<b>人生的目标转换也一定是难于预料的。</b><br /><br />午餐是在华盛顿的一条河边，风景极其优美：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="P1090440-2.JPG" src="http://www.eygle.com/images/usa/P1080979.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><br /><div>
Judy说前个晚上，他们刚和<a href="http://baike.baidu.com/view/21632.htm">基辛格</a>(Henry Alfred Kissinger)共进晚餐，原来基辛格仍然在世。前几天看报纸，讲荣毅仁的病逝，说基辛格当年曾是中信的顾问，基辛格称赞荣毅仁说：苏联就需要这样一个人物，可是他们没有。<br /><br />席间用我极其蹩脚的英文和Olin先生讨论了中国软件和美国软件的优劣，以及中国软件的未来。我相信在Serive到来的时代，中国的机会是有的。哪怕有一天Oracle公司不存在了，可是这个服务的市场仍然不会立即死去。<br />
太太Julia和美国前同事们的合影：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="P1090440-2.JPG" src="http://www.eygle.com/images/usa/P1080974.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><br /><div>
<br />
我和Olin先生的合影:<br />
<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="P1090440-2.JPG" src="http://www.eygle.com/images/usa/P1080977.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><br /><div>

盖小咪的爸爸与妈妈:<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="P1090440-2.JPG" src="http://www.eygle.com/images/usa/P1080981.JPG" class="mt-image-none" style="" height="768" width="432" /></span><br /><br />
<br /><br /></div></div></div></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/10/niagara_fall.html">美东印象 之 尼亚加拉瀑布 - 浩荡之水天上来</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/backto_beijing.html">萧瑟秋风今又是 - 回到北京 开始新的旅程</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/mit_harvord.html">大国与大学 - MIT、哈佛 与 波士顿大学行</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/corning_museum_of_glass.html">美东之旅贴图 - 康宁（Corning）玻璃中心</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/new_york_stock_exchange.html">美东之旅贴图 - 纽交所</a><br /></li>
</ul></p>



<p><strong>评论数量(10)|<a href="http://www.eygle.com/archives/2009/11/lunch_with_wethington.html#comments" title="Comment on: 帝都华盛顿 晤对魏欧林先生 - 令人孺慕之长者">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/lunch_with_wethington.html">http://www.eygle.com/archives/2009/11/lunch_with_wethington.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/A9HrSSVBinE" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Travel</category>


<category domain="http://www.sixapart.com/ns/types#tag">Travel</category>

<pubDate>Mon, 02 Nov 2009 08:05:19 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>2009年冬的第一场雪- 漫天飞舞未觉寒</title>
<description>尽早起来，拉开窗帘，一片白茫茫的天地铺面而来，竟然是漫天满地的雪花，北京2009年冬天将到未到之际的第一场雪就如此意外的来临，而年初的雪还留在记忆里。
</description>
<link>http://www.eygle.com/archives/2009/11/2009_111_snowing.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/11/2009_111_snowing.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

昨晚召集了一大屋子朋友到家里，一伙人玩起"三国杀"的游戏，直至凌晨两点散去。<br /><br />尽早起来，拉开窗帘，一片白茫茫的天地铺面而来，竟然是漫天满地的雪花，北京2009年冬天将到未到之际的第一场雪就如此意外的来临，而<a href="http://www.eygle.com/archives/2009/02/2009_snowing.html">年初的雪</a>还留在记忆里。<br /><br />说起来不凑巧，岳母及Julia的姨妈在北京很久，一直期待看到一场雪，可是始终与大雪失之交臂，今年大学来得早，可是她们又已经回到了南方。<br /><br /><b>但愿这早来的第一场雪能够杀死H1N1流窜的病毒，净化北方的片河山。大家也要注意保暖，远离病毒的侵扰。<br /></b><br />11月1日，在这个月的开端，世界化为黑白，楼下的小公园里，雪下包裹的都是翠绿的生机：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/2009/snow01.jpg" class="mt-image-none" style="" height="467" width="700" /></span><br /><div><br />拍一下阳台上的雪花，漫天飞舞的景色很美很美，等一下要下楼去好好拍一拍这2009年冬的第一场雪：<br /></div>

<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/2009/snow02.jpg" class="mt-image-none" style="" height="467" width="700" /></span><br /><div><br /><br /></div>

-The End-<br /><br /><img hidden="true" style="border: medium none ; position: absolute; z-index: 2147483647; opacity: 0.6; display: none;" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQVR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYEDHGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcfm2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzVFurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqydp4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvHskZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRzG2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVvXbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDdaT0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVVgNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92WvYeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHhYO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WRawIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUBjcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYAG0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAwKXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CYII%3D" id="myFxSearchImg" height="24" width="24" /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/02/2009_snowing.html">天下有雪 冬日最后的料峭 - 久违北京的雪</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/12/odd_day_one.html">甲骨文开发者大会第一天-最佳实践和最差实践</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/01/2008_beijing_skee.html">渔阳滑雪场与金钱豹的自助餐</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2007/12/the_first_snow_2007.html">2007年12月10日，北京，雪</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2005/12/beijing_skee.html">北京天下亦有雪</a><br /></li>
</ul></p>



<p><strong>评论数量(4)|<a href="http://www.eygle.com/archives/2009/11/2009_111_snowing.html#comments" title="Comment on: 2009年冬的第一场雪- 漫天飞舞未觉寒">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/11/2009_111_snowing.html">http://www.eygle.com/archives/2009/11/2009_111_snowing.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/h3I3kJFtyxQ" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Life</category>


<category domain="http://www.sixapart.com/ns/types#tag">Snow</category>

<pubDate>Sun, 01 Nov 2009 09:15:06 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>了解健康 - PSA,FPSA、TPSA是什么涵义</title>
<description>定期体检真的是很重要，很多重大的疾病会在几个月内萌生，所以定期体检，感觉异常及时就医是非常非常重要的，在此提醒一下大家。</description>
<link>http://www.eygle.com/archives/2009/10/psa_fpsa_tpsa.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/10/psa_fpsa_tpsa.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

今天收到了体检报告，这次在慈铭做的体检，虽然是是1500左右的标准，但是感觉和以前在公司几百块的检查没什么不同，一如既往的被牙医忽悠的去洗牙，又花了我900多，结果搞得几天不舒服，洗牙真是一场折磨。<br /><br />不说这些，<b>定期体检真的是很重要，很多重大的疾病会在几个月内萌生，所以定期体检，感觉异常及时就医是非常非常重要的，在此提醒一下大家</b>。<br /><br />这个体检报告上，提到了一项指标FPSA/TPSA，说这个指标参考范围&gt;0.25，我的指标略低，吓了一跳，赶紧研究了一下，读了几份医学报告，大体上说这个指标不靠谱，基本放下心来。<br /><br />引用<a href="http://ks.cn.yahoo.com/question/1407102104388.html">网络</a>扫盲信息：<br /><br /><blockquote><b>PSA是前列腺特异抗原 </b><br />
⑴
血清PSA是前腺癌的特异性标志物：它对早期没有症状的前列腺癌的诊断很有意义。<br /><br />正常情况下，<b>PSA是</b>由前列腺上皮细胞分泌产生的一种<b>丝氨酸蛋白酶，是一
种糖蛋白</b>，直接分泌到前列腺导管系统内。它的正常功能是邦助精液凝块水解液化，与男性生育力有关。<br />正常的前列腺导管系统周围存在着一种血--上皮之间的<b>屏障</b>，<b>避免</b>了前列腺上皮产生的<b>PSA直接进入血液之中，从而维持了血液中PSA的低浓度</b>。一般认为，血清PSA小于4.0
ng/ml为正常，PSA大于10ng/ml
则患前腺癌的危险性增加。当前列腺发生癌时就破坏了血--上皮之间的屏障，而癌分泌的PSA亦多了，致使PSA直接进入血内，癌的恶性程度越高，对于正常前
列腺组织破坏越大，血清中PSA越高。 <br />
前列腺癌根治术后无瘤状态的金标准是PSA为零。由于血清中的PSA几乎全部是由前列腺上皮细胞产生的，前列腺癌根治术切除了全部前列腺组织，如果肿瘤被
根治，那么血清中PSA会在１个月内下降为零。前列腺癌术后患者血清中PSA的半衰期为33小时。据此计算，如果１例患者术前PSA为20ng/ml，术
后12天就应该检测不到PSA；术前若为10ng/ml，则需要10天；术前若为4ng/ml，则需要8天。 <br />
⑵
前列腺非恶性病变血清PSA升高：前列腺炎症、前列腺增生、急性尿潴留、前列腺按摩等可使PSA增高，但当致病因素消除后，大约一个月可趋于正常。直肠指
诊后血清PSA可增高1倍，膀胱镜检查后可增高4倍，前列腺穿剌活检或经尿道前列腺电切后可增至53～57倍。正常状态下的射精也可使PSA增高。因此对
肛门指诊检查的病人，应在检查后一周方可进行PSA检测，前列腺活检穿剌后至少6周才能做血PSA的检测。癌症所造成的PSA升高是持久性的，而且随着肿
瘤的发展而持续不断的升高。 <br />
⑶ 如何区分良性和恶性的PSA升高： <br />
①<b>游离态PSA（fPSA）的应用</b>：在前列腺增生和前列腺癌的PSA水平在4～10
ng/ml时较大部分重叠，在这个所谓灰色区域难以根据PSA水平来区分前列腺增生和前列腺癌。PSA在血清中可以游离态和结合态的形式存在，游离PSA
是指游离在血浆中不被结合那部分PSA，表示为fPSA；血清总PSA以tPSA表示。fPSA浓度在癌症患者中低于良性增生患者。临床上就是应用这个差
异，从良前列腺增生病人中，将早期前列癌筛检出来。<b>目前应用fPSA/tPSA比值来辅助鉴别前列腺癌和良性增生获得广泛使用。参考值为0.16,即其比
值＜0.16则患前腺癌的可能性高</b>。fPSA的百分比低，提示患前列腺癌的可能性较高. <br />
近年研究表明，<b>fPSA水平在血清中不稳定，fPSA/tPSA比值分布较离散，两者相关性不显著,难以根据fPSA/tPSA比值来筛查和诊断前列腺
癌</b>。而结合PSA（cPSA）和tPSA相关性好。前列腺操作对cPSA的影响弱于对tPSA的影响。前列腺体积对cPSA的影响也弱于对tPSA的影
响。故cPSA是诊断前列腺癌的较理想指标。在tPSA&lt;10ng/ml，cPSA/tPSA≥0.78为前列腺癌敏感性97.8%，特异性
95.8%. <br />
②PSA密度：PSA密度指血清PSA的浓度与前列腺体积的比值，前列腺的体积可用B超法测定。若发现一个前列腺体积不大而血清PSA水平却是中等程度的
病人，往往有前列癌的可能。而同样数值的PSA对于一个前列腺体积较大的病人，这可能仅仅是良性前列腺增生。PSA密度小于或等于0.15时一般不会有恶
性病变存在,但大于0.15时,患前列腺癌的危险性增高。 <br />
③PSA速度：从现在的研究看，人随着年龄的增加PSA每年增长小于0.75 ng/ml，一般不会患有前列腺癌。大于0.75
ng/ml则患前列腺癌的危险性增加。据研究对前列腺癌患者术前PSA增长速度在1年内大于2ng/ml，以及前列腺癌切除或放疗后提示复发的患者中，其
PSA倍增时间≤3个月与死亡风险增高相关。近有研究结论认为0.75
ng/ml·年的PSA速率界值的确对于60岁以下的男性定得过高，将会导致相当一部分前列腺癌漏诊。PSA速率高于0.5
ng/ml.年的男性患前列腺癌的危险更高，应当密切随访。 <br />
技术鉴定除已知的前列腺相关标志物PSA外，还有前列腺酸性磷酸酶（PAP），为前列腺分泌的酶，正常时PAP很少进入血液，前列腺癌时，恶性细胞产生
PAP而且进入血液。正常值血清PAP小于3.5ng/ml。目前认为，PAP作用有限，但被认为是前列腺癌根治术后治疗失败的另一独立预测因素，尽管其
不能预测分期以及周围其他器官的情况。前列腺特异性肽（Prostate specific photase , PSP
）和前列腺特异性膜抗原（Prostate specific membrane antigen, PSMA），由于前列腺癌上皮细胞中<br /></blockquote>学习学习，还有更复杂的论文，看起来头晕晕，不引用了。<br /><br />-The End-<br /><br /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/10/wish_everyone_health.html">把时间当做朋友 - 记 李笑来 的卓越见解</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/12/cherish_life.html">珍惜当下，命运无常 - 纪念一位朋友的离开</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2008/03/help_loveit518.html">人人都献出一点爱-生命与健康</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2007/12/health_life.html">一年过了一年 年底再议健康</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2006/12/healthcheck_is_important.html">"软件"、硬件都需要健康检查</a><br /></li>
</ul></p>



<p><strong>评论数量(5)|<a href="http://www.eygle.com/archives/2009/10/psa_fpsa_tpsa.html#comments" title="Comment on: 了解健康 - PSA,FPSA、TPSA是什么涵义">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/10/psa_fpsa_tpsa.html">http://www.eygle.com/archives/2009/10/psa_fpsa_tpsa.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/zLIQptelg-M" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Life</category>


<category domain="http://www.sixapart.com/ns/types#tag">Health</category>

<pubDate>Fri, 30 Oct 2009 22:43:18 +0800</pubDate>
</item>


--------------------------------------------------------------------------------
<item>
<title>美东印象 之 尼亚加拉瀑布 - 浩荡之水天上来</title>
<description>今年10月的美东之行，看到最壮观的景色莫过于尼亚加拉大瀑布，我和Biti说，即使美东之行只见到大瀑布，已经觉得不虚此行，这实在是值得一看的景观。</description>
<link>http://www.eygle.com/archives/2009/10/niagara_fall.html</link>
<author>eygle@eygle.com(eygle)</author>
<guid>http://www.eygle.com/archives/2009/10/niagara_fall.html</guid>
<content:encoded><![CDATA[
<p>&copy作者：<a href="http://www.eygle.com">eygle</a>  发布在 <a href="http://www.eygle.com/">eygle.com</a></p>

<p><font style="font-size: 1.5625em;">今</font>年10月的美东之行，看到最壮观的景色莫过于尼亚加拉大瀑布，我和Biti说，即使美东之行只见到大瀑布，已经觉得不虚此行，这实在是值得一看的景观。<br /><br />摘录一点<a href="http://baike.baidu.com/view/9728.htm">尼亚加拉大瀑布</a>的介绍：<br /></p><blockquote>尼亚加拉瀑布(Niagara Falls)位于<a target="_blank" href="http://baike.baidu.com/view/3647.htm">加拿大</a>和<a target="_blank" href="http://baike.baidu.com/view/2398.htm">美国</a>交界的<a target="_blank" href="http://baike.baidu.com/view/696796.htm">尼亚加拉河</a>中段，号称世界七大奇景之一，与南美的<a target="_blank" href="http://baike.baidu.com/view/20115.htm">伊瓜苏瀑布</a>及非洲的<a target="_blank" href="http://baike.baidu.com/view/66291.htm">维多利亚瀑布</a>合称<a target="_blank" href="http://baike.baidu.com/view/147809.htm">世界三大瀑布</a>。<br /><br />尼亚加拉河--横跨美国纽约州与加拿大安大略省的边界。是连接伊利湖和安大略湖的一条水道，河流蜿蜒而曲折，南起美国纽约州的布法多，北至加拿大安大略省<br />
的杨格镇，全长仅54公里，海拔却从174米直降至75米，上游河段河面宽2～3千米，水面落差仅15米，水流也较缓。从距伊利湖北岸32千米起河道变<br />
窄，河道变窄，水流加速，在一个90°急转弯处，河道上横亘了一道石灰岩构成的断崖，水量丰富的尼亚加拉河经此，骤然陡落，水势澎湃，声震如雷，形成了尼<br />
亚加拉瀑布。<br /></blockquote>在纽约参加了一个千岛湖+大瀑布的旅行团，2天的行程，到达大瀑布时已经是晚上7点左右，导游带我们去"风之洞"，首先大家领到的是雨衣，因为要0距离接触瀑布，水会铺面而来，所以必要的防水是需要的，我记得那晚很有点冷，而且天色已黑，可是未见瀑布就已经听到轰隆隆的水声，让大家充满期待，首先是坐一个电梯下到很深的地下，然后走出去。（<i>Google上的<a href="http://images.google.cn/images?hl=zh-CN&amp;q=%E5%B0%BC%E4%BA%9A%E5%8A%A0%E6%8B%89%E5%A4%A7%E7%80%91%E5%B8%83&amp;sourceid=navclient-ff&amp;rlz=1B3GGGL_zh-CN__225CN280&amp;um=1&amp;ie=UTF-8&amp;sa=N&amp;tab=wi">照片</a>实在是美得已经不真实</i>）<br /><br />看看Julia同学看到瀑布时兴奋的样子：<br /><span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080538.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

瀑布之水奔流直下，然后化为水汽铺面而来，栏杆还可以走到瀑布下面，如果愿意，你可以用脚趟一趟天上之水：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080545.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>
穿着雨衣走进瀑布的人们：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080543.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

水汽在闪光灯下形成七色的彩虹：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080547.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

去这些地方，一定要和亲爱的人一起：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080573.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

当然，如果还有好朋友一起分享是更幸福的：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080576.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

更近距离感受瀑布是坐上雾都女神号到瀑布中央去，在水中央，在天上而来，轰鸣而下的水中央，你会觉得满心都是对这至柔至刚的奇迹的赞美：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080619.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

船会停留在水中央一段时间，每个人都沉浸在翻腾的浪花中、奔流而下的水汽中，那一刻在记忆中会成为永恒：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080606.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

我相信每个人在这里都会找到属于自己的记忆，找到属于自己的洗礼：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://www.eygle.com/images/usa/P1080564.JPG" class="mt-image-none" style="" height="338" width="600" /></span><br /><div><br /><br /></div>

Google上俯瞰马蹄形的瀑布是这个样子的：<br />
<span class="mt-enclosure mt-enclosure-image" style="display: inline;"><img alt="IMG_4352-2.JPG" src="http://lh6.ggpht.com/justin0842/Rpbu0sP5m3I/AAAAAAAAAxo/A4RAfeSeQAs/1023076.jpg" class="mt-image-none" style="" height="600" width="800" /></span><br /><div><br /><br /></div>

尼亚加拉的记忆永在！<br />
<br />(这里还有Julia的<a href="http://tequilabombom.spaces.live.com/Blog/cns%219D64B7DC5729DA96%219634.entry">日记</a>，网友拍摄的<a href="http://xyzmm.spaces.live.com/Blog/cns%217DEA8122E15FE08D%2120432.entry?sa=842681260">精美照片</a>)<br /><br /><br /></p>

<p><strong>相关文章|Related Articles</strong></p>
<p><ul>

    <li><a href="http://www.eygle.com/archives/2009/11/lunch_with_wethington.html">帝都华盛顿 晤对魏欧林先生 - 令人孺慕之长者</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/backto_beijing.html">萧瑟秋风今又是 - 回到北京 开始新的旅程</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/mit_harvord.html">大国与大学 - MIT、哈佛 与 波士顿大学行</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/corning_museum_of_glass.html">美东之旅贴图 - 康宁（Corning）玻璃中心</a><br /></li>

    <li><a href="http://www.eygle.com/archives/2009/10/new_york_stock_exchange.html">美东之旅贴图 - 纽交所</a><br /></li>
</ul></p>



<p><strong>评论数量(3)|<a href="http://www.eygle.com/archives/2009/10/niagara_fall.html#comments" title="Comment on: 美东印象 之 尼亚加拉瀑布 - 浩荡之水天上来">Add Comments</a></strong></p>
<p>本文网址：<a class="permalink" href="http://www.eygle.com/archives/2009/10/niagara_fall.html">http://www.eygle.com/archives/2009/10/niagara_fall.html</a></p>
</description>
<img src="http://feeds.feedburner.com/~r/EyglesOracleBlog/~4/ZZH6aW7-9sk" height="1" width="1"/>]]></content:encoded>

<category domain="http://www.sixapart.com/ns/types#category">Travel</category>


<category domain="http://www.sixapart.com/ns/types#tag">Travel</category>

<pubDate>Fri, 30 Oct 2009 07:39:19 +0800</pubDate>
</item>

</channel>
</rss>
