<?xml version="1.0" encoding="gbk"?>
			<?xml-stylesheet type="text/css" href="http://space.itpub.net/css/rss.css"?>
			<rss version="2.0">
			  <channel>
			    <title>yanggq的个人空间</title>
			    <link>http://space.itpub.net/?uid-26706</link>
			    <description></description>
			    <copyright>Copyright(C) yanggq的个人空间</copyright>
			    <generator>SupeSite/X-Space</generator>
			    <lastBuildDate>Sat, 17 May 2008 15:30:15 GMT</lastBuildDate><item>
								<title>[原创]如何快速找到View的错误信息</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-196143</link>
								<description><![CDATA[<P>当我们建立或者编译View的时候，如果这个View有错误，一般只是在sqlplus中显示The View created with Warning 或者Warning: The view compile with errors,我们再show error会显示No Errors.</P>
<P>现在大家可以直接查询dba_errors或者all_errors或者user_errors去找...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Thu, 28 Feb 2008 15:32:20 GMT</pubDate>
							</item>
							<item>
								<title>配置ntp服务器</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-192110</link>
								<description><![CDATA[<TABLE style="BORDER-COLLAPSE: collapse; WORD-WRAP: break-word" cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle height=25><FONT style="FONT-SIZE: 14pt" color=#02368d><B>配置ntp服务器</B></FONT></B></FONT><BR></TD></T...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Sat, 23 Feb 2008 15:35:12 GMT</pubDate>
							</item>
							<item>
								<title>成语新解_zt</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64615</link>
								<description><![CDATA[1.知书达礼：仅知道书本知识是不够的，还要学会送礼；<br><br /><br /><div class="t_msgfont" id="message9305241"><br />2.度日如年：日子非常好过，每天象过年一样；<br />3.杯水车薪：每天办公室喝喝茶，月底可以拿到一车工资；<br />4.知足常乐：知道有人请自己洗脚，...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Sun, 30 Dec 2007 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>global cache cr request</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64614</link>
								<description><![CDATA[global cache cr request<br>当一个进程访问需要一个或者多个块时，它会首先检查自己的CACHE是否存在该块，如果发现没有，就会先通过global cache赋予这些块<br /><br />共享访问的权限，然后再访问。假如，通过global cache 发现这些块已经在另一个实例的CACHE里面，那么...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 10 Oct 2007 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>如何知道HP-UX是32位还是64位</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64613</link>
								<description><![CDATA[<p><span style="FONT-SIZE: 13px">getconf KERNEL_BITS</span> </p><p>i.e.</p><p>&gt;getconf KERNEL_BITS <br />64</p><br>]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Fri, 01 Jun 2007 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>三十五岁前成功法则</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64612</link>
								<description><![CDATA[第一章:一个目标 一艘没有航行目标的船，任何方向的风都是逆风 1、你为什么是穷人，第一点就是你没有立下成为富人的目标 2、你的人生核心目标是什么？ 杰出人士与平庸之辈的根本差别并不是天赋、机遇，而在于有无目标。<br>第一章:一个目标 一艘没有航行目标的船，任何方向...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Mon, 25 Dec 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>让一天不止24小时的20种方法(请耐心读完)</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64611</link>
								<description><![CDATA[<font face="Verdana" size="1"><br />现代管理大师彼德·德鲁克有这样一句名言：“时间是最高贵而有限的资源，不能管<br />理时间，便什么都不能管理。”英国博物学家赫胥黎说得更形象：“时间是最不偏私的，<br />给任何人都是24小时，同时时间是最偏私的，给任何人都不...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Mon, 11 Dec 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>From a msg</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64610</link>
								<description><![CDATA[<p>未曾清贫难成人，</p><p>不经打击老天真。</p><p>自古英雄出炼狱，</p><p>从来富贵入凡尘。 </p><p>醉生梦死谁成器，</p><p>拓马长枪定乾坤。 </p><p>挥军千里山河在，</p><p>立名扬威传后人。</p><br>]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Tue, 24 Oct 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Atlantis --- 阿特兰蒂斯之谜</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64609</link>
								<description><![CDATA[永远消失的阿特兰蒂斯。。。。<br><p style="TEXT-ALIGN: center" align="center"><b><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体"></span></b></p><p style="TEXT-INDENT: 126pt"><font size="3"><span lang="EN-US"><font face="Times New Roman"></font></span><...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 06 Sep 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Statspack Report Read Info</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64607</link>
								<description><![CDATA[Summary for the Statspack Report<br>一、statspack 输出结果中必须查看的十项内容<br /><br />1、负载间档(Load profile)<br />2、实例效率点击率(Instance efficiency hit ratios)<br />3、首要的5个等待事件(Top 5 wait events)<br />4、等待事件(Wait events)<br />5...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Sat, 17 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>转贴</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64608</link>
								<description><![CDATA[from other site<br>理财的路是一步一步的，给自己设定好目标，然后一步一步的往前走，达到了每个小的目标奖励自己奖励家人，理财其实就是做人，发现最优秀的自己，拥有最真心的朋友，背靠着最和谐的家庭，你就是世界上最富有的人。 <p>　<strong>　第一条：对自己进行投资...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Sat, 17 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Analyze Library Cache Pin and 4021 Error</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64602</link>
								<description><![CDATA[<pre> From Metalink</pre><pre><span lang="EN-US" style="FONT-FAMILY: Courier"><font size="2">PURPOSE</font></span></pre><pre><span lang="EN-US" style="FONT-FAMILY: Courier"><font size="2">-------</font></span></pre><pre><span lang="EN-US" style="FONT-F...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Thu, 08 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Kill Session Not Release Locks</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64603</link>
								<description><![CDATA[Alter system kill session ........<br><p class="MsoNormal" style="0cm 0cm 0pt; TEXT-ALIGN: center" align="center"><span lang="EN-US"></span></p><p class="MsoNormal" style="0cm 0cm 0pt"><span lang="EN-US">Problem Description</span></p><p class="MsoNorma...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Thu, 08 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>How to find a user who is locking the rows</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64604</link>
								<description><![CDATA[<pre><span lang="EN-US" style="FONT-FAMILY: Courier"><font size="2">PURPOSE</font></span></pre><pre><span lang="EN-US" style="FONT-FAMILY: Courier"><font size="2">-------</font></span></pre><pre><span lang="EN-US" style="FONT-FAMILY: Courier"><font siz...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Thu, 08 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Online Index Rebuild and Table Redefinition</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64605</link>
								<description><![CDATA[From Other Site<br>A number of new features in Oracle9i have increased database availablity including:<br /><ul><li><a href="http://211.140.182.228:8080/pebble/#OnlineIndexRebuilds"><strong><font color="#4169aa">Online Index Rebuilds</font></strong></a...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Thu, 08 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Finding the source of enqueue waits</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64606</link>
								<description><![CDATA[From OTN<br><p class="oracleheading1" style="auto 3.75pt"><span lang="EN-US"><strong><font face="Arial" color="#000066"></font></strong></span></p><p style="MARGIN-LEFT: 3.75pt; MARGIN-RIGHT: 3.75pt"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMIL...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Thu, 08 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>DBA Checklist</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64593</link>
								<description><![CDATA[For Oracle DBA Daily/Weekly/Monthly Checklist<br><h2 style="12pt 0cm 3pt 18pt; TEXT-INDENT: 0cm"><a name="_Toc491698917"><span lang="EN-US"><em><font face="Arial" size="3">A.</font></em><span style="7pt "Times New Roman"""">    </span></span><span lang...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Causes of Oracle Buffer Busy Waits</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64594</link>
								<description><![CDATA[From <a href="http://www.hotsos.com">www.hotsos.com</a><br><p><b><span lang="EN-US" style="FONT-SIZE: 18pt"><font face="宋体"></font></span></b></p><p><span lang="EN-US"><font face="宋体"> <p /></font></span></p><p class="MsoNormal" style="0cm 0cm 0pt"...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Oracle Wait Interface</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64595</link>
								<description><![CDATA[From <a href="http://www.oracle.com">Www.oracle.com</a><br><p><span lang="EN-US"><strong><font size="5">Oracle Wait Events</font></strong></span></p><div align="center"><table style="493.5pt" cellspacing="0" cellpadding="0" width="658" border="0"><tbod...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Checkpoint Tuning and Troubleshooting</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64596</link>
								<description><![CDATA[From metalink<br><table style="431.25pt" cellspacing="0" cellpadding="0" width="575" border="0"><tbody><tr style="12.75pt"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Write a simple security audit script for Oracle</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64597</link>
								<description><![CDATA[For Oracle Security<br><h2 style="6pt; TEXT-ALIGN: center" align="left"><span lang="EN-US" style="FONT-FAMILY: Verdana">Those who are familiar with the Oracle data dictionary can use the dictionary to find out if their database has any security exposur...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Welcome to the Oracle FAQ Page</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64598</link>
								<description><![CDATA[Oracle FAQ Page<br><p style="TEXT-ALIGN: center" align="center"><span lang="EN-US" style="FONT-SIZE: 13.5pt"><font face="宋体">Data Storage</font></span></p><p><i><span lang="EN-US"><font face="宋体">Q: I want to move a database file to another directo...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Managing Contention for Oracle Latches</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64599</link>
								<description><![CDATA[From metalink<br><h2 style="auto 0cm"><span lang="EN-US"><font face="宋体"></font></span></h2><p><font face="宋体"><i><span lang="EN-US" style="FONT-SIZE: 10pt">Internally, Oracle uses various types of structures, the access of which is controlled usin...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Performance and Tuning on the Solaris 6 7 8</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64600</link>
								<description><![CDATA[Performance Tuning for Solaris<br><p><b><span lang="EN" style="FONT-SIZE: 16pt; COLOR: #e76f00"><font face="Arial"></font></span></b></p><p><span lang="EN-US"><font face="Arial" size="2">When a system is running slowly and performance is degrading, it ...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Shared memory uncovered</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64601</link>
								<description><![CDATA[Share memory/Shmmax and so on.<br><p><span lang="EN-US"><strong><font size="5"></font></strong></span></p><div style="TEXT-ALIGN: center" align="center"><span lang="EN-US"><strong><font size="5"><hr align="center" width="100%" size="2" /></font></stron...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 07 Jun 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>How To Reduce the DB File Sequential Read Wait Event</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64591</link>
								<description><![CDATA[<p>How to reduce the DB File Sequential Read :)</p><br><p>stripe the data across multiple disks?</p><p>db file sequential read is due to INDEXED reads by the way -- it is single block <br />IO, it is not the result of a full scan.  So.... you may well ...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Mon, 22 May 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Oracle Block Error</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64592</link>
								<description><![CDATA[If you find block Error in alert or when you run sql Statement......<br><p><br />If we run Oracle in Archive log mode. And the Error was not in system/Redo and Rollback segment.<br />A. Recovery with Backup files.<br />  1.cp the backuped datafiles bac...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Mon, 22 May 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>install oracle with rsp file</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64590</link>
								<description><![CDATA[respond file for install oracle automatically<br><span id="ArticleContent1_ArticleContent1_lblContent"> <p><font face="Courier New">通过Oracle通用安装工具（Oracle Universal Installer，以下简称为OUI）和安装应答文件（response file，以下简称为应答文件），...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Sun, 07 May 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Oracle Critical Patch Upgrade April 2006</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64589</link>
								<description><![CDATA[<p>The Critical Patch Update Advisory is the starting point for relevant information, and it provides instructions on how to obtain the patches. It contains a summary of the security vulnerabilities and links to other important documents.</p><p>It is e...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Wed, 19 Apr 2006 00:00:00 GMT</pubDate>
							</item>
							<item>
								<title>Bug of Prod of Oracle</title>
								<link>http://space.itpub.net/?uid-26706-action-viewspace-itemid-64588</link>
								<description><![CDATA[A bug of Oracle 8.0.5.2<br><p><span lang="EN-US">When I query GL_JE_LINES, it prompt like following:</span></p><p><span lang="EN-US">20:42:55<span> </span>ORA-01115: </span><span style="FONT-FAMILY: 宋体">从文件</span><span lang="EN-US">8</span><span s...]]></description>
								<category>blog</category>
								<author>yanggq</author>
								<pubDate>Thu, 09 Mar 2006 00:00:00 GMT</pubDate>
							</item>
							
		</channel>
	</rss>