eygle.com   eygle.com
eygle.com  
 
留言簿 - Powered by eYgLe.Com
eygle.com 我要留言
新书《循序渐进Oracle》即将出版
昵称
内容 页: 1 - << < 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 > >> - 317
# 19005
Julia




To: Chi
  Cantonese Restaurant is really good. Abalone, Lobster, Fish, Shell, Shark Fin....
In Guangdong, the price of these kind of seafood is acceptable. While in Beijing, it's very expensive for us to afford.
From: Julia
2006.11.18 11:46

版主选项: 回复 编辑
# 19004
Chi


来自: Mexico


To: Eygle
  You are killing me!.I am envying your guys. Every time you went out for lunch or dinner, you mentioned those very interesting restaurant.Please, please take some pictures of those dishes next time.I knew you are very good in photography while I read your other articles and at least those dishes fulfill my desire even I can not taste those.In addition I want to show my Mexican colleagues what Chinese really eat.You too, Julia.

From: Chi
2006.11.18 00:36

版主选项: 回复 编辑
# 19002
johnnie




To: eygle
  eygle你好!我心中一直有个疑问。那就是ORACLE数据库,它与其它数据库相比较它的优点和特点在哪里?它一般最常应用再那些场合呢?因为ORACLE是我现在接触最深的唯一一个数据库,由于缺少对其他数据库的了解,所以就提出以上这个问题。谢谢~~!
From: johnnie
2006.11.17 17:03
To: johnnie
  
这样的比较文章很多,你可以参考一下:
http://www.mssqlcity.com/Articles/Compare/Compare.htm

From: eygle
2006.11.20 09:17

版主选项: 回复 编辑
# 19000
Julia




To: Eygle
  我中午去“祖母的厨房”午餐,嘿嘿
下次带你去~
From: Julia
2006.11.17 11:23

版主选项: 回复 编辑
# 18999
julia




To: Qingcaimaomao
  -_-
From: julia
2006.11.16 20:00
To: julia
  
From: eygle
2006.11.17 10:33

版主选项: 回复 编辑
# 18998
qingcaimaomao




To: eygle
  **************帅哥好,JULIA不要吃醋哦***************
我现在DB SERBER里的 ora_lgwr_HCMDEV进程的内存占用情况为:
 Pid CommandInusePin PgspVirtual 64-bit Mthrd16MB
  864412 oracle314462 669756157 133993Y N N

我想知道这个内存难道就是SGA里设置的LOG-BUFFER吗?

有关于ORACLE的内存机制哪里有资料啊???

多谢
From: qingcaimaomao
2006.11.16 17:37
To: qingcaimaomao
  
参考:
http://www.eygle.com/archives/2004/12/howto_get_process_memory_consume.html

From: eygle
2006.11.17 10:31

版主选项: 回复 编辑
# 18997
hounanhai




To: eygle
  您好!
 如果不建复合索引,而建2个单键索引,在查询过程中,就只能用到一个索引了,那不是更不好吗?

************************************************************
但该操作占用CPU时间是全部的80%,而且大量的Logical read,
请问,由于按字段product 进行分组,请问,对于product 字段是否也需要建立索引?

From: hounanhai
2006.11.16 11:05
 
 
 
 
 
 
 
  To: hounanhai
  
要看你的结果集的数据量
(EVENTTIME,EQPID,QUANTITY,SUBCOMPQTY)
不要建复合索引,建关于EQPID和EVENTTIME的单键值索引。
***********************************************************
 
 

From: hounanhai
2006.11.16 17:33
To: hounanhai
  复合索引可能会导致过多的逻辑读,如果能去除无用的键值自然是好的。
From: eygle
2006.11.17 10:32

版主选项: 回复 编辑
# 18996
stockxs333




To:
  oracle 10g for linux的详细删除过程是什么?
From: stockxs333
2006.11.16 15:17
To: stockxs333
  
你可以直接覆盖安装的。

From: eygle
2006.11.17 10:33

版主选项: 回复 编辑
# 18994
Julia




To: Chi
  We've been considering a bike, but also the thief, wind, sand, sun, many many bikes...so...bus is the best....
From: Julia
2006.11.16 11:57

版主选项: 回复 编辑
# 18993
Julia




To: Chi
  天天堵车啊~~
From: Julia
2006.11.16 11:53

版主选项: 回复 编辑

页: 1 - << < 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 > >> - 317
我要留言
Copyright © 2003-2008 eygle.com All Rights Reserved.
Powered by: www.eYgLe.com