咨询oracle 性能慢问题
时间:2010-08-19
来源:互联网
环境:solaris + oracle 10.2+ocr+裸设备双机
用户说起单机oracle性能还可以,起了双机后性能很慢。
查看了oracle日志发现日志切换频繁是否是这个引起的。
Current log# 1 seq# 30492 mem# 0: /dev/rdsk/c1t9d0s0
Fri Aug 13 19:09:10 2010
Thread 1 advanced to log sequence 30493
"alert_kms1.log" 3491 行,134770 字符
Thu Aug 19 10:36:10 2010
Thread 1 cannot allocate new log, sequence 30916
Checkpoint not complete
Current log# 2 seq# 30915 mem# 0: /dev/rdsk/c1t9d0s1
Thread 1 advanced to log sequence 30916
Current log# 1 seq# 30916 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 10:38:00 2010
Thread 1 cannot allocate new log, sequence 30917
Checkpoint not complete
Current log# 1 seq# 30916 mem# 0: /dev/rdsk/c1t9d0s0
Thread 1 advanced to log sequence 30917
Current log# 2 seq# 30917 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 10:40:01 2010
Thread 1 advanced to log sequence 30918
Current log# 1 seq# 30918 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 10:42:19 2010
Thread 1 cannot allocate new log, sequence 30919
Checkpoint not complete
Current log# 1 seq# 30918 mem# 0: /dev/rdsk/c1t9d0s0
Thread 1 advanced to log sequence 30919
Current log# 2 seq# 30919 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 10:44:03 2010
Thread 1 cannot allocate new log, sequence 30920
Checkpoint not complete
Current log# 2 seq# 30919 mem# 0: /dev/rdsk/c1t9d0s1
Thread 1 advanced to log sequence 30920
Current log# 1 seq# 30920 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 10:45:58 2010
Thread 1 advanced to log sequence 30921
Current log# 2 seq# 30921 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 10:56:14 2010
Thread 1 advanced to log sequence 30922
Current log# 1 seq# 30922 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 11:39:25 2010
Thread 1 advanced to log sequence 30923
Current log# 2 seq# 30923 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 11:42:10 2010
Thread 1 advanced to log sequence 30924
Current log# 1 seq# 30924 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 11:44:02 2010
Thread 1 advanced to log sequence 30925
Current log# 2 seq# 30925 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 11:45:17 2010
Thread 1 advanced to log sequence 30926
Current log# 1 seq# 30926 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 11:51:26 2010
Starting background process EMN0
用户说起单机oracle性能还可以,起了双机后性能很慢。
查看了oracle日志发现日志切换频繁是否是这个引起的。
Current log# 1 seq# 30492 mem# 0: /dev/rdsk/c1t9d0s0
Fri Aug 13 19:09:10 2010
Thread 1 advanced to log sequence 30493
"alert_kms1.log" 3491 行,134770 字符
Thu Aug 19 10:36:10 2010
Thread 1 cannot allocate new log, sequence 30916
Checkpoint not complete
Current log# 2 seq# 30915 mem# 0: /dev/rdsk/c1t9d0s1
Thread 1 advanced to log sequence 30916
Current log# 1 seq# 30916 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 10:38:00 2010
Thread 1 cannot allocate new log, sequence 30917
Checkpoint not complete
Current log# 1 seq# 30916 mem# 0: /dev/rdsk/c1t9d0s0
Thread 1 advanced to log sequence 30917
Current log# 2 seq# 30917 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 10:40:01 2010
Thread 1 advanced to log sequence 30918
Current log# 1 seq# 30918 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 10:42:19 2010
Thread 1 cannot allocate new log, sequence 30919
Checkpoint not complete
Current log# 1 seq# 30918 mem# 0: /dev/rdsk/c1t9d0s0
Thread 1 advanced to log sequence 30919
Current log# 2 seq# 30919 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 10:44:03 2010
Thread 1 cannot allocate new log, sequence 30920
Checkpoint not complete
Current log# 2 seq# 30919 mem# 0: /dev/rdsk/c1t9d0s1
Thread 1 advanced to log sequence 30920
Current log# 1 seq# 30920 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 10:45:58 2010
Thread 1 advanced to log sequence 30921
Current log# 2 seq# 30921 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 10:56:14 2010
Thread 1 advanced to log sequence 30922
Current log# 1 seq# 30922 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 11:39:25 2010
Thread 1 advanced to log sequence 30923
Current log# 2 seq# 30923 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 11:42:10 2010
Thread 1 advanced to log sequence 30924
Current log# 1 seq# 30924 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 11:44:02 2010
Thread 1 advanced to log sequence 30925
Current log# 2 seq# 30925 mem# 0: /dev/rdsk/c1t9d0s1
Thu Aug 19 11:45:17 2010
Thread 1 advanced to log sequence 30926
Current log# 1 seq# 30926 mem# 0: /dev/rdsk/c1t9d0s0
Thu Aug 19 11:51:26 2010
Starting background process EMN0
作者: smile_pp 发布时间: 2010-08-19
查看redo都已经150M了。应该也不小了。
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 30928 157286400 1 YES INACTIVE
6068761252 19-8月 -10
2 1 30929 157286400 1 NO CURRENT
6068852336 19-8月 -10
3 2 53503 157286400 1 YES INACTIVE
6068813599 19-8月 -10
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
4 2 53504 157286400 1 NO CURRENT
6068905921 19-8月 -10
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 30928 157286400 1 YES INACTIVE
6068761252 19-8月 -10
2 1 30929 157286400 1 NO CURRENT
6068852336 19-8月 -10
3 2 53503 157286400 1 YES INACTIVE
6068813599 19-8月 -10
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
4 2 53504 157286400 1 NO CURRENT
6068905921 19-8月 -10
作者: smile_pp 发布时间: 2010-08-19
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/dev/rdsk/c1t9d0s1
/dev/rdsk/c1t9d0s0
/dev/rdsk/c1t10d0s0
/dev/rdsk/c1t10d0s1
发现第一台设备切换用的是
/dev/rdsk/c1t9d0s1
/dev/rdsk/c1t9d0s0
发现第二台设备切换用的是
/dev/rdsk/c1t10d0s0
/dev/rdsk/c1t10d0s1
是否正常。
MEMBER
--------------------------------------------------------------------------------
/dev/rdsk/c1t9d0s1
/dev/rdsk/c1t9d0s0
/dev/rdsk/c1t10d0s0
/dev/rdsk/c1t10d0s1
发现第一台设备切换用的是
/dev/rdsk/c1t9d0s1
/dev/rdsk/c1t9d0s0
发现第二台设备切换用的是
/dev/rdsk/c1t10d0s0
/dev/rdsk/c1t10d0s1
是否正常。
作者: smile_pp 发布时间: 2010-08-19
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28