|
# 1903
JeRry
|
|
|
 To:
干脆再费点功夫弄成论坛吧，技术和灌水分开搞，怎么样？衣钩
From: JeRry
2005.10.27 23:04
|
|
|
|
|
To: JeRry
[COLOR=blue]搞论坛很容易，但是可能没有那么多经历去维护了：）[/COLOR]
From: eygle
2005.10.28 19:38
|
|
|
|
|
# 1902
Wood
来自: Shanghai
|
|
|
To: Wood
[COLOR=blue]是的；如果你的底层表会有变化，建议你用高级复制而不是物化视图，DBMS_REPCAT有几个过程可以用来传播DDL操作。[/COLOR]
From: eygle
2005.10.30 19:25
|
|
|
|
|
# 1901
lala
|
|
|
To:
这几天我们这里一直下雨，晚上在家里光着膀子都感觉凉了
上周末俺爹说需要穿薄毛衣了
俺姐姐说25号凌晨开始供暖气
刚刚回来的同事说家里下雪了
From: lala
2005.10.27 17:32
|
|
|
|
|
To: lala
[COLOR=blue]我家里也已经上冻了，冷气来了。北京还好，艳阳高照，今天：）[/COLOR]
From: eygle
2005.10.28 19:39
|
|
|
|
|
# 1900
Ate
|
|
|
 To:
恩，俺的意思是看起来一切都好。
From: Ate
2005.10.27 03:14
|
|
|
|
|
 To: Ate
[COLOR=blue]这是如何看出来的?[/COLOR]
From: eygle
2005.10.27 07:39
|
|
|
|
|
# 1897
lala
|
|
|
To:
office里比较冷，套了一件外套，刚刚下楼吃饭的时候，脱掉外套，突然想到窗口还是海区，就去按windows键跟D，脱外套是霹雳帕啦的，身上带了静电，结果手被电了一下
From: lala
2005.10.26 21:13
|
|
|
|
|
To: lala
[COLOR=blue]北京也是一样，冬天来了，到处都是静电，今天早晨还下了雨；很快就要冷起来了！[/COLOR]
From: eygle
2005.10.27 07:39
|
|
|
|
|
# 1896
westlife
|
|
|
To: eygle
检查日志文件上是否存在磁盘IO竞争现象，用以下sql:
Select event,total_waits,time_waited,average_wait from v$system_event where event like 'log file switch completion%';
结果是：
EVENT TOTAL_WAITS
---------------------------------------------------------------- -----------
TIME_WAITED AVERAGE_WAIT
----------- ------------
log file switch completion 30
126 4
请问是否存在磁盘IO竞争现象？该怎样调整，谢谢！
From: westlife
2005.10.26 05:29
|
|
|
|
|
To: westlife
[COLOR=blue]
单凭一个等待事件不能说明问题的，这只能说明在Log Switch时存在等待。
无法断定原因。需要结合其他事件来看。
[/COLOR]
From: eygle
2005.10.26 20:41
|
|
|
|
|
# 1895
qiuleizhen
|
|
|
To:
我上网查了很多资料，这些问题好像都找不到一个合理的答案哦～大哥，帮忙看下，辛苦了
From: qiuleizhen
2005.10.26 02:21
|
|
|
|
|
# 1894
qiuleizhen
|
|
|
To:
尊敬的eygle,在线么？帮忙看看小弟的问题，好么？谢谢了
From: qiuleizhen
2005.10.26 02:05
|
|
|
|
|
To: qiuleizhen
[COLOR=blue]
你的问题也太多了吧!
很多问题可以自己尝试找出答案!
[/COLOR]
From: eygle
2005.10.26 02:16
|
|
|
|
|
eygle.com
我要留言
回复
编辑
To: eygle
到物化视图站("订阅站"