eygle.com   eygle.com
eygle.com eygle

« Oracle Linux 操作系统及数据库的时区机制分析 | Blog首页 | Oracle ACOUG两周年交流活动记 »

Oracle SCN exhaustion BUG - CPU Jan 2012


这个BUG的BUG号是:13489660 - DB-
files eygle$ ls -R
lib    rdbms

libpls10.a    libserver10.a

pef.o    pei.o    pgmc.o

dmsvma.o    k2s.o        kjcs.o        kkxm.o        kpostr.o    ncodef.o    opiexe.o    qeroc.o        qmix.o
k2.o        kcm.o        kjcts.o        knl.o        ksms.o        npi.o        psdicd.o    qeroi.o        qmxtk.o
k2r.o        kcs.o        kjm.o        kpoal8.o    kspt.o        opial7.o    psdpgi.o    qerrm.o        qxim.o


kkxwtp.o    ksms.o        libknlopt.a


At the core of the issue is the System Change Number (SCN) in Oracle. This is a number that increments sequentially with every database commit: inserts, updates, and deletes. The SCN is also incremented through linked database interactions.

The SCN is crucial to normal Oracle database operation. The SCN "time stamp" is the key to maintaining data consistency in Oracle, allowing the database to respond to every user's query with the appropriate version of data at every point in time. It functions as the database's clock, so to speak. And like time, the SCN cannot decrement. It must always tick forward.

When Oracle databases link to each other, maintaining data consistency requires them to synchronize to a common SCN. This is necessarily the highest SCN carried by any participating Oracle database instance because the SCN clock cannot run backward -- so database linking causes the SCN in many databases to jump during normal operations. And only very basic permissions are required to make a connection that can cause one database to increment the SCN on another.

The architects of Oracle's flagship database application must have been well aware the SCN needed to be a massive integer. It is: a 48-bit number (281,474,976,710,656). It would take eons for an Oracle database to eclipse that number of transactions and cause problems -- or so you might think.


    >> 2011-03-22文章:
    >> 2006-03-22文章:
           Julia and Eygle
           索引 索引 还是索引
    >> 2005-03-22文章:

By eygle on 2012-03-22 08:15 | Comments (0) | Backup&Recovery | 2976 |

CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com