Expandmenu Shrunk


  • Category Archives oracle troubleshooting
  • 移动核心平台挂起处理

    平台:AIX5.3L

    Oracle9208RAC集群(HACMP)
    STATSPACK report for

    DB Name         DB Id    Instance     Inst Num Release     Cluster Host
    ———— ———– ———— ——– ———– ——- ————
    UIDB           431029913 uidb2               2 9.2.0.8.0   YES     cqydnw_db2

                  Snap Id     Snap Time      Sessions Curs/Sess Comment
                ——— —————— ——– ——— ——————-
    Begin Snap:     43188 11-Nov-11 01:00:06      557 #########
      End Snap:     43189 11-Nov-11 02:03:39      977       1.5
       Elapsed:               63.55 (mins)

    Cache Sizes (end)
    ~~~~~~~~~~~~~~~~~
                   Buffer Cache:     8,192M      Std Block Size:          8K
               Shared Pool Size:     1,024M          Log Buffer:        503K

    Load Profile
    ~~~~~~~~~~~~                            Per Second       Per Transaction
                                       —————       —————
                      Redo size:            320,931.88             22,363.18
                  Logical reads:             24,797.41              1,727.93
                  Block changes:              8,026.42                559.30
                 Physical reads:              3,376.27                235.27
                Physical writes:                450.08                 31.36
                     User calls:                160.44                 11.18
                         Parses:                100.77                  7.02
                    Hard parses:                  1.75                  0.12
                          Sorts:                 24.59                  1.71
                         Logons:                  1.60                  0.11
                       Executes:                136.63                  9.52
                   Transactions:                 14.35

      % Blocks changed per Read:   32.37    Recursive Call %:     87.25
     Rollback per transaction %:    0.68       Rows per Sort:   1273.41

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                Buffer Nowait %:   99.85       Redo NoWait %:    100.00
                Buffer  Hit   %:   86.51    In-memory Sort %:     99.99
                Library Hit   %:   98.21        Soft Parse %:     98.26
             Execute to Parse %:   26.24         Latch Hit %:     99.62
    Parse CPU to Parse Elapsd %:    0.49     % Non-Parse CPU:     96.79

     Shared Pool Statistics        Begin   End
                                   ——  ——
                 Memory Usage %:   90.57   97.38
        % SQL with executions>1:   76.42   39.55
      % Memory for SQL w/exec>1:   87.19   38.08

    Top 5 Timed Events
    ~~~~~~~~~~~~~~~~~~                                                     % Total
    Event                                               Waits    Time (s) Ela Time
    ——————————————– ———— ———– ——–
    enqueue                                           203,255      34,183    29.60
    latch free                                        111,791      29,816    25.81
    db file parallel write                             45,579       8,551     7.40
    log file sync                                      71,870       7,349     6.36
    db file scattered read                          1,475,090       7,180     6.22
              ————————————————————-
    Cluster Statistics for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Global Cache Service – Workload Characteristics
    ———————————————–
    Ave global cache get time (ms):                            0.4
    Ave global cache convert time (ms):                        3.9

    Ave build time for CR block (ms):                          1.0
    Ave flush time for CR block (ms):                          5.6
    Ave send time for CR block (ms):                           0.0
    Ave time to process CR block request (ms):                 6.6
    Ave receive time for CR block (ms):                       13.6

    Ave pin time for current block (ms):                       0.2
    Ave flush time for current block (ms):                     0.2
    Ave send time for current block (ms):                      0.1
    Ave time to process current block request (ms):            0.5
    Ave receive time for current block (ms):                   1.3

    Global cache hit ratio:                                   14.5
    Ratio of current block defers:                             0.0
    % of messages sent for buffer gets:                       14.3
    % of remote buffer gets:                                   0.3
    Ratio of I/O for coherence:                                1.0
    Ratio of local vs remote work:                            40.9
    Ratio of fusion vs physical writes:                        0.0

    Global Enqueue Service Statistics
    ———————————
    Ave global lock get time (ms):                            32.1
    Ave global lock convert time (ms):                         0.3
    Ratio of global lock gets vs global lock releases:         1.1

    GCS and GES Messaging statistics
    ——————————–
    Ave message sent queue time (ms):                          0.2
    Ave message sent queue time on ksxp (ms):                  0.9
    Ave message received queue time (ms):                      0.9
    Ave GCS message process time (ms):                         0.1
    Ave GES message process time (ms):                         0.8
    % of direct sent messages:                                 6.6
    % of indirect sent messages:                              49.3
    % of flow controlled messages:                            44.2
              ————————————————————-
    GES Statistics for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Statistic                                    Total   per Second    per Trans
    ——————————— —————- ———— ————
    dynamically allocated gcs resourc                0          0.0          0.0
    dynamically allocated gcs shadows                0          0.0          0.0
    flow control messages received                   5          0.0          0.0
    flow control messages sent                      14          0.0          0.0
    gcs ast xid                                      0          0.0          0.0
    gcs blocked converts                        45,733         12.0          0.8
    gcs blocked cr converts                     32,554          8.5          0.6
    gcs compatible basts                             4          0.0          0.0
    gcs compatible cr basts (global)               537          0.1          0.0
    gcs compatible cr basts (local)            375,045         98.4          6.9
    gcs cr basts to PIs                              0          0.0          0.0
    gcs cr serve without current lock                0          0.0          0.0
    gcs error msgs                                   0          0.0          0.0
    gcs flush pi msgs                            6,365          1.7          0.1
    gcs forward cr to pinged instance                0          0.0          0.0
    gcs immediate (compatible) conver           11,502          3.0          0.2
    gcs immediate (null) converts              312,252         81.9          5.7
    gcs immediate cr (compatible) con          280,393         73.5          5.1
    gcs immediate cr (null) converts        10,995,797      2,883.8        200.9
    gcs msgs process time(ms)                1,043,836        273.8         19.1
    gcs msgs received                       10,866,308      2,849.8        198.6
    gcs out-of-order msgs                          116          0.0          0.0
    gcs pings refused                               28          0.0          0.0
    gcs queued converts                             23          0.0          0.0
    gcs recovery claim msgs                          0          0.0          0.0
    gcs refuse xid                                   0          0.0          0.0
    gcs retry convert request                        0          0.0          0.0
    gcs side channel msgs actual                65,742         17.2          1.2
    gcs side channel msgs logical            6,545,474      1,716.6        119.6
    gcs write notification msgs                    413          0.1          0.0
    gcs write request msgs                       9,448          2.5          0.2
    gcs writes refused                              98          0.0          0.0
    ges msgs process time(ms)                  148,230         38.9          2.7
    ges msgs received                          195,257         51.2          3.6
    global posts dropped                             0          0.0          0.0
    global posts queue time                          0          0.0          0.0
    global posts queued                              0          0.0          0.0
    global posts requested                           0          0.0          0.0
    global posts sent                                0          0.0          0.0
    implicit batch messages received         1,064,803        279.3         19.5
    implicit batch messages sent             1,320,482        346.3         24.1
    lmd msg send time(ms)                          611          0.2          0.0
    lms(s) msg send time(ms)                        38          0.0          0.0
    messages flow controlled                 6,073,308      1,592.8        111.0
    messages received actual                 6,575,604      1,724.5        120.2
    messages received logical               11,076,524      2,904.9        202.4
    messages sent directly                     901,576        236.4         16.5
    messages sent indirectly                 6,771,230      1,775.8        123.7
    msgs causing lmd to send msgs               42,300         11.1          0.8
    msgs causing lms(s) to send msgs            73,416         19.3          1.3
    msgs received queue time (ms)            9,920,736      2,601.8        181.3
    msgs received queued                    11,054,643      2,899.2        202.0
    msgs sent queue time (ms)                1,431,768        375.5         26.2
    msgs sent queue time on ksxp (ms)        7,377,181      1,934.7        134.8
    msgs sent queued                         6,760,545      1,773.0        123.5
    msgs sent queued on ksxp                 7,826,752      2,052.6        143.0
    GES Statistics for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Statistic                                    Total   per Second    per Trans
    ——————————— —————- ———— ————
    process batch messages received          1,199,169        314.5         21.9
    process batch messages sent              1,442,153        378.2         26.4
              ————————————————————-
    Wait Events for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> s  – second
    -> cs – centisecond –     100th of a second
    -> ms – millisecond –    1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc (idle events last)

                                                                       Avg
                                                         Total Wait   wait    Waits
    Event                               Waits   Timeouts   Time (s)   (ms)     /txn
    —————————- ———— ———- ———- —— ——–
    enqueue                           203,255     55,508     34,183    168      3.7
    latch free                        111,791      6,546     29,816    267      2.0
    db file parallel write             45,579          0      8,551    188      0.8
    log file sync                      71,870        437      7,349    102      1.3
    db file scattered read          1,475,090          0      7,180      5     27.0
    db file sequential read         1,139,517          0      6,812      6     20.8
    row cache lock                    149,279      1,355      5,604     38      2.7
    log buffer space                   78,435         16      4,322     55      1.4
    buffer busy waits                 138,895        923      3,930     28      2.5
    PX Deq: Execute Reply              19,348      1,037      1,590     82      0.4
    KJC: Wait for msg sends to c       45,732     15,156        749     16      0.8
    async disk IO                      20,365          0        732     36      0.4
    global cache cr request         1,935,189      2,731        670      0     35.4
    global cache open x               137,816      1,949        344      2      2.5
    log file sequential read           10,215          0        290     28      0.2
    DFS lock handle                    26,549        202        286     11      0.5
    buffer busy global CR               1,496        235        261    174      0.0
    library cache pin                   6,999         47        155     22      0.1
    control file parallel write         3,660          0        147     40      0.1
    buffer busy global cache            2,711         63        137     51      0.0
    global cache null to x             18,245         93        101      6      0.3
    direct path read                    2,253          0         94     42      0.0
    name-service call wait              1,709          3         64     37      0.0
    global cache busy                     507         33         61    120      0.0
    control file sequential read       55,395          0         47      1      1.0
    PX Deq: Signal ACK                  5,825      1,436         37      6      0.1
    LGWR wait for redo copy            17,143      2,912         31      2      0.3
    local write wait                      381          2         29     77      0.0
    direct path write                   1,220          0         23     19      0.0
    library cache lock                 10,447         28         16      2      0.2
    global cache s to x                12,458         77         14      1      0.2
    log file switch completion             63          0         13    208      0.0
    PX Deq Credit: send blkd              981         26         12     12      0.0
    PX Deq: reap credit               534,983    523,868          6      0      9.8
    CGS wait for IPC msg              486,007    479,781          6      0      8.9
    log file parallel write            52,257          0          5      0      1.0
    ksxr poll remote instances        240,883     99,684          5      0      4.4
    index block split                     422        421          4     10      0.0
    lock escalate retry                    43         43          4     91      0.0
    global cache null to s              2,262          1          4      2      0.0
    db file parallel read                 355          0          4     10      0.0
    PX Deq: Parse Reply                 3,972         84          3      1      0.1
    PX Deq Credit: need buffer          1,244        311          2      1      0.0
    global cache open s                   907         13          1      1      0.0
    PX Deq: Join ACK                    3,783        276          1      0      0.1
    ksdxexeotherwait                  336,136    336,136          0      0      6.1
    PX Deq: Msg Fragment                1,916        590          0      0      0.0
    log file single write                  10          0          0     10      0.0
    buffer deadlock                     5,469      5,444          0      0      0.1
    Wait Events for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> s  – second
    -> cs – centisecond –     100th of a second
    -> ms – millisecond –    1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc (idle events last)

                                                                       Avg
                                                         Total Wait   wait    Waits
    Event                               Waits   Timeouts   Time (s)   (ms)     /txn
    —————————- ———— ———- ———- —— ——–
    library cache load lock                11          0          0      4      0.0
    IPC send completion sync               89         88          0      0      0.0
    SQL*Net more data to client           614          0          0      0      0.0
    global cache quiesce wait               1          1          0     10      0.0
    ges inquiry response                    9          0          0      1      0.0
    SQL*Net break/reset to clien            2          0          0      0      0.0
    SQL*Net message from client       356,908          0    583,726   1636      6.5
    gcs remote message              6,164,466     43,790     20,697      3    112.7
    jobq slave wait                     1,589        954      3,922   2468      0.0
    ges remote message                294,562     65,985      3,578     12      5.4
    wakeup time manager                   122        122      3,572  29282      0.0
    PX Deq: Table Q Normal            223,805        202      3,189     14      4.1
    PX Deq: Execution Msg              33,966      1,401      2,646     78      0.6
    PX Idle Wait                        4,771        195        790    166      0.1
    SQL*Net message to client         357,202          0         24      0      6.5
              ————————————————————-
    Background Wait Events for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> ordered by wait time desc, waits desc (idle events last)

                                                                       Avg
                                                         Total Wait   wait    Waits
    Event                               Waits   Timeouts   Time (s)   (ms)     /txn
    —————————- ———— ———- ———- —— ——–
    db file parallel write             45,578          0      8,552    188      0.8
    latch free                          4,698        252        927    197      0.1
    async disk IO                      20,365          0        732     36      0.4
    log buffer space                   16,310          0        323     20      0.3
    log file sequential read           10,215          0        290     28      0.2
    control file parallel write         1,293          0         52     40      0.0
    enqueue                            23,299         66         51      2      0.4
    DFS lock handle                     1,633         42         33     20      0.0
    LGWR wait for redo copy            17,164      2,912         31      2      0.3
    buffer busy waits                     644         16         18     28      0.0
    row cache lock                         96          0         11    112      0.0
    control file sequential read        6,005          0          8      1      0.1
    CGS wait for IPC msg              486,280    480,051          6      0      8.9
    log file parallel write            52,268          0          5      0      1.0
    ksxr poll remote instances        241,242     99,798          5      0      4.4
    db file sequential read               136          0          2     13      0.0
    ksdxexeotherwait                  336,136    336,136          0      0      6.1
    global cache cr request                99          0          0      1      0.0
    db file scattered read                  7          0          0     14      0.0
    log file single write                  10          0          0     10      0.0
    library cache lock                    173          0          0      0      0.0
    global cache open x                    63          0          0      0      0.0
    ges inquiry response                    9          0          0      1      0.0
    global cache null to x                  4          0          0      0      0.0
    global cache open s                     1          0          0      0      0.0
    rdbms ipc message                 355,387     40,054     23,363     66      6.5
    gcs remote message              6,165,481     43,806     20,707      3    112.7
    pmon timer                          1,367      1,306      3,726   2726      0.0
    ges remote message                295,429     66,010      3,581     12      5.4
    smon timer                            498          4      3,579   7187      0.0
              ————————————————————-
    SQL ordered by Gets for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Buffer Gets Threshold:     10000
    -> Note that resources reported for PL/SQL includes the resources used by
       all SQL statements called within the PL/SQL code.  As individual SQL
       statements are also reported, it is possible and valid for the summed
       total % to exceed 100

                                                         CPU      Elapsd
      Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
         33,863,265       26,792        1,263.9   35.8    60.26    670.02  467133836
    Module: aplogic.exe
    SELECT T.ID FROM T_SCESENDTASK T WHERE T.SENDTIME <= SYSDATE AND
     ROWNUM <= 1 AND T.SIAPPCODE <> ‘12582’

         33,761,745       26,730        1,263.1   35.7    62.97    983.43 4287674937
    Module: aplogic.exe
    begin P_SCE_GetVocSMDataNew (: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); end;

          4,907,296       10,353          474.0    5.2   235.13    978.27  121882572
    Module: w3wp.exe
    select BEGINNO,ENDNO,CITYNAME,DESCRIPTION,HOMELOCATIONCODE,LOCAT
    IONID,MODIFYDATE,PROVINCENAME
                           from t_iiss_numbersegment where BeginNO <
    = :phoneNo and endNo >= :phoneNo

          4,320,436            1    4,320,436.0    4.6    48.37    675.14 1105889772
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

          3,713,168           77       48,223.0    3.9   219.46   1065.39 2707120947
    Module: HAWorker_SISubNotify.exe
    select t1.* from (
     select  a.*,c.siapp_gid,
             c.siappco
    de,
             c.siappname,
             c.siappurl,
             c.sia
    ppsoap,
             c.siapproutercode,
             c.locationid,
           c.status,
             c.flag 
     from    t_iiss_subscribe_ca
    che a,
             t_iiss_merchandise     b,
             t_iiss_siap

          3,560,308            1    3,560,308.0    3.8    28.25    132.88 2432000261
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

          3,116,448            1    3,116,448.0    3.3    24.63    104.32 4203601915
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

          2,426,244           51       47,573.4    2.6   141.68    730.73   46529672
    Module: HAWorker_SISubNotify.exe
     insert into t_iiss_subscribe_his select * from T_IISS_SUBSCRIBE
    SQL ordered by Gets for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Buffer Gets Threshold:     10000
    -> Note that resources reported for PL/SQL includes the resources used by
       all SQL statements called within the PL/SQL code.  As individual SQL
       statements are also reported, it is possible and valid for the summed
       total % to exceed 100

                                                         CPU      Elapsd
      Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
    _CACHE where GID < :gid

          2,379,314           50       47,586.3    2.5   139.67   1120.94 3295848716
    Module: HAWorker_SISubNotify.exe
     delete from T_IISS_SUBSCRIBE_CACHE where GID < :gid

          2,228,574            1    2,228,574.0    2.4    26.02    261.51 3412360638
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

          1,444,300            1    1,444,300.0    1.5    12.78     88.69 1696337494
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

          1,392,952            1    1,392,952.0    1.5    13.15    141.59 3751550902
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

          1,284,323            1    1,284,323.0    1.4    13.15    156.80 1623369323
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

          1,283,075            1    1,283,075.0    1.4   105.86    828.87  642080086
    insert /*+ PARALLEL(t_iiss_subscribe_union1, 4) */ into  t_iiss_
    subscribe_union1(gid,phoneno,objectid,partitionnum,field1,begind
    ate,enddate, userLocationId, address1, address2, address3, addre
    ss4, address5, callingId)  SELECT t.gid,t.phoneno,t.objectid,sub
    str(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t.field1,t.begindate,t.en

          1,191,349            3      397,116.3    1.3    28.89    230.10 2156738676
    DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
    broken BOOLEAN := FALSE; BEGIN P_GAHTER_TIMINGRELEASENEW(); :myd
    ate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF;
    END;

            978,255            3      326,085.0    1.0    75.12   2218.73 3508661513
    DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
    broken BOOLEAN := FALSE; BEGIN p_iiss_synmcassubtemp; :mydate :=
    SQL ordered by Gets for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Buffer Gets Threshold:     10000
    -> Note that resources reported for PL/SQL includes the resources used by
       all SQL statements called within the PL/SQL code.  As individual SQL
       statements are also reported, it is possible and valid for the summed
       total % to exceed 100

                                                         CPU      Elapsd
      Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
     next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

              ————————————————————-
    SQL ordered by Reads for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Disk Reads Threshold:      1000

                                                         CPU      Elapsd
     Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
          3,683,149           77       47,833.1   28.6   219.46   1065.39 2707120947
    Module: HAWorker_SISubNotify.exe
    select t1.* from (
     select  a.*,c.siapp_gid,
             c.siappco
    de,
             c.siappname,
             c.siappurl,
             c.sia
    ppsoap,
             c.siapproutercode,
             c.locationid,
           c.status,
             c.flag 
     from    t_iiss_subscribe_ca
    che a,
             t_iiss_merchandise     b,
             t_iiss_siap

          2,410,956           51       47,273.6   18.7   141.68    730.73   46529672
    Module: HAWorker_SISubNotify.exe
     insert into t_iiss_subscribe_his select * from T_IISS_SUBSCRIBE
    _CACHE where GID < :gid

          2,360,881           50       47,217.6   18.3   139.67   1120.94 3295848716
    Module: HAWorker_SISubNotify.exe
     delete from T_IISS_SUBSCRIBE_CACHE where GID < :gid

            976,673            3      325,557.7    7.6    75.12   2218.73 3508661513
    DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
    broken BOOLEAN := FALSE; BEGIN p_iiss_synmcassubtemp; :mydate :=
     next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

            324,263            3      108,087.7    2.5    33.48   1242.96 3588967465
    UPDATE T_IISS_SYNMCASSUBTEMP_ADD A SET A.FIELD1=’0′ WHERE ROWNUM
    <=20000

            324,149            3      108,049.7    2.5    20.70    530.26  757044621
    INSERT INTO T_IISS_SYNMCASSUBTEMP (GID, PHONENO, SERVICETYPE, SE
    RVICEID, PRODUCTID, OBJECTID, OBJECTTYPE, SUBDATE, BEGINDATE, EN
    DDATE, ORDERUSER, ORDERROUTE, CONFIRM, DESCRIPTION, FIELD2, FIEL
    D3, CORPACCOUNT, BOSSCODE, SYNDATE) SELECT GID, PHONENO, SERVICE
    TYPE, SERVICEID, PRODUCTID, OBJECTID, OBJECTTYPE, SUBDATE, BEGIN

            324,104            3      108,034.7    2.5    20.70    437.92  266495115
    DELETE T_IISS_SYNMCASSUBTEMP_ADD WHERE FIELD1=’0′

            164,555            1      164,555.0    1.3   105.86    828.87  642080086
    insert /*+ PARALLEL(t_iiss_subscribe_union1, 4) */ into  t_iiss_
    subscribe_union1(gid,phoneno,objectid,partitionnum,field1,begind
    ate,enddate, userLocationId, address1, address2, address3, addre
    ss4, address5, callingId)  SELECT t.gid,t.phoneno,t.objectid,sub
    str(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t.field1,t.begindate,t.en

             57,649            1       57,649.0    0.4    48.37    675.14 1105889772
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

             52,805            3       17,601.7    0.4    28.89    230.10 2156738676
    DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
    broken BOOLEAN := FALSE; BEGIN P_GAHTER_TIMINGRELEASENEW(); :myd
    ate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF;
    SQL ordered by Reads for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Disk Reads Threshold:      1000

                                                         CPU      Elapsd
     Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
    END;

             34,493            1       34,493.0    0.3    26.02    261.51 3412360638
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

             24,379        9,888            2.5    0.2    10.69   3481.52 1027951557
    Module: w3wp.exe
    SELECT MAX(BOSSOPERDATE) FROM t_iiss_subscribe_today_log T WHERE
     T.MEMBERNO = :PHONENO AND T.OBJECTID = :OBJECTID

             23,766            1       23,766.0    0.2    28.25    132.88 2432000261
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

             23,200            1       23,200.0    0.2     4.73    170.24 3235165266
    insert /*+ PARALLEL(t_iiss_subscribe_union1, 4) */ into  t_iiss_
    subscribe_union1(gid,phoneno,objectid,partitionnum,field1,begind
    ate,enddate, userLocationId, address1, address2, address3, addre
    ss4, address5, callingId)  SELECT t.gid,t.phoneno,t.objectid,sub
    str(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t.field1,t.begindate,t.en

             19,292            1       19,292.0    0.1     4.41    525.15 3430470856
    insert /*+ PARALLEL(t_iiss_subscribe_union1, 4) */ into  t_iiss_
    subscribe_union1(gid,phoneno,objectid,partitionnum,field1,begind
    ate,enddate, userLocationId, address1, address2, address3, addre
    ss4, address5, callingId)  SELECT t.gid,t.phoneno,t.objectid,sub
    str(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t.field1,t.begindate,t.en

             18,025            1       18,025.0    0.1    13.69    170.68 1139557936
    DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
    broken BOOLEAN := FALSE; BEGIN p_daylog_productvsbilllog; :mydat
    e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; EN
    D;

             17,684            1       17,684.0    0.1     9.56     69.54 2133718806
    insert into  t_iiss_subscribe_union_temp(gid,phoneno,objectid,pa
    rtitionnum,field1,begindate,enddate, userLocationId, address1, a
    ddress2, address3, address4, address5, callingId)  SELECT t.gid,
    t.phoneno,t.objectid,substr(t.objectid,-:”SYS_B_0″,:”SYS_B_1″),t
    .field1,t.begindate,t.enddate, t.userLocationId, t.address1, t.a

              ————————————————————-
    SQL ordered by Executions for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Executions Threshold:       100

                                                    CPU per    Elap per
     Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
    ———— ————— —————- ———– ———- ———-
          38,767               0              0.0       0.00        0.00 4274598960
    select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
    estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
    density, col#, spare1, spare2, avgcln from hist_head$ where obj#
    =:1 and intcol#=:2

          29,823          29,823              1.0       0.00        0.00 3948238198
    update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts
    =:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13
    , 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cacheh
    int=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17) where ts#=:1
     and file#=:2 and block#=:3

          26,792               0              0.0       0.00        0.03  467133836
    Module: aplogic.exe
    SELECT T.ID FROM T_SCESENDTASK T WHERE T.SENDTIME <= SYSDATE AND
     ROWNUM <= 1 AND T.SIAPPCODE <> ‘12582’

          26,730          26,604              1.0       0.00        0.04 4287674937
    Module: aplogic.exe
    begin P_SCE_GetVocSMDataNew (: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); end;

          23,149          22,528              1.0       0.00        0.00 1006414593
    select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#
    ,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N
    VL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3

          21,777          26,918              1.2       0.00        0.00 2889900621
    select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#
    =:1

          21,450          21,477              1.0       0.00        0.00 1433558559
    select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1

          20,345          20,345              1.0       0.00        0.36 3799156924
    Module: w3wp.exe
    INSERT INTO T_IISS_INTERBOSS_LOG(GID,FILESEQ,FILETYPE,LOGCONTENT
    ,LOGDATE,LOGTYPE,ORGANIGER,OUTCOME,PROVINCECODE) VALUES(:GID,:Fi
    leSeq,:FileType,:LogContent,:LogDate,:LogType,:Organiger,:Outcom
    e,:ProvinceCode)

          20,323          20,318              1.0       0.00        0.27 3628115315
    Module: w3wp.exe
    SELECT SEQ_IISS_BOSSFILE.NEXTVAL FROM DUAL

          20,321          20,313              1.0       0.00        1.04 1952010973
    Module: w3wp.exe
    INSERT INTO T_IISS_BOSSFILE(GID,FILENAME,FILETYPE,LOGDATE,ORGANI
    GER,PHONE,PROVINCECODE,REQUESTTYPE,SEQ) VALUES(:GID,:FileName,:F
    ileType,:LogDate,:Organiger,:Phone,:ProvinceCode,:RequestType,:S
    eq)

    SQL ordered by Executions for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Executions Threshold:       100

                                                    CPU per    Elap per
     Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
    ———— ————— —————- ———– ———- ———-
          20,306          20,262              1.0       0.00        0.02 2856633856
    Module: w3wp.exe
    SELECT SEQ_IISS_INTERBOSS_LOG.NEXTVAL FROM DUAL

          16,801          16,801              1.0       0.00        0.00  431456802
    select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
    bname,o.dataobj#,o.flags from obj$ o where o.obj#=:1

          15,078          15,078              1.0       0.00        0.00 1380021873
    update tsq$ set blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv
    2=:7,priv3=:8 where ts#=:1 and user#=:2

          15,025         237,049             15.8       0.00        0.00 1254950678
    select file# from file$ where ts#=:1

          10,603          10,603              1.0       0.00        0.01 3716207873
    update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
    order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
    1

          10,353          10,355              1.0       0.02        0.09  121882572
    Module: w3wp.exe
    select BEGINNO,ENDNO,CITYNAME,DESCRIPTION,HOMELOCATIONCODE,LOCAT
    IONID,MODIFYDATE,PROVINCENAME
                           from t_iiss_numbersegment where BeginNO <
    = :phoneNo and endNo >= :phoneNo

          10,259          10,245              1.0       0.00        0.31 3270213255
    Module: w3wp.exe
    SELECT SEQ_IISS_UNION.NEXTVAL FROM DUAL

          10,233          10,233              1.0       0.00        0.04  276750471
    Module: w3wp.exe
    INSERT INTO T_IISS_SUBOPERATIONLOG(LOGID,ADDORDEL,LOCATIONCODE,L
    OCATIONID,MEMBERNO,OBJECTID,OBJECTNAME,OPERDATE,OPERDESC,ORDERRO
    UTE,ORDERTYPE,ORDERUSER,SUBSCRIBETYPE) VALUES(:LogId,:AddOrDel,:
    LocationCode,:LocationId,:MemberNo,:ObjectId,:ObjectName,:OperDa
    te,:OperDesc,:OrderRoute,:OrderType,:OrderUser,:SubscribeType)

          10,233          10,233              1.0       0.00        0.16 3412224227
    Module: w3wp.exe
    INSERT INTO T_IISS_SUBSCRIBE_TODAY_LOG(LOGID,ADDORDEL,BOSSOPERDA
    TE,LOCATIONCODE,LOCATIONID,MEMBERNO,OBJECTID,OPERDATE,OPERDESC,O
    RDERROUTE,ORDERTYPE,ORDERUSER) VALUES(:LogId,:AddOrDel,:BossOper
    Date,:LocationCode,:LocationId,:MemberNo,:ObjectId,:OperDate,:Op
    erDesc,:OrderRoute,:OrderType,:OrderUser)

           9,891           9,891              1.0       0.00        0.23 1562239881
    Module: w3wp.exe
    SELECT GID,ATTTYPE,BEGINDATE,BOSSMERCHCODE,CONFIRM,CPSCALE,DESCR
    IPTION,ENDDATE,
             FEECODE,FEEPOLICY_GID,LINKEDCP,LOCATION_GID,MERCHCODE,M
    ERCHNAME,MERCHTYPE,ORDERSTATUS,
                             PRODUCTATTRIBUTE,PRODUCTLEVEL,PUBLICTYP
    SQL ordered by Executions for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Executions Threshold:       100

                                                    CPU per    Elap per
     Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
    ———— ————— —————- ———– ———- ———-

           9,888           9,887              1.0       0.00        0.35 1027951557
    Module: w3wp.exe
    SELECT MAX(BOSSOPERDATE) FROM t_iiss_subscribe_today_log T WHERE
     T.MEMBERNO = :PHONENO AND T.OBJECTID = :OBJECTID

           9,786           9,784              1.0       0.00        0.06 1708099119
    Module: w3wp.exe
    SELECT SEQ_IISS_SUBID.NEXTVAL FROM DUAL

           9,763           9,764              1.0       0.00        0.10  113072953
    Module: w3wp.exe
    INSERT INTO T_IISS_SYNMCASSUBTEMP(GID,BEGINDATE,BOSSCODE,CONFIRM
    ,CORPACCOUNT,DESCRIPTION,ENDDATE,FIELD1,FIELD2,FIELD3,OBJECTID,O
    BJECTTYPE,ORDERROUTE,ORDERUSER,PHONENO,PRODUCTID,SERVICEID,SERVI

              ————————————————————-
    SQL ordered by Parse Calls for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Parse Calls Threshold:      1000

                               % Total
     Parse Calls  Executions   Parses  Hash Value
    ———— ———— ——– ———-
          29,823       29,823     7.76 3948238198
    update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts
    =:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13
    , 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cacheh
    int=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17) where ts#=:1
     and file#=:2 and block#=:3

          26,802       26,730     6.98 4287674937
    Module: aplogic.exe
    begin P_SCE_GetVocSMDataNew (: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); end;

          23,155       23,149     6.03 1006414593
    select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#
    ,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N
    VL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3

          20,336       20,345     5.29 3799156924
    Module: w3wp.exe
    INSERT INTO T_IISS_INTERBOSS_LOG(GID,FILESEQ,FILETYPE,LOGCONTENT
    ,LOGDATE,LOGTYPE,ORGANIGER,OUTCOME,PROVINCECODE) VALUES(:GID,:Fi
    leSeq,:FileType,:LogContent,:LogDate,:LogType,:Organiger,:Outcom
    e,:ProvinceCode)

          20,329       20,321     5.29 1952010973
    Module: w3wp.exe
    INSERT INTO T_IISS_BOSSFILE(GID,FILENAME,FILETYPE,LOGDATE,ORGANI
    GER,PHONE,PROVINCECODE,REQUESTTYPE,SEQ) VALUES(:GID,:FileName,:F
    ileType,:LogDate,:Organiger,:Phone,:ProvinceCode,:RequestType,:S
    eq)

          20,308       20,323     5.29 3628115315
    Module: w3wp.exe
    SELECT SEQ_IISS_BOSSFILE.NEXTVAL FROM DUAL

          20,246       20,306     5.27 2856633856
    Module: w3wp.exe
    SELECT SEQ_IISS_INTERBOSS_LOG.NEXTVAL FROM DUAL

          15,078       15,078     3.92 1380021873
    update tsq$ set blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv
    2=:7,priv3=:8 where ts#=:1 and user#=:2

          15,047       15,025     3.92 1254950678
    select file# from file$ where ts#=:1

          10,603       10,603     2.76 3716207873
    update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
    order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
    1

          10,355       10,353     2.69  121882572
    Module: w3wp.exe
    SQL ordered by Parse Calls for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Parse Calls Threshold:      1000

                               % Total
     Parse Calls  Executions   Parses  Hash Value
    ———— ———— ——– ———-
    select BEGINNO,ENDNO,CITYNAME,DESCRIPTION,HOMELOCATIONCODE,LOCAT
    IONID,MODIFYDATE,PROVINCENAME
                           from t_iiss_numbersegment where BeginNO <
    = :phoneNo and endNo >= :phoneNo

          10,251       10,259     2.67 3270213255
    Module: w3wp.exe
    SELECT SEQ_IISS_UNION.NEXTVAL FROM DUAL

          10,233       10,233     2.66  276750471
    Module: w3wp.exe
    INSERT INTO T_IISS_SUBOPERATIONLOG(LOGID,ADDORDEL,LOCATIONCODE,L
    OCATIONID,MEMBERNO,OBJECTID,OBJECTNAME,OPERDATE,OPERDESC,ORDERRO
    UTE,ORDERTYPE,ORDERUSER,SUBSCRIBETYPE) VALUES(:LogId,:AddOrDel,:
    LocationCode,:LocationId,:MemberNo,:ObjectId,:ObjectName,:OperDa
    te,:OperDesc,:OrderRoute,:OrderType,:OrderUser,:SubscribeType)

          10,232       10,233     2.66 3412224227
    Module: w3wp.exe
    INSERT INTO T_IISS_SUBSCRIBE_TODAY_LOG(LOGID,ADDORDEL,BOSSOPERDA
    TE,LOCATIONCODE,LOCATIONID,MEMBERNO,OBJECTID,OPERDATE,OPERDESC,O
    RDERROUTE,ORDERTYPE,ORDERUSER) VALUES(:LogId,:AddOrDel,:BossOper
    Date,:LocationCode,:LocationId,:MemberNo,:ObjectId,:OperDate,:Op
    erDesc,:OrderRoute,:OrderType,:OrderUser)

           9,893        9,891     2.57 1562239881
    Module: w3wp.exe
    SELECT GID,ATTTYPE,BEGINDATE,BOSSMERCHCODE,CONFIRM,CPSCALE,DESCR
    IPTION,ENDDATE,
             FEECODE,FEEPOLICY_GID,LINKEDCP,LOCATION_GID,MERCHCODE,M
    ERCHNAME,MERCHTYPE,ORDERSTATUS,
                             PRODUCTATTRIBUTE,PRODUCTLEVEL,PUBLICTYP

           9,887        9,888     2.57 1027951557
    Module: w3wp.exe
    SELECT MAX(BOSSOPERDATE) FROM t_iiss_subscribe_today_log T WHERE
     T.MEMBERNO = :PHONENO AND T.OBJECTID = :OBJECTID

           9,786        9,786     2.55 1708099119
    Module: w3wp.exe
    SELECT SEQ_IISS_SUBID.NEXTVAL FROM DUAL

           9,771        9,763     2.54  113072953
    Module: w3wp.exe
    INSERT INTO T_IISS_SYNMCASSUBTEMP(GID,BEGINDATE,BOSSCODE,CONFIRM
    ,CORPACCOUNT,DESCRIPTION,ENDDATE,FIELD1,FIELD2,FIELD3,OBJECTID,O
    BJECTTYPE,ORDERROUTE,ORDERUSER,PHONENO,PRODUCTID,SERVICEID,SERVI
    CETYPE,SUBDATE,SYNDATE) VALUES(:Gid,:BeginDate,:BossCode,:Confir
    m,:CorpAccount,:Description,:EndDate,:Field1,:Field2,:Field3,:Ob

           5,597        5,596     1.46 1983404613
    Module: aplogic.exe
    begin p_sce_getid (:1, :2); end;

    SQL ordered by Parse Calls for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Parse Calls Threshold:      1000

                               % Total
     Parse Calls  Executions   Parses  Hash Value
    ———— ———— ——– ———-
           4,474        4,476     1.16 1946207931
    Module: HAWorker_SubContentNotify.exe
    begin :v_OPRNUMBER := F_IISS_GETOPRNUMBER; end;

           2,742            0     0.71  260339297
    insert into sys.col_usage$ values (   :objn, :coln,   decode(bit
    and(:flag,1),0,0,1),   decode(bitand(:flag,2),0,0,1),   decode(b
    itand(:flag,4),0,0,1),   decode(bitand(:flag,8),0,0,1),   decode
    (bitand(:flag,16),0,0,1),   decode(bitand(:flag,32),0,0,1),   :t
    ime)

           2,742        2,742     0.71 2554034351
    lock table sys.col_usage$ in exclusive mode nowait

           2,742        2,793     0.71 3665763022
    update sys.col_usage$ set   equality_preds    = equality_preds

              ————————————————————-
    Instance Activity Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Statistic                                      Total     per Second    per Trans
    ——————————— —————— ————– ————
    CPU used by this session                     178,615           46.8          3.3
    CPU used when call started                   115,951           30.4          2.1
    CR blocks created                             56,882           14.9          1.0
    Cached Commit SCN referenced                  49,677           13.0          0.9
    Commit SCN cached                                  8            0.0          0.0
    DBWR buffers scanned                         698,864          183.3         12.8
    DBWR checkpoint buffers written            1,282,754          336.4         23.4
    DBWR checkpoints                                   5            0.0          0.0
    DBWR cross instance writes                        13            0.0          0.0
    DBWR free buffers found                      673,110          176.5         12.3
    DBWR fusion writes                             6,754            1.8          0.1
    DBWR lru scans                                 4,059            1.1          0.1
    DBWR make free requests                        5,170            1.4          0.1
    DBWR revisited being-written buff                  0            0.0          0.0
    DBWR summed scan depth                       698,864          183.3         12.8
    DBWR transaction table writes                  1,038            0.3          0.0
    DBWR undo block writes                       734,974          192.8         13.4
    DFO trees parallelized                         1,224            0.3          0.0
    DML statements parallelized                    1,224            0.3          0.0
    PX local messages recv’d                     283,220           74.3          5.2
    PX local messages sent                       283,220           74.3          5.2
    PX remote messages recv’d                      3,788            1.0          0.1
    PX remote messages sent                        6,630            1.7          0.1
    Parallel operations downgraded to                170            0.0          0.0
    Parallel operations not downgrade              1,224            0.3          0.0
    RowCR – row contention                             0            0.0          0.0
    RowCR attempts                                   300            0.1          0.0
    RowCR hits                                       300            0.1          0.0
    SQL*Net roundtrips to/from client            355,646           93.3          6.5
    SQL*Net roundtrips to/from dblink                  0            0.0          0.0
    active txn count during cleanout             772,790          202.7         14.1
    background checkpoints completed                   4            0.0          0.0
    background checkpoints started                     5            0.0          0.0
    background timeouts                            7,273            1.9          0.1
    branch node splits                               775            0.2          0.0
    buffer is not pinned count                49,392,478       12,953.7        902.6
    buffer is pinned count                    31,646,028        8,299.5        578.3
    bytes received via SQL*Net from c        106,715,094       27,987.2      1,950.2
    bytes received via SQL*Net from d                  0            0.0          0.0
    bytes sent via SQL*Net to client          58,096,227       15,236.4      1,061.7
    bytes sent via SQL*Net to dblink                   0            0.0          0.0
    calls to get snapshot scn: kcmgss          1,975,458          518.1         36.1
    calls to kcmgas                            1,234,324          323.7         22.6
    calls to kcmgcs                              115,386           30.3          2.1
    change write time                            424,854          111.4          7.8
    cleanout – number of ktugct calls            572,853          150.2         10.5
    cluster key scan block gets                  225,417           59.1          4.1
    cluster key scans                             97,617           25.6          1.8
    commit cleanout failures: block l              2,356            0.6          0.0
    commit cleanout failures: buffer                 245            0.1          0.0
    commit cleanout failures: callbac              1,967            0.5          0.0
    commit cleanout failures: cannot               9,011            2.4          0.2
    commit cleanouts                           1,473,350          386.4         26.9
    commit cleanouts successfully com          1,459,771          382.8         26.7
    commit txn count during cleanout             373,702           98.0          6.8
    consistent changes                            88,739           23.3          1.6
    Instance Activity Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Statistic                                      Total     per Second    per Trans
    ——————————— —————— ————– ————
    consistent gets                           58,851,836       15,434.5      1,075.5
    consistent gets – examination              2,074,685          544.1         37.9
    current blocks converted for CR                    2            0.0          0.0
    cursor authentications                           147            0.0          0.0
    data blocks consistent reads – un             86,748           22.8          1.6
    db block changes                          30,604,739        8,026.4        559.3
    db block gets                             35,705,362        9,364.1        652.5
    deferred (CURRENT) block cleanout            245,044           64.3          4.5
    dirty buffers inspected                        5,785            1.5          0.1
    enqueue conversions                           12,284            3.2          0.2
    enqueue releases                             826,469          216.8         15.1
    enqueue requests                             828,509          217.3         15.1
    enqueue timeouts                               1,915            0.5          0.0
    enqueue waits                                105,277           27.6          1.9
    exchange deadlocks                             5,485            1.4          0.1
    execute count                                520,965          136.6          9.5
    failed probes on index block recl                  5            0.0          0.0
    free buffer inspected                         10,802            2.8          0.2
    free buffer requested                     14,225,277        3,730.7        260.0
    gcs messages sent                         13,518,590        3,545.4        247.1
    ges messages sent                            252,127           66.1          4.6
    global cache blocks lost                           4            0.0          0.0
    global cache convert time                     15,531            4.1          0.3
    global cache converts                         39,903           10.5          0.7
    global cache cr block build time               1,841            0.5          0.0
    global cache cr block flush time              10,116            2.7          0.2
    global cache cr block receive tim             25,414            6.7          0.5
    global cache cr block send time                   78            0.0          0.0
    global cache cr blocks received               18,729            4.9          0.3
    global cache cr blocks served                 18,195            4.8          0.3
    global cache current block flush               9,473            2.5          0.2
    global cache current block pin ti              9,831            2.6          0.2
    global cache current block receiv             39,259           10.3          0.7
    global cache current block send t              2,743            0.7          0.1
    global cache current blocks recei            309,383           81.1          5.7
    global cache current blocks serve            420,568          110.3          7.7
    global cache defers                            1,859            0.5          0.0
    global cache get time                        482,048          126.4          8.8
    global cache gets                         13,370,376        3,506.5        244.3
    global cache skip prepare failure             20,062            5.3          0.4
    global lock async converts                    68,247           17.9          1.3
    global lock async gets                        97,495           25.6          1.8
    global lock convert time                       4,921            1.3          0.1
    global lock get time                       3,028,139          794.2         55.3
    global lock releases                         864,989          226.9         15.8
    global lock sync converts                     72,772           19.1          1.3
    global lock sync gets                        846,298          222.0         15.5
    hot buffers moved to head of LRU             185,816           48.7          3.4
    immediate (CR) block cleanout app              5,732            1.5          0.1
    immediate (CURRENT) block cleanou            817,150          214.3         14.9
    index crx upgrade (found)                          0            0.0          0.0
    index crx upgrade (positioned)                 9,618            2.5          0.2
    index fast full scans (full)                       0            0.0          0.0
    index fetch by key                           265,326           69.6          4.9
    index scans kdiixs1                          724,336          190.0         13.2
    leaf node 90-10 splits                        14,731            3.9          0.3
    Instance Activity Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Statistic                                      Total     per Second    per Trans
    ——————————— —————— ————– ————
    leaf node splits                             249,379           65.4          4.6
    logons cumulative                              6,113            1.6          0.1
    messages received                            319,846           83.9          5.9
    messages sent                                319,850           83.9          5.9
    no buffer to keep pinned count                     0            0.0          0.0
    no work – consistent read gets            54,410,851       14,269.8        994.4
    opened cursors cumulative                    386,859          101.5          7.1
    parse count (failures)                             1            0.0          0.0
    parse count (hard)                             6,670            1.8          0.1
    parse count (total)                          384,252          100.8          7.0
    parse time cpu                                 5,735            1.5          0.1
    parse time elapsed                         1,170,892          307.1         21.4
    physical reads                            12,873,709        3,376.3        235.3
    physical reads direct                        115,558           30.3          2.1
    physical reads direct (lob)                        0            0.0          0.0
    physical writes                            1,716,173          450.1         31.4
    physical writes direct                       396,969          104.1          7.3
    physical writes non checkpoint             1,538,367          403.5         28.1
    pinned buffers inspected                       4,039            1.1          0.1
    prefetched blocks                         10,386,274        2,723.9        189.8
    prefetched blocks aged out before                 19            0.0          0.0
    process last non-idle time             2,438,707,030      639,577.0     44,567.0
    recursive calls                            4,184,590        1,097.5         76.5
    recursive cpu usage                           22,442            5.9          0.4
    redo blocks written                       19,419,446        5,093.0        354.9
    redo buffer allocation retries                81,483           21.4          1.5
    redo entries                              15,752,490        4,131.3        287.9
    redo log space requests                          363            0.1          0.0
    redo log space wait time                       1,345            0.4          0.0
    redo ordering marks                          700,425          183.7         12.8
    redo size                              1,223,713,240      320,931.9     22,363.2
    redo synch time                              754,155          197.8         13.8
    redo synch writes                             71,027           18.6          1.3
    redo wastage                              13,048,024        3,422.0        238.5
    redo write time                              284,098           74.5          5.2
    redo writer latching time                      3,177            0.8          0.1
    redo writes                                   52,243           13.7          1.0
    remote instance undo block writes                 13            0.0          0.0
    rollback changes – undo records a              2,998            0.8          0.1
    rows fetched via callback                    172,035           45.1          3.1
    session connect time                               0            0.0          0.0
    session cursor cache count                    11,719            3.1          0.2
    session cursor cache hits                    330,983           86.8          6.1
    session logical reads                     94,552,517       24,797.4      1,727.9
    session pga memory                     4,866,561,496    1,276,307.8     88,935.7
    session pga memory max               343,531,022,256   90,094,681.9  6,277,979.2
    session uga memory                 3,113,931,055,496  816,661,698.3 ############
    session uga memory max                 2,787,694,696      731,102.7     50,944.7
    shared hash latch upgrades – no w             49,624           13.0          0.9
    shared hash latch upgrades – wait                210            0.1          0.0
    sorts (disk)                                       7            0.0          0.0
    sorts (memory)                                93,747           24.6          1.7
    sorts (rows)                             119,387,467       31,310.6      2,181.8
    summed dirty queue length                     36,524            9.6          0.7
    switch current to new buffer                   2,182            0.6          0.0
    table fetch by rowid                      16,573,934        4,346.7        302.9
    Instance Activity Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Statistic                                      Total     per Second    per Trans
    ——————————— —————— ————– ————
    table fetch continued row                    265,695           69.7          4.9
    table scan blocks gotten                  46,589,770       12,218.7        851.4
    table scan rows gotten                    84,632,473       22,195.8      1,546.7
    table scans (long tables)                        223            0.1          0.0
    table scans (rowid ranges)                         0            0.0          0.0
    table scans (short tables)                   108,267           28.4          2.0
    transaction lock background gets                 264            0.1          0.0
    transaction lock foreground reque                263            0.1          0.0
    transaction lock foreground wait               1,507            0.4          0.0
    transaction rollbacks                          1,016            0.3          0.0
    transaction tables consistent rea                  8            0.0          0.0
    transaction tables consistent rea              1,598            0.4          0.0
    user calls                                   611,750          160.4         11.2
    user commits                                  54,346           14.3          1.0
    user rollbacks                                   374            0.1          0.0
    workarea executions – onepass                     14            0.0          0.0
    workarea executions – optimal                 68,398           17.9          1.3
    write clones created in backgroun                 10            0.0          0.0
    write clones created in foregroun              3,077            0.8          0.1
              ————————————————————-
    Tablespace IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by IOs (Reads + Writes) desc

    Tablespace
    ——————————
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    CORE_DAT
         1,343,628     352    2.9     6.4       43,773       11      4,531  249.3
    IISS_DAT
           693,952     182    5.4     1.8      191,257       50         34    2.4
    UNDOTBS2
                21       0   35.7     1.0      734,441      193     13,577    7.1
    IISS_IDX
           131,257      34    5.9     1.0      101,747       27          6   18.3
    CORE_BILL_DAT
           205,772      54   12.7     7.9       22,591        6      2,032   24.6
    CORE_SUBSCRIBE_ALL_IDX
             1,150       0   17.3     1.0      163,152       43    106,022   11.6
    BILL_DAT
           121,461      32   13.7     7.9       14,702        4          0    0.0
    CORE_IDX
            69,404      18    7.1     1.0       13,019        3        385   30.4
    MC_IDX
            23,129       6   37.7     1.0       51,168       13      1,699   35.0
    SERVICE_MAIN_DAT
            17,945       5    8.6     1.1        2,757        1      2,396   22.1
    NW_TEMP
             5,868       2   68.0    17.3        4,215        1          0    0.0
    CORE_SUBSCRIBE_ALL_DAT
                30       0    6.0     1.0        8,191        2        892    2.1
    UNDOTBS1
             6,237       2    9.0     1.0            0        0        521  530.4
    SYSTEM
             2,341       1   11.5     1.0          820        0      6,353    9.3
    MC_DAT
                41       0    9.8     1.0        1,960        1      3,907  375.5
    IISS_TEMP
               775       0   29.0    18.4          556        0          0    0.0
    CORE_BILL_IDX
                 0       0    0.0                  684        0          0    0.0
    CORE_SUBSCRIBE_DAT
               302       0    3.6     1.0            0        0          0    0.0
    SERVICE_LOG_DAT
               128       0  140.5     1.0           87        0          0    0.0
    USERS
                15       0   14.7     1.0          166        0          9   65.6
    ZWT_DAT
               129       0   12.9     2.8            0        0          0    0.0
    CORE_SUBSCRIBE_IDX
                77       0    3.9     1.0            0        0          0    0.0
    SERVICE_MAIN_IDX
                27       0    4.8     1.0           22        0          0    0.0
    ISSOP_DAT
                 6       0   21.7     1.0            0        0          0    0.0
    SERVICE_LOG_IDX
                 0       0    0.0                    2        0          0    0.0
    ICD_BILLLOG3
                 1       0   10.0     1.0            0        0          0    0.0
    Tablespace IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by IOs (Reads + Writes) desc

    Tablespace
    ——————————
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
              ————————————————————-
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    BILL_DAT                 /dev/rlv_4G_033
             5,904       2   10.9     7.9          316        0          0
                             /dev/rlv_4G_034
             3,778       1    9.7     7.6          506        0          0
                             /dev/rlv_4G_041
             2,474       1   11.1     7.9          985        0          0
                             /dev/rlv_4G_042
             2,431       1   10.9     7.8          477        0          0
                             /dev/rlv_4G_043
             2,421       1   10.5     7.8          861        0          0
                             /dev/rlv_4G_044
             2,342       1   11.7     8.0          999        0          0
                             /dev/rlv_4G_045
             2,369       1   10.4     7.9        1,125        0          0
                             /dev/rlv_4G_046
             2,385       1   10.4     7.9          902        0          0
                             /dev/rlv_4G_047
             2,358       1   10.4     7.9        1,050        0          0
                             /dev/rlv_4G_048
             2,383       1   11.4     7.9        1,004        0          0
                             /dev/rlv_4G_049
             2,345       1   11.3     8.0          415        0          0
                             /dev/rlv_4G_050
             2,366       1   10.8     7.9          900        0          0
                             /dev/rlv_4G_247
             5,774       2   11.4     7.9          889        0          0
                             /dev/rlv_4G_248
             5,785       2   10.7     7.9        1,003        0          0
                             /dev/rlv_4G_249
             5,922       2   11.1     7.9          725        0          0
                             /dev/rlv_4G_250
             5,896       2   10.7     7.9            0        0          0
                             /dev/rlv_4G_251
             5,982       2   10.9     7.9            0        0          0
                             /dev/rlv_4G_252
             6,262       2   10.5     7.9          416        0          0
                             /dev/rlv_4G_253
             6,127       2   11.1     7.9          437        0          0
                             /dev/rlv_4G_257
             4,598       1   10.5     7.9          157        0          0
                             /dev/rlv_4G_339
             1,943       1   21.1     8.0          449        0          0
                             /dev/rlv_4G_340
             4,560       1   19.7     7.9          156        0          0
                             /dev/rlv_4G_392
             4,837       1   19.0     7.9          118        0          0
                             /dev/rlv_4G_393
             5,034       1   19.8     7.9          285        0          0
                             /dev/rlv_4G_394
             4,935       1   17.7     8.0           78        0          0
                             /dev/rlv_4G_395
             5,311       1   19.9     7.9           78        0          0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    BILL_DAT                 /dev/rlv_4G_396
             5,736       2   18.9     7.9          141        0          0
                             /dev/rlv_4G_406
             4,626       1   19.6     7.9          113        0          0
                             /dev/rlv_4G_407
             4,577       1   19.2     7.9          117        0          0

    CORE_BILL_DAT            /dev/rlv_2G_086
             5,578       1   10.5     7.9          742        0         60   28.0
                             /dev/rlv_2G_087
             4,477       1   11.0     8.0          629        0         47   38.3
                             /dev/rlv_2G_088
             5,733       2    9.8     7.9          695        0         64   37.8
                             /dev/rlv_2G_089
             2,380       1   13.3     8.0          618        0         39   25.4
                             /dev/rlv_2G_094
               751       0    9.0     7.8          727        0         42   25.0
                             /dev/rlv_2G_095
               545       0   10.6     7.9          673        0         40   21.0
                             /dev/rlv_2G_096
               496       0   12.1     7.9          737        0         43   31.6
                             /dev/rlv_2G_097
               805       0    9.2     7.9          674        0         43   20.9
                             /dev/rlv_2G_187
             3,621       1   11.8     8.0          501        0         58   29.8
                             /dev/rlv_2G_188
             3,452       1   11.7     8.0          496        0         56   25.0
                             /dev/rlv_2G_191
             4,815       1   10.4     7.8          557        0         54   18.7
                             /dev/rlv_2G_192
             4,035       1   11.3     7.9          553        0         53   17.2
                             /dev/rlv_2G_194
             3,845       1   10.6     7.7          466        0         48   18.5
                             /dev/rlv_2G_195
             3,864       1   11.1     7.6          522        0         51   19.6
                             /dev/rlv_2G_241
             5,175       1   20.2     8.0          704        0         62   25.2
                             /dev/rlv_2G_242
             5,861       2   20.6     7.9          732        0         59   25.4
                             /dev/rlv_2G_243
             5,028       1   21.9     7.9          670        0         58   25.3
                             /dev/rlv_2G_285
             3,686       1   26.4     8.0          498        0         57   23.0
                             /dev/rlv_2G_286
             3,829       1   25.7     8.0          601        0         58   25.9
                             /dev/rlv_2G_287
             3,730       1   27.4     8.0          592        0         56   24.8
                             /dev/rlv_2G_288
             4,807       1   22.1     8.0          577        0         52   23.3
                             /dev/rlv_2G_289
             4,975       1   23.3     7.9          649        0         61   27.7
                             /dev/rlv_2G_294
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
             4,268       1   25.8     8.0          527        0         55   25.8
    CORE_BILL_DAT            /dev/rlv_2G_295
             4,191       1   26.4     8.0          524        0         55   22.4
                             /dev/rlv_2G_296
             4,343       1   26.8     8.0          563        0         65   24.2
                             /dev/rlv_4G_110
             6,085       2    9.9     7.9          715        0         49   15.1
                             /dev/rlv_4G_111
             5,972       2   10.4     8.0          649        0         45   19.6
                             /dev/rlv_4G_112
             5,851       2    9.9     7.9          590        0         43   19.5
                             /dev/rlv_4G_113
             5,739       2    9.8     8.0          607        0         47   21.3
                             /dev/rlv_4G_114
             5,737       2    9.3     7.9          576        0         46   24.6
                             /dev/rlv_4G_115
            10,428       3    7.5     8.0          504        0         47   26.8
                             /dev/rlv_4G_116
            10,391       3    6.9     8.0          456        0         46   22.6
                             /dev/rlv_4G_117
            11,034       3    6.7     8.0          481        0         52   22.1
                             /dev/rlv_4G_118
            10,939       3    7.0     8.0          491        0         50   22.4
                             /dev/rlv_4G_119
             9,689       3    7.3     8.0          515        0         48   27.1
                             /dev/rlv_4G_120
             8,340       2    7.5     8.0          407        0         47   23.4
                             /dev/rlv_4G_121
             9,181       2    8.1     7.7          433        0         46   22.6
                             /dev/rlv_4G_255
             6,244       2   10.9     7.9          446        0         70   25.0
                             /dev/rlv_4G_258
             5,852       2   11.0     7.9          494        0         60   29.0

    CORE_BILL_IDX            /dev/rlv_2G_148
                 0       0                          83        0          0
                             /dev/rlv_2G_149
                 0       0                          52        0          0
                             /dev/rlv_2G_228
                 0       0                          60        0          0
                             /dev/rlv_2G_229
                 0       0                          61        0          0
                             /dev/rlv_4G_122
                 0       0                          85        0          0
                             /dev/rlv_4G_123
                 0       0                          36        0          0
                             /dev/rlv_4G_124
                 0       0                          90        0          0
                             /dev/rlv_4G_125
                 0       0                          58        0          0
                             /dev/rlv_4G_126
                 0       0                          34        0          0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    CORE_BILL_IDX            /dev/rlv_4G_127
                 0       0                          79        0          0
                             /dev/rlv_4G_128
                 0       0                          46        0          0

    CORE_DAT                 /dev/rlv_2G_090
             1,037       0    2.0     1.0            8        0          0
                             /dev/rlv_2G_091
             1,035       0    2.2     1.0            7        0          0
                             /dev/rlv_2G_092
             1,029       0    2.0     1.0            5        0          2    0.0
                             /dev/rlv_2G_132
             1,038       0    2.3     1.0           21        0          0
                             /dev/rlv_2G_133
             1,077       0    1.9     1.0           51        0          0
                             /dev/rlv_2G_134
             1,056       0    2.4     1.0           31        0          1   10.0
                             /dev/rlv_2G_135
             1,046       0    1.9     1.0           13        0          0
                             /dev/rlv_2G_136
             1,060       0    1.7     1.0           16        0          0
                             /dev/rlv_2G_137
             1,069       0    3.0     1.0           46        0         89  319.3
                             /dev/rlv_2G_138
             1,040       0    2.5     1.0           16        0          0
                             /dev/rlv_2G_139
             1,042       0    2.4     1.0           14        0          0
                             /dev/rlv_2G_140
             1,050       0    2.5     1.0           87        0          0
                             /dev/rlv_2G_141
             1,034       0    1.9     1.0           31        0          0
                             /dev/rlv_2G_142
             1,057       0    2.4     1.0           21        0          0
                             /dev/rlv_2G_143
             1,038       0    2.6     1.0           15        0          0
                             /dev/rlv_2G_144
             1,071       0    3.0     1.0           19        0          0
                             /dev/rlv_2G_145
             1,057       0    2.6     1.0           41        0          0
                             /dev/rlv_2G_146
             1,048       0    2.6     1.0           27        0          0
                             /dev/rlv_2G_147
             1,039       0    1.8     1.0           25        0          0
                             /dev/rlv_2G_153
            23,870       6    0.9     7.6            7        0          0
                             /dev/rlv_2G_154
            23,994       6    1.0     7.6           12        0          0
                             /dev/rlv_2G_155
            24,338       6    1.0     7.5           26        0          0
                             /dev/rlv_2G_156
            25,137       7    1.1     7.3          117        0          0
                             /dev/rlv_2G_157
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
            25,077       7    1.0     7.3           70        0          0
    CORE_DAT                 /dev/rlv_2G_158
            24,199       6    1.0     7.5           28        0          0
                             /dev/rlv_2G_159
            24,307       6    1.0     7.5           17        0          0
                             /dev/rlv_2G_162
            24,411       6    1.0     7.5           31        0          0
                             /dev/rlv_2G_163
            24,414       6    1.1     7.5           70        0          4   25.0
                             /dev/rlv_2G_164
            36,613      10    0.8     4.3           52        0          3   23.3
                             /dev/rlv_2G_165
            24,404       6    1.1     7.5           36        0          0
                             /dev/rlv_2G_166
            24,194       6    1.2     7.6           20        0          0
                             /dev/rlv_2G_168
               580       0   10.8     1.0        1,042        0          3   46.7
                             /dev/rlv_2G_169
               304       0   40.9     1.0           16        0          4   10.0
                             /dev/rlv_2G_170
               475       0   10.3     1.0           38        0          5   10.0
                             /dev/rlv_2G_171
            26,391       7    1.6     7.2           63        0          6   21.7
                             /dev/rlv_2G_172
            23,438       6    1.1     7.7           68        0          1   10.0
                             /dev/rlv_2G_173
            23,744       6    1.3     7.7           60        0          2    5.0
                             /dev/rlv_2G_174
            50,701      13    1.0     7.0           71        0          0
                             /dev/rlv_2G_175
               342       0    4.2     1.0           50        0          0
                             /dev/rlv_2G_176
               519       0    5.2     1.0           97        0          0
                             /dev/rlv_2G_177
            12,100       3    1.5     7.5          135        0          1   10.0
                             /dev/rlv_2G_178
               766       0    4.3     1.0          110        0          3   26.7
                             /dev/rlv_2G_179
               715       0    7.1     1.0          561        0      3,154  332.4
                             /dev/rlv_2G_180
             1,296       0   10.7     1.0        1,104        0          4    7.5
                             /dev/rlv_2G_181
             1,326       0   10.1     1.0        1,596        0         10    8.0
                             /dev/rlv_2G_232
             1,024       0    4.4     1.0            0        0          0
                             /dev/rlv_2G_233
             1,022       0    5.3     1.0            7        0          0
                             /dev/rlv_2G_234
               104       0    9.6     1.0            5        0          0
                             /dev/rlv_2G_235
                 1       0   10.0     1.0            2        0          0
                             /dev/rlv_2G_236
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
                29       0   33.1     1.6           24        0          0
    CORE_DAT                 /dev/rlv_2G_247
            23,962       6    3.3     7.6           26        0          0
                             /dev/rlv_2G_248
            24,008       6    2.7     7.6           29        0          0
                             /dev/rlv_2G_249
            23,954       6    3.0     7.6           14        0          0
                             /dev/rlv_2G_250
            23,971       6    3.0     7.6           25        0          0
                             /dev/rlv_2G_251
            23,970       6    3.0     7.6           18        0          2   50.0
                             /dev/rlv_2G_252
            24,008       6    2.7     7.6           17        0          0
                             /dev/rlv_2G_253
            24,890       7    2.8     7.3           49        0          0
                             /dev/rlv_2G_254
            24,860       7    2.8     7.4          105        0          0
                             /dev/rlv_2G_255
            24,145       6    2.6     7.5           57        0          0
                             /dev/rlv_2G_256
            23,886       6    2.7     7.6           39        0          0
                             /dev/rlv_2G_257
            24,235       6    3.1     7.5           26        0          0
                             /dev/rlv_2G_258
            23,188       6    3.0     7.8           78        0          0
                             /dev/rlv_2G_259
            23,219       6    3.1     7.8          117        0          0
                             /dev/rlv_2G_260
            23,748       6    4.5     7.7          712        0          4   30.0
                             /dev/rlv_2G_261
            24,431       6    4.8     7.4        1,281        0          1   50.0
                             /dev/rlv_2G_262
            24,010       6    4.1     7.6        2,310        1          1   10.0
                             /dev/rlv_2G_263
            24,045       6    3.6     7.6        1,053        0          0
                             /dev/rlv_2G_264
            23,510       6    3.2     7.7           71        0          0
                             /dev/rlv_2G_265
            23,326       6    3.0     7.7           63        0          0
                             /dev/rlv_2G_272
             1,342       0   30.6     1.0          986        0         23  408.7
                             /dev/rlv_2G_273
             1,276       0   20.6     1.1          652        0         10   33.0
                             /dev/rlv_2G_274
             4,705       1   13.0     5.2          688        0          3   56.7
                             /dev/rlv_2G_275
             4,709       1   10.9     5.2          670        0          5   68.0
                             /dev/rlv_2G_276
             1,524       0   22.6     1.0          489        0          7   31.4
                             /dev/rlv_2G_277
             1,287       0   18.3     1.0          464        0          9   34.4
                             /dev/rlv_2G_278
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
             1,474       0   27.9     1.0          471        0          3    6.7
    CORE_DAT                 /dev/rlv_2G_279
             1,407       0   17.1     1.0          903        0         76   15.1
                             /dev/rlv_2G_280
             4,307       1    8.1     5.6          465        0          4   80.0
                             /dev/rlv_2G_281
             3,816       1    6.6     6.2          403        0          1   30.0
                             /dev/rlv_2G_282
             3,956       1    7.4     6.0          707        0          4   45.0
                             /dev/rlv_2G_283
             4,159       1    8.2     5.7          744        0          8   48.8
                             /dev/rlv_2G_290
             4,341       1   13.9     5.6          911        0          2    5.0
                             /dev/rlv_2G_291
             1,268       0   20.9     1.2          705        0         16   15.6
                             /dev/rlv_2G_292
             1,354       0   22.1     1.2          753        0         14   31.4
                             /dev/rlv_4G_051
             3,598       1    5.5     1.3          198        0          0
                             /dev/rlv_4G_052
            15,164       4    2.7     6.3          578        0          3    3.3
                             /dev/rlv_4G_053
            32,266       8    1.7     7.2          541        0          2   10.0
                             /dev/rlv_4G_054
             9,477       2    3.2     5.3          481        0          3   13.3
                             /dev/rlv_4G_055
             9,452       2    3.3     5.3          475        0         12   45.8
                             /dev/rlv_4G_056
             9,616       3    5.4     5.2          452        0          8   42.5
                             /dev/rlv_4G_057
             9,601       3    3.1     5.2          579        0         11   43.6
                             /dev/rlv_4G_058
             9,294       2    2.9     5.3          629        0        175   15.8
                             /dev/rlv_4G_059
             9,116       2    2.8     5.4          514        0          7   28.6
                             /dev/rlv_4G_060
             9,492       2    2.7     5.4          697        0         11   10.0
                             /dev/rlv_4G_061
             9,887       3    4.2     5.2          892        0        120    5.4
                             /dev/rlv_4G_062
            10,061       3    3.1     5.1          687        0          9   15.6
                             /dev/rlv_4G_063
            10,925       3    3.3     4.8          847        0          9   40.0
                             /dev/rlv_4G_064
            11,410       3    4.2     4.6          904        0          6   23.3
                             /dev/rlv_4G_065
            12,000       3    4.4     4.5          676        0          3    6.7
                             /dev/rlv_4G_066
            14,113       4    2.7     3.9          901        0          6   10.0
                             /dev/rlv_4G_067
            14,145       4    2.8     3.9          787        0         15   26.0
                             /dev/rlv_4G_068
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
            14,444       4    2.8     3.8          836        0         12   37.5
    CORE_DAT                 /dev/rlv_4G_069
            13,801       4    3.1     4.0        1,138        0        322   46.6
                             /dev/rlv_4G_070
            29,167       8    2.4     5.8          801        0        135   35.6
                             /dev/rlv_4G_071
            13,499       4    3.4     4.1          870        0          6   25.0
                             /dev/rlv_4G_072
            13,647       4    3.2     4.1          792        0          8   20.0
                             /dev/rlv_4G_073
            13,944       4    4.1     4.0          890        0         86  116.3
                             /dev/rlv_4G_074
            13,371       4    4.7     4.2          783        0         34   12.4
                             /dev/rlv_4G_075
            13,308       3    3.6     4.2          782        0         11   13.6
                             /dev/rlv_4G_076
            13,094       3    3.6     4.1          908        0          9   15.6
                             /dev/rlv_4G_077
            11,964       3    3.6     4.4          783        0          2    5.0
                             /dev/rlv_4G_078
            11,569       3    3.7     4.7          806        0          9    6.7
                             /dev/rlv_4G_079
            11,297       3    3.8     4.6          810        0         10   30.0
                             /dev/rlv_4G_080
             4,857       1   10.4     1.3          606        0          2    5.0

    CORE_IDX                 /dev/rlv_2G_237
               819       0    7.6     1.0           50        0          0
                             /dev/rlv_2G_238
               696       0    4.8     1.0           63        0          0
                             /dev/rlv_2G_239
               638       0    5.1     1.0          210        0        179   36.1
                             /dev/rlv_4G_081
             2,210       1    9.0     1.0          312        0          4   15.0
                             /dev/rlv_4G_082
             2,241       1    9.6     1.0          493        0          2    5.0
                             /dev/rlv_4G_083
             4,239       1    8.2     1.0          675        0          3    3.3
                             /dev/rlv_4G_084
             2,297       1    5.7     1.0          444        0          3   10.0
                             /dev/rlv_4G_085
             2,954       1    7.7     1.0          300        0          0
                             /dev/rlv_4G_086
             2,897       1    4.1     1.0          283        0          1   20.0
                             /dev/rlv_4G_087
             2,036       1   10.6     1.0          349        0          4    2.5
                             /dev/rlv_4G_088
             2,031       1    6.1     1.0          491        0          1   20.0
                             /dev/rlv_4G_089
             2,252       1    6.5     1.0          550        0          6    8.3
                             /dev/rlv_4G_090
             2,024       1    6.1     1.0          491        0          5   10.0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    CORE_IDX                 /dev/rlv_4G_091
             1,953       1    6.0     1.0          299        0         15   17.3
                             /dev/rlv_4G_092
             1,812       0    6.1     1.0          367        0         13   23.1
                             /dev/rlv_4G_093
             1,632       0    6.5     1.0          498        0          1   10.0
                             /dev/rlv_4G_094
             1,756       0    5.8     1.0          469        0          1   20.0
                             /dev/rlv_4G_095
             2,007       1    5.4     1.0          403        0          4    7.5
                             /dev/rlv_4G_096
             2,037       1    5.7     1.0          276        0          0
                             /dev/rlv_4G_097
             2,049       1    6.3     1.0          891        0         56    6.3
                             /dev/rlv_4G_098
             2,270       1    5.7     1.0          210        0          0
                             /dev/rlv_4G_099
             2,485       1    5.3     1.0          309        0          7   12.9
                             /dev/rlv_4G_100
             2,738       1   10.5     1.0          327        0          0
                             /dev/rlv_4G_101
             2,412       1    6.1     1.0          515        0          4   20.0
                             /dev/rlv_4G_102
             2,322       1    6.5     1.0          515        0          4  142.5
                             /dev/rlv_4G_103
             2,270       1   10.4     1.0          490        0          2    5.0
                             /dev/rlv_4G_104
             2,526       1   13.2     1.0          565        0          7   10.0
                             /dev/rlv_4G_105
             2,271       1   11.4     1.0          632        0          7   37.1
                             /dev/rlv_4G_106
             2,374       1    5.2     1.0          461        0         10   11.0
                             /dev/rlv_4G_107
             2,308       1    5.8     1.0          453        0         35   77.4
                             /dev/rlv_4G_108
             2,405       1    5.7     1.0          336        0          6    8.3
                             /dev/rlv_4G_109
             2,443       1    4.8     1.0          292        0          5    8.0

    CORE_SUBSCRIBE_ALL_DAT   /dev/rlv_2G_072
                16       0    7.5     1.0        1,894        0        161    0.1
                             /dev/rlv_2G_073
                14       0    4.3     1.0        5,179        1        717    2.6
                             /dev/rlv_2G_240
                 0       0                       1,118        0         14    0.0

    CORE_SUBSCRIBE_ALL_IDX   /dev/rlv_2G_074
               232       0   14.7     1.0       34,836        9     30,798   14.1
                             /dev/rlv_2G_075
               183       0   14.0     1.0       32,230        8     18,523   21.6
                             /dev/rlv_2G_131
               139       0   14.3     1.0       33,546        9     21,398    7.3
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    CORE_SUBSCRIBE_ALL_IDX   /dev/rlv_2G_196
               422       0   13.7     1.0       31,724        8     16,762    6.8
                             /dev/rlv_2G_271
               174       0   35.7     1.0       30,816        8     18,541    6.8

    CORE_SUBSCRIBE_DAT       /dev/rlv_2G_022
               128       0    3.0     1.0            0        0          0
                             /dev/rlv_2G_023
                46       0    3.7     1.0            0        0          0
                             /dev/rlv_2G_036
               128       0    4.1     1.0            0        0          0

    CORE_SUBSCRIBE_IDX       /dev/rlv_2G_051
                77       0    3.9     1.0            0        0          0

    ICD_BILLLOG3             /dev/rlv_4G_296
                 1       0   10.0     1.0            0        0          0

    IISS_DAT                 /dev/rlv_4G_020
            16,001       4    4.1     2.0        1,942        1          0
                             /dev/rlv_4G_021
             4,858       1    4.0     1.3        1,475        0          0
                             /dev/rlv_4G_022
            25,355       7    3.8     2.1        1,562        0          0
                             /dev/rlv_4G_023
            24,458       6    3.7     2.1        1,228        0          0
                             /dev/rlv_4G_024
            24,209       6    3.8     2.1        1,375        0          0
                             /dev/rlv_4G_025
            23,571       6    3.5     2.1        1,600        0          0
                             /dev/rlv_4G_026
            22,884       6    3.7     2.1        1,434        0          0
                             /dev/rlv_4G_027
            23,367       6    3.8     2.1        1,408        0          0
                             /dev/rlv_4G_028
            23,244       6    3.7     2.1        1,978        1          0
                             /dev/rlv_4G_029
            22,582       6    3.7     2.1        1,153        0          0
                             /dev/rlv_4G_204
             1,694       0    3.6     1.0          577        0          0
                             /dev/rlv_4G_239
             3,022       1    2.9     1.0          524        0          0
                             /dev/rlv_4G_240
             1,549       0    3.0     1.0          409        0          0
                             /dev/rlv_4G_241
             1,886       0    4.2     1.0        1,425        0          0
                             /dev/rlv_4G_242
             1,997       1    3.9     1.0          340        0          0
                             /dev/rlv_4G_243
             1,772       0    2.9     1.0          300        0          0
                             /dev/rlv_4G_244
             1,742       0    3.5     1.0          355        0          0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    IISS_DAT                 /dev/rlv_4G_245
             1,771       0    3.5     1.0          396        0          0
                             /dev/rlv_4G_256
             3,194       1    3.3     1.0          519        0          0
                             /dev/rlv_4G_259
             3,593       1    3.1     1.0          605        0          0
                             /dev/rlv_4G_266
             3,099       1    3.4     1.0          553        0          0
                             /dev/rlv_4G_269
             4,243       1    2.9     1.0          864        0          0
                             /dev/rlv_4G_270
               877       0    8.0     1.0        1,088        0          0
                             /dev/rlv_4G_274
             1,371       0    3.6     1.0        1,193        0          0
                             /dev/rlv_4G_275
             2,810       1    2.9     1.0        1,428        0          0
                             /dev/rlv_4G_276
            20,353       5    3.6     2.3        1,275        0          0
                             /dev/rlv_4G_277
            20,989       6    3.7     2.2        1,619        0          0
                             /dev/rlv_4G_278
            21,533       6    3.8     2.2        1,319        0          0
                             /dev/rlv_4G_279
             2,600       1    3.0     1.1        1,494        0          0
                             /dev/rlv_4G_282
             3,097       1    2.9     1.1        1,487        0          0
                             /dev/rlv_4G_283
             2,408       1    3.4     1.1        1,438        0          3   13.3
                             /dev/rlv_4G_284
            21,468       6    3.8     2.2        1,296        0          0
                             /dev/rlv_4G_285
             3,905       1    3.3     1.3        1,155        0          0
                             /dev/rlv_4G_286
             4,135       1    3.3     1.3          805        0          0
                             /dev/rlv_4G_302
             2,187       1    8.9     2.4       28,409        7          0
                             /dev/rlv_4G_303
             2,338       1    6.8     1.0       15,856        4          0
                             /dev/rlv_4G_304
             2,212       1    6.9     1.0       11,348        3          0
                             /dev/rlv_4G_305
             2,295       1    6.7     1.0        8,329        2          0
                             /dev/rlv_4G_306
             2,009       1    8.6     1.0        8,415        2          0
                             /dev/rlv_4G_307
             2,315       1    9.4     1.0        6,260        2          0
                             /dev/rlv_4G_308
             2,009       1    8.5     1.0        6,538        2          0
                             /dev/rlv_4G_309
             1,876       0    9.4     1.0        6,236        2          0
                             /dev/rlv_4G_310
               772       0   10.9     1.0        3,513        1          0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    IISS_DAT                 /dev/rlv_4G_311
             3,723       1    7.6     1.0        3,351        1          0
                             /dev/rlv_4G_312
             5,642       1    7.6     1.0        2,850        1          0
                             /dev/rlv_4G_313
             6,913       2    6.3     1.0        2,806        1          0
                             /dev/rlv_4G_314
             7,348       2    6.5     1.0        3,078        1          0
                             /dev/rlv_4G_315
             9,327       2    6.0     1.0        2,947        1          0
                             /dev/rlv_4G_316
             9,861       3    7.1     1.0        3,205        1          0
                             /dev/rlv_4G_317
             9,986       3    7.7     1.0        3,020        1          0
                             /dev/rlv_4G_318
             8,297       2    7.4     1.0        2,794        1          0
                             /dev/rlv_4G_319
             7,186       2    8.2     1.0        2,204        1          0
                             /dev/rlv_4G_320
             6,603       2    8.8     1.0        1,899        0          0
                             /dev/rlv_4G_321
             5,867       2    7.0     1.0        2,046        1          0
                             /dev/rlv_4G_322
             6,368       2    7.4     1.2        2,738        1          0
                             /dev/rlv_4G_323
            25,535       7    7.5     2.1        2,278        1          0
                             /dev/rlv_4G_324
            24,992       7    7.3     2.1        2,099        1          0
                             /dev/rlv_4G_325
            25,306       7    7.4     2.1        1,945        1          0
                             /dev/rlv_4G_326
            24,353       6    7.2     2.1        1,762        0          0
                             /dev/rlv_4G_327
            23,840       6    7.0     2.2        1,211        0          0
                             /dev/rlv_4G_338
             2,443       1    8.4     1.0          557        0          0
                             /dev/rlv_4G_357
             2,274       1    4.2     1.0          840        0          0
                             /dev/rlv_4G_387
             2,425       1    4.1     1.0          334        0          0
                             /dev/rlv_4G_388
             3,153       1    5.3     1.0          702        0          0
                             /dev/rlv_4G_389
             2,252       1    5.1     1.0        1,054        0          0
                             /dev/rlv_4G_405
             2,625       1    6.2     1.0          532        0          0
                             /dev/rlv_4G_412
             2,346       1    5.4     1.0          396        0          0
                             /dev/rlv_4G_413
             4,880       1    6.1     1.0        2,400        1          0
                             /dev/rlv_4G_415
             1,056       0   11.2     1.0          888        0          0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    IISS_DAT                 /dev/rlv_4G_416
             2,069       1    5.5     1.0          919        0          0
                             /dev/rlv_4G_417
             2,280       1    4.7     1.0          518        0          0
                             /dev/rlv_4G_418
             2,044       1    5.6     1.0        1,155        0          0
                             /dev/rlv_4G_419
             1,782       0    7.3     1.0          988        0         31    1.3
                             /dev/rlv_4G_420
             2,195       1    5.8     1.0        1,344        0          0
                             /dev/rlv_4G_421
            20,811       5    7.7     2.2        1,644        0          0
                             /dev/rlv_4G_422
            21,224       6    7.5     2.2          573        0          0
                             /dev/rlv_4G_423
            19,905       5    7.5     2.3          493        0          0
                             /dev/rlv_4G_424
             1,251       0    4.7     1.0          426        0          0
                             /dev/rlv_4G_430
            22,140       6    6.7     2.2          738        0          0

    IISS_IDX                 /dev/rlv_4G_006
             5,172       1    4.7     1.0        1,614        0          0
                             /dev/rlv_4G_007
             5,391       1    4.2     1.0        1,919        1          0
                             /dev/rlv_4G_008
             5,113       1    4.5     1.0        1,675        0          0
                             /dev/rlv_4G_009
             2,053       1   12.2     1.0        1,638        0          0
                             /dev/rlv_4G_010
               211       0    7.0     1.0        1,623        0          0
                             /dev/rlv_4G_011
             4,176       1    4.5     1.0        1,592        0          0
                             /dev/rlv_4G_012
             3,710       1    4.2     1.0        1,812        0          0
                             /dev/rlv_4G_013
             2,624       1    3.6     1.0        2,165        1          0
                             /dev/rlv_4G_014
             3,636       1    4.3     1.0        2,183        1          0
                             /dev/rlv_4G_015
             4,747       1    4.8     1.0       18,443        5          0
                             /dev/rlv_4G_016
             3,633       1    4.2     1.0        7,727        2          0
                             /dev/rlv_4G_017
             3,999       1    4.3     1.0        5,525        1          0
                             /dev/rlv_4G_018
             8,990       2    4.0     1.0        4,642        1          0
                             /dev/rlv_4G_213
               312       0   15.1     1.0        2,676        1          2   15.0
                             /dev/rlv_4G_246
             4,388       1    5.9     1.0        3,718        1          0
                             /dev/rlv_4G_254
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
             3,793       1    5.7     1.0        3,058        1          2   30.0
    IISS_IDX                 /dev/rlv_4G_262
             3,056       1    5.5     1.0        3,012        1          0
                             /dev/rlv_4G_263
             2,054       1    6.3     1.0        2,637        1          0
                             /dev/rlv_4G_264
             1,954       1    5.8     1.0        2,507        1          0
                             /dev/rlv_4G_267
             5,019       1    7.2     1.0        4,569        1          2   10.0
                             /dev/rlv_4G_268
             3,925       1    4.3     1.0        3,015        1          0
                             /dev/rlv_4G_272
             7,112       2    4.9     1.0        2,004        1          0
                             /dev/rlv_4G_273
             6,594       2    5.2     1.0        2,178        1          0
                             /dev/rlv_4G_280
             5,021       1    4.1     1.0        1,568        0          0
                             /dev/rlv_4G_281
             7,241       2    4.2     1.0        1,847        0          0
                             /dev/rlv_4G_331
             4,772       1   10.0     1.0        3,971        1          0
                             /dev/rlv_4G_332
             4,421       1    8.9     1.0        3,714        1          0
                             /dev/rlv_4G_333
             4,649       1    8.2     1.0        3,401        1          0
                             /dev/rlv_4G_334
             4,351       1    9.2     1.0        3,251        1          0
                             /dev/rlv_4G_429
             9,140       2   11.1     1.0        2,063        1          0

    IISS_TEMP                /dev/rlv_4G_202
               277       0   13.8    20.5          222        0          0
                             /dev/rlv_4G_414
               498       0   37.4    17.2          334        0          0

    ISSOP_DAT                /dev/rlv_4G_038
                 6       0   21.7     1.0            0        0          0

    MC_DAT                   /dev/rlv_4G_136
                 1       0   10.0     1.0           21        0         12   40.8
                             /dev/rlv_4G_137
                 1       0   10.0     1.0           40        0         12   22.5
                             /dev/rlv_4G_138
                 1       0   10.0     1.0          388        0        354   66.9
                             /dev/rlv_4G_139
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_140
                 2       0   15.0     1.0           22        0          4    0.0
                             /dev/rlv_4G_141
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_142
                 2       0    5.0     1.0            0        0          0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    MC_DAT                   /dev/rlv_4G_143
                 0       0                          11        0         15   80.7
                             /dev/rlv_4G_148
                 0       0                          26        0         25   53.6
                             /dev/rlv_4G_157
                 0       0                           1        0          0
                             /dev/rlv_4G_169
                 1       0   30.0     1.0            5        0         63  909.8
                             /dev/rlv_4G_170
                 1       0    0.0     1.0           14        0          0
                             /dev/rlv_4G_171
                 0       0                          18        0         15   74.7
                             /dev/rlv_4G_172
                 1       0    0.0     1.0            0        0          0
                             /dev/rlv_4G_173
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_174
                 2       0   15.0     1.0            0        0          0
                             /dev/rlv_4G_206
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_207
                 2       0   25.0     1.0          197        0          1    0.0
                             /dev/rlv_4G_208
                 3       0    6.7     1.0          214        0        351   67.0
                             /dev/rlv_4G_209
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_210
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_211
                 2       0    5.0     1.0            0        0          0
                             /dev/rlv_4G_212
                 2       0    5.0     1.0           24        0          0
                             /dev/rlv_4G_214
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_215
                 2       0   10.0     1.0            0        0          0
                             /dev/rlv_4G_216
                 2       0    5.0     1.0          979        0      3,055  444.6
                             /dev/rlv_4G_217
                 2       0    5.0     1.0            0        0          0

    MC_IDX                   /dev/rlv_4G_342
               552       0   33.8     1.0        1,631        0         23   30.9
                             /dev/rlv_4G_343
               517       0   31.8     1.0        1,122        0          6   31.7
                             /dev/rlv_4G_344
               565       0   51.0     1.0        1,512        0        381   21.6
                             /dev/rlv_4G_345
               624       0   35.9     1.0        1,341        0          2  140.0
                             /dev/rlv_4G_346
               567       0   37.0     1.0        1,141        0         14   67.1
                             /dev/rlv_4G_347
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
               828       0   35.2     1.0        1,584        0          9   51.1
    MC_IDX                   /dev/rlv_4G_348
             1,008       0   49.8     1.0        1,856        0         21   30.5
                             /dev/rlv_4G_349
               874       0   34.9     1.0        1,757        0         11   58.2
                             /dev/rlv_4G_350
               752       0   35.1     1.0        1,268        0          6   91.7
                             /dev/rlv_4G_351
               682       0   34.6     1.0        1,342        0         10   29.0
                             /dev/rlv_4G_352
               814       0   57.9     1.0        1,556        0          7  175.7
                             /dev/rlv_4G_353
               801       0   33.9     1.0        1,971        1        380    4.8
                             /dev/rlv_4G_354
               782       0   36.6     1.0        1,405        0          8   93.8
                             /dev/rlv_4G_355
               839       0   33.3     1.0        1,620        0         83  197.2
                             /dev/rlv_4G_356
               668       0   35.4     1.0        1,392        0         80   13.6
                             /dev/rlv_4G_361
               483       0   36.5     1.0          783        0          1  120.0
                             /dev/rlv_4G_362
               477       0   35.9     1.0        1,059        0          3    3.3
                             /dev/rlv_4G_363
               557       0   36.4     1.0        1,213        0          2   60.0
                             /dev/rlv_4G_364
               573       0   36.1     1.0        1,189        0          8   20.0
                             /dev/rlv_4G_365
               770       0   34.3     1.0        1,418        0          8   50.0
                             /dev/rlv_4G_366
               654       0   35.6     1.0        1,269        0         10   52.0
                             /dev/rlv_4G_367
               634       0   33.0     1.0        1,154        0          8   36.3
                             /dev/rlv_4G_368
               684       0   37.4     1.0        1,184        0          7   55.7
                             /dev/rlv_4G_369
               567       0   34.0     1.0        1,199        0         10  198.0
                             /dev/rlv_4G_370
               483       0   35.5     1.0        2,202        1         48   31.5
                             /dev/rlv_4G_371
               495       0   38.8     1.0        1,114        0         14   14.3
                             /dev/rlv_4G_372
               475       0   38.1     1.0        1,268        0        225   32.7
                             /dev/rlv_4G_373
               499       0   33.2     1.0        1,086        0          9   42.2
                             /dev/rlv_4G_374
               533       0   39.5     1.0        1,101        0          7  717.1
                             /dev/rlv_4G_375
               494       0   34.8     1.0        1,305        0         10   45.0
                             /dev/rlv_4G_376
               544       0   39.5     1.0        1,254        0          7   28.6
                             /dev/rlv_4G_377
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
               464       0   35.0     1.0        1,041        0          5  148.0
    MC_IDX                   /dev/rlv_4G_378
               503       0   36.1     1.0        1,767        0        249   12.6
                             /dev/rlv_4G_379
               515       0   35.5     1.0        1,227        0          4   35.0
                             /dev/rlv_4G_380
               478       0   35.6     1.0        1,060        0          5   46.0
                             /dev/rlv_4G_381
               451       0   35.2     1.0        1,025        0         10   81.0
                             /dev/rlv_4G_382
               466       0   58.4     1.0        1,255        0          4  140.0
                             /dev/rlv_4G_383
               457       0   36.7     1.0        1,497        0          4  127.5

    NW_TEMP                  /dev/rlv_4G_408
                 0       0                           1        0          0
                             /dev/rlv_4G_409
             5,868       2   68.0    17.3        4,214        1          0

    SERVICE_LOG_DAT          /dev/rlv_4G_003
               128       0  140.5     1.0           87        0          0

    SERVICE_LOG_IDX          /dev/rlv_4G_004
                 0       0                           2        0          0

    SERVICE_MAIN_DAT         /dev/rlv_2G_001
             3,533       1   14.3     1.2           10        0      1,176   30.4
                             /dev/rlv_4G_005
             6,204       2   10.3     1.2          761        0      1,220   14.0
                             /dev/rlv_4G_019
             8,208       2    4.8     1.0        1,986        1          0

    SERVICE_MAIN_IDX         /dev/rlv_4G_002
                27       0    4.8     1.0           22        0          0

    SYSTEM                   /dev/rlv_system
             2,341       1   11.5     1.0          820        0      6,353    9.3

    UNDOTBS1                 /dev/rlv_2G_076
             2,593       1    8.4     1.0            0        0         52    5.6
                             /dev/rlv_2G_077
               563       0    8.3     1.0            0        0          1    0.0
                             /dev/rlv_2G_078
               815       0    8.5     1.0            0        0         29    1.0
                             /dev/rlv_2G_079
             1,064       0    9.4     1.0            0        0          5    0.0
                             /dev/rlv_2G_080
               680       0    8.9     1.0            0        0          0
                             /dev/rlv_2G_207
                42       0   27.4     1.0            0        0          8   11.3
                             /dev/rlv_4G_260
               111       0   11.4     1.0            0        0          8    0.0
    File IO Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->ordered by Tablespace, File

    Tablespace               Filename
    ———————— —————————————————-
                     Av      Av     Av                    Av        Buffer Av Buf
             Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    UNDOTBS1                 /dev/rlv_undotbs1
               369       0   10.5     1.0            0        0        418  660.1

    UNDOTBS2                 /dev/rlv_2G_216
                 1       0   10.0     1.0       90,605       24         10    2.0
                             /dev/rlv_2G_217
                 3       0   70.0     1.0       90,720       24          1    0.0
                             /dev/rlv_2G_218
                 1       0   10.0     1.0       86,041       23          5    0.0
                             /dev/rlv_2G_219
                 4       0   55.0     1.0       88,894       23         15    3.3
                             /dev/rlv_2G_220
                 4       0   20.0     1.0       88,962       23          3   13.3
                             /dev/rlv_4G_001
                 3       0   10.0     1.0       88,566       23     12,607    7.3
                             /dev/rlv_4G_328
                 3       0   23.3     1.0       98,298       26        642    3.9
                             /dev/rlv_4G_329
                 2       0   60.0     1.0      102,355       27        294    5.4

    USERS                    /dev/rlv_users
                15       0   14.7     1.0          166        0          9   65.6

    ZWT_DAT                  /dev/rlv_4G_196
               129       0   12.9     2.8            0        0          0

              ————————————————————-
    Buffer Pool Statistics for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> Standard block size Pools  D: default,  K: keep,  R: recycle
    -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

                                                               Free    Write  Buffer
         Number of Cache      Buffer    Physical   Physical  Buffer Complete    Busy
    P      Buffers Hit %        Gets       Reads     Writes   Waits    Waits   Waits
    — ———- —– ———– ———– ———- ——- ——–  ——
    D      979,456  86.5  94,435,857  12,769,828  1,314,052       0        0 138,385
              ————————————————————-

    Instance Recovery Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> B: Begin snapshot,  E: End snapshot

      Targt Estd                                    Log File   Log Ckpt   Log Ckpt
      MTTR  MTTR   Recovery    Actual     Target      Size     Timeout    Interval
       (s)   (s)   Estd IOs  Redo Blks  Redo Blks  Redo Blks  Redo Blks  Redo Blks
    – —– —– ———- ———- ———- ———- ———- ———-
    B   300   211      52984     547379    3760128    3760128
    E   300   202      41471     562317    3760128    3760128
              ————————————————————-

    Buffer Pool Advisory for DB: UIDB  Instance: uidb2  End Snap: 43189
    -> Only rows with estimated physical reads >0 are displayed
    -> ordered by Block Size, Buffers For Estimate (default block size first)

            Size for  Size      Buffers for  Est Physical          Estimated
    P   Estimate (M) Factr         Estimate   Read Factor     Physical Reads
    — ———— —– —————- ————- ——————
    D            816    .1           97,563         14.03     30,058,555,318
    D          1,632    .2          195,126          7.10     15,213,638,717
    D          2,448    .3          292,689          2.72      5,828,545,057
    D          3,264    .4          390,252          1.89      4,052,387,906
    D          4,080    .5          487,815          1.41      3,026,677,833
    D          4,896    .6          585,378          1.24      2,653,124,911
    D          5,712    .7          682,941          1.16      2,488,154,620
    D          6,528    .8          780,504          1.10      2,356,187,255
    D          7,344    .9          878,067          1.04      2,236,657,824
    D          8,160   1.0          975,630          1.00      2,144,969,236
    D          8,192   1.0          979,456          1.00      2,142,008,814
    D          8,976   1.1        1,073,193          0.97      2,071,168,517
    D          9,792   1.2        1,170,756          0.93      2,001,316,328
    D         10,608   1.3        1,268,319          0.91      1,951,267,376
    D         11,424   1.4        1,365,882          0.89      1,913,135,652
    D         12,240   1.5        1,463,445          0.88      1,880,499,107
    D         13,056   1.6        1,561,008          0.86      1,849,039,190
    D         13,872   1.7        1,658,571          0.85      1,816,467,392
    D         14,688   1.8        1,756,134          0.84      1,789,024,003
    D         15,504   1.9        1,853,697          0.82      1,762,774,793
    D         16,320   2.0        1,951,260          0.81      1,737,619,523
              ————————————————————-
    Buffer wait Statistics for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> ordered by wait time desc, waits desc

                                     Tot Wait    Avg
    Class                    Waits   Time (s) Time (ms)
    —————— ———– ———- ———
    data block             115,614      3,738        32
    undo header             13,988        372        27
    segment header          10,735        285        27
    file header block        2,927         51        18
    undo block                 169          1         4
              ————————————————————-
    PGA Aggr Target Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> B: Begin snap   E: End snap (rows dentified with B or E contain data
       which is absolute i.e. not diffed over the interval)
    -> PGA cache hit % – percentage of W/A (WorkArea) data processed only in-memory
    -> Auto PGA Target – actual workarea memory target
    -> W/A PGA Used    – amount of memory used for all Workareas (manual + auto)
    -> %PGA W/A Mem    – percentage of PGA memory allocated to workareas
    -> %Auto W/A Mem   – percentage of workarea memory controlled by Auto Mem Mgmt
    -> %Man W/A Mem    – percentage of workarea memory under manual control

    PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
    ————— —————- ————————-
               90.8           11,304                     1,141

                                                 %PGA  %Auto   %Man
      PGA Aggr  Auto PGA   PGA Mem    W/A PGA    W/A    W/A    W/A   Global Mem
      Target(M) Target(M)  Alloc(M)   Used(M)    Mem    Mem    Mem    Bound(K)
    – ——— ——— ———- ———- —— —— —— ———-
    B     4,096     3,456      471.3       75.4   16.0  100.0     .0    102,400
    E     4,096     3,320    1,092.6      175.1   16.0   98.8    1.2    102,400
              ————————————————————-

    PGA Aggr Target Histogram for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> Optimal Executions are purely in-memory operations

        Low    High
    Optimal Optimal    Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
    ——- ——- ————– ————- ———— ————
         2K      4K         53,657        53,657            0            0
         4K      8K          7,287         7,287            0            0
         8K     16K            620           620            0            0
        16K     32K            545           545            0            0
        32K     64K            620           620            0            0
        64K    128K          1,443         1,443            0            0
       128K    256K            611           611            0            0
       256K    512K          1,024         1,024            0            0
       512K   1024K          1,135         1,135            0            0
         1M      2M            691           691            0            0
         2M      4M            388           388            0            0
         4M      8M            204           204            0            0
         8M     16M            108           108            0            0
        16M     32M            112           112            0            0
        32M     64M             35            33            2            0
        64M    128M             18             6           12            0
              ————————————————————-

    PGA Memory Advisory for DB: UIDB  Instance: uidb2  End Snap: 43189
    -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
       where Estd PGA Overalloc Count is 0

                                           Estd Extra    Estd PGA   Estd PGA
    PGA Target    Size           W/A MB   W/A MB Read/      Cache  Overalloc
      Est (MB)   Factr        Processed Written to Disk     Hit %      Count
    ———- ——- —————- —————- ——– ———-
           512     0.1      3,426,207.3        237,579.3     94.0          0
         1,024     0.3      3,426,207.3        178,030.9     95.0          0
         2,048     0.5      3,426,207.3        160,999.5     96.0          0
         3,072     0.8      3,426,207.3        160,999.5     96.0          0
         4,096     1.0      3,426,207.3        158,520.0     96.0          0
         4,915     1.2      3,426,207.3         89,013.9     97.0          0
         5,734     1.4      3,426,207.3         89,013.9     97.0          0
         6,554     1.6      3,426,207.3         89,013.9     97.0          0
         7,373     1.8      3,426,207.3         89,013.9     97.0          0
         8,192     2.0      3,426,207.3         89,013.9     97.0          0
        12,288     3.0      3,426,207.3         89,013.9     97.0          0
        16,384     4.0      3,426,207.3         89,013.9     97.0          0
        24,576     6.0      3,426,207.3         89,013.9     97.0          0
        32,768     8.0      3,426,207.3         89,013.9     97.0          0
              ————————————————————-
    Enqueue activity for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> Enqueue stats gathered prior to 9i should not be compared with 9i data
    -> ordered by Wait Time desc, Waits desc

                                                            Avg Wt         Wait
    Eq     Requests    Succ Gets Failed Gets       Waits   Time (ms)     Time (s)
    — ———— ———— ———– ———– ————- ————
    US       27,257       27,231           0      23,811      1,223.53       29,133
    SQ        6,510        6,510           0       1,950      2,937.68        5,728
    TX      403,044      403,219           0       9,339         60.10          561
    HW      100,371      100,371           0      52,834          7.40          391
    CF       30,071       30,032          11         774        107.27           83
    DR            2            2           0           2     18,202.50           36
    JD        1,403        1,403           0           2      8,103.50           16
    PS       21,093       19,201       1,826       7,123           .27            2
    TT       18,224       18,224           0       3,719           .39            1
    TM      172,629      172,593           0       4,138           .29            1
    IR        5,325        5,325           0       1,160           .41            0
    TS        1,719        1,717           0         362           .37            0
    ST          115          115           0         115           .37            0
    JQ          823          761          62          42           .60            0
    WL           21            5          16           5          4.80            0
    TD            9            9           0           9          1.44            0
    RO            8            8           0           8           .25            0
    TA           14           14           0           3           .33            0
              ————————————————————-
    Rollback Segment Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->A high value for “Pct Waits” suggests more rollback segments may be required
    ->RBS stats may not be accurate between begin and end snaps when using Auto Undo
      managment, as RBS may be dynamically created and dropped as needed

            Trans Table       Pct   Undo Bytes
    RBS No      Gets        Waits     Written        Wraps  Shrinks  Extends
    —— ————– ——- ————— ——– ——– ——–
         0          472.0    0.00          53,118        1        0        0
        11       43,364.0    0.00      88,209,440       50        0       49
        12       30,700.0    0.00      74,836,634       53        0       53
        13       21,379.0    0.00      34,886,446       44        0       39
        14       34,311.0    0.00      63,243,464       50        0       50
        15       71,796.0    0.01     167,233,982       77        0       73
        16       81,809.0    0.00     138,676,902       65        0       65
        17       18,619.0    0.00      34,186,550       49        0       47
        18       16,792.0    0.00      42,483,110       56        0       56
        19       28,402.0    0.00      26,326,892        2        0        0
        20       17,424.0    0.00      34,831,862       46        0       44
        51       26,649.0    0.00      76,913,298       59        0       57
        52       18,569.0    0.00      27,357,386       37        0       36
        53      268,319.0    0.00     735,133,208      172        0      170
        54       67,958.0    0.00     206,315,830       80        0       79
        55       53,294.0    0.00     117,695,618       70        0       70
        56       34,795.0    0.00      86,929,496       65        0       64
        57       66,042.0    0.00     168,470,092       83        0       82
        58      130,972.0    0.00     421,438,484      121        0      121
        59       79,937.0    0.00     223,691,648       86        0       86
        60       25,554.0    0.00      46,377,576       57        0       57
        61      116,856.0    0.00     403,968,856      116        0      116
              ————————————————————-
    Rollback Segment Storage for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->Optimal Size should be larger than Avg Active

    RBS No    Segment Size      Avg Active    Optimal Size    Maximum Size
    —— ————— ————— ————— —————
         0         385,024          49,254                         385,024
        11     167,895,040      29,507,699                   4,227,981,312
        12     125,952,000      58,666,247                   4,278,312,960
        13      64,086,016       3,738,631                   3,637,633,024
        14     125,952,000      12,044,927                   4,227,981,312
        15     276,946,944      23,324,590                   2,550,259,712
        16     243,392,512      16,749,479                   2,142,363,648
        17      66,183,168       4,855,315                   1,610,735,616
        18      75,620,352      12,533,898                   1,946,279,936
        19      84,008,960     219,578,327                   1,952,571,392
        20      58,843,136      12,700,004                   1,610,735,616
        51     117,563,392      83,659,155                     125,952,000
        52      49,405,952       5,720,056                      49,405,952
        53   1,208,082,432     659,945,024                   1,208,082,432
        54     302,112,768     164,904,943                     302,112,768
        55     201,449,472      53,190,124                     201,449,472
        56     142,729,216      28,318,867                     142,729,216
        57     268,558,336      28,357,404                     268,558,336
        58     620,879,872      74,638,092                     620,879,872
        59     352,444,416     127,498,891                     352,444,416
        60      84,008,960       6,663,637                      84,008,960
        61     578,936,832      49,227,622                     578,936,832
              ————————————————————-
    Undo Segment Summary for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> Undo segment block stats:
    -> uS – unexpired Stolen,   uR – unexpired Released,   uU – unexpired reUsed
    -> eS – expired   Stolen,   eR – expired   Released,   eU – expired   reUsed

    Undo           Undo        Num  Max Qry     Max Tx Snapshot Out of uS/uR/uU/
     TS#         Blocks      Trans  Len (s)   Concurcy  Too Old  Space eS/eR/eU
    —- ————– ———- ——– ———- ——– —— ————-
       5        795,879 ##########    3,855         13        0      0 0/0/0/0/0/0
              ————————————————————-
    Undo Segment Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> ordered by Time desc

                         Undo      Num Max Qry   Max Tx  Snap   Out of uS/uR/uU/
    End Time           Blocks    Trans Len (s)    Concy Too Old  Space eS/eR/eU
    ———— ———— ——– ——- ——– ——- —— ————-
    11-Nov 02:06       67,764 ########   3,855       13       0      0 0/0/0/0/0/0
    11-Nov 01:56      120,330 ########   3,344        7       0      0 0/0/0/0/0/0
    11-Nov 01:46      134,884 ########   2,772        6       0      0 0/0/0/0/0/0
    11-Nov 01:36      111,476 ########   2,142       12       0      0 0/0/0/0/0/0
    11-Nov 01:26      142,485 ########   1,567       12       0      0 0/0/0/0/0/0
    11-Nov 01:16      169,642 ########     974        6       0      0 0/0/0/0/0/0
    11-Nov 01:06       49,298 ########     254        8       0      0 0/0/0/0/0/0
              ————————————————————-
    Latch Activity for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->”Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
      willing-to-wait latch get requests
    ->”NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    ->”Pct Misses” for both should be very close to 0.0

                                               Pct    Avg   Wait                 Pct
                                  Get          Get   Slps   Time       NoWait NoWait
    Latch                       Requests      Miss  /Miss    (s)     Requests   Miss
    ———————— ————– —— —— —— ———— ——
    Consistent RBA                   52,263    0.0             0            0
    FAL request queue                    72    0.0             0            0
    FIB s.o chain latch                  40    0.0             0            0
    FOB s.o list latch               40,422    0.2    0.4      3            0
    KCL bast context freelis         90,410    0.0    0.0      0            0
    KCL freelist parent latc     35,085,564    0.2    0.0    579            0
    KCL gc element parent la     63,966,130    0.0    0.1    114    8,190,453    0.1
    KCL name table parent la     14,438,865    0.0    0.9    251    8,154,064    0.0
    KJC message pool free li      5,285,696    0.1    0.0      0    1,432,218    0.0
    KJCT flow control latch      15,606,520    0.0    0.0      0    2,117,834    0.0
    SQL memory manager latch              1    0.0             0        1,221    0.0
    SQL memory manager worka        237,041    0.3    0.0      0            0
    active checkpoint queue          77,457    1.7    0.0      0            0
    alert log latch                      68    0.0             0            0
    archive control                     120    0.0             0            0
    archive process latch               116    0.0             0            0
    begin backup scn array           36,539    0.0    0.0      0            0
    cache buffer handles             67,677    0.0             0            0
    cache buffers chains        274,057,512    0.1    0.0    793   38,551,668    0.0
    cache buffers lru chain       1,434,304    0.1    0.2     49   25,056,875    0.1
    channel handle pool latc          1,200    0.0             0            0
    channel operations paren      1,293,106    0.0    0.0      0            0
    checkpoint queue latch       12,282,739    0.0    0.6     78    1,323,544    0.0
    child cursor hash table          80,151    0.0    0.0      0            0
    dictionary lookup                   275    0.0             0            0
    dml lock allocation             344,522    0.3    0.1     17            0
    dummy allocation                 11,806    5.7    0.0      0            0
    enqueue hash chains           3,186,855    0.2    0.2    285            0
    enqueues                        566,566    0.9    0.4    657            0
    error message lists              11,177    4.3    0.0      0            0
    event group latch                   782    0.0             0            0
    gcs opaque info freelist        838,472    2.4    0.0      0            0
    gcs resource freelist        22,806,423    3.9    0.0    380            0
    gcs resource hash            39,282,146    0.2    0.0    683          192    0.5
    gcs resource scan list              385    0.0             0            0
    gcs shadows freelist         10,598,701    2.4    0.0     94            0
    ges caches resource list      1,088,163    0.2    0.1     59      908,018    0.2
    ges deadlock list               195,806    0.1    0.0      0           33    0.0
    ges domain table              1,504,332    0.0    0.0      0            0
    ges enqueue table freeli      1,843,211    0.0    0.0      0            0
    ges group parent              1,500,459    0.3    0.0      1            0
    ges group table               1,526,062    0.0    0.0      0            0
    ges process hash list            23,525    0.0             0            0
    ges process parent latch      7,061,600    0.0    0.1      0            0
    ges process table freeli          1,145    0.0             0            0
    ges resource hash list        3,172,344    1.1    0.0    149      516,679    0.2
    ges resource scan list          102,467    0.0    0.0      0            0
    ges resource table freel      1,588,459    0.0    0.2     12            0
    ges timeout list                 83,990    0.0    0.0      0        8,575    0.0
    global tx hash mapping              935    0.0             0            0
    Latch Activity for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->”Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
      willing-to-wait latch get requests
    ->”NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    ->”Pct Misses” for both should be very close to 0.0

                                               Pct    Avg   Wait                 Pct
                                  Get          Get   Slps   Time       NoWait NoWait
    Latch                       Requests      Miss  /Miss    (s)     Requests   Miss
    ———————— ————– —— —— —— ———— ——
    hash table column usage           4,270    0.0             0       15,115    0.0
    job workq parent latch                0                    0        1,490    0.7
    job_queue_processes para            607    0.0             0            0
    ksxp tid allocation           6,551,885    0.0    0.0      0            0
    ktm global data                     489    0.0             0            0
    kwqit: protect wakeup ti            123    0.0             0            0
    lgwr LWN SCN                     52,769    0.1    0.0      0            0
    library cache                 3,769,995    4.5    0.5  21710       16,372    0.3
    library cache load lock          25,280    0.0    0.0      0            0
    library cache pin             2,851,321    0.2    0.0      0            0
    library cache pin alloca      1,019,267    0.3    2.1   1794            0
    list of block allocation         35,608    0.4    0.0      0            0
    loader state object free          1,349    0.9    0.0      0            0
    longop free list parent             439    0.0             0          293    0.0
    message pool operations           1,010    0.0             0            0
    messages                      1,150,727    0.4    0.0      0            0
    mostly latch-free SCN            53,716    0.8    0.0      0            0
    multiblock read objects       3,060,274    0.0    0.0      0            0
    name-service entry                2,447    0.0             0            0
    name-service memory obje         18,166    0.0             0            0
    name-service namespace b         45,638    0.0             0            0
    name-service namespace o            586    0.0             0            0
    name-service pending que         16,320    0.0             0            0
    name-service request              2,448    0.0             0            0
    name-service request que         51,243    0.0    0.0      0            0
    ncodef allocation latch             111    0.0             0            0
    object stats modificatio          7,446    0.0    0.0      0            0
    parallel query alloc buf        133,089    3.8    0.0      0            0
    parallel query stats              8,593   12.2    0.0      0            0
    parallel txn reco latch          12,192    0.0             0            0
    post/wait queue                 441,539    0.9    0.0      0      210,225    0.1
    process allocation               34,120    0.0    0.0      0          782    0.0
    process group creation            1,144    0.0             0            0
    process queue                    21,737    2.1    0.0      0            0
    process queue reference       3,466,609    0.0    0.0      0      324,442    0.1
    query server freelists           23,135    1.1    0.0      0            0
    redo allocation              15,948,024    0.7    0.0      0            0
    redo copy                             0                    0   16,179,164    0.1
    redo writing                    230,883    0.1    0.0      0            0
    row cache enqueue latch       1,753,253    4.2    0.0      0            0
    row cache objects             3,150,977    0.9    0.1    746        9,389    0.0
    sequence cache                  204,761    1.4    0.0      0            0
    session allocation            6,279,431    0.2    0.0      0            0
    session idle bit              1,272,703    0.0    0.0      0            0
    session switching                   111    0.0             0            0
    session timer                     1,339    0.0             0            0
    shared pool                   1,345,784    0.3    1.3   1455            0
    sim partition latch                   0                    0        5,373    0.1
    simulator hash latch          6,368,610    0.0    0.1      0            0
    simulator lru latch             176,139    0.0    0.7      4      902,907    0.0
    Latch Activity for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->”Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
      willing-to-wait latch get requests
    ->”NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    ->”Pct Misses” for both should be very close to 0.0

                                               Pct    Avg   Wait                 Pct
                                  Get          Get   Slps   Time       NoWait NoWait
    Latch                       Requests      Miss  /Miss    (s)     Requests   Miss
    ———————— ————– —— —— —— ———— ——
    sort extent pool                  4,953    0.0             0            0
    spilled msgs queues list            123    0.0             0            0
    temporary table state ob              1    0.0             0            0
    trace latch                         367    0.0             0            0
    transaction allocation           75,768    0.0    0.0      0            0
    transaction branch alloc          1,046    0.0             0            0
    undo global data              2,276,167    0.1    0.0      0           88    0.0
    user lock                         4,325    0.1    0.0      0            0
              ————————————————————-
    Latch Sleep breakdown for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> ordered by misses desc

                                          Get                            Spin &
    Latch Name                       Requests      Misses      Sleeps Sleeps 1->4
    ————————– ————– ———– ———– ————
    gcs resource freelist          22,806,423     887,732       1,766 887183/483/1
                                                                      4/52/0
    cache buffers chains          274,057,512     359,201       6,921 355391/3146/
                                                                      151/516/0
    gcs shadows freelist           10,598,701     258,273         421 258148/103/4
                                                                      /18/0
    library cache                   3,769,995     168,135      75,757 165577/1503/
                                                                      153/902/0
    redo allocation                15,948,024     114,837          10 114829/6/2/0
                                                                      /0
    gcs resource hash              39,282,146      81,585       2,853 80953/529/14
                                                                      /89/0
    row cache enqueue latch         1,753,253      74,133           1 74132/1/0/0/
                                                                      0
    KCL freelist parent latch      35,085,564      62,513       2,952 61383/1034/1
                                                                      6/80/0
    ges resource hash list          3,172,344      36,418       1,428 35389/1007/3
                                                                      /19/0
    row cache objects               3,150,977      28,750       2,749 28492/158/7/
                                                                      93/0
    gcs opaque info freelist          838,472      20,358           6 20352/6/0/0/
                                                                      0
    session allocation              6,279,431      11,757           4 11753/4/0/0/
                                                                      0
    KCL gc element parent latc     63,966,130      10,906         597 10665/214/7/
                                                                      20/0
    enqueue hash chains             3,186,855       6,241         987 6207/1/0/33/
                                                                      0
    KJC message pool free list      5,285,696       5,381           2 5379/2/0/0/0
    enqueues                          566,566       5,318       2,282 5230/1/0/87/
                                                                      0
    library cache pin               2,851,321       5,299           7 5292/7/0/0/0
    parallel query alloc buffe        133,089       5,104          54 5055/44/5/0/
                                                                      0
    KJCT flow control latch        15,606,520       4,384           2 4382/2/0/0/0
    ges group parent                1,500,459       4,093          11 4082/11/0/0/
                                                                      0
    shared pool                     1,345,784       3,813       5,055 3682/83/2/46
                                                                      /0
    library cache pin allocati      1,019,267       2,915       6,151 2867/16/3/29
                                                                      /0
    ges caches resource lists       1,088,163       2,671         226 2641/21/1/8/
                                                                      0
    undo global data                2,276,167       1,955           1 1954/1/0/0/0
    cache buffers lru chain         1,434,304       1,818         293 1668/131/9/1
                                                                      0/0
    KCL name table parent latc     14,438,865       1,148       1,062 906/203/3/36
                                                                      /0
    dml lock allocation               344,522       1,088          81 1053/12/0/23
                                                                      /0
    checkpoint queue latch         12,282,739         511         291 476/23/2/10/
                                                                      0
    ges resource table freelis      1,588,459         243          46 238/4/0/1/0
    ges enqueue table freelist      1,843,211         142           3 139/3/0/0/0
    Latch Sleep breakdown for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> ordered by misses desc

                                          Get                            Spin &
    Latch Name                       Requests      Misses      Sleeps Sleeps 1->4
    ————————– ————– ———– ———– ————
    FOB s.o list latch                 40,422          95          42 59/30/6/0/0
    simulator lru latch               176,139          21          15 19/1/0/1/0
    simulator hash latch            6,368,610          12           1 11/1/0/0/0
    ges process parent latch        7,061,600          11           1 10/1/0/0/0
              ————————————————————-
    Latch Miss Sources for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> only latches with sleeps are shown
    -> ordered by name, sleeps desc

                                                         NoWait              Waiter
    Latch Name               Where                       Misses     Sleeps   Sleeps
    ———————— ————————– ——- ———- ——–
    FOB s.o list latch       ksfd_allfob                      0         42       42
    KCL freelist parent latc kclfrem                          0      1,673      351
    KCL freelist parent latc kclfget                          0      1,090    2,229
    KCL freelist parent latc kclfadb                          0        191      374
    KCL gc element parent la kclulb                           0        177      187
    KCL gc element parent la kclnloc                          0        120       97
    KCL gc element parent la kclfget                          0         72        0
    KCL gc element parent la kclfwrite1                       0         58       36
    KCL gc element parent la kclrwrite                        0         45      127
    KCL gc element parent la kclpdc_2                         0         35        0
    KCL gc element parent la kclbla                           0         34        1
    KCL gc element parent la kclpdcl                          0         34      105
    KCL gc element parent la KCLUNLNK                         0         15       32
    KCL gc element parent la kclpdc_3                         0          3        0
    KCL gc element parent la kclchkping                       0          1        3
    KCL gc element parent la kclgrantlk_1                     0          1        0
    KCL gc element parent la kclpto                           0          1        1
    KCL gc element parent la kclebs                           0          1        3
    KCL name table parent la kclnfnd                          0      1,033    1,062
    KCL name table parent la kclnrem                          0         29        0
    KJC message pool free li kjcsmpav: allocate a msg b       0          3        3
    KJCT flow control latch  kjctcsnd: send normal mess       0          2        1
    cache buffers chains     kcbgtcr: kslbegin excl           0      3,032    2,344
    cache buffers chains     kcbgcur: kslbegin                0      1,571      600
    cache buffers chains     kcbgtcr: fast path               0        740      495
    cache buffers chains     kcbzgb: scan from tail. no       0        524        0
    cache buffers chains     kcbnew                           0        318        1
    cache buffers chains     kcbget: pin buffer               0        178      124
    cache buffers chains     kcbchg: kslbegin: bufs not       0        164      480
    cache buffers chains     kcbzwb                           0        142      164
    cache buffers chains     kcbrls: kslbegin                 0         61    1,676
    cache buffers chains     kcbbxsv                          0         47        0
    cache buffers chains     kcbnlc                           0         27       62
    cache buffers chains     kcbgtcr: kslbegin shared         0         24        5
    cache buffers chains     kcbzib: multi-block read:        0         18        0
    cache buffers chains     kcbget: exchange rls             0         13        6
    cache buffers chains     kclpdcl                          0         10      542
    cache buffers chains     kcbget: exchange                 0          9        0
    cache buffers chains     kcbchg: kslbegin: call CR        0          7      360
    cache buffers chains     kcbbic2                          0          6        0
    cache buffers chains     kcbgtcr                          0          5        1
    cache buffers chains     kclpdc_1                         0          5        9
    cache buffers chains     kclpto                           0          5        0
    cache buffers chains     kcbbic1                          0          4        0
    cache buffers chains     kclwlr                           0          1        1
    cache buffers lru chain  kcbzgb: multiple sets nowa   9,372        291        0
    cache buffers lru chain  H_MK_PI_CR_BG                1,652          2        0
    cache buffers lru chain  kcbbic2                         68          1      287
    checkpoint queue latch   kcbklbc: Link buffer into        0        139        2
    checkpoint queue latch   kcbbwthc: thread checkpoin       0         90        1
    checkpoint queue latch   kcbbxsv: move to being wri       0         58        3
    checkpoint queue latch   kcbbcthc: check thread que       0          2       57
    checkpoint queue latch   kcbkllrba: compute lowest        0          2      222
    Latch Miss Sources for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> only latches with sleeps are shown
    -> ordered by name, sleeps desc

                                                         NoWait              Waiter
    Latch Name               Where                       Misses     Sleeps   Sleeps
    ———————— ————————– ——- ———- ——–
    dml lock allocation      ktaiam                           0         62       30
    dml lock allocation      ktaidm                           0         19       51
    enqueue hash chains      ksqcmi: get hash chain lat       0        980      860
    enqueue hash chains      ksqgtl3                          0          6      126
    enqueue hash chains      ksqrcl                           0          1        1
    enqueues                 ksqgel: create enqueue           0      2,222    1,182
    enqueues                 ksqies                           0         37      909
    enqueues                 ksqdel                           0         21      190
    enqueues                 ksqgel: failed to get enqu       0          1        0
    gcs opaque info freelist kjbrgrant free opaque info       0          5        0
    gcs opaque info freelist kjbrcvt save opaque info         0          1        6
    gcs resource freelist    kjbrfr free resource             0        891      385
    gcs resource freelist    kjbralc add resource             0        875    1,381
    gcs resource hash        kjbmpclose                       0      1,082      379
    gcs resource hash        kjbcropen                        0        858      592
    gcs resource hash        kjbmpopen                        0        558      165
    gcs resource hash        kjbopen                          0        198      101
    gcs resource hash        kclpdc                           0         85      544
    gcs resource hash        kjbassume                        0         33      615
    gcs resource hash        kjbmpconvert                     0         17        0
    gcs resource hash        kclfwrite1                       0          8       85
    gcs resource hash        kclrwrite                        0          5      130
    gcs resource hash        kclgrantlk_1                     0          2        0
    gcs resource hash        kjbmprefuse                      0          2        0
    gcs resource hash        kjblpast                         0          2        6
    gcs resource hash        kjbconvert                       0          2      133
    gcs resource hash        kjbcrcomplete                    0          2      104
    gcs shadows freelist     kjblalc add lock                 0        402      353
    gcs shadows freelist     kjblfr free lock                 0         19       68
    ges enqueue table freeli kjlfr: remove lock from pa       0          3        2
    ges group parent         kjgdgpar: move a group loc       0          6        6
    ges group parent         kjgagpar: move a group loc       0          5        5
    ges process parent latch kjlalc: lock allocation fr       0          1        0
    ges resource hash list   kjrmas1: lookup master nod       0        883        3
    ges resource hash list   kjlrlr: remove lock from r       0        443      189
    ges resource hash list   kjrref: find matched resou       0         37    1,212
    ges resource hash list   kjakcai: search for resp b       0         31       13
    ges resource hash list   kjcvscn: remove from scan        0         21        0
    ges resource hash list   kjlmfnd: search for lockp        0         11        6
    ges resource hash list   kjucvl: lock convert reque       0          2        5
    ges resource table freel kjrm2c: move resource to c       0        215      226
    ges resource table freel kjralc: resource allocatio       0         45        1
    ges resource table freel kjruch: cached obj cleanup       0          7        0
    ges resource table freel kjrchc: cached obj cleanup       0          4        0
    ges resource table freel kjrfr: remove from resourc       0          1        2
    library cache            kglupc: child                    0     44,294    8,383
    library cache            kglpndl: child: before pro       0      8,920    1,666
    library cache            kglhdgn: child:                  0      6,320   22,846
    library cache            kglpin: child: heap proces       0      2,505    6,903
    library cache            kglobpn: child:                  0      2,257   13,274
    library cache            kglhdgc: child:                  0      1,611       37
    library cache            kgllkdl: child: cleanup          0        571      394
    library cache            kglpnc: child                    0        540   15,786
    Latch Miss Sources for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> only latches with sleeps are shown
    -> ordered by name, sleeps desc

                                                         NoWait              Waiter
    Latch Name               Where                       Misses     Sleeps   Sleeps
    ———————— ————————– ——- ———- ——–
    library cache            kglidp: child                    0        175        0
    library cache            kglpnp: child                    0         52    1,252
    library cache            kgldte: child 0                  0         37    4,106
    library cache            kglpndl: child: after proc       0         25        0
    library cache            kglhdiv: child                   0         21        0
    library cache            kglpin                           0          6        3
    library cache            kgllkdl: child: multiinsta       0          5        0
    library cache            kgldti: 2child                   0          4        0
    library cache            kqlmbpil: parent                 0          4        0
    library cache            kglget: child: KGLDSBRD          0          3      275
    library cache            kglobld                          0          2        0
    library cache            kgldtld: 2child                  0          1        0
    library cache            kglrtl                           0          1        0
    library cache            kglic                            0          1        0
    library cache pin        kglpndl                          0          4        0
    library cache pin        kglpnc: child                    0          2        4
    library cache pin        kglupc                           0          1        2
    library cache pin alloca kglpnal                          0      6,085    3,908
    library cache pin alloca kglpndl                          0         63    2,239
    library cache pin alloca kgllkdl                          0          3        4
    parallel query alloc buf kxfpbalo                         0         40        7
    parallel query alloc buf kxfpnfy                          0         12       47
    parallel query alloc buf kxfpbfre                         0          2        0
    redo allocation          kcrfwr                           0         10       10
    row cache enqueue latch  kqreqa                           0          1        1
    row cache objects        kqrpre: find obj                 0      2,307    2,526
    row cache objects        kqrpfl: not dirty                0        441        0
    row cache objects        kqrigt                           0         27      173
    row cache objects        kqrbgl                           0          5        2
    row cache objects        kqrbtm: pop parent               0          1       78
    session allocation       ksuxds: KSUSFCLC not set         0          3        0
    session allocation       ksucri                           0          1        3
    shared pool              kghfrunp: clatch: nowait         0      7,470        0
    shared pool              kghalo                           0      4,036      800
    shared pool              kghfrunp: clatch: wait           0        928      786
    shared pool              kghupr1                          0        901    4,243
    shared pool              kghfrunp: alloc: wait            0        111        0
    shared pool              kghfre                           0          7       11
    simulator hash latch     kcbs_lookup_setid: lookup        0          1        0
    simulator lru latch      kcbs_simulate: simulate se       0         15       15
    undo global data         ktusmofu: KSLBEGIN               0          1        0
              ————————————————————-
    Top 5 Logical Reads per Segment for DB: UIDB  Instance: uidb2  Snaps: 43188 -431
    -> End Segment Logical Reads Threshold:     10000

                                               Subobject  Obj.       Logical
    Owner      Tablespace Object Name          Name       Type         Reads  %Total
    ———- ———- ——————– ———- —– ———— ——-
    ICDMAIN    SERVICE_MA T_SCESENDTASK                   TABLE   33,976,896   37.37
    ISEADMIN2  IISS_IDX   IX_IISS_SUBUNION_PHO            INDEX   16,860,128   18.54
    CORE       CORE_DAT   T_IISS_SUBSCRIBE_CAC            TABLE    8,465,936    9.31
    ISEADMIN2  IISS_DAT   PK_T_IISS_SUBSCRIBE_            INDEX    6,057,488    6.66
    CORE       CORE_IDX   PK_T_IISS_NUMBERSEGM            INDEX    5,028,096    5.53
              ————————————————————-
    Top 5 Physical Reads per Segment for DB: UIDB  Instance: uidb2  Snaps: 43188 -43
    -> End Segment Physical Reads Threshold:      1000

                                               Subobject  Obj.      Physical
    Owner      Tablespace Object Name          Name       Type         Reads  %Total
    ———- ———- ——————– ———- —– ———— ——-
    CORE       CORE_DAT   T_IISS_SUBSCRIBE_CAC            TABLE    8,404,126   65.78
    ISEADMIN2  IISS_DAT   T_IISS_SYNMCASSUBTEM            TABLE      972,516    7.61
    ISEADMIN2  BILL_DAT   T_IISS_BILLFROMSI_AL P12_08     TABLE      133,840    1.05
    ISEADMIN2  BILL_DAT   T_IISS_BILLFROMSI_AL P11_24     TABLE      111,500     .87
    ISEADMIN2  BILL_DAT   T_IISS_BILLFROMSI_AL P12_06     TABLE      106,018     .83
              ————————————————————-
    Top 5 Buf. Busy Waits per Segment for DB: UIDB  Instance: uidb2  Snaps: 43188 -4
    -> End Segment Buffer Busy Waits Threshold:       100

                                                                      Buffer
                                               Subobject  Obj.          Busy
    Owner      Tablespace Object Name          Name       Type         Waits  %Total
    ———- ———- ——————– ———- —– ———— ——-
    CORE       CORE_SUBSC IX_UNION_ADDRESS2               INDEX       40,666   31.20
    CORE       CORE_SUBSC IX_UNION_PHONENO                INDEX       18,129   13.91
    CORE       CORE_SUBSC IX_UNION_PARTITIONNU            INDEX       17,971   13.79
    CORE       CORE_SUBSC IX_UNION_ADDRESS1               INDEX       15,622   11.99
    CORE       CORE_SUBSC IX_UNION_CALLINGID              INDEX       11,074    8.50
              ————————————————————-
    Top 5 Row Lock Waits per Segment for DB: UIDB  Instance: uidb2  Snaps: 43188 -43
    -> End Segment Row Lock Waits Threshold:       100

                                                                         Row
                                               Subobject  Obj.          Lock
    Owner      Tablespace Object Name          Name       Type         Waits  %Total
    ———- ———- ——————– ———- —– ———— ——-
    CORE       CORE_SUBSC IX_UNION_ADDRESS2               INDEX        2,918   37.68
    CORE       CORE_SUBSC IX_UNION_PHONENO                INDEX        1,987   25.66
    CORE       CORE_SUBSC IX_UNION_CALLINGID              INDEX          516    6.66
    CORE       CORE_SUBSC IX_UNION_PARTITIONNU            INDEX          389    5.02
    CORE       CORE_SUBSC IX_UNION_ADDRESS1               INDEX          349    4.51
              ————————————————————-
    Top 5 ITL Waits per Segment for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> End Segment ITL Waits Threshold:       100

                                               Subobject  Obj.           ITL
    Owner      Tablespace Object Name          Name       Type         Waits  %Total
    ———- ———- ——————– ———- —– ———— ——-
    SYS        SYSTEM     SEG$                            TABLE          670   42.19
    CORE       CORE_SUBSC IX_UNION_ADDRESS2               INDEX          382   24.06
    CORE       CORE_SUBSC IX_UNION_PHONENO                INDEX          377   23.74
    CORE       CORE_SUBSC IX_UNION_PARTITIONNU            INDEX           63    3.97
    CORE       CORE_SUBSC IX_UNION_CALLINGID              INDEX           42    2.64
              ————————————————————-
    Top 5 CR Blocks Served (RAC) per Segment for DB: UIDB  Instance: uidb2  Snaps: 4
    -> End Global Cache CR Blocks Served Threshold:      1000

                                                                          CR
                                               Subobject  Obj.        Blocks
    Owner      Tablespace Object Name          Name       Type        Served  %Total
    ———- ———- ——————– ———- —– ———— ——-
    CORE       CORE_DAT   IX_SUBSCRIBE_TODAY_L            INDEX        1,709   21.77
    SYS        SYSTEM     SEG$                            TABLE        1,161   14.79
    SYS        SYSTEM     JOB$                            TABLE          944   12.03
    CORE       CORE_DAT   T_IISS_SUBSCRIBE_TOD            TABLE          705    8.98
    CORE       CORE_DAT   T_IISS_SERVICE                  TABLE          565    7.20
              ————————————————————-
    Top 5 CU Blocks Served (RAC) per Segment for DB: UIDB  Instance: uidb2  Snaps: 4
    -> End Global Cache CU Blocks Served Threshold:      1000

                                                                          CU
                                               Subobject  Obj.        Blocks
    Owner      Tablespace Object Name          Name       Type        Served  %Total
    ———- ———- ——————– ———- —– ———— ——-
    CORE       CORE_DAT   T_GATHER_USABLEINFOD            TABLE       81,515   20.96
    CORE       CORE_BILL_ T_IISS_BILLFROMSIERR P10_25     TABLE       18,626    4.79
    CORE       CORE_DAT   IX_GATHER_USABLEINFO            INDEX       15,022    3.86
    CORE       CORE_BILL_ T_IISS_BILLFROMSIERR P09_07     TABLE       13,917    3.58
    ISEADMIN2  BILL_DAT   T_IISS_BILLFROMSI_AL P11_13     TABLE       10,104    2.60
              ————————————————————-
    Dictionary Cache Stats for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->”Pct Misses”  should be very low (< 2% in most cases)
    ->”Cache Usage” is the number of cache entries being used
    ->”Pct SGA”     is the ratio of usage to allocated size for that cache

                                       Get    Pct    Scan   Pct      Mod      Final
    Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
    ————————- ———— —— ——- —– ——– ———-
    dc_histogram_defs              111,541   34.7       0              0     40,776
    dc_object_ids                  268,434    6.3       0              0     25,968
    dc_objects                      65,283    4.0       0            280      4,712
    dc_profiles                      1,505    0.0       0              0          2
    dc_rollback_segments           106,063    1.1       0            230        853
    dc_segments                    131,648   17.2       0         30,974     35,322
    dc_sequences                    10,311    1.2       0         10,311         22
    dc_tablespace_quotas            15,066    0.0       0         15,066          5
    dc_tablespaces                  60,596    0.0       0              0         68
    dc_user_grants                  28,532    0.0       0              0         25
    dc_usernames                    11,159    0.0       0              0         18
    dc_users                        98,151    0.0       0              0         42
              ————————————————————-
                                       GES          GES          GES
    Cache                         Requests    Conflicts     Releases
    ————————- ———— ———— ————
    dc_histogram_defs               38,657            0        1,107
    dc_object_ids                   16,810            1        3,875
    dc_objects                       2,971           15          678
    dc_profiles                          0            0            0
    dc_rollback_segments               445          101            0
    dc_segments                     82,222          245        1,628
    dc_sequences                    18,603          126            2
    dc_tablespace_quotas            30,132            6            4
    dc_tablespaces                       0            0            0
    dc_user_grants                       0            0            0
    dc_usernames                         0            0            2
    dc_users                             0            0            0
              ————————————————————-
    Library Cache Activity for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    ->”Pct Misses”  should be very low

                             Get  Pct        Pin        Pct               Invali-
    Namespace           Requests  Miss     Requests     Miss     Reloads  dations
    ————— ———— —— ————– —— ———- ——–
    BODY                      68    1.5             68    2.9          0        0
    CLUSTER                    2    0.0              3    0.0          0        0
    INDEX                  1,439    1.3          1,439    1.7          6        0
    SQL AREA              33,768   19.4      1,115,229    1.2         78       55
    TABLE/PROCEDURE       73,678    3.2        326,413    3.9      1,185        0
    TRIGGER                2,470    0.0          2,470    0.0          0        0
              ————————————————————-
                        GES Lock      GES Pin      GES Pin   GES Inval GES Invali-
    Namespace           Requests     Requests     Releases    Requests     dations
    ————— ———— ———— ———— ———– ———–
    BODY                       1            1            4           1           0
    CLUSTER                    2            0            1           0           0
    INDEX                  1,439           78           14          19           0
    SQL AREA                   0            0            0           0           0
    TABLE/PROCEDURE       67,410        2,518          608       2,342           0
    TRIGGER                    0            0            8           0           0
              ————————————————————-
    Shared Pool Advisory for DB: UIDB  Instance: uidb2  End Snap: 43189
    -> Note there is often a 1:Many correlation between a single logical object
       in the Library Cache, and the physical number of memory objects associated
       with it.  Therefore comparing the number of Lib Cache objects (e.g. in
       v$librarycache), with the number of Lib Cache Memory Objects is invalid

                                                              Estd
    Shared Pool    SP       Estd         Estd     Estd Lib LC Time
       Size for  Size  Lib Cache    Lib Cache   Cache Time   Saved  Estd Lib Cache
      Estim (M) Factr   Size (M)      Mem Obj    Saved (s)   Factr    Mem Obj Hits
    ———– —– ———- ———— ———— ——- —————
            592    .6        589       46,509    2,495,962     1.0     292,571,307
            704    .7        700       54,623    2,496,529     1.0     292,658,950
            816    .8        811       64,651    2,496,969     1.0     292,733,728
            928    .9        922       75,608    2,497,217     1.0     292,777,999
          1,040   1.0      1,033       83,112    2,497,403     1.0     292,817,931
          1,152   1.1      1,144       89,899    2,497,589     1.0     292,858,854
          1,264   1.2      1,255       97,008    2,497,793     1.0     292,894,479
          1,376   1.3      1,390      106,883    2,498,011     1.0     292,923,503
          1,488   1.4      1,501      114,815    2,498,180     1.0     292,944,628
          1,600   1.5      1,641      126,010    2,498,322     1.0     292,959,338
          1,712   1.6      1,753      136,446    2,498,425     1.0     292,971,587
          1,824   1.8      1,864      147,715    2,498,504     1.0     292,982,085
          1,936   1.9      1,975      155,616    2,498,555     1.0     292,990,730
          2,048   2.0      2,086      163,866    2,498,605     1.0     292,995,283
          2,160   2.1      2,307      183,063    2,498,688     1.0     293,000,601
              ————————————————————-
    SGA Memory Summary for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    SGA regions                       Size in Bytes
    —————————— —————-
    Database Buffers                  8,589,934,592
    Fixed Size                              758,280
    Redo Buffers                            655,360
    Variable Size                     3,992,977,408
                                   —————-
    sum                              12,584,325,640
              ————————————————————-
    SGA breakdown difference for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Pool   Name                                Begin value        End value  % Diff
    —— —————————— —————- —————- ——-
    java   free memory                         268,435,456      268,435,456    0.00
    large  free memory                         268,435,456      268,435,456    0.00
    shared Checkpoint queue                     31,472,640       31,472,640    0.00
    shared DML lock                              1,566,544        1,566,544    0.00
    shared FileIdentificatonBlock                1,153,752        1,153,752    0.00
    shared FileOpenBlock                        16,270,720       16,270,720    0.00
    shared KCL extra lock elements               1,327,104        1,327,104    0.00
    shared KCL name table                        5,876,952        5,876,952    0.00
    shared KGK heap                                 33,352           33,352    0.00
    shared KGLS heap                            14,826,056       81,530,784  449.92
    shared KQR L PO                             19,536,720       31,648,096   61.99
    shared KQR L SO                                 38,928           38,928    0.00
    shared KQR M PO                             10,511,224       39,995,832  280.51
    shared KQR M SO                                 60,616           60,616    0.00
    shared KQR S SO                                  9,008            9,008    0.00
    shared KQR X PO                                 90,192           90,192    0.00
    shared KSXR large reply queue                  167,624          167,624    0.00
    shared KSXR pending messages que               853,952          853,952    0.00
    shared MTTR advisory                           388,840          388,840    0.00
    shared PL/SQL DIANA                          2,044,792        1,062,144  -48.06
    shared PL/SQL MPCODE                         2,100,872        1,562,816  -25.61
    shared PL/SQL PPCODE                            35,000           56,352   61.01
    shared PLS non-lib hp                            2,088            2,088    0.00
    shared PX subheap                               28,984           28,984    0.00
    shared character set object                    222,768          222,768    0.00
    shared db_block_hash_buckets                50,217,040       50,217,040    0.00
    shared db_handles                            1,781,760        1,781,760    0.00
    shared dictionary cache                      4,274,432        4,274,432    0.00
    shared enqueue                               3,246,840        3,246,840    0.00
    shared errors                                   26,960           25,360   -5.93
    shared event statistics per sess            16,051,616       16,051,616    0.00
    shared fixed allocation callback                 3,552            3,552    0.00
    shared free memory                         147,197,552       40,853,792  -72.25
    shared gcs resource hash table              16,273,216       16,273,216    0.00
    shared gcs resources                       157,318,344      157,318,344    0.00
    shared gcs shadows                         104,519,808      104,519,808    0.00
    shared ges big msg buffers                   6,921,000        6,921,000    0.00
    shared ges enqueues                        107,515,216      109,374,280    1.73
    shared ges process array                     1,955,064        1,955,064    0.00
    shared ges regular msg buffers               1,611,384        1,611,384    0.00
    shared ges resource hash table               4,194,304        4,194,304    0.00
    shared ges resources                        70,558,688       72,268,104    2.42
    shared joxs heap init                            4,240            4,240    0.00
    shared kglsim hash table bkts                  700,416          700,416    0.00
    shared krvxrr                                  253,056          253,056    0.00
    shared ktlbk state objects                     998,568          998,568    0.00
    shared library cache                       168,528,152      156,049,000   -7.40
    shared miscellaneous                       100,517,616      115,323,456   14.73
    shared parameters                               91,016           64,136  -29.53
    shared partitioning d                        1,206,496        1,873,744   55.30
    shared qmps connections                        745,360          745,360    0.00
    shared session param values                  5,341,888        9,145,536   71.20
    shared sessions                              2,290,288        2,290,288    0.00
    shared sim memory hea                        8,172,800        8,172,800    0.00
    SGA breakdown difference for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

    Pool   Name                                Begin value        End value  % Diff
    —— —————————— —————- —————- ——-
    shared sql area                            464,933,120      452,295,968   -2.72
    shared table definiti                          111,424           19,784  -82.24
    shared trace buffer                          3,489,792        5,423,104   55.40
    shared transaction                             600,720          604,040    0.55
    shared trigger defini                            4,152            2,360  -43.16
    shared trigger inform                            3,248            2,744  -15.52
    shared trigger source                            3,232              824  -74.50
           buffer_cache                      8,589,934,592    8,589,934,592    0.00
           fixed_sga                               758,280          758,280    0.00
           log_buffer                              647,168          647,168    0.00
              ————————————————————-
    Resource Limit Stats for DB: UIDB  Instance: uidb2  End Snap: 43189
    -> only rows with Current or Maximum Utilization > 80% of Limit are shown
    -> ordered by resource name

                                     Current      Maximum     Initial
    Resource Name                  Utilization  Utilization  Allocation      Limit
    —————————— ———— ———— ———- ———-
    gcs_resources                       754,227      949,251    1077401    1077401
    parallel_max_servers                      5            6          6          6
              ————————————————————-
    init.ora Parameters for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189

                                                                      End value
    Parameter Name                Begin value                       (if different)
    —————————– ——————————— ————–
    aq_tm_processes               1
    audit_trail                   TRUE
    background_dump_dest          /oracle/app/oracle/admin/uidb/bdu
    cluster_database              TRUE
    cluster_database_instances    2
    compatible                    9.2.0.0.0
    control_files                 /dev/rlv_contorl1, /dev/rlv_contr
    core_dump_dest                /oracle/app/oracle/admin/uidb/cdu
    cursor_sharing                SIMILAR
    db_block_size                 8192
    db_cache_size                 8589934592
    db_domain
    db_file_multiblock_read_count 8
    db_files                      1024
    db_name                       uidb
    fast_start_mttr_target        300
    hash_join_enabled             TRUE
    instance_name                 uidb2
    instance_number               2
    java_pool_size                268435456
    job_queue_processes           4
    large_pool_size               268435456
    local_listener                LISTENER_UIDB2
    lock_sga                      FALSE
    log_archive_dest              /db2arch
    log_archive_format            UIDB_%S_%T.dbf
    log_archive_start             TRUE
    log_buffer                    514560
    log_checkpoint_timeout        0
    max_dump_file_size            5242880
    open_cursors                  800
    pga_aggregate_target          4294967296
    pre_page_sga                  TRUE
    processes                     1536
    query_rewrite_enabled         FALSE
    remote_listener
    remote_login_passwordfile     EXCLUSIVE
    session_cached_cursors        50
    sga_max_size                  12584325640
    shared_pool_size              1073741824
    sort_area_size                524288
    star_transformation_enabled   FALSE
    thread                        2
    timed_statistics              TRUE
    undo_management               AUTO
    undo_retention                18000
    undo_tablespace               UNDOTBS2
    user_dump_dest                /oracle/app/oracle/admin/uidb/udu
              ————————————————————-

    End of Report

     
    时间1:00-1:30分,数据库异常1.6主机不可用,外部链接不上(OS也无法登陆,但是能ping通)
    查看警告日志没有异常
    操作系统日志
    IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION
    3A30359F   1107173411 T S init           SOFTWARE PROGRAM ERROR
    C86ACB7E   1012234311 I H hdisk9         ARRAY CONFIGURATION CHANGED
    C86ACB7E   1012234211 I H hdisk7         ARRAY CONFIGURATION CHANGED
    C86ACB7E   1012234211 I H hdisk13        ARRAY CONFIGURATION CHANGED
    C86ACB7E   1012234211 I H hdisk11        ARRAY CONFIGURATION CHANGED
    C86ACB7E   1012234211 I H hdisk15        ARRAY CONFIGURATION CHANGED
    C86ACB7E   1012234011 I H hdisk5         ARRAY CONFIGURATION CHANGED
    C86ACB7E   1012234011 I H hdisk3         ARRAY CONFIGURATION CHANGED
    3D32B80D   1012230111 P S topsvcs        NIM thread blocked
    3D32B80D   1012230111 P S topsvcs        NIM thread blocked

    2:20分左右系统自动回复故障,登陆进入cpu wait25%,idle 49%左右,无明显的使用cpu进程
    当时2边的负载
    1     1206
    2     949

    关注下主机的网络情况,程序这边出现适配器链接超时,io比较严重的排序
    ac1             0.0     33522.0     1135.5      30456      3080    33m/s,1135的tps  dac: 磁盘阵列控制器,是磁盘子系统的控制器
    dac1utm          0.0       0.0       0.0          0         0
    hdisk2          21.0     6109.5     175.9       5992       120
    hdisk3          19.0     5581.7     146.9       5528        56
    hdisk4          14.0     5637.7     150.9       5608        32
    hdisk5          46.0     6085.5     205.9       5680       408
    hdisk6          43.0     6933.1     224.9       6504       432
    hdisk7          30.0     7117.0     202.9       7064        56
    hdisk8          31.0     6933.1     179.9       6920        16
    hdisk9          14.0     6837.2     165.9       6816        24
    hdisk10         70.0     3702.5     176.9       2720       984
    hdisk11         88.0     4159.3     185.9       2576      1585
    hdisk12         84.0     4206.2     226.9       2712      1496
    hdisk13         89.0     4262.2     230.9       3128      1136
    1.6 topas io非常明显

     

    Topas Monitor for host:    cqydnw_db2           EVENTS/QUEUES    FILE/TTY
    Fri Nov 11 02:38:34 2011   Interval:  2         Cswitch   17512  Readch  5390.2K
                                                    Syscall   59631  Writech    2528
    CPU  User%  Kern%  Wait%  Idle%                 Reads       698  Rawin         0
    ALL    3.8    3.2   15.9   77.1                 Writes       14  Ttyout      660
                                                    Forks         0  Igets         0
    Network  KBPS   I-Pack  O-Pack   KB-In  KB-Out  Execs         0  Namei        67
    en0    3233.0   5469.0  3170.0  1104.1  2128.9  Runqueue    0.5  Dirblk        0
    en2      10.0     26.0    15.0     6.7     3.2  Waitqueue   2.0
    en1       0.3      1.5     1.5     0.2     0.2
    en5       0.3      3.0     1.0     0.2     0.1  PAGING           MEMORY
    lo0       0.2      2.0     2.0     0.1     0.1  Faults      796  Real,MB   23167
                                                    Steals      385  % Comp     86
    Disk    Busy%     KBPS     TPS KB-Read KB-Writ  PgspIn      194  % Noncomp  13
    dac0      0.0    28.4K   950.0   26.4K    1.9K  PgspOut      60  % Client   13
    dac1      0.0    28.3K   963.0   26.3K    2.1K  PageIn      199
    hdisk11  57.0    11.3K   263.0   10.5K  824.0   PageOut      60  PAGING SPACE
    hdisk10  84.0    11.2K   258.0   10.4K  820.2   Sios        259  Size,MB   24576
    hdisk12  74.0    11.1K   265.0   10.2K  896.0                    % Used     38
    hdisk13  57.0    11.0K   253.0   10.3K  788.5   NFS (calls/sec)  % Free     62
    hdisk9   39.0     1.7K   129.0    1.6K  112.0   ServerV2       0
    hdisk2   51.0     1.7K   135.0    1.5K  172.0   ClientV2       0   Press:
    hdisk8   31.0     1.5K   106.0    1.5K   32.0   ServerV3       0   “h” for help
    hdisk7   31.0     1.5K   108.0    1.4K   80.0   ClientV3       0   “q” to quit
    hdisk4   36.0     1.5K   106.0    1.3K  152.0
    hdisk5   43.0     1.4K    98.0    1.3K   84.0
    hdisk3   34.0     1.4K    97.0    1.3K   60.0
    hdisk6   26.0     1.4K    92.0    1.3K   36.0
    hdisk0  100.0   950.0    188.0  706.0   244.0
    同事1.6的归档进程arc
    根据以上猜测可能是io问题,同事关注下linstener的日志,由于安全基线,目前没有listener的密码
    同时,正常转台下2变得负载

       INST_ID   COUNT(*)
    ———- ———-
             1       1092
             2        866
    对比发现大概有300多个链接上来,可能机器本身性能也是个因素

    下面是故障期间的statspack的后台进程
    ^LBackground Wait Events for DB: UIDB  Instance: uidb2  Snaps: 43188 -43189
    -> ordered by wait time desc, waits desc (idle events last)

                                                                       Avg
                                                         Total Wait   wait    Waits
    Event                               Waits   Timeouts   Time (s)   (ms)     /txn
    —————————- ———— ———- ———- —— ——–
    db file parallel write             45,578          0      8,552    188      0.8
    latch free                          4,698        252        927    197      0.1
    async disk IO                      20,365          0        732     36      0.4
    都是个io紧密相关的等待

     结论:经过排查是因为某块磁盘坏道引起的,协调工程师替换磁盘问题解决

     



  • Ora-00431处理

    5.3ora 04031错误处理
    方法:
    1.flush shared_pool(最后手段)
    2.shared_pool_reserved_size
      隐藏参数_shared_pool_reserved_min_alloc (reserved_pool 最小值)
        NAME                           VALUE                DEC
       —————————— ——————– ——————————
       _shared_pool_reserved_min_allo 4400                 minimum allocation size in byt
       c                                                   es for reserved area of shared
                                                         pool
    3.dbms_shared_pool.pin pin住常用的对象(小表)

     

    Fenny:

    http://www.dbanotes.net/Oracle/Ora-04031.htm

    在继续之前,有必要理解下面的实例参数:

    SHARED_POOL_SIZE
    这个参数指定了共享池的大小,单位是字节。可以接受数字值或者数字后面跟上后缀”K” 或 “M” 。”K”代表千字节, “M”代表兆字节。
    SHARED_POOL_RESERVED_SIZE
    指定了为共享池内存保留的用于大的连续请求的共享池空间。当共享池碎片强制使 Oracle 查找并释放大块未使用的池来满足当前的请求的时候,这个参数和SHARED_POOL_RESERVED_MIN_ALLOC 参数一起可以用来避免性能下降。
    这个参数理想的值应该大到足以满足任何对保留列表中内存的请求扫描而无需从共享池中刷新对象。既然操作系统内存可以限制共享池的大小,一般来说,你应该设定这个参数为 SHARED_POOL_SIZE 参数的 10% 大小。
    SHARED_POOL_RESERVED_MIN_ALLOC 这个参数的值控制保留内存的分配。如果一个足够尺寸的大块内存在共享池空闲列表中没能找到,内存就从保留列表中分配一块比这个值大的空间。默认的值对于大多数系统来说都足够了。如果你加大这个值,那么Oracle 服务器将允许从这个保留列表中更少的分配并且将从共享池列表中请求更多的内存。这个参数在Oracle 8i 和更高的版本中是隐藏的。提交如下的语句查找这个参数值: SELECT   nam.ksppinm NAME, val.ksppstvl VALUE
        FROM x$ksppi nam, x$ksppsv val
       WHERE nam.indx = val.indx AND nam.ksppinm LIKE ‘%shared%’
    ORDER BY 1;
    10g 注释:Oracle 10g 的一个新特性叫做 “自动内存管理” 允许DBA保留一个共享内存池来分shared pool,buffer cache, java pool 和large pool。一般来说,当数据库需要分配一个大的对象到共享池中并且不能找到连续的可用空间,将自动使用其他SGA结构的空闲空间来增加共享池的大小 。既然空间分配是Oracle自动管理的,ora-4031出错的可能性将大大降低。自动内存管理在初始化参数SGA_TARGET大于0的时候被激活。当前设定可以通过查询v$sga_dynamic_components 视图获得。请参考10g管理手册以得到更多内容 。

     

     

    2.诊断ORA-04031 错误
    注:大多数的常见的 ORA-4031 的产生都和 SHARED POOL SIZE 有关,这篇文章中的诊断步骤大多都是关于共享池的。 对于其它方面如Large_pool或是Java_pool,内存分配算法都是相似的,一般来说都是因为结构不够大造成。

    ORA-04031 可能是因为 SHARED POOL 不够大,或是因为碎片问题导致数据库不能找到足够大的内存块。

    ORA-04031 错误通常是因为库高速缓冲中或共享池保留空间中的碎片。 在加大共享池大小的时 候考虑调整应用,使用共享的SQL 并且调整如下的参数:
    SHARED_POOL_SIZE,
    SHARED_POOL_RESERVED_SIZE,
    SHARED_POOL_RESERVED_MIN_ALLOC.
    首先判定是否ORA-04031 错误是由共享池保留空间中的库高速缓冲的碎片产生的。提交下的查询:
    SELECT free_space, avg_free_size,used_space, avg_used_size, request_failures,
           last_failure_size
      FROM v$shared_pool_reserved;

    SQL> SELECT free_space, avg_free_size,used_space, avg_used_size, request_failures,
      2         last_failure_size
      3    FROM v$shared_pool_reserved;

    FREE_SPACE AVG_FREE_SIZE USED_SPACE AVG_USED_SIZE REQUEST_FAILURES LAST_FAILURE_SIZE
    ———- ————- ———- ————- —————- —————–
      31061352        839496          0             0             1760              4192

    _shared_pool_reserved_min_alloc          4400                 minimum allocation size in bytes for reserved area of shared
                                                                   pool
    一种是shared_pool缺少连续的可分配空间,一种是shared_reserved_pool缺少连续的客户端请求可分配空间
    if
    REQUEST_FAILURES > 0 并且 LAST_FAILURE_SIZE > SHARED_POOL_RESERVED_MIN_ALLOC
    那么ORA-04031 错误就是因为shared_pool_reserverd_pool(共享池保留空间)缺少连续空间所致。要解决这个问题,可以考虑加大SHARED_POOL_RESERVED_MIN_ALLOC 来降低缓冲进共 享池保留空间的对象数目,并增大 SHARED_POOL_RESERVED_SIZE 和 SHARED_POOL_SIZE 来加大共享池保留空间的可用内存。

    如果:
    REQUEST_FAILURES > 0 并且 LAST_FAILURE_SIZE < SHARED_POOL_RESERVED_MIN_ALLOC
    或者
    REQUEST_FAILURES 等于0 并且 LAST_FAILURE_SIZE < SHARED_POOL_RESERVED_MIN_ALLOC
    那么是因为在库高速缓冲缺少连续空间导致ORA-04031 错误。
    第一步应该考虑降低SHARED_POOL_RESERVED_MIN_ALLOC 以放入更多的对象到共享池保留空间中并且加大SHARED_POOL_SIZE。
    解决方法ora-04031方法,查询librarycache的mis率,假如>1%,则可以尝试增加shared_pool_size来减少miss率

    SELECT SUM(PINS) “EXECUTIONS”,
                SUM(RELOADS) “CACHE MISSES WHILE EXECUTING” ,to_char(100*SUM(RELOADS) /SUM(PINS),’99999.9999′) ||’ %’ miss_ratio
                FROM V$LIBRARYCACHE;




香港马会开奖记录|香港马会开奖资料|香港马会开奖现场|香港马会走势图|香港马会开奖结果直播|香港马会n730|