# 43493
cloveyboy
来自: 北京
|
|
To:
老师,请教一个问题,我的服务器处理能力非常好,现在批量插入数据时写数据日志非常快,达到20M,但写数据非常慢,只有1M,经常出现写日志停下等数据的情况,造成访问会时常中断,卡在那里,不知道是那里出问题了,用的是64位的ORACLE.归档什么都停掉的,就纯粹的写数据也会这样,急盼回复.
From: cloveyboy 2007.07.31 18:13
|
|
|
|
# 43492
Chi
来自: Mexico
|
|
To: Eygle
Check my 10g R2 with the EM, I saw the "log file parallel" and "log file sync" are in the top wait event list in busy hour.However The configuration of my redo log is setup with 2 copies of each group (5 groups, 50M each). But all first copies are located on one drive (hd3) and another copies are stored in another drive (physically hd2).I have no other drive that can be spared for the redo. Because my /oradata has taken one (hd3) with redo copy 1a, 2a, 3a, 4a, 5a, $ORACLE_HOME uses another hd1 and OS has its own (hd0).According to Oracle principle that the “log file sync” and log file parallel” could be caused by such set up; Oracle recommends to spread each group on different dh.If I can not, how can I optimize redo activity and avoid such “waiting”?
From: Chi 2007.07.31 15:06
|
|
|
|
# 43489
咪咪
|
|
To: 猫咪
下了一夜的大雨呢~
From: 咪咪 2007.07.30 06:37
|
|
|
|
# 43488
sa
来自: 广东
|
|
To:
盖大师:
你好,我学习linux 已有四五年的时间了,水平一般般..,linux基本系统管理,LAMP基本配置基本能搞定.我不会写程序,只会点十分简单的shell script,我现在十分迷茫..,想向Linux/unix + Oracle 方面发展,向DBA方向发展. 学了一阵Java 编程,觉得没投入大理的时间和精力根本擦不到边.请问没有开发背景,程序只能写个Hello Word 能学好Oracle,学好数据库吗?谢谢!
From: sa 2007.07.30 01:32
|
|
|
|
To: sa
[COLOR=blue]有志者事竟成阿,关键是坚持;Oracle的学习和编程关系不大,只要多下点功夫,就能成功。[/COLOR]
From: eygle 2007.08.05 18:28
|
|
|
|
# 43486
soul
来自: 深圳
|
|
To: 盖先生
盖先生你好!
很希望你能够在百忙之中抽时间帮我看下关于批处理的问题,前段时间看了你的书,有点儿不明白,当面请教下:
我用普通的单机,,没有做过任何的优化,用java的批处理,addBatch(),将一句"UPDATE tablename SET 字段=? WHERE 条件=? AND 条件=?"其中两个条件都有索引,当添加到1万的时候执行批处理executeBatch,用时差不多10分钟,如此之慢,,一直没找到解决方案,特向您请教...
From: soul 2007.07.28 17:54
|
|
|
|
|