<?xml version="1.0" encoding="gb2312"?>
<feed version="0.3" xmlns="http://purl.org/atom/ns#" xmlns:dc="http://purl.org/dc/elements/1.1/" xml:lang="zh-cn">
    
    <title>oracle tips</title> 
<link rel="alternate" type="text/html" href="http://jametong.itpub.net" /> 
 
<modified>Wed,16 05 2012 22:45:30</modified> 
<tagline></tagline> 
<generator url="http://www.plogworld.net/" version="1.0.1">pLog</generator> 
 
<copyright>Copyright (c) jametong</copyright> 
    
 <entry> 
 <id>tag:post:blog.itpub.net,Tue,11 07 2006 11:59:41</id>
 <title>又见惊人之余, 实在是高啊..</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/138476" /> 
  
 <modified>Tue,11 07 2006 11:59:41</modified> 
 <issued>Tue,11 07 2006 11:59:41</issued> 
 <created>Tue,11 07 2006 11:59:41</created> 
 <summary type="text/plain"> http://biz.163.com/06/0706/17/2LC8H6LN00020QEO.html人不要脸到这种程度也没什么好说的了....董藩：房价下跌受损的是百姓 做讲真话教授真难近期国家对房地产行业的新一轮政策调控，使围绕房地产
行业热点问题的讨论进一步升温。5日，在“按揭生态圈的构建——中国按揭行业格局与前景”论坛上，北京师范大学管理学院的董藩教授，用自己的特色语言阐述
了他“关于房地产话题的10个观点”，其中令房地产开发商和商业银行深感惊奇的观点是“房地产市场秩序混乱的根源在于民族文化”。房地产市场不存在价格虚高 
根据他的观点，目前房地产...</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
My life
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 http://biz.163.com/06/0706/17/2LC8H6LN00020QEO.html人不要脸到这种程度也没什么好说的了....董藩：房价下跌受损的是百姓 做讲真话教授真难近期国家对房地产行业的新一轮政策调控，使围绕房地产
行业热点问题的讨论进一步升温。5日，在“按揭生态圈的构建——中国按揭行业格局与前景”论坛上，北京师范大学管理学院的董藩教授，用自己的特色语言阐述
了他“关于房地产话题的10个观点”，其中令房地产开发商和商业银行深感惊奇的观点是“房地产市场秩序混乱的根源在于民族文化”。房地产市场不存在价格虚高 
根据他的观点，目前房地产...</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Tue,14 06 2005 16:04:35</id>
 <title>Problem to connect as SYSDBA(zt from asktom)</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/32288" /> 
  
 <modified>Tue,14 06 2005 16:04:35</modified> 
 <issued>Tue,14 06 2005 16:04:35</issued> 
 <created>Tue,14 06 2005 16:04:35</created> 
 <summary type="text/plain"> Hi there,I am running Oracle 8.1.7 EE on SUN Solaris. I created two databasesSUGAR and TestDb (I need one to do some testing). Both are set remote_login_passwordfile = exclusive. The following shows how I had trouble to connect as SYSDBA. The big problem is that I cannot connect to TestDb as SYSDBA.$sqlplus /nologSQL&gt; conn sys/change_on_install@testdbconnectedSQL&gt; select * from v$pwfile_users;username sysdb sysop------------------------------internal true truesys true trueSQL&gt; conn sys/change_on...</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 Hi there,I am running Oracle 8.1.7 EE on SUN Solaris. I created two databasesSUGAR and TestDb (I need one to do some testing). Both are set remote_login_passwordfile = exclusive. The following shows how I had trouble to connect as SYSDBA. The big problem is that I cannot connect to TestDb as SYSDBA.$sqlplus /nologSQL&gt; conn sys/change_on_install@testdbconnectedSQL&gt; select * from v$pwfile_users;username sysdb sysop------------------------------internal true truesys true trueSQL&gt; conn sys/change_on...</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Tue,07 06 2005 09:03:21</id>
 <title>relation between consistent gets and arraysize(zt from asktom)</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/31700" /> 
  
 <modified>Tue,07 06 2005 09:03:21</modified> 
 <issued>Tue,07 06 2005 09:03:21</issued> 
 <created>Tue,07 06 2005 09:03:21</created> 
 <summary type="text/plain"> Consistenet gets is based upon re-constructing a block
for consistent read. Hence it is a function of only the
number of db_blocks to be read.
If you say that it is altered by the arraysize, do you
suggest that, due to arraysize, some blocks are read
muliple times and hence some blocks have &gt; 1 
consistent read in the process
Thanks 



Followup:





No, you are wrong in your statement.
A consistent get is a block gotten in read consistent mode (point in time mode). It MAY or ...</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 Consistenet gets is based upon re-constructing a block
for consistent read. Hence it is a function of only the
number of db_blocks to be read.
If you say that it is altered by the arraysize, do you
suggest that, due to arraysize, some blocks are read
muliple times and hence some blocks have &gt; 1 
consistent read in the process
Thanks 



Followup:





No, you are wrong in your statement.
A consistent get is a block gotten in read consistent mode (point in time mode). It MAY or ...</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Thu,19 05 2005 18:34:05</id>
 <title>about tune db cache</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/30373" /> 
  
 <modified>Thu,19 05 2005 18:34:05</modified> 
 <issued>Thu,19 05 2005 18:34:05</issued> 
 <created>Thu,19 05 2005 18:34:05</created> 
 <summary type="text/plain"> about tune db cache</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 about tune db cache</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Thu,28 04 2005 10:06:57</id>
 <title>DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS(zt from asktom)</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/27966" /> 
  
 <modified>Thu,28 04 2005 10:06:57</modified> 
 <issued>Thu,28 04 2005 10:06:57</issued> 
 <created>Thu,28 04 2005 10:06:57</created> 
 <summary type="text/plain"> DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS(zt from asktom)</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS(zt from asktom)</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Wed,27 04 2005 23:26:45</id>
 <title>Calling Export from Pl/sql using C external proc</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/27944" /> 
  
 <modified>Wed,27 04 2005 23:26:45</modified> 
 <issued>Wed,27 04 2005 23:26:45</issued> 
 <created>Wed,27 04 2005 23:26:45</created> 
 <summary type="text/plain"> Calling Export from Pl/sql using C external proc</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 Calling Export from Pl/sql using C external proc</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Wed,27 04 2005 21:31:02</id>
 <title>如何sql查询出连续号码段</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/27936" /> 
  
 <modified>Wed,27 04 2005 21:31:02</modified> 
 <issued>Wed,27 04 2005 21:31:02</issued> 
 <created>Wed,27 04 2005 21:31:02</created> 
 <summary type="text/plain"> 如何sql查询出连续号码段</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
Oracle tips
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 如何sql查询出连续号码段</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Wed,27 04 2005 08:39:12</id>
 <title>sql to get data from flat file(zt from asktom)</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/27838" /> 
  
 <modified>Wed,27 04 2005 08:39:12</modified> 
 <issued>Wed,27 04 2005 08:39:12</issued> 
 <created>Wed,27 04 2005 08:39:12</created> 
 <summary type="text/plain"> sql to get data from flat file(zt from asktom)</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 sql to get data from flat file(zt from asktom)</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Wed,27 04 2005 00:58:48</id>
 <title>how tom write pagenation sql</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/27824" /> 
  
 <modified>Wed,27 04 2005 00:58:48</modified> 
 <issued>Wed,27 04 2005 00:58:48</issued> 
 <created>Wed,27 04 2005 00:58:48</created> 
 <summary type="text/plain"> how tom write pagenation sql</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 how tom write pagenation sql</content> 
</entry> 

 <entry> 
 <id>tag:post:blog.itpub.net,Tue,26 04 2005 07:41:32</id>
 <title>DIAGNOSING AND RESOLVING ORA-04031 ERROR</title> 
 <link rel="alternate" type="text/html" href="http://jametong.itpub.net/post/5042/27713" /> 
  
 <modified>Tue,26 04 2005 07:41:32</modified> 
 <issued>Tue,26 04 2005 07:41:32</issued> 
 <created>Tue,26 04 2005 07:41:32</created> 
 <summary type="text/plain"> DIAGNOSING AND RESOLVING ORA-04031 ERROR</summary> 
 <author> 
  
 <name>jametong</name> 
 <url>http://jametong.itpub.net</url> 
 <email>jametong@gmail.com</email> 
</author> 
<dc:subject>
oracle refs
</dc:subject> 
 <content type="text/html" mode="escaped" xml:lang="zh-cn" xml:base="http://jametong.itpub.net"> 
 DIAGNOSING AND RESOLVING ORA-04031 ERROR</content> 
</entry> 
     </feed>



