AUM \u5e38\u7528\u5206\u6790\/\u8bca\u65ad\u811a\u672c (\u6587\u6863 ID 1526122.1)<\/p>\n

Oracle Database – Enterprise Edition – \u7248\u672c 10.1.0.5 \u5230 11.1.0.6 [\u53d1\u884c\u7248 10.1 \u5230 11.1]<\/p>\n

\u672c\u6587\u6863\u6240\u542b\u4fe1\u606f\u9002\u7528\u4e8e\u6240\u6709\u5e73\u53f0<\/p>\n

\u7528\u9014<\/p>\n

\u672c\u6587\u65e8\u5728\u89c4\u8303\u5bf9\u7528\u4ee5\u8bca\u65ad\u548c\u5206\u6790 ORA-1555 \u9519\u8bef\u7684\u811a\u672c\u7684\u4f7f\u7528\u3002\u672c\u6587\u9002\u7528\u4e8e\u6240\u6709\u6570\u636e\u5e93\u7ba1\u7406\u5458\u53ca Oracle Support \u5206\u6790\u4eba\u5458\u3002<\/p>\n

\u8981\u6c42<\/p>\n

\u4ee5\u4e0b\u811a\u672c\u53ef\u5728 SQL*Plus \u6216 iSQL*Plus \u4e2d\u8fd0\u884c\u3002\u5f88\u591a\u811a\u672c\u90fd\u8981\u6c42\u62e5\u6709\u6570\u636e\u5e93\u7684 DBA \u6743\u9650\u3002<\/p>\n

\u5355\u51fb \u6b64\u5904 [\u4fee\u8ba2\u65f6\u95f4\uff1a2011 \u5e74 5 \u6708 12 \u65e5] \u4e0b\u8f7d\u672c\u6587\u4e2d\u8ba8\u8bba\u7684\u811a\u672c\u3002<\/p>\n

\u914d\u7f6e<\/p>\n

\u67e5\u770b\u6bcf\u4e2a\u811a\u672c\u7684\u5907\u6ce8\u4ee5\u5224\u5b9a\u5bf9\u4e8e\u7279\u5b9a\u914d\u7f6e\/\u5e94\u7528\u7a0b\u5e8f\u73af\u5883\u662f\u5426\u63d0\u793a\u6709\u6240\u66f4\u6539\u3002<\/p>\n

\u8bf4\u660e<\/p>\n

\u5bf9\u4e8e\u4ee5\u4e0b\u811a\u672c\uff0c\u9700\u8981\u4f7f\u7528\u80fd\u591f\u8bbf\u95ee DBA* \u548c V$ \u8868\u7684\u6570\u636e\u5e93\u7ba1\u7406\u7528\u6237\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u8fd9\u4e9b\u811a\u672c\u767b\u5f55\u5f62\u5f0f\u4e3a\uff1a<\/p>\n

$ sqlplus \/nolog<\/p>\n

connect \/ as sysdba<\/p>\n

\u8fd9\u4e9b\u811a\u672c\u5e94\u8be5\u4e0d\u4f1a\u5f71\u54cd\u6570\u636e\u5e93\u6027\u80fd\uff0c\u53ef\u4ee5\u591a\u6b21\u8fd0\u884c\u3002<\/p>\n

\u8b66\u544a<\/p>\n

\u6b64\u793a\u4f8b\u4ee3\u7801\u53ea\u4e3a\u6559\u80b2\u76ee\u7684\uff0cOracle Support\u4e0d\u63d0\u4f9b\u6280\u672f\u652f\u6301\u3002\u5b83\u5df2\u7ecf\u8fc7\u5185\u90e8\u6d4b\u8bd5\uff0c\u7136\u800c\u6211\u4eec\u65e0\u6cd5\u786e\u4fdd\u5b83\u5728\u4efb\u4f55\u73af\u5883\u4e2d\u90fd\u80fd\u6210\u529f\u4f7f\u7528\u3002\u8bf7\u60a8\u5728\u4f7f\u7528\u4e4b\u524d\u5148\u5728\u6d4b\u8bd5\u73af\u5883\u4e2d\u8fd0\u884c\u3002<\/p>\n

\u793a\u4f8b\u4ee3\u7801<\/p>\n

Oracle \u53d1\u5e03\u7684\u7528\u4e8e\u8c03\u67e5 ORA-1555 \u9519\u8bef\u7684\u811a\u672c\u6bcf\u4e00\u7248\u672c\u90fd\u6709\u6240\u4e0d\u540c\u3002\u8fd9\u4e9b\u811a\u672c\u53ea\u9002\u7528\u4e8e\u81ea\u52a8 UNDO \u7ba1\u7406 (AUM) \u914d\u7f6e\u7684\u73af\u5883\u3002<\/p>\n

\u811a\u672c\u6587\u4ef6\u4ee5\u672c\u6587\u6863\u9644\u4ef6\u7684\u5f62\u5f0f\u63d0\u4f9b\u3002\u6ce8\u610f\uff1a\u5728\u672c\u6587\u6863\u4e2d\u6267\u884c\u526a\u5207\u7c98\u8d34\u64cd\u4f5c\u65f6\uff0c\u8fd9\u4e9b\u811a\u672c\u53ef\u80fd\u51fa\u73b0\u683c\u5f0f\u95ee\u9898\u3002\u56e0\u6b64\uff0c\u811a\u672c\u90fd\u9644\u5728\u6587\u6863\u4e2d\uff0c\u53ef\u4e0b\u8f7d\u4f7f\u7528\u3002\u672c\u6587\u5c06\u8ba8\u8bba\u6bcf\u4e2a\u811a\u672c\u7684\u4f18\u52bf\/\u4f5c\u7528\uff0c\u5e76\u63d0\u4f9b\u793a\u4f8b\u8f93\u51fa\u3002<\/p>\n

AUM \u914d\u7f6e\u548c ORA-1555 \u5168\u9762\u5206\u6790<\/p>\n

\u914d\u7f6e\uff1a<\/li>\n<\/ol>\n
UndoDatafiles.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684\u6587\u4ef6 undodatafiles.out \u4e2d\u3002<\/p>\n
UndoParameters.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684\u6587\u4ef6 undoparameters.out \u4e2d\u3002<\/p>\n
UndoUsage.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684\u6587\u4ef6 undousage.out \u4e2d\u3002<\/p>\n
1. \u5f53\u524d\u672a\u63d0\u4ea4\u7684\u4e8b\u52a1\uff1a<\/li>\n<\/ol>\n
  CurrentActivity.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684\u6587\u4ef6 undoactivity.out \u4e2d\u3002<\/p>\n
  1. \u5386\u53f2 UNDO \u4fe1\u606f\uff1a<\/li>\n<\/ol>\n
    UndoHistoryInfo.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684 undohistory.out \u4e2d\u3002<\/p>\n
    UndoStatistics.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684 undostatistics.out \u4e2d\u3002\u60a8\u53ef\u4fee\u6539\u6b64\u62a5\u544a\u4ee5\u663e\u793a\u9002\u5f53\u7684\u5206\u6790\u65f6\u95f4\u8303\u56f4\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u67e5\u770b\u6700\u540e\u4e24\u5929\u7684 V$UNDOSTAT \u6570\u636e\u3002\u5728 V$UNDOSTAT \u89c6\u56fe\u4e2d\uff0c\u6570\u636e\u4f1a\u4fdd\u7559\u4e03\u5929\u3002<\/p>\n
    1. \u7b49\u5f85\/\u9501\u5b9a\u5206\u6790\uff1a<\/li>\n<\/ol>\n
      UndoPressure.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684 undopressure.out \u4e2d\u3002<\/p>\n
      1. \u8c03\u67e5 LOB \u95ee\u9898\uff1a<\/li>\n<\/ol>\n
        LobData.sql — spool \u8f93\u51fa\u5230\u4f4d\u4e8e\u9ed8\u8ba4\u76ee\u5f55\u4f4d\u7f6e\u7684 lobdata.out \u4e2d\u3002<\/p>\n
        \u793a\u4f8b\u8f93\u51fa<\/p>\n
        \n
        \u914d\u7f6e<\/li>\n<\/ol>\n
        \u793a\u4f8b undodatafiles.out<\/p>\n
        ############## RUNTIME ##############<\/p>\n
        Run Time<\/p>\n
        —————–<\/p>\n
        05-Aug-2009 08:53<\/p>\n
        ############## DATAFILES ##############<\/p>\n
        Aut<\/p>\n
        TBSP Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 File #\u00a0\u00a0 Bytes Alloc (MB) Max Bytes Used (MB) (MB)\u00a0\u00a0\u00a0\u00a0 Ext<\/p>\n
        —————————— —— ————————- ———————————— ——<\/p>\n
        SMALLUNDO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 200\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 200\u00a0\u00a0\u00a0\u00a0 YES<\/p>\n
        \u67e5\u770b\u914d\u7f6e\u6570\u636e\u3002AUTOEXTEND \u662f\u5426\u6253\u5f00\uff1f\u5982\u679c UNDO \u8868\u7a7a\u95f4\u914d\u7f6e\u4e3a\u968f\u7740\u7a7a\u95f4\u9700\u6c42\u81ea\u52a8\u589e\u957f\uff0c\u8fd9\u4f1a\u5bf9\u6570\u636e\u5e93\u9020\u6210\u5f71\u54cd\uff0c\u6570\u636e\u5e93\u53ef\u80fd\u4e0d\u4f1a\u91cd\u65b0\u4f7f\u7528\u8d85\u8fc7Retention\u8bbe\u7f6e\u7684\u8fc7\u671f Undo extent\uff0c\u4ee5\u51cf\u5c11\u53d1\u751f ORA-1555 \u7684\u51e0\u7387\u3002\u8868\u7a7a\u95f4\u8fdb\u800c\u4f1a\u968f\u7740\u65b0\u7684\u9700\u6c42\u589e\u957f\u3002<\/p>\n
        \u793a\u4f8b undoparameters.out<\/p>\n
        ############## RUNTIME ##############Run Time<\/p>\n
        —————–<\/p>\n
        05-Aug-2009 08:56<\/p>\n
        ############## PARAMETERS ##############<\/p>\n
        Instance #\u00a0 Parameter\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Session Value\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Instance Value<\/p>\n
        ————– ———————————– ————————- ————————-<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _smu_debug_mode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 33554432\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 33554432<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 _undo_autotune\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TRUE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TRUE<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 undo_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AUTO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AUTO<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 undo_retention\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0900\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 undo_tablespace\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SMALLUNDO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SMALLUNDO<\/p>\n
        \u67e5\u770b\u5f71\u54cd Undo Retention\u89c4\u5219\u7684\u53c2\u6570\u8bbe\u7f6e\u3002<\/p>\n
        ‘_smu_debug_mode’=33554432 \u4f1a\u5f3a\u5236\u8ba9\u81ea\u52a8\u4f18\u5316\u7a0b\u5e8f\u57fa\u4e8e\u7cfb\u7edf\u4e2d\u8fd0\u884c\u65f6\u95f4\u6700\u957f\u7684 SQL \u7684\u6267\u884c\u65f6\u95f4\u6765\u8ba1\u7b97\u81ea\u52a8\u7684 undo retention\u3002\u5728\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u81ea\u52a8\u8c03\u6574\u540e\u7684\u4fdd\u7559\u65f6\u95f4\u4f1a\u589e\u957f\u5230\u5f88\u957f\u7684\u65f6\u95f4\u6bb5\uff0c\u7a7a\u95f4\u538b\u529b\u5c06\u6210\u4e3a Undo \u8868\u7a7a\u95f4\u4e2d\u7684\u91cd\u5927\u95ee\u9898\u3002<\/p>\n
        ‘_undo_autotune’=false \u662f\u4e00\u4e9b AUM bug \u7684\u6743\u5b9c\u65b9\u6cd5\uff0c\u4f46\u8fd9\u4f1a\u5bf9\u5206\u6790\u4ea7\u751f\u91cd\u5927\u5f71\u54cd\u3002V$UNDOSTAT \u4e2d\u4e0d\u4f1a\u518d\u8fdb\u4e00\u6b65\u8ddf\u8e2a\u5176\u4ed6\u6570\u636e\uff0c\u663e\u5f0f\u6307\u5b9a\u7684\u7684 UNDO_RETENTION \u8bbe\u7f6e\u662f\u5f71\u54cd undo Retention\u5904\u7406\u7684\u5173\u952e\u3002<\/p>\n
        \u793a\u4f8b undousage.out<\/p>\n
        ############## RUNTIME ##############<\/p>\n
        Run Time<\/p>\n
        ————————–<\/p>\n
        05-Aug-2009 08:58<\/p>\n
        ############## IN USE Undo Data ##############<\/p>\n
        PCT_INUSE<\/p>\n
        —————-<\/p>\n
        23.625<\/p>\n
        TABLESPACE_NAME\u00a0\u00a0\u00a0 EXTENT_MAN\u00a0\u00a0\u00a0 ALLOCATIO\u00a0\u00a0\u00a0\u00a0\u00a0 SEGMEN\u00a0\u00a0\u00a0\u00a0\u00a0 RETENTION<\/p>\n
        ——————————— ———————— ———————- —————- —————–<\/p>\n
        SMALLUNDO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LOCAL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MANUAL\u00a0\u00a0\u00a0 NOGUARANTEE<\/p>\n
        Sum of Free<\/p>\n
        —————-<\/p>\n
        65,536<\/p>\n
        Total Bytes<\/p>\n
        —————-<\/p>\n
        209,715,200<\/p>\n
        ############## UNDO SEGMENTS ##############<\/p>\n
        Status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Total Extents<\/p>\n
        —————— —————–<\/p>\n
        UNEXPIRED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 21<\/p>\n
        EXPIRED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 807<\/p>\n
        ACTIVE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 195<\/p>\n
        ————-<\/p>\n
        sum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01,023<\/p>\n
        <\/p>\n
        Status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Total Segments<\/p>\n
        ——————– ——————-<\/p>\n
        ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11<\/p>\n
        ————-<\/p>\n
        sum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11<\/p>\n
        \n
        \u5f53\u524d\u672a\u63d0\u4ea4\u7684\u4e8b\u52a1<\/li>\n<\/ol>\n
        \u793a\u4f8b undoactivity.out<\/p>\n
        ############## RUNTIME ##############<\/p>\n
        Run Time<\/p>\n
        —————–<\/p>\n
        19-Aug-2009 09:43<\/p>\n
        ############## Current Uncommitted Transactions ##############<\/p>\n
        Started\u00a0\u00a0\u00a0 User\u00a0\u00a0\u00a0\u00a0 Undo Segment Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 File #\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Block #\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 KBytes\u00a0\u00a0\u00a0 \u00a0Rows<\/p>\n
        ———— ——— ————————————- ———— ————– ————– ————- ———-<\/p>\n
        08\/19\/09 KEN\u00a0\u00a0\u00a0\u00a0\u00a0 _SYSSMU8_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9735\u00a0\u00a0\u00a0\u00a0 ACTIVE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 48,664\u00a0\u00a0 614,178<\/p>\n
        09:43:02<\/p>\n
        \u67e5\u770b\u672a\u63d0\u4ea4\u7684\u4e8b\u52a1\u3002\u8be5\u4e8b\u52a1\u6709\u591a\u5927\uff1f\u4ec0\u4e48\u7528\u6237\u5728\u5904\u7406\u8be5\u4e8b\u52a1\uff1f\u968f\u7740\u65f6\u95f4\u7684\u63a8\u79fb\uff0c\u5176\u662f\u5426\u663e\u793a\u4e3a\u672a\u63d0\u4ea4\uff1f\u8fd9\u5728\u9884\u671f\u4e4b\u5185\u5417\uff1f\u5728\u6b64\u4e8b\u52a1\u4e4b\u524d\u5f00\u59cb\u7684\u4efb\u4f55\u957f\u65f6\u95f4\u8fd0\u884c\u7684\u67e5\u8be2\u3001\u6216\u5728\u6b64\u4e8b\u52a1\u4e4b\u524d\u4f7f\u7528\u95ea\u56de\u529f\u80fd\u90fd\u5fc5\u987b\u521b\u5efa\u6b64\u6570\u636e\u7684\u65e7\u201c\u526f\u672c\u201d\u3002<\/p>\n
        \n
        \u5386\u53f2 UNDO \u4fe1\u606f<\/li>\n<\/ol>\n
        \u793a\u4f8b – undohistory.out<\/p>\n
        ############## RUNTIME ##############<\/p>\n
        Run Time<\/p>\n
        —————–<\/p>\n
        05-Aug-2009 09:08<\/p>\n
        ############## HISTORICAL DATA ##############<\/p>\n
        Max Concurrent<\/p>\n
        Last 7 Days<\/p>\n
        ——————–<\/p>\n
        5<\/p>\n
        Max Concurrent<\/p>\n
        Since Startup<\/p>\n
        ———————–<\/p>\n
        5<\/p>\n
        1555 Errors<\/p>\n
        —————<\/p>\n
        0<\/p>\n
        Undo Space Errors<\/p>\n
        ————————-<\/p>\n
        0<\/p>\n
        ############## CURRENT STATUS OF SEGMENTS ##############<\/p>\n
        ############## SNAPSHOT IN TIME INFO ##############<\/p>\n
        ##############(SHOWS CURRENT UNDO ACTIVITY)##############<\/p>\n
        Segment Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Active Bytes\u00a0\u00a0\u00a0\u00a0 Unexpired Bytes Expired Bytes<\/p>\n
        ———————————– ——————— ———————- ——————–<\/p>\n
        _SYSSMU10_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,114,112\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 65,536<\/p>\n
        _SYSSMU1_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3,211,264\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 75,497,472<\/p>\n
        _SYSSMU2_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 196,608\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 65,536<\/p>\n
        _SYSSMU3_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,507,328\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 55,115,776<\/p>\n
        _SYSSMU4_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 43,253,760\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        _SYSSMU5_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,048,576\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19,922,944<\/p>\n
        _SYSSMU6_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 327,680\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        _SYSSMU7_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,114,112\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 65,536<\/p>\n
        _SYSSMU8_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 458,752\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4,849,664<\/p>\n
        _SYSSMU9_1245875459$\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,179,648\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 65,536<\/p>\n
        10 rows selected.<\/p>\n
        ############## UNDO SPACE USAGE ##############<\/p>\n
        Segment#\u00a0\u00a0\u00a0\u00a0\u00a0 Shrinks\u00a0\u00a0\u00a0\u00a0 Avg Shrink Size<\/p>\n
        —————– ————- ———————–<\/p>\n
        0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,424,832<\/p>\n
        2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,402,470<\/p>\n
        3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,457,600<\/p>\n
        4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 425,984<\/p>\n
        5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,638,400<\/p>\n
        6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,523,712<\/p>\n
        7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,048,576<\/p>\n
        8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,031,616<\/p>\n
        9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,621,440<\/p>\n
        10\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,114,112<\/p>\n
        11 rows selected.<\/p>\n
        \u4e86\u89e3\u5e76\u53d1\u6027\u4fe1\u606f\u3002\u6709\u591a\u5c11\u5e76\u53d1\u6027\u4e8b\u52a1\u76f8\u4e92\u91cd\u53e0\uff1f\u5982\u679c\u60a8\u4e0d\u65ad\u770b\u5230\u9ad8\u5e76\u53d1\u7684\u672a\u63d0\u4ea4\u4e8b\u52a1\uff0c\u662f\u5426\u81ea\u52a8\u8c03\u6574\u7684 retention \u6b63\u5728\u6b63\u786e\u5904\u7406\u5de5\u4f5c\u8d1f\u8f7d?\u5bf9\u4e8e\u5f53\u524d\u672a\u63d0\u4ea4\u7684\u5de5\u4f5c\uff0c\u60a8\u8fd8\u53ef\u4ee5\u68c0\u67e5\u8fd0\u884c\u65f6\u7684\u6bb5\u6d3b\u52a8\u60c5\u51b5\u3002\u540c\u65f6\u67e5\u770b UNDO \u6539\u52a8\u7684\u4fe1\u606f\u3002\u8fd9\u4e9b\u6bb5\u7684\u5de5\u4f5c\u8d1f\u8f7d\u662f\u5426\u5e73\u8861\uff1f\u6536\u7f29\u662f\u5426\u5747\u5300\u5730\u5206\u5e03\u5728\u6bb5\u4e2d\uff1f\u662f\u5426\u6709\u4efb\u4f55\u6bb5\u627f\u53d7\u7684\u538b\u529b\u5927\u4e8e\u5176\u4ed6\u6bb5\uff1f<\/p>\n
        \u793a\u4f8b undostatistics.out<\/p>\n
        ############## RUNTIME ##############<\/p>\n
        Run Time<\/p>\n
        —————–<\/p>\n
        05-09:08<\/p>\n
        ############## Historical V$UNDOSTAT (Last 2 Days) ##############<\/p>\n
        Query<\/p>\n
        Maximum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Undo\u00a0\u00a0\u00a0\u00a0 # of\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Tuned Ret<\/p>\n
        Date\/Time Minutes\u00a0\u00a0 SqlID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TBS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Blocks\u00a0\u00a0\u00a0 Trans\u00a0\u00a0 # of Unexpired\u00a0\u00a0\u00a0 # of Expired Minutes<\/p>\n
        ————- ————- ——————– ———– ——— ———- ——————— —————- —————<\/p>\n
        03-09:15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 39\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 160\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 312\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25,024\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 29<\/p>\n
        03-09:25\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 36\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 220\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 312\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25,024\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 43<\/p>\n
        03-09:35\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 327\u00a0\u00a0\u00a0\u00a0\u00a0 200\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25,024\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 43<\/p>\n
        03-09:45\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0 202\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0464\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24,896\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 29<\/p>\n
        . . .<\/p>\n
        05-08:37\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0\u00a0 195\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 80\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25,344\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15<\/p>\n
        05-08:47\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35\u00a0\u00a0\u00a0\u00a0\u00a0 216\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 48\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25,376\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15<\/p>\n
        05-08:57\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 33\u00a0\u00a0\u00a0\u00a0\u00a0 183\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 56\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25,368\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15<\/p>\n
        <\/p>\n
        284 rows selected.<\/p>\n
        ############## RECENT MISSES FOR UNDO (Last 2 Days) ##############<\/p>\n
        no rows selected<\/p>\n
        no rows selected<\/p>\n
        ############## AUTO-TUNING TUNE-DOWN DATA ##############<\/p>\n
        ######## ROLLBACK DATA (Since Startup) ##############<\/h6>\n
        Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Counters<\/p>\n
        ————————————————————————————- ————<\/p>\n
        user rollbacks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04,959<\/p>\n
        transaction tables consistent reads – undo records applied\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/p>\n
        transaction tables consistent read rollbacks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        data blocks consistent reads – undo records applied\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 300,730<\/p>\n
        rollbacks only – consistent read gets\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11,384<\/p>\n
        cleanouts and rollbacks – consistent read gets\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a039<\/p>\n
        rollback changes – undo records applied\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 18,529<\/p>\n
        transaction rollbacks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 190<\/p>\n
        total number of undo segments dropped\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        tune down retentions in space pressure\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        global undo segment hints helped\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01<\/p>\n
        global undo segment hints were stale\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        local undo segment hints helped\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        local undo segment hints were stale\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        undo segment header was pinned\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 90,532<\/p>\n
        IMU CR rollbacks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06,183<\/p>\n
        SMON posted for undo segment recovery\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        SMON posted for undo segment shrink\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        18 rows selected.<\/p>\n
        ############## Long Running Query History ##############<\/p>\n
        <\/p>\n
        Date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Runaway SQL ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Space Issues<\/p>\n
        ——————– ———————- —————————————– ————————————————<\/p>\n
        02-19:05\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Max Tuned Down – Not Auto-Tuning<\/p>\n
        02-19:15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Reached Best Retention<\/p>\n
        02-19:25\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Reached Best Retention<\/p>\n
        02-19:35\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Reached Best Retention<\/p>\n
        02-19:45\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0rc4km05kgzb9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Reached Best Retention<\/p>\n
        ############## Details on Long Run Queries ##############<\/p>\n
        SQL ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Last Load\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Elapsed Days<\/p>\n
        ———————- ——————————————————————————— ————————– ——————<\/p>\n
        0rc4km05kgzb9\u00a0\u00a0\u00a0 select 1 from obj$ where name=’DBA_QUEUE_SCHEDULES’\u00a0 2009-08-04\/13:30:06\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19<\/p>\n
        \u67e5\u770b\u62a5\u544a\u4e2d\u5728\u8bbe\u5b9a\u65f6\u95f4\u5185\u6536\u96c6\u7684\u5173\u4e8e undo \u6d3b\u52a8\u7684\u6570\u636e\uff08\u9ed8\u8ba4\u4e3a 2 \u5929\uff09\u3002<\/p>\n
        \u7b2c\u4e8c\u90e8\u5206\u5c06\u663e\u793a\u5728 V$UNDOSTAT \u4e2d\u7684\u4e03\u5929\u6216\u5728\u5b9e\u4f8b\u751f\u547d\u5468\u671f\u4e2d\uff0c\u67e5\u8be2\u6301\u7eed\u65f6\u95f4\u5927\u4e8e\u8c03\u6574\u540e\u7684Retention\u65f6\u95f4\u7684\u60c5\u51b5\u3002<\/p>\n
        \u662f\u5426\u6709\u5927\u91cf\u7684\u201c\u8c03\u4f4e\u201d\u76f8\u5173\u6d3b\u52a8\uff1f\u201c\u8c03\u4f4e\u201d\u662f\u81ea\u52a8\u8c03\u6574 AUM \u7684\u4e00\u79cd\u529f\u80fd\uff0c\u5c06\u4f1a\u6536\u7f29\u4fdd\u7559\u65f6\u95f4\u4ee5\u51cf\u5c11 UNDO \u7a7a\u95f4\u538b\u529b\u3002\u8fd9\u53ef\u6307\u5411\u5c1a\u672a\u5f15\u53d1 ORA-30036 \u9519\u8bef\u7684\u7a7a\u95f4\u95ee\u9898\u3002<\/p>\n
        \u6700\u540e\u8c03\u67e5\u957f\u65f6\u8fd0\u884c\u67e5\u8be2\u6570\u636e\u3002\u8fd9\u4e9b\u53ef\u80fd\u662f\u6211\u4eec\u9884\u671f\u5185\u7684\uff0c\u4f46\u4e5f\u6709\u52a9\u4e8e\u6307\u51fa\u610f\u5916\u7684\u67e5\u8be2\u6d3b\u52a8\u3002<\/p>\n
        \n
        \u7b49\u5f85\/\u9501\u5b9a\u5206\u6790<\/li>\n<\/ol>\n
        \u793a\u4f8b undopressure.out<\/p>\n
        ############## RUNTIME ##############<\/p>\n
        Run Time<\/p>\n
        —————–<\/p>\n
        05-08:58<\/p>\n
        ############## WAITS FOR UNDO (Since Startup) ##############<\/p>\n
        Cummalitve<\/p>\n
        Instance# Enq Total Requests\u00a0\u00a0 Total Waits\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Successes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Failures\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Time<\/p>\n
        ————- —— ——————– —————- ———————— ————— ——————<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HW\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,104\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,104\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 US\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 58\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 58\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        ############## LOCKS FOR UNDO ##############<\/p>\n
        no rows selected<\/p>\n
        ############## TUNED RETENTION HISTORY (Last 2 Days) ##############<\/p>\n
        ############## LOWEST AND HIGHEST DATA ##############<\/p>\n
        END_TIME TUNED_UNDORETENTION<\/p>\n
        —————– ————————————–<\/p>\n
        05-08:58\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-08:57\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-08:37\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-07:17\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-04:17\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-03:57\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-03:37\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0900<\/p>\n
        05-02:57\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-02:37\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-02:17\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        05-01:17\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0900<\/p>\n
        11 rows selected.<\/p>\n
        END_TIME TUNED_UNDORETENTION<\/p>\n
        —————– ————————————-<\/p>\n
        04-17:57\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2227<\/p>\n
        ############## CURRENT TRANSACTIONS ##############<\/p>\n
        START_DATE\u00a0 START_SCN\u00a0\u00a0 STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Code<\/p>\n
        ——————— —————— —————- —————————————-<\/p>\n
        05-08:58\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 53717782\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ACTIVE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 update abc_tmp set edition_name=”<\/p>\n
        CURRENT_SCN<\/p>\n
        ———————<\/p>\n
        53734654<\/p>\n
        ############## WHO’S STEALING WHAT? (Last 2 Days) ##############<\/p>\n
        UnexStolen ExStolen UnexReuse ExReuse<\/p>\n
        ————— ———— ————— ———–<\/p>\n
        0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 22\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00<\/p>\n
        0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/p>\n
        \u67e5\u770b\u7b49\u5f85\u548c\u9501\u5b9a\u4fe1\u606f\u3002\u9ad8\u7b49\u5f85\u548c\u6027\u80fd\u95ee\u9898\u53ef\u80fd\u4e0e\u5df2\u77e5\u7684 UNDO \u6027\u80fd bug \u5339\u914d\u3002\u540c\u65f6\u67e5\u770b\u9ad8\u3001\u4f4e\u8c03\u6574\u540e\u7684Retention\u4fe1\u606f\u3002\u5728\u6b64\u62a5\u544a\u4e2d\uff0c\u60a8\u662f\u5426\u53d1\u73b0\u88ab\u76d7 extent \u7684\u8bc1\u636e\uff1f\u672a\u8fc7\u671f extent \u662f\u5426\u88ab\u76d7\uff1f<\/p>\n
        \n
        \u8c03\u67e5 LOB \u95ee\u9898<\/li>\n<\/ol>\n
        \u793a\u4f8b lobdata.out<\/p>\n
        Table\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Tablespace\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PCTVersion %\u00a0\u00a0 Retention<\/p>\n
        —————— ———————————————- ——————– ——————– ————-<\/p>\n
        CTEST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0DATA_OBJECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        PAA_TEST\u00a0\u00a0\u00a0 RESPONDER_COMMENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        EMP_O\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PICTURE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10<\/p>\n
        EMP_O\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RESUME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10<\/p>\n
        TEST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COMMENTS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0TB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900<\/p>\n
        5 rows selected.<\/p>\n
        \u5982\u679c\u5b9a\u671f\u66f4\u65b0 LOB \u6570\u636e\uff0cLOB \u5bf9\u8c61\u4e0a\u53d1\u751f ORA-1555 \u5c31\u53ef\u80fd\u662f\u9884\u671f\u5185\u7684\u3002PCTVersion \u9ed8\u8ba4\u4e3a 10%\uff0c\u5982\u679c\u60a8\u6301\u7eed\u5bf9 LOB \u6570\u636e\u8fdb\u884c\u4e86\u66f4\u6539\uff0c\u90a3\u4e48\u8fd9\u4e2a\u6b64\u503c\u901a\u5e38\u9700\u8981\u8c03\u9ad8\u5f88\u591a\u3002\u6709\u65f6 100%\uff08\u4fdd\u7559\u6240\u6709\u66f4\u6539\uff09\u8fd8\u4e0d\u8db3\u4ee5\u9002\u5e94\u5de5\u4f5c\u8d1f\u8f7d\u3002\u5e38\u89c4\u7684 ORA-1555 \u8bca\u65ad\/\u5206\u6790\u5bf9\u4e0e LOB \u76f8\u5173\u7684 ORA-1555 \u9519\u8bef\u662f\u6ca1\u6709\u7528\u7684\u3002LOB \u4ea7\u751f\u7684 UNDO \u4e0d\u662f\u4f7f\u7528 UNDO \u8868\u7a7a\u95f4\u4e2d\u7684 extent\uff0c\u800c\u662f\u4fdd\u7559\u5728 LOB \u8868\u7a7a\u95f4\u4e2d\u3002<\/p>\n
        \u5176\u4ed6\u53c2\u8003\uff1a
        \nhttps:\/\/wenku.baidu.com\/view\/47b01e6ab84ae45c3b358ca8.html<\/p>\n
        https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14237\/initparams222.htm#REFRN10225<\/p>\n
        https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=341463354078393&parent=DOCUMENT&sourceId=1307334.1&id=1555.1&_afrWindowMode=0&_adf.ctrl-state=wgqt71fpl_126<\/p>\n
        https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=341423607535564&id=1307334.1&_afrWindowMode=0&_adf.ctrl-state=wgqt71fpl_77<\/p>\n<\/div>\n
        Oracle \u6807\u51c6\u670d\u52a1 – \u6570\u636e\u5e93\u6280\u672f\u652f\u6301\u901a\u8baf – 2015\u5e7411\u6708\u7248\uff0c57\u671f (\u6587\u6863 ID 2088997.1)<\/p>\n
        \n
        https:\/\/support.oracle.com\/epmos\/faces\/SearchDocDisplay?_adf.ctrl-state=wgqt71fpl_299&_afrLoop=344990618186201#title1<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/form>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
        AUM \u5e38\u7528\u5206\u6790\/\u8bca\u65ad\u811a\u672c (\u6587\u6863 ID 1526122.1) Oracle Database – … \u7ee7\u7eed\u9605\u8bfbAUM \u5e38\u7528\u5206\u6790\/\u8bca\u65ad\u811a\u672c (\u6587\u6863 ID 1526122.1)<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31,1],"tags":[250],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1590"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1590"}],"version-history":[{"count":4,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1590\/revisions"}],"predecessor-version":[{"id":1594,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1590\/revisions\/1594"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}