Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › enq: TC - contention 咨询
发新帖
xifenfei

8

积分

0

好友

0

主题

enq: TC - contention 咨询

1#
发表于 2011-10-27 09:30:06 | 查看: 7627| 回复: 7
今天数据库出现enq: TC - contention等待时间，查询了一些资料，不知道怎么理解这个等待事件合适
系统环境
redhat 5.4   oracle 10.2.0.4  单机

当时系统在执行一个大的批量处理，日志切换异常频繁
日志开始时间                      日志结束时间                分钟   seq
2011-10-27 02:59:08
2011-10-27 02:59:32
0.4
43894
2011-10-27 02:58:47
2011-10-27 02:59:08
0.35
43893
2011-10-27 02:57:56
2011-10-27 02:58:47
0.85
43892
2011-10-27 02:23:50
2011-10-27 02:57:56
34.1
43891
2011-10-27 02:22:39
2011-10-27 02:23:50
1.183
43890
2011-10-27 02:21:31
2011-10-27 02:22:39
1.133
43889
2011-10-27 02:20:18
2011-10-27 02:21:31
1.217
43888
2011-10-27 02:19:02
2011-10-27 02:20:18
1.267
43887
2011-10-27 02:17:46
2011-10-27 02:19:02
1.267
43886
2011-10-27 02:16:28
2011-10-27 02:17:46
1.3
43885
2011-10-27 02:15:46
2011-10-27 02:16:28
0.7
43884
2011-10-27 02:15:21
2011-10-27 02:15:46
0.417
43883
2011-10-27 02:14:52
2011-10-27 02:15:21
0.483
43882
2011-10-27 02:14:08
2011-10-27 02:14:52
0.733
43881
2011-10-27 02:13:13
2011-10-27 02:14:08
0.917
43880
2011-10-27 02:12:27
2011-10-27 02:13:13
0.767
43879
2011-10-27 02:11:58
2011-10-27 02:12:27
0.483
43878
2011-10-27 02:11:29
2011-10-27 02:11:58
0.483
43877
2011-10-27 02:10:59
2011-10-27 02:11:29
0.5
43876


我的理解是当然日志切换比较频繁，导致datafile header修改频繁，所以导致了enq: TC - contention等待

请问liu是否遇到这样情况
2#
发表于 2011-10-27 09:35:40
enq: TC - contention
Lock held to guarantee uniqueness of a tablespace checkpoint

回复 只看该作者 道具 举报

3#
发表于 2011-10-27 15:40:31
:) 纷飞你好，

请把问题发生时段的alert.log 内容贴出来 ， 使用代码形式<code>

  1. tail -50000 alert*.log
复制代码

回复 只看该作者 道具 举报

4#
发表于 2011-10-27 20:50:21
下午参加oracle 研讨会去了，刚刚回来
因为这个等待是在26日的2到3点的awr中出现的，所以只贴了这么多（论坛一次回复最多也只支持1000字符）

  2. Wed Oct 26 00:05:39 2011
  3. Thread 1 advanced to log sequence 43822 (LGWR switch)
  4.   Current log# 4 seq# 43822 mem# 0: /opt/oracle/oradata/ora9i/redo0401.log
  5.   Current log# 4 seq# 43822 mem# 1: /opt/oracle/oradata/ora9i/redo04_2.log
  6. Wed Oct 26 01:00:40 2011
  7. ALTER SYSTEM ARCHIVE LOG
  8. Wed Oct 26 01:00:40 2011
  9. Thread 1 advanced to log sequence 43823 (LGWR switch)
  10.   Current log# 5 seq# 43823 mem# 0: /opt/oracle/oradata/ora9i/redo0501.log
  11.   Current log# 5 seq# 43823 mem# 1: /opt/oracle/oradata/ora9i/redo05_2.log
  12. Wed Oct 26 02:11:29 2011
  13. Thread 1 advanced to log sequence 43824 (LGWR switch)
  14.   Current log# 6 seq# 43824 mem# 0: /opt/oracle/oradata/ora9i/redo0601.log
  15.   Current log# 6 seq# 43824 mem# 1: /opt/oracle/oradata/ora9i/redo06_2.log
  16. Wed Oct 26 02:12:16 2011
  17. Thread 1 advanced to log sequence 43825 (LGWR switch)
  18.   Current log# 1 seq# 43825 mem# 0: /opt/oracle/oradata/ora9i/redo0101.log
  19.   Current log# 1 seq# 43825 mem# 1: /opt/oracle/oradata/ora9i/redo01_2.log
  20. Wed Oct 26 02:12:56 2011
  21. Thread 1 advanced to log sequence 43826 (LGWR switch)
  22.   Current log# 2 seq# 43826 mem# 0: /opt/oracle/oradata/ora9i/redo0201.log
  23.   Current log# 2 seq# 43826 mem# 1: /opt/oracle/oradata/ora9i/redo02_1.log
  24. Wed Oct 26 02:13:32 2011
  25. Thread 1 advanced to log sequence 43827 (LGWR switch)
  26.   Current log# 3 seq# 43827 mem# 0: /opt/oracle/oradata/ora9i/redo0301.log
  27.   Current log# 3 seq# 43827 mem# 1: /opt/oracle/oradata/ora9i/redo03_1.log
  28. Wed Oct 26 02:14:31 2011
  29. Thread 1 advanced to log sequence 43828 (LGWR switch)
  30.   Current log# 4 seq# 43828 mem# 0: /opt/oracle/oradata/ora9i/redo0401.log
  31.   Current log# 4 seq# 43828 mem# 1: /opt/oracle/oradata/ora9i/redo04_2.log
  32. Wed Oct 26 02:15:27 2011
  33. Thread 1 advanced to log sequence 43829 (LGWR switch)
  34.   Current log# 5 seq# 43829 mem# 0: /opt/oracle/oradata/ora9i/redo0501.log
  35.   Current log# 5 seq# 43829 mem# 1: /opt/oracle/oradata/ora9i/redo05_2.log
  36. Wed Oct 26 02:16:21 2011
  37. Thread 1 advanced to log sequence 43830 (LGWR switch)
  38.   Current log# 6 seq# 43830 mem# 0: /opt/oracle/oradata/ora9i/redo0601.log
  39.   Current log# 6 seq# 43830 mem# 1: /opt/oracle/oradata/ora9i/redo06_2.log
  40. Wed Oct 26 02:16:46 2011
  41. Thread 1 advanced to log sequence 43831 (LGWR switch)
  42.   Current log# 1 seq# 43831 mem# 0: /opt/oracle/oradata/ora9i/redo0101.log
  43.   Current log# 1 seq# 43831 mem# 1: /opt/oracle/oradata/ora9i/redo01_2.log
  44. Wed Oct 26 02:17:14 2011
  45. Thread 1 advanced to log sequence 43832 (LGWR switch)
  46.   Current log# 2 seq# 43832 mem# 0: /opt/oracle/oradata/ora9i/redo0201.log
  47.   Current log# 2 seq# 43832 mem# 1: /opt/oracle/oradata/ora9i/redo02_1.log
  48. Wed Oct 26 02:17:44 2011
  49. Thread 1 advanced to log sequence 43833 (LGWR switch)
  50.   Current log# 3 seq# 43833 mem# 0: /opt/oracle/oradata/ora9i/redo0301.log
  51.   Current log# 3 seq# 43833 mem# 1: /opt/oracle/oradata/ora9i/redo03_1.log
  52. Wed Oct 26 02:19:16 2011
  53. Thread 1 advanced to log sequence 43834 (LGWR switch)
  54.   Current log# 4 seq# 43834 mem# 0: /opt/oracle/oradata/ora9i/redo0401.log
  55.   Current log# 4 seq# 43834 mem# 1: /opt/oracle/oradata/ora9i/redo04_2.log
  56. Wed Oct 26 02:20:58 2011
  57. Thread 1 advanced to log sequence 43835 (LGWR switch)
  58.   Current log# 5 seq# 43835 mem# 0: /opt/oracle/oradata/ora9i/redo0501.log
  59.   Current log# 5 seq# 43835 mem# 1: /opt/oracle/oradata/ora9i/redo05_2.log
  60. Wed Oct 26 02:22:33 2011
  61. Thread 1 advanced to log sequence 43836 (LGWR switch)
  62.   Current log# 6 seq# 43836 mem# 0: /opt/oracle/oradata/ora9i/redo0601.log
  63.   Current log# 6 seq# 43836 mem# 1: /opt/oracle/oradata/ora9i/redo06_2.log
  64. Wed Oct 26 02:24:01 2011
  65. Thread 1 advanced to log sequence 43837 (LGWR switch)
  66.   Current log# 1 seq# 43837 mem# 0: /opt/oracle/oradata/ora9i/redo0101.log
  67.   Current log# 1 seq# 43837 mem# 1: /opt/oracle/oradata/ora9i/redo01_2.log
  68. Wed Oct 26 02:25:12 2011
  69. Thread 1 advanced to log sequence 43838 (LGWR switch)
  70.   Current log# 2 seq# 43838 mem# 0: /opt/oracle/oradata/ora9i/redo0201.log
  71.   Current log# 2 seq# 43838 mem# 1: /opt/oracle/oradata/ora9i/redo02_1.log
  72. Wed Oct 26 02:26:18 2011
  73. Thread 1 advanced to log sequence 43839 (LGWR switch)
  74.   Current log# 3 seq# 43839 mem# 0: /opt/oracle/oradata/ora9i/redo0301.log
  75.   Current log# 3 seq# 43839 mem# 1: /opt/oracle/oradata/ora9i/redo03_1.log
  76. Wed Oct 26 02:27:29 2011
  77. Thread 1 advanced to log sequence 43840 (LGWR switch)
  78.   Current log# 4 seq# 43840 mem# 0: /opt/oracle/oradata/ora9i/redo0401.log
  79.   Current log# 4 seq# 43840 mem# 1: /opt/oracle/oradata/ora9i/redo04_2.log
  80. Wed Oct 26 03:00:49 2011
  81. Thread 1 advanced to log sequence 43841 (LGWR switch)
  82.   Current log# 5 seq# 43841 mem# 0: /opt/oracle/oradata/ora9i/redo0501.log
  83.   Current log# 5 seq# 43841 mem# 1: /opt/oracle/oradata/ora9i/redo05_2.log
  84. Wed Oct 26 03:01:22 2011
  85. Thread 1 advanced to log sequence 43842 (LGWR switch)
  86.   Current log# 6 seq# 43842 mem# 0: /opt/oracle/oradata/ora9i/redo0601.log
  87.   Current log# 6 seq# 43842 mem# 1: /opt/oracle/oradata/ora9i/redo06_2.log
  88. Wed Oct 26 03:01:59 2011
  89. Thread 1 advanced to log sequence 43843 (LGWR switch)
  90.   Current log# 1 seq# 43843 mem# 0: /opt/oracle/oradata/ora9i/redo0101.log
  91.   Current log# 1 seq# 43843 mem# 1: /opt/oracle/oradata/ora9i/redo01_2.log
  92. Wed Oct 26 03:02:27 2011
  93. Thread 1 advanced to log sequence 43844 (LGWR switch)
  94.   Current log# 2 seq# 43844 mem# 0: /opt/oracle/oradata/ora9i/redo0201.log
  95.   Current log# 2 seq# 43844 mem# 1: /opt/oracle/oradata/ora9i/redo02_1.log
  96. Wed Oct 26 03:03:03 2011
  97. Thread 1 advanced to log sequence 43845 (LGWR switch)
  98.   Current log# 3 seq# 43845 mem# 0: /opt/oracle/oradata/ora9i/redo0301.log
  99.   Current log# 3 seq# 43845 mem# 1: /opt/oracle/oradata/ora9i/redo03_1.log
  100. Wed Oct 26 03:05:40 2011
  101. Thread 1 advanced to log sequence 43846 (LGWR switch)
  102.   Current log# 4 seq# 43846 mem# 0: /opt/oracle/oradata/ora9i/redo0401.log
  103.   Current log# 4 seq# 43846 mem# 1: /opt/oracle/oradata/ora9i/redo04_2.log
  104. Wed Oct 26 03:11:10 2011
  105. Thread 1 advanced to log sequence 43847 (LGWR switch)
  106.   Current log# 5 seq# 43847 mem# 0: /opt/oracle/oradata/ora9i/redo0501.log
  107.   Current log# 5 seq# 43847 mem# 1: /opt/oracle/oradata/ora9i/redo05_2.log
  108. Wed Oct 26 03:12:20 2011
  109. Thread 1 advanced to log sequence 43848 (LGWR switch)
  110.   Current log# 6 seq# 43848 mem# 0: /opt/oracle/oradata/ora9i/redo0601.log
  111.   Current log# 6 seq# 43848 mem# 1: /opt/oracle/oradata/ora9i/redo06_2.log
  112. Wed Oct 26 04:00:32 2011
  113. Thread 1 advanced to log sequence 43849 (LGWR switch)
  114.   Current log# 1 seq# 43849 mem# 0: /opt/oracle/oradata/ora9i/redo0101.log
  115.   Current log# 1 seq# 43849 mem# 1: /opt/oracle/oradata/ora9i/redo01_2.log
  116. Wed Oct 26 06:46:43 2011
  117. ALTER SYSTEM ARCHIVE LOG
  118. Wed Oct 26 06:46:43 2011
  119. Thread 1 advanced to log sequence 43850 (LGWR switch)
  120.   Current log# 2 seq# 43850 mem# 0: /opt/oracle/oradata/ora9i/redo0201.log
  121.   Current log# 2 seq# 43850 mem# 1: /opt/oracle/oradata/ora9i/redo02_1.log
  122. Wed Oct 26 06:46:47 2011
  123. ALTER SYSTEM ARCHIVE LOG
  124. Wed Oct 26 06:46:47 2011
  125. Thread 1 advanced to log sequence 43851 (LGWR switch)
复制代码

贴了几百行，5000行有点多

回复 只看该作者 道具 举报

5#
发表于 2011-10-27 20:51:15
从alert中看无异常信息

回复 只看该作者 道具 举报

6#
发表于 2011-10-27 23:11:15
像ckpt进程的trace文件里有什么特别的不？

回复 只看该作者 道具 举报

7#
发表于 2011-10-30 13:55:56

回复 6# 的帖子

没有发现相关异常………………

回复 只看该作者 道具 举报

8#
发表于 2013-9-19 22:47:25
TC Thread Checkpoint
Enqueue
Checkpoint Id((thread <<
UB2BITS)+processid) always 0

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-15 04:58 , Processed in 0.049387 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569