Oracle 里面如何实现只回滚某个事务的一部分内容

昨天凌晨被电话吵醒,某客户的一套11gR2 RAC出现异常，正常启动之后很快就crash掉，并伴随相关ora- […]

Tags: bbed, ora-00600, Smon, uba, undo chain, [ktubko_1]
Posted in backup & rcovery, oracle internal on 12月 27, 2013 | There are currently 1 Comment

datafile 也能跨resetlogs ？

我们都知道Oracle 10g引入了跨resetlogs特性，这个特性确实很棒。在10g之前，如果我们要进行跨 […]

Tags: bbed, checkpoint, datafile header, ORA-00283, ora-00600, ORA-01190, [krhpfh_03-1202]
Posted in backup & rcovery on 12月 13, 2013 | There are currently No Comments

ABout db file async I/O submit ?

前不见，某客户的系统遭遇性能问题，该环境redo量较大，高峰超过20m/s。业务应用程序在运行过程之中发现运 […]

Tags: db, db file async i/o submit, db file parallel write, db file sequential read
Posted in troubleshooting on 10月 28, 2013 | There are currently 1 Comment

15 TB 3节点RAC 的恢复记录

某客户的业务系统(15TB,3节点RAC) 由于abort关闭之后,导致数据库无法正常open. 在Open时 […]

Posted in backup & rcovery on 10月 24, 2013 | There are currently 3 Comments

10.2.0.4+版本的最新psu信息，供大家参考！(新增加12c psu信息)

如下是我整理的最新的10.2.0.4+版本的最新psu信息，供大家参考！(新增加12c psu信息)
++++10.2.0.4
Oracle Database Patch Set Update   Unix      Comments                 Includes Cpu 
10.2.0.4.1                         8576156   Bash 10.2.0.4.0          includes CPU Jul 2009
10.2.0.4.2                         8833280   Bash 10.2.0.4.0          includes CPU Oct 2009
10.2.0.4.3                         9119284   Bash 10.2.0.4.0          includes CPU Jan 2010
10.2.0.4.4                         9352164   Bash 10.2.0.4.0          includes CPU Apr 2010
10.2.0.4.5                         9654991   该psu必须基于10.2.0.4.4  includes CPU Jul 2010
10.2.0.4.6                         9952234   该psu必须基于10.2.0.4.4  includes CPU Oct 2010
10.2.0.4.7                         10248636  该psu必须基于10.2.0.4.4  includes CPU Jan 2011
10.2.0.4.8                         11724977  该psu必须基于10.2.0.4.4  includes CPU Apr 2011
10.2.0.4.9                         12419397  该psu必须基于10.2.0.4.4  includes CPU Jul 2011
10.2.0.4.10                        12827778  该psu必须基于10.2.0.4.4  includes CPU Oct 2011
10.2.0.4.11                        12879929  该psu必须基于10.2.0.4.4  includes CPU Jan 2012
10.2.0.4.12                        12879933  该psu必须基于10.2.0.4.4  includes CPU Apr 2012
10.2.0.4.13                        13923851  该psu必须基于10.2.0.4.4  includes CPU Jul 2012
10.2.0.4.14                        14275630  该psu必须基于10.2.0.4.4  includes CPU Oct 2012
10.2.0.4.15                        14736542  该psu必须基于10.2.0.4.4  includes CPU Jan 2013
10.2.0.4.16                        16056269  该psu必须基于10.2.0.4.4  includes CPU Apr 2013
10.2.0.4.17                        16619897  该psu必须基于10.2.0.4.4  includes CPU Jul 2013
+++++10.2.0.5
Oracle Database Patch Set Update   Unix       Comments                Includes Cpu 
10.2.0.5.1                         9952230    Bash 10.2.0.5.0         includes CPU Oct 2010
10.2.0.5.2                         10248542   Bash 10.2.0.5.0         includes CPU Jan 2011
10.2.0.5.3                         11724962   Bash 10.2.0.5.0         includes CPU Apr 2011
10.2.0.5.4                         12419392   Bash 10.2.0.5.0         includes CPU Jul 2011
10.2.0.5.5                         12827745   Bash 10.2.0.5.0         Includes CPU Oct 2011
10.2.0.5.6                         13343471   Bash 10.2.0.5.0         includes CPU Jan 2012
10.2.0.5.7                         13632743   Bash 10.2.0.5.0         includes CPU Apr 2012
10.2.0.5.8                         13923855   Bash 10.2.0.5.0         includes CPU Jul 2012
10.2.0.5.9                         14275629   Bash 10.2.0.5.0         includes CPU Oct 2012
10.2.0.5.10                        14727319   Bash 10.2.0.5.0         includes CPU Jan 2013
10.2.0.5.11                        16056270   Bash 10.2.0.5.0         includes CPU Apr 2013 
10.2.0.5.12                        16619894   Bash 10.2.0.5.0         includes CPU Jul 2013 
+++++11.1.0.7
Oracle Database Patch Set Update   Database   CRS                   Comments          Includes Cpu 
11.1.0.7.1                         8833297    bug: 8287931          Bash 11.1.0.7.0   includes CPU Oct 2009
11.1.0.7.2                         9209238    bug: 9207257          Bash 11.1.0.7.0   includes CPU Jan 2010
11.1.0.7.3                         9352179                          Bash 11.1.0.7.0   includes CPU Apr 2010
11.1.0.7.4                         9654987    bug: 9294495          Bash 11.1.0.7.0   includes CPU Jul 2010
11.1.0.7.5                         9952228    bug: 9952240          Bash 11.1.0.7.0   includes CPU Oct 2010
11.1.0.7.6                         10248531   bug: 10248535         Bash 11.1.0.7.0   includes CPU Jan 2011
11.1.0.7.7                         11724936   11724953              Bash 11.1.0.7.0   includes CPU Apr 2011
11.1.0.7.8                         12419384   11724953              Bash 11.1.0.7.0   includes CPU Jul 2011
11.1.0.7.9                         12827740   11724953              Bash 11.1.0.7.0   includes CPU Oct 2011
11.1.0.7.10                        13343461   11724953              Bash 11.1.0.7.0   includes CPU Jan 2012
11.1.0.7.11                        13621679   11724953              Bash 11.1.0.7.0   includes CPU Apr 2012
11.1.0.7.12                        13923474   11724953              Bash 11.1.0.7.0   includes CPU Jul 2012
11.1.0.7.13                        14275623   11724953              Bash 11.1.0.7.0   includes CPU Oct 2012
11.1.0.7.14                        14739378   11724953              Bash 11.1.0.7.0   includes CPU Jan 2013
11.1.0.7.15                        16056268   11724953              Bash 11.1.0.7.0   includes CPU Apr 2013
11.1.0.7.16                        16619896   11724953              Bash 11.1.0.7.0   includes CPU Jul 2013
11.1.0.7.17                        17082366   11724953              Bash 11.1.0.7.0   includes CPU Oct 2013
++++++11.2.0.1
Oracle Database Patch Set Update   Database   Grid Infrastructure   Comments          Includes Cpu 
11.2.0.1.1                         9352237    9343627               Bash 11.2.0.1.0   includes CPU Apr 2010
11.2.0.1.2                         9654983    9343627               Bash 11.2.0.1.0   includes CPU Jul 2010
11.2.0.1.3                         9952216    9655006               Bash 11.2.0.1.0   includes CPU Oct 2010
11.2.0.1.4                         10248516   9655006               Bash 11.2.0.1.0   includes CPU Jan 2011
11.2.0.1.5                         11724930   9655006               Bash 11.2.0.1.0   includes CPU Apr 2011
11.2.0.1.6                         12419378   9655006               Bash 11.2.0.1.0   includes CPU Apr 2011
+++++++11.2.0.2
OracleDatabase PatchSet Update   Database   Grid Infrastructure   Comments          Includes  Cpu
11.2.0.2.1                       10248523   Bundle1 10157506      Bash 11.2.0.2.0   no CPU fixes
11.2.0.2.2                       11724916   Bundle2 10425672      Bash 11.2.0.2.0   includes CPU Apr 2011
PSU2 12311357
11.2.0.2.3                       12419331   12419353              Bash 11.2.0.2.0   includes CPU Jul 2011
11.2.0.2.4                       12827726   12827731              Bash 11.2.0.2.0   includes CPU Oct 2011
11.2.0.2.5                       13343424   13343447              Bash 11.2.0.2.0   includes CPU Jan 2012
11.2.0.2.6                       13696224   13696242              Bash 11.2.0.2.0   includes CPU Apr 2012
11.2.0.2.7                       13923804   14192201              Bash 11.2.0.2.0   includes CPU Jul 2012
11.2.0.2.8                       14275621   14390437              Bash 11.2.0.2.0   includes CPU Oct 2012
11.2.0.2.9                       14727315   14390437              Bash 11.2.0.2.0   includes CPU Jan 2013
11.2.0.2.10                      16056267   16166868              Bash 11.2.0.2.0   includes CPU Apr 2013
11.2.0.2.11                      16619893   16742320              Bash 11.2.0.2.0   includes CPU Jul 2013
11.2.0.2.12                      17082367   17272753              Bash 11.2.0.2.0   includes CPU Oct 2013
+++++++11.2.0.3
OracleDatabase PatchSet Update   Database   Grid Infrastructure   Comments           Includes  Cpu
11.2.0.3.0                       10404530   (包含在10404530中)
11.2.0.3.1                       13343438   13348650             Bash 11.2.0.3.0     includes CPU Jan 2012
11.2.0.3.2                       13696216   13696251             Bash 11.2.0.3.0     includes CPU Apr 2012
11.2.0.3.3                       13923374   13919095             Bash 11.2.0.3.0     includes CPU Jul 2012
11.2.0.3.4                       14275605   14275572             Bash 11.2.0.3.0     includes CPU Oct 2012
11.2.0.3.5                       14727310   14727347             Bash 11.2.0.3.0     includes CPU Jan 2013
11.2.0.3.6                       16056266   16083653             Bash 11.2.0.3.0     includes CPU Apr 2013
11.2.0.3.7                       16619892   16742216             Bash 11.2.0.3.0     includes CPU Jul 2013
11.2.0.3.8                       16902043   17272731             Bash 11.2.0.3.0     includes CPU Oct 2013
+++++++11.2.0.4
OracleDatabase PatchSet Update   Database   Grid Infrastructure   Comments           Includes  Cpu
11.2.0.4.0                       13390677   13390677 
+++++++12.1.0.1
OracleDatabase PatchSet Update   Database   Grid Infrastructure   Comments           Includes  Cpu
12.1.0.1.1                       17027533   17272829             Bash 12.1.0.1.0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

如下是我整理的最新的10.2.0.4+版本的最新psu信息，供大家参考！(新增加12c psu信息)

++++10.2.0.4

Oracle Database Patch Set Update Unix Comments Includes Cpu

10.2.0.4.1 8576156 Bash 10.2.0.4.0 includes CPU Jul 2009

10.2.0.4.2 8833280 Bash 10.2.0.4.0 includes CPU Oct 2009

10.2.0.4.3 9119284 Bash 10.2.0.4.0 includes CPU Jan 2010

10.2.0.4.4 9352164 Bash 10.2.0.4.0 includes CPU Apr 2010

10.2.0.4.5 9654991 该psu必须基于10.2.0.4.4 includes CPU Jul 2010

10.2.0.4.6 9952234 该psu必须基于10.2.0.4.4 includes CPU Oct 2010

10.2.0.4.7 10248636 该psu必须基于10.2.0.4.4 includes CPU Jan 2011

10.2.0.4.8 11724977 该psu必须基于10.2.0.4.4 includes CPU Apr 2011

10.2.0.4.9 12419397 该psu必须基于10.2.0.4.4 includes CPU Jul 2011

10.2.0.4.10 12827778 该psu必须基于10.2.0.4.4 includes CPU Oct 2011

10.2.0.4.11 12879929 该psu必须基于10.2.0.4.4 includes CPU Jan 2012

10.2.0.4.12 12879933 该psu必须基于10.2.0.4.4 includes CPU Apr 2012

10.2.0.4.13 13923851 该psu必须基于10.2.0.4.4 includes CPU Jul 2012

10.2.0.4.14 14275630 该psu必须基于10.2.0.4.4 includes CPU Oct 2012

10.2.0.4.15 14736542 该psu必须基于10.2.0.4.4 includes CPU Jan 2013

10.2.0.4.16 16056269 该psu必须基于10.2.0.4.4 includes CPU Apr 2013

10.2.0.4.17 16619897 该psu必须基于10.2.0.4.4 includes CPU Jul 2013

+++++10.2.0.5

Oracle Database Patch Set Update Unix Comments Includes Cpu

10.2.0.5.1 9952230 Bash 10.2.0.5.0 includes CPU Oct 2010

10.2.0.5.2 10248542 Bash 10.2.0.5.0 includes CPU Jan 2011

10.2.0.5.3 11724962 Bash 10.2.0.5.0 includes CPU Apr 2011

10.2.0.5.4 12419392 Bash 10.2.0.5.0 includes CPU Jul 2011

10.2.0.5.5 12827745 Bash 10.2.0.5.0 Includes CPU Oct 2011

10.2.0.5.6 13343471 Bash 10.2.0.5.0 includes CPU Jan 2012

10.2.0.5.7 13632743 Bash 10.2.0.5.0 includes CPU Apr 2012

10.2.0.5.8 13923855 Bash 10.2.0.5.0 includes CPU Jul 2012

10.2.0.5.9 14275629 Bash 10.2.0.5.0 includes CPU Oct 2012

10.2.0.5.10 14727319 Bash 10.2.0.5.0 includes CPU Jan 2013

10.2.0.5.11 16056270 Bash 10.2.0.5.0 includes CPU Apr 2013

10.2.0.5.12 16619894 Bash 10.2.0.5.0 includes CPU Jul 2013

+++++11.1.0.7

Oracle Database Patch Set Update Database CRS Comments Includes Cpu

11.1.0.7.1 8833297 bug: 8287931 Bash 11.1.0.7.0 includes CPU Oct 2009

11.1.0.7.2 9209238 bug: 9207257 Bash 11.1.0.7.0 includes CPU Jan 2010

11.1.0.7.3 9352179 Bash 11.1.0.7.0 includes CPU Apr 2010

11.1.0.7.4 9654987 bug: 9294495 Bash 11.1.0.7.0 includes CPU Jul 2010

11.1.0.7.5 9952228 bug: 9952240 Bash 11.1.0.7.0 includes CPU Oct 2010

11.1.0.7.6 10248531 bug: 10248535 Bash 11.1.0.7.0 includes CPU Jan 2011

11.1.0.7.7 11724936 11724953 Bash 11.1.0.7.0 includes CPU Apr 2011

11.1.0.7.8 12419384 11724953 Bash 11.1.0.7.0 includes CPU Jul 2011

11.1.0.7.9 12827740 11724953 Bash 11.1.0.7.0 includes CPU Oct 2011

11.1.0.7.10 13343461 11724953 Bash 11.1.0.7.0 includes CPU Jan 2012

11.1.0.7.11 13621679 11724953 Bash 11.1.0.7.0 includes CPU Apr 2012

11.1.0.7.12 13923474 11724953 Bash 11.1.0.7.0 includes CPU Jul 2012

11.1.0.7.13 14275623 11724953 Bash 11.1.0.7.0 includes CPU Oct 2012

11.1.0.7.14 14739378 11724953 Bash 11.1.0.7.0 includes CPU Jan 2013

11.1.0.7.15 16056268 11724953 Bash 11.1.0.7.0 includes CPU Apr 2013

11.1.0.7.16 16619896 11724953 Bash 11.1.0.7.0 includes CPU Jul 2013

11.1.0.7.17 17082366 11724953 Bash 11.1.0.7.0 includes CPU Oct 2013

++++++11.2.0.1

Oracle Database Patch Set Update Database Grid Infrastructure Comments Includes Cpu

11.2.0.1.1 9352237 9343627 Bash 11.2.0.1.0 includes CPU Apr 2010

11.2.0.1.2 9654983 9343627 Bash 11.2.0.1.0 includes CPU Jul 2010

11.2.0.1.3 9952216 9655006 Bash 11.2.0.1.0 includes CPU Oct 2010

11.2.0.1.4 10248516 9655006 Bash 11.2.0.1.0 includes CPU Jan 2011

11.2.0.1.5 11724930 9655006 Bash 11.2.0.1.0 includes CPU Apr 2011

11.2.0.1.6 12419378 9655006 Bash 11.2.0.1.0 includes CPU Apr 2011

+++++++11.2.0.2

OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu

11.2.0.2.1 10248523 Bundle1 10157506 Bash 11.2.0.2.0 no CPU fixes

11.2.0.2.2 11724916 Bundle2 10425672 Bash 11.2.0.2.0 includes CPU Apr 2011

PSU2 12311357

11.2.0.2.3 12419331 12419353 Bash 11.2.0.2.0 includes CPU Jul 2011

11.2.0.2.4 12827726 12827731 Bash 11.2.0.2.0 includes CPU Oct 2011

11.2.0.2.5 13343424 13343447 Bash 11.2.0.2.0 includes CPU Jan 2012

11.2.0.2.6 13696224 13696242 Bash 11.2.0.2.0 includes CPU Apr 2012

11.2.0.2.7 13923804 14192201 Bash 11.2.0.2.0 includes CPU Jul 2012

11.2.0.2.8 14275621 14390437 Bash 11.2.0.2.0 includes CPU Oct 2012

11.2.0.2.9 14727315 14390437 Bash 11.2.0.2.0 includes CPU Jan 2013

11.2.0.2.10 16056267 16166868 Bash 11.2.0.2.0 includes CPU Apr 2013

11.2.0.2.11 16619893 16742320 Bash 11.2.0.2.0 includes CPU Jul 2013

11.2.0.2.12 17082367 17272753 Bash 11.2.0.2.0 includes CPU Oct 2013

+++++++11.2.0.3

OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu

11.2.0.3.0 10404530 (包含在10404530中)

11.2.0.3.1 13343438 13348650 Bash 11.2.0.3.0 includes CPU Jan 2012

11.2.0.3.2 13696216 13696251 Bash 11.2.0.3.0 includes CPU Apr 2012

11.2.0.3.3 13923374 13919095 Bash 11.2.0.3.0 includes CPU Jul 2012

11.2.0.3.4 14275605 14275572 Bash 11.2.0.3.0 includes CPU Oct 2012

11.2.0.3.5 14727310 14727347 Bash 11.2.0.3.0 includes CPU Jan 2013

11.2.0.3.6 16056266 16083653 Bash 11.2.0.3.0 includes CPU Apr 2013

11.2.0.3.7 16619892 16742216 Bash 11.2.0.3.0 includes CPU Jul 2013

11.2.0.3.8 16902043 17272731 Bash 11.2.0.3.0 includes CPU Oct 2013

+++++++11.2.0.4

OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu

11.2.0.4.0 13390677 13390677

+++++++12.1.0.1

OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu

12.1.0.1.1 17027533 17272829 Bash 12.1.0.1.0

Tags: 10.2.0.4.17, 10.2.0.5.12, 11.2.0.2.12, 11.2.0.3.8, 12.1.0.1.1, Oracle 最新psu
Posted in mangement, Oracle rdbms on 10月 17, 2013 | There are currently 2 Comments

oracle 12c 中asm元数据是否有所变化

oracle 12c 已经发布了几个月了，最近太忙，一直没时间研究12c，今天抽空研究一下12c 中asm的元 […]

Tags: alias directory, amdu, file directory, oracle 12c, x$kffxp
Posted in ASM on 9月 2, 2013 | There are currently 1 Comment

Rac 实例被莫名重启案例分析

某客户的一套rac，其中node1 被莫名的重启了，如下：

1	某客户的一套rac，其中node1 被莫名的重启了，如下：

[crayon-66838e8a98b322 […]

Tags: aix rac, IPC Send timeout, lms, ORA-29740
Posted in troubleshooting on 8月 31, 2013 | There are currently 3 Comments

asm rebalance 原理

上周6,某客户进行存储扩容(11gR2 rac asm),扩容完成之后,我们需要将新划的lun加到现有的asm […]

Tags: 11.2.0.2, asm rebalance, asm_power_limit
Posted in ASM on 8月 5, 2013 | There are currently 2 Comments

One case:Latch free of oracle 9208 ?

最近某客户9208环境,遭遇latch free问题,而在oracle 9i版本中,latch free 只是 […]

Tags: 9208, latch free, rollback_segment_count, row cache objects
Posted in troubleshooting on 7月 14, 2013 | There are currently No Comments

oracle 12c 学习系列(1)–12c初体验

oracle 12c发布已经有几天了,最近一直比较忙,没时间研究,趁周末在家玩玩,熟悉下12c的新特性. 其中 […]

Tags: 10046 event, move datafile, oracle 12c, strace
Posted in oracle database 12c on 7月 7, 2013 | There are currently 4 Comments

about flashback_transaction_query

前几天某大师提醒我说了，我以前一篇文档flashback_transaction_query 查询慢的问题有 […]

Tags: bbed, FLASHBACK_TRANSACTION_QUERY, itl
Posted in mangement on 7月 1, 2013 | There are currently 1 Comment

intra blcok chain

最近在一个优化项目中，通过awr报告发现table fetch continued row 指标很高,怀疑是行 […]

Tags: dbms_rowid, intra block chaining, table fetch continued row, 行迁移
Posted in mangement on 6月 19, 2013 | There are currently 6 Comments

10g 中DEPENDENCY$被move 数据库无法open

51放假期间，同事问我一个问题，那就是dependency$被move后，数据库起不来了，虽然是测试环境。他 […]

Tags: 10.2, 11.2, bbed, DEPENDENCY$, ora-00600 [kkdlusr1], ORA-00604, ORA-00704, ORA-01502
Posted in oracle internal on 5月 3, 2013 | There are currently 5 Comments

about subquery unnest/push pred

落落的sql优化班级确实牛叉，我也试听了1次，学不到不少东西，如果大家有兴趣，可以加他的试听QQ群：17922 […]

Tags: push_pred no_push_pred unnest subquery
Posted in tunning on 4月 28, 2013 | There are currently 1 Comment

10.2.0.4+版本PSU以及相关bundle patch列表-（2013/4/18 update)

如下是我整理的最新的10.2.0.4+版本的最新psu信息，供大家参考！ [crayon-66838e8ab5 […]

Tags: 10gR2 11gR new psu
Posted in mangement on 4月 18, 2013 | There are currently 3 Comments

About Compress Tables and structure

昨天朋友问到压缩表的细节问题，我准备用实验来解释，最近很久也没写博客了，就正好完善一下，贴出来。首先我们来看 […]

Tags: basic compression, compress table, oltp compression
Posted in mangement on 3月 24, 2013 | There are currently No Comments

normal diskgroup情况下的IO读取

前段时间，在ML的群中，原厂一个哥们发了图，图中提到oracle 12c之前，asm 的读取默认都是始终从pr […]

Tags: asm remap 11gR2
Posted in ASM on 3月 14, 2013 | There are currently No Comments

详解段头block和位图block每个offset的含义(非完整版)

前几天跟lunar讨论问题，他提到关于数据库中段头block损坏的恢复以及假如出现位图block损坏等的情况恢 […]

Tags: bbed, bitmap block, segment header
Posted in oracle internal on 2月 28, 2013 | There are currently 5 Comments

oracle asm剖析系列(9)–ASM Dynamic Volume Manager (ADVM)

从oracle 11gR2开始，引入了ACFS，其中11gR2同时又引入了ASM Dynamic Volume […]

Tags: 11gR2, acfs, advm, kfed
Posted in ASM on 2月 23, 2013 | There are currently 1 Comment

oracle asm剖析系列(8)–Continuing Operations Directory

在asm系列的上一篇文章中，我们描述了ACD，将其比喻成oracle database中的redo，如果说起作 […]

Tags: ACD, asm 10gR2, COD, disk header, kfed, x$kffxp
Posted in ASM on 2月 2, 2013 | There are currently No Comments

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

Categories

Archives

最新评论

国内圈子

oracle security

Oracle 里面如何实现只回滚某个事务的一部分内容

datafile 也能跨resetlogs ？

ABout db file async I/O submit ?

15 TB 3节点RAC 的恢复记录

10.2.0.4+版本的最新psu信息，供大家参考！(新增加12c psu信息)

oracle 12c 中asm元数据是否有所变化

Rac 实例被莫名重启案例分析

asm rebalance 原理

One case:Latch free of oracle 9208 ?

oracle 12c 学习系列(1)–12c初体验

about flashback_transaction_query

intra blcok chain

10g 中DEPENDENCY$被move 数据库无法open

about subquery unnest/push pred

10.2.0.4+版本PSU以及相关bundle patch列表-（2013/4/18 update)

About Compress Tables and structure

normal diskgroup情况下的IO读取

详解段头block和位图block每个offset的含义(非完整版)

oracle asm剖析系列(9)–ASM Dynamic Volume Manager (ADVM)

oracle asm剖析系列(8)–Continuing Operations Directory