love wife love life —Roger的Oracle/MySQL数据恢复博客

Phone:18180207355 提供专业Oracle/MySQL数据恢复、性能优化、迁移升级、紧急救援等服务

这周遇到的2个问题

本站文章除注明转载外,均为本站原创: 转载自love wife love life —Roger的Oracle/MySQL数据恢复博客

本文链接地址: 这周遇到的2个问题

昨天在青海某客户计费数据库反应入库很慢,通过查询发现所有的program都在等待reliable message。 对于该等待事件几年前遇到过。通过如下脚本很容易判断产生该等待事件的channel是什么:

通过查询发现均为Result Cache:channel ;由此可见跟11gR2引入的Result cache新特性有关;但是询问客户之后,发现业务sql并没有使用/*+result_cache */之类的hint。

那么为什么会产生这个问题呢? 通过模糊查询v$sqlarea/v$session发现 oracle在对table进行统计信息动态采样;而动态采样的sql语句中使用来诸如result_cache(snapshot=360)之类的hint。经查发现这是12c针对动态采样的增强,通过调整如下的几个参数可以屏蔽该问题:

今天另外一个客户也遇到一个奇怪的问题,insert 语句报错ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn]。

这个问题我还是第一次遇见,从mos文档来看该问题应该是bug,如下:Bug 22241601 – ORA-600 [kdsgrp1] ORA-1555 / ORA-600 [ktbdchk1: bad dscn] due to Invalid Commit SCN in INDEX block (Doc ID 22241601.8)

解决方案是通过重建index或者设置_ktb_debug_flags参数,不过该参数的设置并不会对已经损坏对block起任何作用,仍然建议设置该参数或者打相应打patch。

如下是trace文件的过滤内容:

 

119 Responses to “这周遇到的2个问题”

  1. 罗拉 Says:

    呵呵。学习了。感触良多!

  2. cialis over counter at walmart Says:

    cialis otc

    trackback einen kommentar hinterlassen cialis – natural cures for ed – cialis da acquistare

  3. canada pharmacy viagra generic Says:

    female viagra

    viagra 20mg tablets most users ever online was – viagra taladafil – viagra 10mg cost location

  4. tadalafil 5mg Says:

    tadalafil online

    buy cheap cialis online – genuine viagra cialis gel tabs best price – cialis 20mg canada msn messenger

  5. viagra vs cialis Says:

    cialis coupon

    buy cialis online in total there are – side effects of cialis – compare levitra viagra and cialis joyful.cgi

  6. cheap generic cialis Says:

    cheap generic cialis

    American health

  7. buy cialis 36 hour online Says:

    buy cialis 36 hour online

    American health

  8. tadalafil price 5mg Says:

    tadalafil price 5mg

    tadalafil price 5mg

  9. viagra definition Says:

    viagra definition

    viagra definition

  10. cialis mexico pharmacy Says:

    cialis mexico pharmacy

    cialis mexico pharmacy

  11. cvs cialis cost Says:

    cvs cialis cost

    cvs cialis cost

  12. sildenafil capsule Says:

    sildenafil capsule

    sildenafil capsule

  13. online viagra purchase Says:

    online viagra purchase

    online viagra purchase

  14. neurontin 800 Says:

    neurontin 800

    neurontin 800

  15. cialis com coupons Says:

    cialis com coupons

    cialis com coupons

  16. levitra overdose Says:

    levitra overdose

    levitra overdose

  17. vietnamese viagra Says:

    vietnamese viagra

    vietnamese viagra

  18. amlodipine reviews Says:

    amlodipine reviews

    amlodipine reviews

  19. atorvastatin 40 mg Says:

    atorvastatin 40 mg

    atorvastatin 40 mg

  20. metoprolol tartrate 50mg Says:

    metoprolol tartrate 50mg

    metoprolol tartrate 50mg

  21. losartan hctz recall Says:

    losartan hctz recall

    losartan hctz recall

  22. viagra online Says:

    viagra online

    viagra online

  23. cialis professional samples Says:

    cialis professional samples

    cialis professional samples

  24. levitra dosage Says:

    levitra dosage

    levitra dosage

  25. cymbalta for pain Says:

    cymbalta for pain

    cymbalta for pain

  26. prednisone 10 mg Says:

    prednisone 10 mg

    prednisone 10 mg

  27. amitriptyline for sleep Says:

    amitriptyline for sleep

    amitriptyline for sleep

  28. cymbalta 60 mg Says:

    cymbalta 60 mg

    cymbalta 60 mg

  29. losartan potassium hydrochlorothiazide Says:

    losartan potassium hydrochlorothiazide

    losartan potassium hydrochlorothiazide

  30. metformin benefits Says:

    metformin benefits

    metformin benefits

  31. side effects for mirtazapine Says:

    side effects for mirtazapine

    side effects for mirtazapine

  32. bupropion brand name Says:

    bupropion brand name

    bupropion brand name

  33. buy buspar Says:

    buy buspar

    buy buspar

  34. citalopram and alcohol Says:

    citalopram and alcohol

    citalopram and alcohol

  35. buy tizanidine Says:

    buy tizanidine

    buy tizanidine

  36. bupropion xl Says:

    bupropion xl

    bupropion xl

  37. voltaren schmerzgel forte Says:

    voltaren schmerzgel forte

    voltaren schmerzgel forte

  38. clonidine class Says:

    clonidine class

    clonidine class

  39. finasteride side effects men Says:

    finasteride side effects men

    finasteride side effects men

  40. coreg cr 10mg Says:

    coreg cr 10mg

    coreg cr 10mg

  41. flagyl Says:
  42. generic tadalafil medication Says:

    generic tadalafil medication

    generic tadalafil medication

  43. cheap sildenafil Says:

    cheap sildenafil

    cheap sildenafil

  44. better than viagra Says:

    better than viagra

    better than viagra

  45. levitra for daily use Says:

    levitra for daily use

    levitra for daily use

  46. acyclovir 800 mg Says:

    acyclovir 800 mg

    acyclovir 800 mg

  47. amoxil Says:
  48. donepezil uses Says:

    donepezil uses

    donepezil uses

  49. 500 mg amoxicillin Says:

    500 mg amoxicillin

    500 mg amoxicillin

  50. azithromycin Says:

    azithromycin

    azithromycin

  51. what is cefdinir Says:

    what is cefdinir

    what is cefdinir

  52. genericsbb keflex 500 mg Says:

    genericsbb keflex 500 mg

    genericsbb keflex 500 mg

  53. clindamycin phosphate topical Says:

    clindamycin phosphate topical

    clindamycin phosphate topical

  54. erythromycin 250 mg coupon Says:

    erythromycin 250 mg coupon

    erythromycin 250 mg coupon

  55. zithromax capsules 250mg Says:

    zithromax capsules 250mg

    zithromax capsules 250mg

  56. cialis black 800mg reviews Says:

    cialis black 800mg reviews

    cialis black 800mg reviews

  57. 10 mg tadalafil generic Says:

    10 mg tadalafil generic

    10 mg tadalafil generic

  58. cialis Says:
  59. levitra wiki Says:

    levitra wiki

    levitra wiki

  60. canadian rx viagra Says:

    canadian rx viagra

    canadian rx viagra

  61. cialis canada generic Says:

    cialis canada generic

    cialis canada generic

  62. levitra 20mg price australia Says:

    levitra 20mg price australia

    levitra 20mg price australia

  63. generic viagra for women Says:

    generic viagra for women

    generic viagra for women

  64. online tadalafil 20mg Says:

    online tadalafil 20mg

    online tadalafil 20mg

  65. tadalafil online Says:

    tadalafil online

    tadalafil online

  66. viagra discount coupon Says:

    viagra discount coupon

    viagra discount coupon

  67. sildenafil buy online Says:

    sildenafil buy online

    sildenafil buy online

  68. womens viagra pill Says:

    womens viagra pill

    womens viagra pill

  69. viagra prices Says:

    viagra prices

    viagra prices

  70. walgreens viagra substitute Says:

    walgreens viagra substitute

    walgreens viagra substitute

  71. sildenafil price 20mg Says:

    sildenafil price 20mg

    sildenafil price 20mg

  72. sildenafil 100mg price Says:

    sildenafil 100mg price

    sildenafil 100mg price

  73. amlodipine besylate Says:

    amlodipine besylate

    amlodipine besylate

  74. black cialis c800 Says:

    black cialis c800

    black cialis c800

  75. levitra buy online Says:

    levitra buy online

    levitra buy online

  76. metformin dosage Says:

    metformin dosage

    metformin dosage

  77. cialis website Says:

    cialis website

    cialis website

  78. fish antibiotics amoxicillin Says:

    fish antibiotics amoxicillin

    fish antibiotics amoxicillin

  79. doxycycline 100mg tablet price Says:

    doxycycline 100mg tablet price

    doxycycline 100mg tablet price

  80. furosemide 40 mg tablet Says:

    furosemide 40 mg tablet

    furosemide 40 mg tablet

  81. xenical Says:
  82. dapoxetine tablets price Says:

    dapoxetine tablets price

    dapoxetine tablets price

  83. propecia cost nz Says:

    propecia cost nz

    propecia cost nz

  84. careprost buy online Says:

    careprost buy online

    careprost buy online

  85. pregnancy category for clomid Says:

    pregnancy category for clomid

    pregnancy category for clomid

  86. fluconazole 200 mg Says:

    fluconazole 200 mg

    fluconazole 200 mg

  87. domperidone galactagogue Says:

    domperidone galactagogue

    domperidone galactagogue

  88. tamoxifen citrate classification Says:

    tamoxifen citrate classification

    tamoxifen citrate classification

  89. prednisolone eye drops burn Says:

    prednisolone eye drops burn

    prednisolone eye drops burn

  90. naltrexone hcl 50mg tab Says:

    naltrexone hcl 50mg tab

    naltrexone hcl 50mg tab

  91. warnings for valacyclovir Says:

    warnings for valacyclovir

    warnings for valacyclovir

  92. zanaflex looks like Says:

    zanaflex looks like

    zanaflex looks like

  93. tadalafil 20mg pills Says:

    tadalafil 20mg pills

    tadalafil 20mg pills

  94. tadalafil gel Says:

    tadalafil gel

    tadalafil gel

  95. treating ciprofloxacin headache Says:

    treating ciprofloxacin headache

    treating ciprofloxacin headache

  96. cialis recommended dosage Says:

    cialis recommended dosage

    cialis recommended dosage

  97. cialis alternative Says:

    cialis alternative

    cialis alternative

  98. cialis 10mg sale Says:

    cialis 10mg sale

    cialis 10mg sale

  99. sildenafil uses Says:

    sildenafil uses

    sildenafil uses

  100. sildenafil 100mg uk Says:

    sildenafil 100mg uk

    sildenafil 100mg uk

  101. real viagra pills Says:

    real viagra pills

    real viagra pills

  102. generic viagra online canadian pharmacy Says:

    generic viagra online canadian pharmacy

    WALCOME

  103. sildenafil viagra Says:

    sildenafil viagra

    WALCOME

  104. viagrahati Says:

    viagrahati

    WALCOME

  105. viagra pill Says:

    viagra pill

    WALCOME

  106. order viagra online Says:

    order viagra online

    WALCOME

  107. where can i buy cialis pills Says:

    where can i buy cialis pills

    WALCOME

  108. cialis 24 hours Says:

    cialis 24 hours

    WALCOME

  109. cialis 5mg Says:

    cialis 5mg

    WALCOME

  110. cialis for sale Says:

    cialis for sale

    WALCOME

  111. viagra online prescription free Says:

    viagra online prescription free

    WALCOME

  112. buy viagra thailand Says:

    […] buy levitra 20 mg online […]

  113. viagra alternatives Says:

    viagra alternatives

    WALCOME

  114. viagra online cheap Says:

    viagra online cheap

    WALCOME

  115. where to buy cialis Says:

    where to buy cialis

    WALCOME

  116. buy viagra online legal Says:

    […] cheap viagra online uk […]

  117. generic viagra online Says:

    generic viagra online

    WALCOME

  118. viagra half pill Says:

    […] buy cialis uk […]

  119. how to buy generic viagra in canada Says:

    how to buy generic viagra in canada

    WALCOME

Leave a Reply

You must be logged in to post a comment.