11 Replies Latest reply: Jul 5, 2013 1:14 PM by $Amogh K RSS

    too many archive logs getting generated on 11.1.0.7

    871455

      I could see heavy arch generation on PROD instance although there is not much activity on PROD

      this is a fresh instance which has gone live month ago and archive log being enabled weeks ago but

      i could see about 20 to 23 GB of arch generation daily although the database size is 90 GB around

       

      Raised SR they told me its unable to Purge statistics from the SYSAUX tablespace

       

      they asked me to run some queries an run this

      exec dbms_stats.purge_stats(sysdate - 50);

      which was running for long hours and just coming out because of insufficient space

      although the retention policy is 31 days

       

      SQL> select DBMS_STATS.GET_STATS_HISTORY_RETENTION from dual;

       

      GET_STATS_HISTORY_RETENTION

      ---------------------------

                               31

      history is avail for more than 90 days

       

      SQL> select dbms_stats.get_stats_history_availability from dual;

       

      GET_STATS_HISTORY_AVAILABILITY

      ---------------------------------------------------------------------------

      01-APR-13 11.00.07.250483000 AM +05:30

       

       

      asked to apply this patch 12683802 which i applied on DEV instance

      but still i can see so many archs generating although there is no activity on DEV instance.

       

      now when i run this scripts little by little

      exec dbms_stats.purge_stats(sysdate - 50);

      its purging but its taking ages and the size of sysaux is getting filled the current size of DEV have 3 datafiles each with around 4000mb

       

       

      -- B4 applying patch

      SQL> select trunc(first_time) on_date,

        2         thread# thread,

        3         min(sequence#) min_sequence,

        4         max(sequence#) max_sequence,

        5         max(sequence#) - min(sequence#) nos_archives,

        6         (max(sequence#) - min(sequence#)) * log_avg_mb req_space_mb

        7  from   v$log_history,

        8         (select avg(bytes/1024/1024) log_avg_mb

        9          from   v$log)

      10  group  by trunc(first_time), thread#, log_avg_mb

      11  order by on_date

      12  /

       

      ON_DATE             THREAD MIN_SEQUENCE MAX_SEQUENCE NOS_ARCHIVES REQ_SPACE_MB

      --------------- ---------- ------------ ------------ ------------ ------------

      24-JUN-13                1            1            3            2         2000

      25-JUN-13                1            4           17           13        13000

      26-JUN-13                1           18           30           12        12000

      27-JUN-13                1           31           43           12        12000

      28-JUN-13                1           44           51            7         7000

      29-JUN-13                1           52           64           12        12000

      30-JUN-13                1           65           77           12        12000

      01-JUL-13                1           78           88           10        10000

       

      -- after applying patch

      ON_DATE         THREAD MIN_SEQUENCE MAX_SEQUENCE NOS_ARCHIVES REQ_SPACE_MB

      --------------- ---------- ------------ ------------ ------------ ------------

      21-JUN-13            1        1        5        4     4000
      22-JUN-13            1        6       20       14    14000
      23-JUN-13            1       21       35       14    14000
      24-JUN-13            1       36       85       49    49000
      25-JUN-13            1       86      111       25    25000
      26-JUN-13            1      112      127       15    15000
      27-JUN-13            1      128      134        6     6000
      28-JUN-13            1      135      143        8     8000
      29-JUN-13            1      144      151        7     7000
      30-JUN-13            1      152      158        6     6000
      01-JUL-13            1      159      163        4     4000

      the above results b4 and after are taken from TEST and DEV which are cloned from PROD instance and only on DEV the patch is applied

      here are env details

      EBS:21.1.3

      Database:11.1.0.7

      OS:RHEL 5.6

      am still not satisfied wanted to know if any one of you have a solution for this

      please help

      Zavi

        • 1. Re: too many archive logs getting generated on 11.1.0.7
          871455

          HI All,

           

          Does any one have some clue or workaround or support link or blog from which i can get some help

           

          please help

           

          Thanks & Regards

           

           

          Zavi

          • 2. Re: too many archive logs getting generated on 11.1.0.7
            Tushar Thakker

            Since you said on development when no activity is going on still archives are getting generated. As you can understand when archives are getting generated, means some changes are going on and since users are not doing it then it must be system who is doing automatically This will lead you to look at automatic scheduler jobs as well as automatic maintenance tasks which are running for example gathering statistics, materialized view refreshes and so on. So even though your database size is 90GB, you can see 20GB or so redo every day. You can change schedule for automatic maintenance tasks if possible and this will help you. By the way 20GB a day redo is not exactly too bad.

             

            Regards

            Tushar

            • 3. Re: too many archive logs getting generated on 11.1.0.7
              871455

              Hi Tushar,

               

              thanks for your reply,

              i wanted to know if we can find what is running at background(system generated) which is generating so much redo even though the activity is so less.

              please share any queries or note id to find so.

               

              thanks

               

              Zavi

              • 4. Re: too many archive logs getting generated on 11.1.0.7
                Tushar Thakker

                As I told you, check scheduled jobs (DB level), OS level scheduled jobs (cron in unix and scheduled tasks for wndows) for list of automated jobs. This includes the automatic maintenance task as well (you can check from scheduler or directly from Enterprise manager)

                 

                Regards

                Tushar

                • 5. Re: too many archive logs getting generated on 11.1.0.7
                  $Amogh K

                  Hi Zavi,

                  Kindly run logminer utility on set of 2 to 3 archive logs, this will give you an idea of what exactly is getting writen in logs.

                  From the output of this you can find the table details which are getting highly transacted and inturn causing an huge archive generation.

                   

                  For more details about logminer kindly go through below MOS ID

                  The LogMiner Utility [ID 62508.1]

                   

                  Thanks,

                  Amogh


                  • 6. Re: too many archive logs getting generated on 11.1.0.7
                    871455

                    Hi Amogh,

                    As said from support as well to run logminer i have run here is the output from it

                    i followed note id:1504755.1

                     

                    ------------------------------log miner output for archs of 02.07.13 on PROD------------------------

                    -- following logs

                    Jul 2 10:59 archive_PROD_1_1446_807549584.arc

                    Jul 2 11:05 archive_PROD_1_1447_807549584.arc

                     

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1446_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.NEW);

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1447_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.ADDFILE);

                     

                    SQL> select operation,seg_owner,seg_name,count(*) from v$logmnr_contents group by seg_owner,seg_name,operation;

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              APPLSYS    FND_LOGINS                        47

                    UPDATE                              PO         RCV_TRANSACTIONS_INTERFAC          2

                                                                   E

                     

                    INSERT                              PO         RCV_TRANSACTIONS                   3

                    UNSUPPORTED                         INV        MTL_SUPPLY                         6

                    DELETE                              PO         RCV_SUPPLY                         3

                    UPDATE                              CSI        CSI_ITEM_INSTANCES                 3

                    UPDATE                              APPLSYS    FND_CONC_RELEASE_CLASSES          17

                    INSERT                              JA         JAI_RTP_POPULATE_T                 3

                    INSERT                              GL         GL_CODE_COMBINATIONS               1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         JA         JAI_AP_TDS_INV_TAXES               7

                    UNSUPPORTED                         AP         AP_INVOICE_LINES_ALL               8

                    DELETE                              ZX         ZX_TRX_HEADERS_GT                  4

                    INSERT                              INV        MTL_ITEM_CATEGORIES                3

                    INSERT                              XLA        XLA_AE_HEADERS_GT                  3

                    UPDATE                              XLA        XLA_AE_HEADERS_GT                  3

                    UPDATE                              ENI        DR$ENI_DEN_HRCHY_PAR_IM1$          4

                                                                   R

                     

                    UPDATE                              APPLSYS    FND_USER_DESKTOP_OBJECTS          10

                    INSERT                              APPLSYS    FND_APPL_SESSIONS                  3

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              XLA        XLA_TRANSFER_LOGS                  2

                    INSERT                              GL         GL_JE_HEADERS                      2

                    DELETE                              GL         GL_INTERFACE_CONTROL               1

                    DELETE                              GL         GL_INTERFACE                       3

                    INSERT                              CE         CE_SECURITY_PROFILES_GT            1

                    INSERT                              PA         PA_PROJECTS_FOR_ACCUM              8

                    INSERT                              PA         PA_PJM_REQ_COMMITMENTS_TM       1162

                                                                   P

                     

                    DELETE                              PA         PA_PROJECT_ACCUM_COMMITME        162

                                                                   NTS

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    UPDATE                              PA         PA_TXN_ACCUM                    1749

                    UPDATE                              PA         PA_RESOURCE_LIST_ASSIGNME         13

                                                                   NTS

                     

                    INSERT                              ENI        ENI_OLTP_ITEM_STAR                 1

                    START                                                                           561

                    COMMIT                                                                          934

                    INSERT                              ICX        ICX_SESSION_ATTRIBUTES            45

                    INSERT                              INV        MTL_SUPPLY                         8

                    UPDATE                              INV        MTL_MATERIAL_TRANSACTIONS         11

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   _TEMP

                     

                    INSERT                              CSI        CSI_TRANSACTIONS                   3

                    INSERT                              CSI        CSI_I_VERSION_LABELS               1

                    INSERT                              CSI        CSI_I_VERSION_LABELS_H             1

                    INSERT                              JA         JAI_RTP_TRANS_T                    3

                    INSERT                              JA         JAI_AP_INVOICE_LINES               1

                    UNSUPPORTED                         AP         AP_INVOICE_DISTRIBUTIONS_          9

                                                                   ALL

                     

                    DELETE                              BOM        BOM_RESOURCE_CHANGES               2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    ROLLBACK                                                                          3

                    INSERT                              XLA        XLA_TRANSACTION_ENTITIES,          2

                                                                   AP

                     

                    INSERT                              ENI        MLOG$_ENI_OLTP_ITEM_STAR           7

                    UNSUPPORTED                         XLA        XLA_TRANSACTION_ENTITIES,          4

                                                                   AP

                     

                    INSERT                              XLA        XLA_DISTRIBUTION_LINKS,AP          6

                    UPDATE                              QA         QA_CHARS                           1

                    UPDATE                              MRP        MRP_SCHEDULE_DATES                 7

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              ENI        ENI_DENORM_HIERARCHIES             4

                    UNSUPPORTED                         SYS        SEG$                               1

                    INSERT                              INV        MTL_TRANSACTION_ACCOUNTS           4

                    UPDATE                              APPLSYS    FND_USER_PREFERENCES               5

                    DELETE                              SYS        WRI$_OPTSTAT_HISTHEAD_HIS     235644

                                                                   TORY

                     

                    INSERT                              BNE        BNE_DOC_USER_PARAMS                1

                    INSERT                              GL         GL_INTERFACE                       6

                    INSERT                              GL         GL_JE_LINES                        4

                    INSERT                              GL         GL_JE_SEGMENT_VALUES               2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              GL         GL_IMPORT_REFERENCES               4

                    UPDATE                              PA         PA_MAPPABLE_TXNS_TMP               3

                    UPDATE                              PA         PA_PROJECT_ACCUM_COMMITME         95

                                                                   NTS

                     

                    INSERT                              INV        MLOG$_MTL_SYSTEM_ITEMS_B           1

                    INSERT                              INV        MTL_SYSTEM_ITEMS_TL                1

                    UPDATE                              APPLSYS    FND_CONFLICTS_DOMAIN            6040

                    INSERT                              APPLSYS    MO_GLOB_ORG_ACCESS_TMP            97

                    UPDATE                              APPLSYS    FND_CONCURRENT_QUEUES            117

                    UNSUPPORTED                         JA         JAI_RCV_LINES                      3

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              INV        MLOG$_MTL_MATERIAL_TRANSA         21

                                                                   C

                     

                    INSERT                              CSI        CSI_ITEM_INSTANCES                 1

                    INSERT                              JA         JAI_AP_TDS_INV_TAXES               2

                    INSERT                              BOM        BOM_RES_INSTANCE_CHANGES           2

                    INSERT                              PA         PA_TXN_INTERFACE_AUDIT_AL          4

                                                                   L

                     

                    INSERT                              PA         PA_EXPENDITURE_COMMENTS            2

                    DELETE                              PA         PA_TRANSACTION_XFACE_CTRL          1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   _ALL

                     

                    INSERT                              AP         AP_LINE_TEMP_GT                    3

                    UPDATE                              ENI        ENI_OLTP_ITEM_STAR                 3

                    INSERT                              XLA        XLA_EVENTS_GT                      3

                    UPDATE                              XLA        XLA_EVENTS_GT                      3

                    UPDATE                              XLA        XLA_AE_HEADERS,AP                  8

                    DELETE                              XLA        XLA_VALIDATION_LINES_GT            2

                    INSERT                              INV        MTL_TXN_COST_DET_INTERFAC          2

                                                                   E

                     

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              INV        MTL_CST_TXN_COST_DETAILS           2

                    DELETE                              INV        MTL_TXN_COST_DET_INTERFAC          2

                                                                   E

                     

                    UNSUPPORTED                         SYS        HISTGRM$                          16

                    UPDATE                              INV        MTL_MATERIAL_TRANSACTIONS          6

                    INSERT                              XLA        XLA_EVENTS,CST                     3

                    DELETE                              BNE        BNE_DOC_ACTIONS                    1

                    INSERT                              GL         GL_INTERFACE_CONTROL               2

                    INSERT                              XLA        XLA_TB_WORK_UNITS                  1

                    UPDATE                              ZX         ZX_TRX_HEADERS_GT                 67

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DDL                                 SYS        SYS_TEMP_0FD9D6611_EC264F          1

                                                                   91

                     

                    DELETE                              PA         PA_TXN_ACCUM_DETAILS            1327

                    UNSUPPORTED                         PA         PA_TXN_ACCUM                     523

                    INSERT                              PA         PA_MAPPABLE_TXNS_TMP               2

                    DELETE                              PA         PA_RESOURCE_LIST_PARENTS_          2

                                                                   TMP

                     

                    DELETE                              PA         PA_PROJECTS_FOR_ACCUM             17

                    UPDATE                              SYS        SEQ$                             224

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              APPLSYS    WF_DEFERRED                        5

                    UPDATE                              APPLSYS    FND_CONC_PROG_ONSITE_INFO         51

                    INSERT                              APPLSYS    FND_CONCURRENT_REQUESTS           46

                    INSERT                              PO         PO_SESSION_GT                      7

                    INSERT                              INV        MTL_MATERIAL_TRANSACTIONS          5

                                                                   _TEMP

                     

                    INSERT                              INV        MTL_ONHAND_QUANTITIES_DET          3

                                                                   AIL

                     

                    UPDATE                              SYS        SYS_FBA_BARRIERSCN                 2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              MRP        MRP_MESSAGES_TMP                  29

                    DELETE                              MRP        MRP_MESSAGES_TMP                  29

                    UPDATE                              AP         AP_INVOICES_ALL                   15

                    UPDATE                              JA         JAI_AP_TDS_INV_TAXES              43

                    INSERT                              BOM        MLOG$_BOM_RESOURCE_CHANGE          4

                                                                   S

                     

                    UNSUPPORTED                         PA         PA_TRANSACTION_INTERFACE_          2

                                                                   ALL

                     

                    INSERT                              PA         PA_EXPENDITURE_GROUPS_ALL          1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              PA         PA_EXPENDITURE_ITEMS_ALL           2

                    INSERT                              AP         AP_INVOICE_LINES_ALL               3

                    INSERT                              APPLSYS    FND_LOG_MESSAGES                  29

                    INSERT                              ZX         ZX_ITM_DISTRIBUTIONS_GT           71

                    UNSUPPORTED                         ZX         ZX_TRX_HEADERS_GT                  5

                    INSERT                              XLA        XLA_EVENTS,AP                      3

                    UPDATE                              AP         AP_PREPAY_HISTORY_ALL              3

                    UPDATE                              AP         AP_PREPAY_APP_DISTS                1

                    INSERT                              INV        MLOG$_MTL_ITEM_CATEGORIES          3

                    INSERT                              XLA        XLA_AE_LINES,AP                    6

                    DELETE                              XLA        XLA_AE_HEADERS_GT                  1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              SYS        HIST_HEAD$                        76

                    INSERT                              SYS        WRI$_OPTSTAT_IND_HISTORY          10

                    UNSUPPORTED                         ENI        DR$ENI_DEN_HRCHY_PAR_IM1$          3

                                                                   R

                     

                    UPDATE                              INV        MTL_CST_ACTUAL_COST_DETAI          3

                                                                   LS

                     

                    INSERT                              XLA        XLA_TRANSACTION_ENTITIES,          3

                                                                   CST

                     

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              ICX        ICX_TRANSACTIONS                   1

                    UPDATE                              GL         GL_INTERFACE                       4

                    UPDATE                              PO         PO_REQ_DISTRIBUTIONS_ALL          66

                    UNSUPPORTED                         PO         PO_REQUISITION_HEADERS_AL          1

                                                                   L

                     

                    UNSUPPORTED                         PO         PO_REQUISITION_LINES_ALL          66

                    DELETE                              PA         PA_COMMITMENT_TXNS              1461

                    UNSUPPORTED                         PA         PA_MAPPABLE_TXNS_TMP               3

                    INSERT                              PA         PA_PROJECT_ACCUM_COMMITME        197

                                                                   NTS

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    INSERT                              BOM        CST_ITEM_COSTS                     1

                    INSERT                              JA         JAI_RCV_TRANSACTIONS               3

                    UPDATE                              PO         RCV_SUPPLY                         3

                    UPDATE                              INV        MTL_SUPPLY                        11

                    DELETE                              INV        MTL_SUPPLY                        11

                    UPDATE                              PO         PO_DISTRIBUTIONS_ALL               3

                    UPDATE                              PO         PO_LINE_LOCATIONS_ALL              9

                    INSERT                              INV        MLOG$_MTL_ONHAND_QUANTITI          3

                                                                   E

                     

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              PO         RCV_TRANSACTIONS_INTERFAC          3

                                                                   E

                     

                    INSERT                              MRP        MRP_MESSAGES_TMP                  22

                    INSERT                              AP         AP_INVOICE_DISTRIBUTIONS_          3

                                                                   ALL

                     

                    UPDATE                              AP         AP_INVOICE_DISTRIBUTIONS_         30

                                                                   ALL

                     

                    INSERT                              PA         PA_EXPENDITURES_ALL                1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              ZX         ZX_TRX_HEADERS_GT                  8

                    UNSUPPORTED                         ZX         ZX_LINES_DET_FACTORS             566

                    DELETE                              AP         AP_LINE_TEMP_GT                    9

                    UPDATE                              AP         AP_PAYMENT_SCHEDULES_ALL           5

                    UPDATE                              ICX        ICX_SESSIONS                      12

                    UNSUPPORTED                         AP         AP_INVOICES_ALL                    3

                    INSERT                              JA         JAI_RCV_JOURNAL_ENTRIES            4

                    UNSUPPORTED                         INV        MTL_TRANSACTIONS_INTERFAC         24

                                                                   E

                     

                    UPDATE                              MRP        MRP_RECOMMENDATIONS               14

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              ENI        MLOG$_ENI_DENORM_HIERARCH         16

                                                                   I

                     

                    INSERT                              SYS        WRI$_OPTSTAT_HISTGRM_HIST          8

                                                                   ORY

                     

                    INSERT                              APPLSYS    WF_CONTROL                         1

                    UPDATE                              BNE        BNE_DOC_USER_PARAMS                1

                    DELETE                              APPLSYS    WF_CONTROL                         1

                    UPDATE                              GL         GL_JE_BATCHES                      2

                    INSERT                              GL         GL_POSTING_INTERIM                 1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         JA         JAI_PO_OSP_LINES                   1

                    INSERT                              AP         AP_INVOICES_ALL                    2

                    INSERT                              PA         PA_COMMITMENT_TXNS_TMP           160

                    UPDATE                              PA         PA_COMMITMENT_TXNS              1391

                    DELETE                              PA         PA_MAPPABLE_TXNS_TMP               3

                    INTERNAL                                                                    4906910

                    UPDATE                              APPLSYS    FND_CONCURRENT_REQUESTS          153

                    UPDATE                              JA         JAI_RCV_LINES                      3

                    INSERT                              INV        MLOG$_MTL_SUPPLY                  30

                    INSERT                              CSI        CSI_I_PARTIES_H                    1

                    UNSUPPORTED                         JA         JAI_RCV_TRANSACTIONS               7

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              JA         JAI_RCV_TRANSACTIONS              24

                    INSERT                              MRP        MRP_RECOMMENDATIONS                8

                    UNSUPPORTED                         AP         AP_PAYMENT_SCHEDULES_ALL           4

                    UPDATE                              PA         PA_TRANSACTION_INTERFACE_          4

                                                                   ALL

                     

                    INSERT                              XLA        XLA_ACCT_PROG_EVENTS_GT            4

                    INSERT                              XLA        XLA_AE_LINES_GT                   12

                    UNSUPPORTED                         XLA        XLA_AE_LINES_GT                   30

                    INSERT                              XLA        XLA_AE_HEADERS,AP                  3

                    INSERT                              XLA        XLA_VALIDATION_LINES_GT            3

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              XLA        XLA_EVENTS_GT                      1

                    UNSUPPORTED                         XLA        XLA_BAL_CONCURRENCY_CONTR          2

                                                                   OL

                     

                    DELETE                              XLA        XLA_BAL_CONCURRENCY_CONTR          2

                                                                   OL

                     

                    INSERT                              APPLSYS    FND_CONC_REQUEST_ARGUMENT          2

                                                                   S

                     

                    UPDATE                              QA         QA_RESULTS                         2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              MRP        MRP_SCHEDULE_CONSUMPTIONS         21

                    INSERT                              ENI        ENI_DENORM_HRCHY_PARENTS           4

                    UNSUPPORTED                         ENI        ENI_DENORM_HRCHY_PARENTS           4

                    UPDATE                              APPLSYS    FND_USER                           6

                    INSERT                              XLA        XLA_TRANSFER_LOGS                  2

                    UPDATE                              GL         GL_JE_LINES                        4

                    UPDATE                              APPLSYS    FND_NODES                          3

                    UNSUPPORTED                         PO         PO_REQ_DISTRIBUTIONS_ALL          66

                    DELETE                              ZX         ZX_ITM_DISTRIBUTIONS_GT           66

                    INSERT                              AP         AP_PAYMENT_SCHEDULES_ALL           2

                    INSERT                              IBY        IBY_DOCS_PAYABLE_GT                2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              AP         AP_DOC_SEQUENCE_AUDIT              1

                    INSERT                              PA         PA_COMMITMENT_TXNS              1380

                    INSERT                              PA         PA_RESOURCE_ACCUM_DETAILS          3

                    INSERT                              ENI        DR$ENI_DEN_HRCHY_PAR_IM1$         19

                                                                   I

                     

                    UPDATE                              PA         PA_PROJECT_ACCUM_ACTUALS          12

                    INSERT                              EGO        EGO_ITEM_TEXT_TL                   1

                    INSERT                              INV        MTL_ITEM_REVISIONS_TL              1

                    UNSUPPORTED                                                                    1720

                    INSERT                              APPLSYS    FND_CONC_PP_ACTIONS               47

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         APPLSYS    FND_CONCURRENT_PROCESSES          97

                    DELETE                              APPLSYS    MO_GLOB_ORG_ACCESS_TMP            11

                    INSERT                              MRP        MRP_RELIEF_INTERFACE              16

                    UPDATE                              PO         PO_REQUISITION_LINES_ALL           1

                    INSERT                              INV        MTL_MATERIAL_TRANSACTIONS          5

                    INSERT                              CSI        CSI_I_PARTIES                      1

                    UNSUPPORTED                         SYS        DBMS_LOCK_ALLOCATED               15

                    UPDATE                              PO         PO_SESSION_GT                      4

                    INSERT                              MRP        MRP_SCHEDULE_DATES                 4

                    INSERT                              MRP        MLOG$_MRP_SCHEDULE_DATES          15

                    DELETE                              MRP        MRP_SCHEDULE_DATES                 4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              BOM        BOM_RES_INSTANCE_CHANGES           2

                    INSERT                              PA         PA_COST_DISTRIBUTION_LINE          2

                                                                   S_ALL

                     

                    INSERT                              ZX         ZX_TRANSACTION_LINES_GT          138

                    UNSUPPORTED                         CSI        CSI_ITEM_INSTANCES                 2

                    UNSUPPORTED                         XLA        XLA_EVENTS,AP                      6

                    INSERT                              XLA        XLA_AE_SEGMENT_VALUES             13

                    UNSUPPORTED                         SYS        TAB$                              15

                    INSERT                              SYS        WRI$_OPTSTAT_HISTHEAD_HIS      81562

                                                                   TORY

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    DDL                                 SYS        SYS_TEMP_0FD9D6610_EC264F          1

                                                                   91

                     

                    UNSUPPORTED                         SYS        IND$                              10

                    DELETE                              APPLSYS    FND_CONC_PP_ACTIONS                7

                    INSERT                              BNE        BNE_DOC_ACTIONS                    1

                    INSERT                              GL         GL_JE_BATCHES                      1

                    INSERT                              PA         PA_TXN_ACCUM_DETAILS            1386

                    INSERT                              PA         PA_TXN_ACCUM                       2

                    INSERT                              PA         PA_RESOURCE_LIST_PARENTS_          2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   TMP

                     

                    UPDATE                              CTXSYS     DR$INDEX                           1

                    INSERT                              INV        MTL_PENDING_ITEM_STATUS            1

                    DELETE                              SYS        WRI$_OPTSTAT_IND_HISTORY     2130287

                    UNSUPPORTED                         APPLSYS    FND_CONCURRENT_REQUESTS           49

                    INSERT                              PO         RCV_TRANSACTIONS_INTERFAC          3

                                                                   E

                     

                    UPDATE                              APPLSYS    FND_CONCURRENT_PROCESSES          40

                    UPDATE                              PO         RCV_TRANSACTIONS                   3

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         PO         PO_HEADERS_ALL                     3

                    INSERT                              INV        MTL_CST_TXN_COST_DETAILS           5

                    INSERT                              CSI        CSI_ITEM_INSTANCES_H               3

                    DELETE                              INV        MTL_MATERIAL_TRANSACTIONS          5

                                                                   _TEMP

                     

                    UPDATE                              SYS        DBMS_LOCK_ALLOCATED               15

                    DELETE                              MRP        MRP_RECOMMENDATIONS                8

                    UPDATE                              AP         AP_INVOICE_LINES_ALL              11

                    INSERT                              BOM        MLOG$_BOM_RES_INSTANCE_CH          4

                                                                   A

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    INSERT                              BOM        BOM_RESOURCE_CHANGES               2

                    UPDATE                              PA         PA_TRANSACTION_XFACE_CTRL          1

                                                                   _ALL

                     

                    INSERT                              AP         AP_PREPAY_HISTORY_ALL              1

                    INSERT                              AP         AP_PREPAY_APP_DISTS                1

                    INSERT                              XLA        XLA_EVT_CLASS_ORDERS_GT            4

                    UPDATE                              XLA        XLA_EVENTS,AP                      6

                    INSERT                              ENI        ENI_DENORM_HIERARCHIES             6

                    INSERT                              SYS        WRI$_OPTSTAT_TAB_HISTORY           5

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         XLA        XLA_AE_HEADERS_GT                  3

                    UPDATE                              BNE        BNE_DOC_ACTIONS                    1

                    UPDATE                              GL         GL_JE_HEADERS                      2

                    DELETE                              XLA        XLA_TRANSFER_LOGS                  1

                    UNSUPPORTED                         ZX         ZX_TRANSACTION_LINES_GT          264

                    INSERT                              PA         PA_PJM_PO_COMMITMENTS_TMP        378

                    UNSUPPORTED                         INV        MTL_SYSTEM_ITEMS_B                 2

                    INSERT                              INV        MTL_ITEM_REVISIONS_B               1

                     

                    266 rows selected.

                     

                     

                    ------------------------------log miner output for archs of 03.07.13 on PROD------------------------

                    --following log files

                    Jul 3 10:56 archive_PROD_1_1469_807549584.arc

                    Jul 3 10:58 archive_PROD_1_1470_807549584.arc

                    Jul 3 11:01 archive_PROD_1_1471_807549584.arc

                    Jul 3 11:03 archive_PROD_1_1472_807549584.arc

                    Jul 3 11:04 archive_PROD_1_1473_807549584.arc

                    Jul 3 11:05 archive_PROD_1_1474_807549584.arc

                     

                     

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1469_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.ADDFILE);

                     

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1470_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.ADDFILE);

                     

                     

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1471_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.ADDFILE);

                     

                     

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1472_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.ADDFILE);

                     

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1473_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.ADDFILE);

                     

                     

                    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -

                         LOGFILENAME => '/archive_prod/prod/archive_PROD_1_1474_807549584.arc', -

                         OPTIONS => DBMS_LOGMNR.ADDFILE);

                     

                     

                    SQL> select operation,seg_owner,seg_name,count(*) from v$logmnr_contents group by seg_owner,seg_name,operation;

                     

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              SYS        CCOL$                              6

                    DELETE                              SYS        SEG$                               3

                    INSERT                              APPLSYS    FND_LOGINS                       108

                    UPDATE                              APPLSYS    FND_CONC_RELEASE_CLASSES          33

                    UPDATE                              PO         RCV_TRANSACTIONS_INTERFAC          4

                                                                   E

                     

                    INSERT                              APPLSYS    FND_LOG_TRANSACTION_CONTE          1

                                                                   XT

                     

                    INSERT                              PO         RCV_TRANSACTIONS                   2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         INV        MTL_SUPPLY                         4

                    INSERT                              PO         RCV_RECEIVING_SUB_LEDGER           4

                    INSERT                              GL         GL_JE_HEADERS                     12

                    DELETE                              GL         GL_INTERFACE                      49

                    DELETE                              GL         GL_INTERFACE_CONTROL               8

                    INSERT                              JA         JAI_RTP_POPULATE_T                 1

                    INSERT                              JA         JAI_RGM_TRM_SCHEDULES_T            4

                    UPDATE                              JA         JAI_RCV_CENVAT_CLAIMS              2

                    INSERT                              APPLSYS    FND_APPL_SESSIONS                  9

                    UPDATE                              APPLSYS    WF_NOTIFICATIONS                   4

                    UPDATE                              PO         PO_HEADERS_INTERFACE              10

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              PO         PO_DISTRIBUTIONS_INTERFAC          6

                                                                   E

                     

                    INSERT                              JA         JAI_PO_LINE_LOCATIONS             18

                    UNSUPPORTED                         PO         PO_LINE_LOCATIONS_ALL              2

                    UNSUPPORTED                         PO         PO_LINES_ALL                       8

                    DELETE                              ZX         ZX_TRX_HEADERS_GT                 14

                    INSERT                              PA         PA_STRUCTURES_TASKS_TMP          440

                    INSERT                              SYS        SEQ$                               2

                    INSERT                              BNE        BNE_DOC_CREATION_PARAMS            9

                    UPDATE                              ENI        DR$ENI_DEN_HRCHY_PAR_IM1$          6

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   R

                     

                    INSERT                              SYS        MON_MODS$                          9

                    UPDATE                              PA         PA_PROJECTS_ALL                    4

                    UPDATE                              WIP        WIP_MOVE_TXN_INTERFACE             1

                    INSERT                              CE         CE_SECURITY_PROFILES_GT            8

                    UPDATE                              WIP        WIP_PERIOD_BALANCES                1

                    INSERT                              INV        MTL_MWB_GTMP                      14

                    UPDATE                              SYS        WRI$_SCH_CONTROL                   1

                    DELETE                              SYS        OBJ$                              51

                    DDL                                 SYS        WRH$_ROWCACHE_SUMMARY              1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DDL                                 SYS        WRH$_ACTIVE_SESSION_HISTO          1

                                                                   RY

                     

                    DDL                                 SYS        WRH$_SYS_TIME_MODEL                1

                    INSERT                              IBY        IBY_DOCS_PAYABLE_ALL               6

                    UPDATE                              IBY        IBY_DOCS_PAYABLE_ALL              36

                    INSERT                              GL         GL_CODE_COMBINATIONS               3

                    INSERT                              XLA        XLA_AE_HEADERS_GT                 12

                    UPDATE                              XLA        XLA_AE_HEADERS_GT                 12

                    INSERT                              APPLSYS    FND_CP_GSM_OPP_AQTBL               2

                    UNSUPPORTED                         AP         AP_INVOICE_LINES_ALL              22

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         JA         JAI_AP_TDS_INV_TAXES              19

                    DDL                                                                               1

                    UPDATE                              INV        MTL_TXN_REQUEST_LINES             13

                    UPDATE                              CSI        CSI_ITEM_INSTANCES                 2

                    DELETE                              APPLSYS    FND_CP_GSM_OPP_AQTBL               2

                    UPDATE                              XLA        XLA_TRANSFER_LOGS                  8

                    INSERT                              PA         PA_TRANSACTION_INTERFACE_          3

                                                                   ALL

                     

                    INSERT                              ENI        ENI_OLTP_ITEM_STAR                 4

                    INSERT                              INV        MTL_ITEM_CATEGORIES                8

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              PA         PA_PROJECTS_FOR_ACCUM             35

                    INSERT                              PA         PA_PJM_REQ_COMMITMENTS_TM       1186

                                                                   P

                     

                    DELETE                              PA         PA_PROJECT_ACCUM_COMMITME        141

                                                                   NTS

                     

                    UPDATE                              PA         PA_TXN_ACCUM                    1847

                    UPDATE                              PA         PA_RESOURCE_LIST_ASSIGNME         17

                                                                   NTS

                     

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              IBE        IBE_CT_IMEDIA_SEARCH           46838

                    START                                                                          6520

                    COMMIT                                                                         7966

                    UNSUPPORTED                         SYS        SEG$                             599

                    UNSUPPORTED                         SYS        ICOL$                             28

                    INSERT                              SYS        SECOBJ$                            8

                    UNSUPPORTED                         SYS        COL$                              36

                    UNSUPPORTED                         SYS        CCOL$                             30

                    UNSUPPORTED                         SYS        CDEF$                             24

                    DDL                                 APPS       SYS_IOT_TOP_739624                 1

                    DDL                                 APPS       DR$IBE_CT_IMEDIA_SEARCH_I          3

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   M$K

                     

                    INSERT                              UNKNOWN    OBJ# 739626                       22

                    DDL                                 APPS       DR$IBE_CT_IMEDIA_SEARCH_I          2

                                                                   M$X

                     

                    INSERT                              PO         RCV_SHIPMENT_HEADERS               1

                    INSERT                              INV        MTL_SUPPLY                         2

                    INSERT                              APPLSYS    WF_DEFERRED                        5

                    UPDATE                              MRP        MRP_SCHEDULE_DATES                 2

                    INSERT                              BNE        BNE_DOC_USER_PARAMS                4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    ROLLBACK                                                                         33

                    INSERT                              GL         GL_INTERFACE                      62

                    INSERT                              ICX        ICX_SESSION_ATTRIBUTES           352

                    UNSUPPORTED                         XLA        XLA_TRANSACTION_ENTITIES,         18

                                                                   AP

                     

                    INSERT                              GL         GL_JE_LINES                       61

                    INSERT                              GL         GL_JE_SEGMENT_VALUES              12

                    INSERT                              JA         JAI_RTP_TRANS_T                    1

                    UNSUPPORTED                         APPLSYS    WF_DEFERRED                       13

                    DELETE                              JA         JAI_PO_LINE_LOCATIONS             12

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              INV        MTL_TRANSACTION_ACCOUNTS           6

                    INSERT                              QA         QA_RESULTS                         1

                    UPDATE                              QA         QA_CHARS                           1

                    DELETE                              BOM        BOM_RESOURCE_CHANGES               4

                    INSERT                              WIP        MLOG$_WIP_OPERATIONS               3

                    INSERT                              WIP        MLOG$_WIP_OPERATION_RESOU          3

                                                                   R

                     

                    UPDATE                              ENI        ENI_DENORM_HIERARCHIES             6

                    UNSUPPORTED                         WIP        WIP_OPERATIONS                     1

                    UPDATE                              WIP        WIP_OPERATION_OVERHEADS            8

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              XLA        XLA_EVENTS_INT_GT                  9

                    DELETE                              WIP        WIP_COST_TXN_INTERFACE             1

                    DELETE                              SYS        INDPART$                          20

                    DDL                                 SYS        WRH$_SEG_STAT                      1

                    UPDATE                              SYS        MON_MODS_ALL$                    203

                    DELETE                              SYS        WRI$_OPTSTAT_TAB_HISTORY     1518271

                    INSERT                              JA         JAI_AP_INVOICE_LINES               6

                    INSERT                              XLA        XLA_TRANSACTION_ENTITIES,          8

                                                                   AP

                     

                    INSERT                              IBY        IBY_TRXN_DOCUMENTS                 4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              AP         AP_PAYMENT_HIST_DISTS             12

                    INSERT                              XLA        XLA_DISTRIBUTION_LINKS,AP         40

                    UNSUPPORTED                         IEX        IEX_DLN_UWQ_SUMMARY               49

                    UNSUPPORTED                         AP         AP_INVOICE_DISTRIBUTIONS_         24

                                                                   ALL

                     

                    DELETE                              CTXSYS     DR$INDEX                           1

                    DDL                                 IBE        IBE_CT_IMEDIA_SEARCH               1

                    UPDATE                              INV        MTL_MATERIAL_TRANSACTIONS          8

                                                                   _TEMP

                     

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              INV        MTL_DO_CHECK_TEMP                  2

                    INSERT                              CSI        CSI_TRANSACTIONS                   2

                    INSERT                              GL         GL_IMPORT_REFERENCES              22

                    UNSUPPORTED                         PA         PA_TRANSACTION_XFACE_CTRL          1

                                                                   _ALL

                     

                    INSERT                              INV        MLOG$_MTL_SYSTEM_ITEMS_B           3

                    INSERT                              INV        MTL_SYSTEM_ITEMS_TL                3

                    INSERT                              ENI        MLOG$_ENI_OLTP_ITEM_STAR          22

                    DELETE                              SYS        WRI$_OPTSTAT_HISTHEAD_HIS     178932

                                                                   TORY

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    INSERT                              BOM        BOM_SMALL_EXPL_TEMP              280

                    UPDATE                              PA         PA_PROJECT_ACCUM_COMMITME        109

                                                                   NTS

                     

                    UPDATE                              PA         PA_MAPPABLE_TXNS_TMP               5

                    UPDATE                              APPLSYS    FND_CONFLICTS_DOMAIN           14318

                    INSERT                              APPLSYS    MO_GLOB_ORG_ACCESS_TMP           284

                    INSERT                              SYS        OBJ$                              24

                    DDL                                 APPS       DR$IBE_CT_IMEDIA_SEARCH_I          3

                                                                   M$I

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    UPDATE                              UNKNOWN    OBJ# 739626                       16

                    DDL                                 APPS       IBE_CT_IMEDIA_SEARCH_IM            2

                    INSERT                              JA         JAI_RCV_HEADERS                    1

                    INSERT                              XLA        XLA_EVENTS,CST                    14

                    INSERT                              PO         RCV_SHIPMENT_LINES                 1

                    DELETE                              BNE        BNE_DOC_ACTIONS                    5

                    UPDATE                              BNE        BNE_ASYNC_UPLOAD_JOBS              1

                    UPDATE                              APPLSYS    FND_CONCURRENT_QUEUES            188

                    UPDATE                              INV        MTL_MATERIAL_TRANSACTIONS          5

                    INSERT                              PO         PO_LINES_ALL                       6

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              PO         PO_LINE_LOCATIONS_ALL              6

                    UPDATE                              ZX         ZX_TRX_HEADERS_GT                 18

                    UNSUPPORTED                         GL         GL_JE_HEADERS                      1

                    INSERT                              PJI        PJI_PLAN_EXTR_TMP                 18

                    DELETE                              SYS        IDL_UB1$                           2

                    INSERT                              BOM        BOM_RES_INSTANCE_CHANGES           4

                    UPDATE                              WIP        WIP_DISCRETE_JOBS                  2

                    UNSUPPORTED                         SYS        HISTGRM$                          24

                    UPDATE                              PA         PA_PROJ_ROLLUP_BULK_TEMP         112

                    UNSUPPORTED                         PA         PA_PROJECTS_ALL                    2

                    UPDATE                              WIP        WIP_OPERATIONS                     2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         WIP        WIP_PERIOD_BALANCES                1

                    DELETE                              INV        MTL_MWB_GTMP                       9

                    UPDATE                              SYS        WRM$_SNAPSHOT                     24

                    DDL                                 SYS        WRH$_FILESTATXS                    1

                    UPDATE                              SYS        PARTOBJ$                          39

                    INSERT                              IBY        IBY_PAY_SERVICE_REQUESTS           4

                    INSERT                              APPS       IBY_DOCS_IN_PMT_GT                 4

                    INSERT                              IBY        IBY_PAYMENTS_ALL                   4

                    UPDATE                              IBY        IBY_PAYMENTS_ALL                  24

                    UPDATE                              APPLSYS    FND_LOBS                         269

                    INSERT                              XLA        XLA_EVENTS_GT                     10

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              AP         AP_INVOICE_PAYMENTS_ALL           18

                    UPDATE                              XLA        XLA_EVENTS_GT                     12

                    UPDATE                              XLA        XLA_AE_HEADERS,AP                 36

                    UPDATE                              IEX        IEX_DLN_UWQ_SUMMARY              150

                    INSERT                              AP         AP_LINE_TEMP_GT                    8

                    DELETE                              SYS        CON$                               8

                    INSERT                              INV        MLOG$_MTL_MATERIAL_TRANSA         13

                                                                   C

                     

                    INSERT                              INV        MTL_ONHAND_LOCK_TEMP               2

                    DELETE                              INV        MTL_ONHAND_LOCK_TEMP               2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              XLA        XLA_VALIDATION_LINES_GT            4

                    INSERT                              GL         GL_INTERFACE_CONTROL               8

                    UNSUPPORTED                         WIP        WIP_TRANSACTIONS                   1

                    UPDATE                              WIP        WIP_TRANSACTIONS                   5

                    INSERT                              JA         JAI_AP_TDS_INV_TAXES               5

                    INSERT                              PA         PA_TXN_INTERFACE_AUDIT_AL         18

                                                                   L

                     

                    INSERT                              QA         QA_INSP_COLLECTIONS_TEMP           1

                    UPDATE                              QA         QA_INSP_PLANS_TEMP                 2

                    UPDATE                              ENI        ENI_OLTP_ITEM_STAR                 9

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         ICX        ICX_CAT_ATTRIBUTE_VALUES           4

                    INSERT                              ICX        ICX_CAT_ITEMS_CTX_DTLS_TL         18

                                                                   P

                     

                    UNSUPPORTED                         ICX        DR$ICX_CAT_ITEMSCTXDESC_H          1

                                                                   DRS$R

                     

                    UPDATE                              ICX        DR$ICX_CAT_ITEMSCTXDESC_H          2

                                                                   DRS$R

                     

                    DELETE                              PA         PA_TXN_ACCUM_DETAILS            1400

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         PA         PA_TXN_ACCUM                     596

                    INSERT                              PA         PA_MAPPABLE_TXNS_TMP               4

                    DELETE                              PA         PA_RESOURCE_LIST_PARENTS_          6

                                                                   TMP

                     

                    DELETE                              PA         PA_PROJECTS_FOR_ACCUM             23

                    UPDATE                              SYS        SEQ$                            2913

                    UPDATE                              APPLSYS    FND_CONC_PROG_ONSITE_INFO         81

                    INSERT                              SYS        CON$                              16

                    DDL                                 APPS       DR$IBE_CT_IMEDIA_SEARCH_I          3

                                                                   M$N

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    INSERT                              SYS        DBMS_LOCK_ALLOCATED                2

                    INSERT                              APPLSYS    FND_CONCURRENT_REQUESTS           99

                    UPDATE                              PO         RCV_SHIPMENT_LINES                 2

                    INSERT                              PO         PO_SESSION_GT                     33

                    INSERT                              PO         RCV_ACCOUNTING_EVENTS              2

                    INSERT                              APPLSYS    FND_LOG_MESSAGES                  88

                    INSERT                              XLA        XLA_TRANSACTION_ENTITIES,         14

                                                                   CST

                     

                    UPDATE                              PO         RCV_RECEIVING_SUB_LEDGER           4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              MRP        MRP_MESSAGES_TMP                  26

                    DELETE                              MRP        MRP_MESSAGES_TMP                  28

                    UPDATE                              GL         GL_INTERFACE                      64

                    INSERT                              JA         JAI_RCV_CENVAT_CLAIMS              1

                    DELETE                              PA         PA_PERF_EXCP_MSR_TEMP           6031

                    UNSUPPORTED                         PO         PO_REQUISITION_LINES_ALL           6

                    INSERT                              PO         PO_LINES_INTERFACE                 6

                    INSERT                              ZX         ZX_ITM_DISTRIBUTIONS_GT           30

                    UPDATE                              SYS        SYS_FBA_BARRIERSCN                 4

                    UPDATE                              INV        MTL_CST_ACTUAL_COST_DETAI          3

                                                                   LS

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    INSERT                              SYS        IDL_SB4$                           4

                    DELETE                              SYS        IDL_UB2$                           4

                    DELETE                              SYS        IDL_SB4$                           4

                    DELETE                              APPLSYS    WF_DEFERRED                        4

                    INSERT                              BOM        MLOG$_BOM_RESOURCE_CHANGE          8

                                                                   S

                     

                    UPDATE                              SYS        HIST_HEAD$                       114

                    INSERT                              SYS        WRI$_OPTSTAT_IND_HISTORY     2503732

                    UNSUPPORTED                         ENI        DR$ENI_DEN_HRCHY_PAR_IM1$          4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   R

                     

                    UNSUPPORTED                         PO         PO_DISTRIBUTIONS_ALL               6

                    UPDATE                              WIP        WIP_COST_TXN_INTERFACE             5

                    UPDATE                              PA         PA_PROJ_ELEMENT_VERSIONS          20

                    INSERT                              PA         PA_OBJECT_RELATIONSHIPS            2

                    INSERT                              ICX        ICX_TRANSACTIONS                   5

                    INSERT                              WIP        WIP_OPERATION_OVERHEADS            8

                    UPDATE                              AP         AP_INVOICES_ALL                   45

                    DELETE                              SYS        HIST_HEAD$                       215

                    DDL                                 SYS        WRH$_SYSTEM_EVENT                  1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DDL                                 SYS        WRH$_SYSSTAT                       1

                    DELETE                              SYS        COL_USAGE$                       501

                    INSERT                              XLA        XLA_EVENTS,AP                     12

                    UPDATE                              IBY        IBY_PAY_INSTRUCTIONS_ALL          12

                    INSERT                              XLA        XLA_AE_LINES,AP                   24

                    INSERT                              AP         AP_INVOICE_LINES_ALL               9

                    UPDATE                              JA         JAI_AP_TDS_INV_TAXES              91

                    UNSUPPORTED                         ZX         ZX_TRX_HEADERS_GT                  8

                    DELETE                              MDSYS      SDO_GEOR_DDL__TABLE$$              4

                    INSERT                              INV        MTL_MATERIAL_TRANSACTIONS          3

                                                                   _TEMP

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    UPDATE                              AP         AP_PREPAY_HISTORY_ALL             12

                    UPDATE                              AP         AP_PREPAY_APP_DISTS                4

                    DELETE                              XLA        XLA_AE_HEADERS_GT                  2

                    UNSUPPORTED                         JA         JAI_RCV_HEADERS                    1

                    INSERT                              INV        MLOG$_MTL_ITEM_CATEGORIES          8

                    INSERT                              BOM        CST_ITEM_COSTS                     4

                    INSERT                              ICX        ICX_CAT_ATTRIBUTE_VALUES_          2

                                                                   TLP

                     

                    UNSUPPORTED                         ICX        ICX_CAT_ITEMS_CTX_HDRS_TL          2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   P

                     

                    UPDATE                              BOM        BOM_SMALL_EXPL_TEMP              280

                    DELETE                              PA         PA_COMMITMENT_TXNS              1538

                    INSERT                              PA         PA_PROJECT_ACCUM_COMMITME        233

                                                                   NTS

                     

                    UNSUPPORTED                         PA         PA_MAPPABLE_TXNS_TMP               5

                    INSERT                              GL         GL_POSTING_INTERIM                13

                    UNSUPPORTED                         PO         RCV_PARAMETERS                     1

                    INSERT                              JA         JAI_RCV_TRANSACTIONS               2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              JA         JAI_RCV_LINES                      2

                    INSERT                              JA         JAI_RCV_LINE_TAXES                 2

                    UPDATE                              INV        MTL_SUPPLY                         6

                    DELETE                              INV        MTL_SUPPLY                         2

                    UPDATE                              PO         RCV_SUPPLY                         2

                    UPDATE                              PO         PO_LINE_LOCATIONS_ALL             44

                    INSERT                              JA         JAI_RCV_SUBLED_ENTRIES             8

                    DELETE                              PO         RCV_TRANSACTIONS_INTERFAC          2

                                                                   E

                     

                    UPDATE                              MRP        MRP_RECOMMENDATIONS                4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              MRP        MRP_MESSAGES_TMP                  20

                    UPDATE                              BNE        BNE_DOC_USER_PARAMS                4

                    INSERT                              JA         JAI_RCV_JOURNAL_ENTRIES            4

                    UNSUPPORTED                         JA         JAI_RCV_CENVAT_CLAIMS              2

                    UPDATE                              ICX        ICX_SESSIONS                      30

                    UPDATE                              PO         PO_DISTRIBUTIONS_ALL              30

                    DELETE                              PO         PO_HEADERS_INTERFACE               3

                    INSERT                              ZX         ZX_TRX_HEADERS_GT                 22

                    UNSUPPORTED                         ZX         ZX_LINES_DET_FACTORS             172

                    UNSUPPORTED                         GL         GL_JE_BATCHES                      4

                    UPDATE                              GL         GL_JE_BATCHES                     25

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              PJI        PJI_PLAN_EXTR_TMP                 12

                    UPDATE                              GL         GL_POSTING_INTERIM                 4

                    INSERT                              WIP        WIP_OPERATION_RESOURCES            1

                    INSERT                              ENI        MLOG$_ENI_DENORM_HIERARCH         24

                                                                   I

                     

                    INSERT                              SYS        WRI$_OPTSTAT_HISTGRM_HIST         12

                                                                   ORY

                     

                    DELETE                              ENI        ENI_DENORM_HRCHY_PARENTS           2

                    UPDATE                              PA         PA_PROJ_ELEM_VER_STRUCTUR          2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   E

                     

                    INSERT                              WIP        WIP_MOVE_TXN_INTERFACE             1

                    INSERT                              WIP        WIP_COST_TXN_INTERFACE             2

                    INSERT                              PO         PO_HEADERS_ALL                     2

                    INSERT                              WIP        WIP_TRANSACTIONS                   1

                    UNSUPPORTED                         CE         CE_PAYMENT_DOCUMENTS               3

                    UNSUPPORTED                         AP         AP_INVOICES_ALL                    6

                    INSERT                              AP         AP_INVOICES_ALL                    7

                    UPDATE                              AP         AP_PAYMENT_SCHEDULES_ALL          24

                    DDL                                 SYS        WRH$_SQLSTAT                       1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DDL                                 SYS        WRH$_SGASTAT                       1

                    DDL                                 SYS        WRH$_SERVICE_WAIT_CLASS            1

                    DELETE                              SYS        WRH$_SQLTEXT                      27

                    INSERT                              AP         AP_INVOICE_PAYMENTS_ALL            6

                    INSERT                              APPLSYS    FND_DOCUMENTS                      4

                    INSERT                              CTXSYS     DR$WAITING                       284

                    INSERT                              INV        MTL_TXN_REQUEST_LINES              3

                    INSERT                              INV        MLOG$_MTL_TXN_REQUEST_LIN         16

                                                                   E

                     

                    INSERT                              IEX        IEX_DLN_UWQ_SUMMARY                6

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              AP         AP_INVOICE_DISTRIBUTIONS_          9

                                                                   ALL

                     

                    UPDATE                              AP         AP_INVOICE_DISTRIBUTIONS_         79

                                                                   ALL

                     

                    DELETE                              AP         AP_LINE_TEMP_GT                   15

                    DELETE                              CTXSYS     DR$INDEX_VALUE                    67

                    UNSUPPORTED                         INV        MTL_TXN_REQUEST_LINES              3

                    UNSUPPORTED                         INV        MTL_ONHAND_QUANTITIES_DET          2

                                                                   AIL

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                     

                    INSERT                              INV        MLOG$_MTL_ONHAND_QUANTITI          2

                                                                   E

                     

                    DDL                                 APPS       SYS_IOT_TOP_739640                 1

                    DELETE                              SYS        DBMS_LOCK_ALLOCATED               47

                    UPDATE                              UNKNOWN    OBJ# 739642                       16

                    INSERT                              PA         PA_TRANSACTION_XFACE_CTRL          1

                                                                   _ALL

                     

                    INSERT                              WIP        WIP_DISCRETE_JOBS                  1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              APPLSYS    FND_RAND_STATES                    2

                    UPDATE                              GL         GL_INTERFACE_CONTROL               3

                    DDL                                 SYS        SYS_TEMP_0FD9D668F_EC264F          1

                                                                   91

                     

                    INSERT                              APPLSYS    WF_CONTROL                         1

                    INSERT                              BOM        CST_ITEM_COST_DETAILS              2

                    INSERT                              PO         PO_ATTRIBUTE_VALUES_TLP            2

                    INSERT                              ICX        DR$ICX_CAT_ITEMSCTXDESC_H          3

                                                                   DRS$I

                     

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              APPLSYS    WF_CONTROL                         1

                    UNSUPPORTED                         APPLSYS    FND_CONC_PROG_ONSITE_INFO          2

                    INSERT                              PA         PA_COMMITMENT_TXNS_TMP           167

                    UPDATE                              PA         PA_COMMITMENT_TXNS              1462

                    DELETE                              PA         PA_MAPPABLE_TXNS_TMP               5

                    INTERNAL                                                                   16723144

                    UPDATE                              APPLSYS    FND_CONCURRENT_REQUESTS          243

                    DDL                                 SYS        ODCI_WARNINGS$                     5

                    DELETE                              SYS        TAB$                               8

                    UPDATE                              JA         JAI_RCV_LINES                      6

                    INSERT                              PO         RCV_SUPPLY                         2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              INV        MLOG$_MTL_SUPPLY                  10

                    INSERT                              MRP        MRP_RECOMMENDATIONS                4

                    INSERT                              MRP        MRP_SCHEDULE_CONSUMPTIONS          6

                    UNSUPPORTED                         JA         JAI_RCV_TRANSACTIONS               6

                    UPDATE                              JA         JAI_RCV_TRANSACTIONS              14

                    INSERT                              XLA        XLA_ACCT_PROG_EVENTS_GT           18

                    INSERT                              JA         JAI_RCV_RGM_LINES                  1

                    INSERT                              JA         JAI_RCV_REP_ACCRUAL_T              2

                    DELETE                              JA         JAI_RGM_TRM_SCHEDULES_T            4

                    INSERT                              JA         JAI_RCV_RGM_CLAIMS                 2

                    UPDATE                              APPLSYS    FND_USER                          17

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              PO         PO_LINES_INTERFACE                12

                    DELETE                              PO         PO_LINES_INTERFACE                 6

                    DELETE                              ZX         ZX_ITM_DISTRIBUTIONS_GT           12

                    UPDATE                              GL         GL_JE_LINES                       66

                    INSERT                              SYS        IDL_UB2$                           4

                    DELETE                              SYS        IDL_CHAR$                          2

                    DELETE                              SYS        SEQ$                               2

                    UPDATE                              QA         QA_RESULTS                         2

                    DELETE                              APPLSYS    FND_FILE_TEMP                      4

                    DELETE                              PA         PA_STRUCTURES_TASKS_TMP            9

                    UPDATE                              BNE        BNE_DOC_CREATION_PARAMS            8

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              WIP        WIP_OPERATIONS                     1

                    INSERT                              WIP        MLOG$_WIP_DISCRETE_JOBS            5

                    DELETE                              APPLSYS    FND_OAM_APP_SYS_STATUS            32

                    DDL                                 SYS        SYS_TEMP_0FD9D668D_EC264F          1

                                                                   91

                     

                    INSERT                              ENI        ENI_DENORM_HRCHY_PARENTS           6

                    UNSUPPORTED                         ENI        ENI_DENORM_HRCHY_PARENTS           6

                    UNSUPPORTED                         SYS        SMON_SCN_TIME                     10

                    UPDATE                              SYS        MON_MODS$                        229

                    INSERT                              PA         PA_PROJ_ROLLUP_BULK_TEMP         170

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              PA         PA_OBJECT_RELATIONSHIPS            3

                    UPDATE                              INV        MTL_TXN_REQUEST_HEADERS            9

                    INSERT                              WIP        WIP_TRANSACTION_ACCOUNTS          18

                    INSERT                              XLA        XLA_EVENTS_INT_GT                  1

                    UNSUPPORTED                         WIP        WIP_OPERATION_RESOURCES            1

                    INSERT                              AP         AP_DOC_SEQUENCE_AUDIT              7

                    UNSUPPORTED                         AP         AP_PAYMENT_SCHEDULES_ALL          18

                    INSERT                              AP         AP_PAYMENT_SCHEDULES_ALL           7

                    INSERT                              IBY        IBY_DOCS_PAYABLE_GT                7

                    DDL                                 SYS        WRH$_WAITSTAT                      1

                    DDL                                 SYS        WRH$_LATCH                         1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DDL                                 SYS        WRH$_TABLESPACE_STAT               1

                    DDL                                 SYS        WRH$_OSSTAT                        1

                    DDL                                 SYS        WRH$_EVENT_HISTOGRAM               1

                    INSERT                              SYS        MON_MODS_ALL$                    349

                    INSERT                              IBY        IBY_PROCESS_ORGS                   8

                    INSERT                              APPLSYS    FND_CONC_REQUEST_ARGUMENT         16

                                                                   S

                     

                    UPDATE                              AP         AP_CHECKS_ALL                      8

                    INSERT                              IBY        IBY_VIEW_PARAMETERS_GT             4

                    INSERT                              APPLSYS    FND_DOCUMENTS_TL                   4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              XLA        XLA_AE_LINES_GT                   80

                    UNSUPPORTED                         XLA        XLA_AE_LINES_GT                  208

                    INSERT                              XLA        XLA_AE_HEADERS,AP                 12

                    INSERT                              XLA        XLA_VALIDATION_LINES_GT           10

                    UNSUPPORTED                         XLA        XLA_BAL_CONCURRENCY_CONTR          8

                                                                   OL

                     

                    DELETE                              XLA        XLA_BAL_CONCURRENCY_CONTR          8

                                                                   OL

                     

                    INSERT                              ENI        DR$ENI_DEN_HRCHY_PAR_IM1$          7

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   I

                     

                    UPDATE                              INV        MTL_ONHAND_QUANTITIES_DET          2

                                                                   AIL

                     

                    DDL                                 APPS       SYS_IOT_TOP_739645                 1

                    DELETE                              XLA        XLA_EVENTS_GT                      2

                    INSERT                              XLA        XLA_TRANSFER_LOGS                  8

                    INSERT                              WIP        WIP_ENTITIES                       1

                    DELETE                              XLA        XLA_TB_WORK_UNITS                  2

                    UPDATE                              PA         PA_TRANSACTION_INTERFACE_         18

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   ALL

                     

                    INSERT                              EGO        EGO_ITEM_TEXT_TL                   3

                    INSERT                              INV        MTL_ITEM_REVISIONS_TL              4

                    INSERT                              ICX        ICX_CAT_ITEMS_CTX_HDRS_TL          2

                                                                   P

                     

                    INSERT                              PA         PA_COMMITMENT_TXNS              1440

                    UPDATE                              PA         PA_PROJECT_ACCUM_ACTUALS          16

                    INSERT                              PA         PA_RESOURCE_ACCUM_DETAILS          5

                    UNSUPPORTED                                                                    6695

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         SYS        IND$                              37

                    UNSUPPORTED                         SYS        TAB$                              82

                    UPDATE                              SYS        CON$                              16

                    UNSUPPORTED                         SYS        LOB$                               6

                    INSERT                              APPLSYS    FND_CONC_PP_ACTIONS              107

                    UPDATE                              PO         RCV_PARAMETERS                     1

                    INSERT                              MRP        MRP_RELIEF_INTERFACE               6

                    INSERT                              MRP        MRP_SCHEDULE_DATES                 2

                    INSERT                              MRP        MLOG$_MRP_SCHEDULE_DATES           6

                    DELETE                              MRP        MRP_SCHEDULE_DATES                 2

                    INSERT                              BNE        BNE_DOC_ACTIONS                    6

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UNSUPPORTED                         XLA        XLA_EVENTS,AP                     26

                    UNSUPPORTED                         APPLSYS    FND_CONCURRENT_PROCESSES         186

                    INSERT                              GL         GL_JE_BATCHES                      8

                    UNSUPPORTED                         SYS        DBMS_LOCK_ALLOCATED               31

                    INSERT                              PA         PA_PERF_EXCP_MSR_TEMP           6357

                    DELETE                              APPLSYS    FND_CONC_PP_ACTIONS               22

                    UPDATE                              APPLSYS    WF_DEFERRED                       13

                    DELETE                              APPLSYS    MO_GLOB_ORG_ACCESS_TMP            17

                    DELETE                              PO         PO_SESSION_GT                      6

                    INSERT                              PO         PO_HEADERS_INTERFACE               3

                    UPDATE                              PO         PO_HEADERS_ALL                     7

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              PO         PO_DISTRIBUTIONS_INTERFAC          6

                                                                   E

                     

                    UPDATE                              PO         PO_REQUISITION_LINES_ALL           6

                    INSERT                              ZX         ZX_TRANSACTION_LINES_GT           42

                    UPDATE                              PO         PO_LINES_ALL                      24

                    UPDATE                              PO         PO_SESSION_GT                     17

                    DELETE                              PJI        PJI_PLAN_EXTR_TMP                 46

                    INSERT                              SYS        IDL_UB1$                           2

                    DELETE                              BOM        BOM_RES_INSTANCE_CHANGES           3

                    INSERT                              WIP        MLOG$_WIP_REQUIREMENT_OPE          2

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                                                                   R

                     

                    INSERT                              SYS        WRI$_OPTSTAT_HISTHEAD_HIS     179046

                                                                   TORY

                     

                    INSERT                              SYS        COL_USAGE$                         1

                    INSERT                              PA         PA_PROJ_ELEM_VER_SCHEDULE          2

                    INSERT                              WIP        WIP_MOVE_TRANSACTIONS              1

                    DELETE                              WIP        WIP_MOVE_TXN_INTERFACE             1

                    UPDATE                              WIP        WIP_OPERATION_RESOURCES            2

                    UPDATE                              INV        MTL_MWB_GTMP                      45

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              SYS        DEPENDENCY$                       21

                    DELETE                              SYS        TABPART$                          19

                    DDL                                 SYS        WRH$_LATCH_MISSES_SUMMARY          1

                    DDL                                 SYS        WRH$_DB_CACHE_ADVICE               1

                    DDL                                 SYS        WRH$_PARAMETER                     1

                    DELETE                              SYS        MON_MODS$                        815

                    INSERT                              IBY        IBY_PROCESS_FUNCTIONS              8

                    UPDATE                              IBY        IBY_PAY_SERVICE_REQUESTS          20

                    UPDATE                              AP         AP_PAYMENT_HISTORY_ALL            12

                    INSERT                              INV        MTL_TXN_REQUEST_HEADERS            3

                    INSERT                              XLA        XLA_AE_SEGMENT_VALUES             48

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DDL                                 SYS        SYS_TEMP_0FD9D668E_EC264F          1

                                                                   91

                     

                    UPDATE                              CTXSYS     DR$INDEX                           2

                    INSERT                              MDSYS      SDO_GEOR_DDL__TABLE$$              4

                    INSERT                              INV        MTL_MATERIAL_TRANSACTIONS          2

                    UNSUPPORTED                         CSI        CSI_ITEM_INSTANCES                 2

                    INSERT                              UNKNOWN    OBJ# 739642                       22

                    INSERT                              ICX        ICX_SESSIONS                       1

                    UPDATE                              CE         CE_PAYMENT_DOCUMENTS               2

                    INSERT                              QA         QA_INSP_PLANS_TEMP                 1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    INSERT                              INV        MTL_PENDING_ITEM_STATUS            4

                    UNSUPPORTED                         PO         PO_ATTRIBUTE_VALUES                4

                    INSERT                              PA         PA_TXN_ACCUM_DETAILS            1449

                    INSERT                              PA         PA_TXN_ACCUM                       5

                    INSERT                              PA         PA_RESOURCE_LIST_PARENTS_          4

                                                                   TMP

                     

                    INSERT                              SYS        DEPENDENCY$                        2

                    UPDATE                              SYS        OBJ$                              40

                    INSERT                              SYS        WRI$_OPTSTAT_TAB_HISTORY     1465262

                    UNSUPPORTED                         APPLSYS    FND_CONCURRENT_REQUESTS           85

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DDL                                 APPS       DR$IBE_CT_IMEDIA_SEARCH_I          3

                                                                   M$R

                     

                    DDL                                 APPS       SYS_IOT_TOP_739629                 1

                    INSERT                              PO         RCV_TRANSACTIONS_INTERFAC          2

                                                                   E

                     

                    UPDATE                              PO         RCV_SHIPMENT_HEADERS               1

                    UNSUPPORTED                         PO         PO_HEADERS_ALL                     4

                    UPDATE                              JA         JAI_RCV_SUBLED_ENTRIES             4

                    DELETE                              MRP        MRP_RECOMMENDATIONS                4

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              BNE        BNE_DOC_ACTIONS                    4

                    INSERT                              XLA        XLA_EVT_CLASS_ORDERS_GT           18

                    UNSUPPORTED                         GL         GL_INTERFACE                       4

                    UPDATE                              JA         JAI_RGM_TRM_SCHEDULES_T            4

                    UPDATE                              SYS        DBMS_LOCK_ALLOCATED               31

                    UPDATE                              JA         JAI_PO_LINE_LOCATIONS             12

                    INSERT                              PO         PO_DISTRIBUTIONS_ALL               6

                    DELETE                              PO         PO_DISTRIBUTIONS_INTERFAC          6

                                                                   E

                     

                    UNSUPPORTED                         ZX         ZX_TRANSACTION_LINES_GT           48

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              GL         GL_JE_HEADERS                     22

                    UPDATE                              PA         PA_STRUCTURES_TASKS_TMP          472

                    UPDATE                              APPLSYS    FND_CONCURRENT_PROCESSES          65

                    UPDATE                              GL         GL_BALANCES                       90

                    INSERT                              SYS        IDL_CHAR$                          2

                    DDL                                 APPS       CPW_PO_TAX_SORT                    4

                    INSERT                              BOM        MLOG$_BOM_RES_INSTANCE_CH          8

                                                                   A

                     

                    INSERT                              BOM        BOM_RESOURCE_CHANGES               4

                    UNSUPPORTED                         WIP        WIP_DISCRETE_JOBS                  1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              WIP        WIP_REQUIREMENT_OPERATION          2

                                                                   S

                     

                    INSERT                              APPLSYS    FND_OAM_APP_SYS_STATUS            18

                    INSERT                              ENI        ENI_DENORM_HIERARCHIES             9

                    UPDATE                              SYS        COL_USAGE$                      5461

                    INSERT                              PA         PA_TASKS                           1

                    INSERT                              PA         PA_PROJ_ELEMENT_VERSIONS           2

                    UPDATE                              PA         PA_PROJ_ELEMENTS                 176

                    DELETE                              PA         PA_PROJ_ROLLUP_BULK_TEMP         170

                    UPDATE                              SYS        WRI$_SCH_VOTES                     1

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              SYS        WRM$_WR_CONTROL                    1

                    DDL                                 SYS        WRH$_SERVICE_STAT                  1

                    DELETE                              SYS        MON_MODS_ALL$                     21

                    INSERT                              AP         AP_CHECKS_ALL                      4

                    INSERT                              AP         AP_PAYMENT_HISTORY_ALL             4

                    INSERT                              IBY        IBY_PAY_INSTRUCTIONS_ALL           4

                    UPDATE                              XLA        XLA_EVENTS,AP                     24

                    INSERT                              APPLSYS    FND_ATTACHED_DOCUMENTS             4

                    INSERT                              APPLSYS    FND_LOBS                           4

                    UNSUPPORTED                         XLA        XLA_AE_HEADERS_GT                 12

                    DELETE                              IEX        IEX_DLN_UWQ_SUMMARY               21

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    UPDATE                              AP         AP_INVOICE_LINES_ALL              31

                    INSERT                              AP         AP_PREPAY_HISTORY_ALL              4

                    INSERT                              AP         AP_PREPAY_APP_DISTS                4

                    INSERT                              CSI        CSI_ITEM_INSTANCES_H               2

                    DELETE                              INV        MTL_MATERIAL_TRANSACTIONS          2

                                                                   _TEMP

                     

                    UPDATE                              PA         PA_TRANSACTION_XFACE_CTRL          6

                                                                   _ALL

                     

                    DELETE                              XLA        XLA_TRANSFER_LOGS                  8

                     

                    OPERATION                           SEG_OWNER  SEG_NAME                    COUNT(*)

                    ----------------------------------- ---------- ------------------------- ----------

                    DELETE                              SYS        WRI$_OPTSTAT_IND_HISTORY     2503717

                    UNSUPPORTED                         INV        MTL_SYSTEM_ITEMS_B                 4

                    INSERT                              INV        MTL_ITEM_REVISIONS_B               4

                    UPDATE                              BOM        CST_ITEM_COSTS                     1

                    INSERT                              PA         PA_PJM_PO_COMMITMENTS_TMP        418

                     

                    520 rows selected.

                     

                     

                     

                    THE FOLLLOWING QUERY IS RETURNING NO ROWS FROM NOTE ID 1504755.1

                    SELECT username AS USR,

                         (XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS XID,

                         operation,

                         SQL_REDO,

                         SQL_UNDO

                         FROM V$LOGMNR_CONTENTS

                         WHERE username IN ('SYS');  2    3    4    5    6    7

                     

                    no rows selected

                     

                     

                    what to do next

                    please help

                    Thanks

                    Zavi

                    • 7. Re: too many archive logs getting generated on 11.1.0.7
                      Tushar Thakker

                      That's the reason I asked you to check scheduled jobs, concurrent programs if any, etc since logminer will give you what is being updated but not how these DMLs are getting fired.

                      • 8. Re: too many archive logs getting generated on 11.1.0.7
                        Helios-GunesEROL

                        Hi;

                         

                        If archive log is generate which mean you have do something on your application. So

                         

                        1. Check https://forums.oracle.com/forums/thread.jspa?threadID=2428471&tstart=0

                        2. Check which hours you get max archive(redo change)

                        3. Check schedule concurrent jobs

                         

                        Regard

                        Helios

                        • 9. Re: too many archive logs getting generated on 11.1.0.7
                          871455

                          Hi Helios and Tushar,

                           

                          i have check the following  from our instance

                          QL> SELECT owner, program_name, enabled FROM dba_scheduler_programs;

                           

                           

                          OWNER                          PROGRAM_NAME                   ENABL

                          ------------------------------ ------------------------------ -----

                          SYS                            JDM_XFORM_SEQ_PROGRAM          TRUE

                          SYS                            JDM_PROFILE_PROGRAM            TRUE

                          SYS                            JDM_EXPLAIN_PROGRAM            TRUE

                          SYS                            JDM_PREDICT_PROGRAM            TRUE

                          SYS                            JDM_XFORM_PROGRAM              TRUE

                          SYS                            JDM_IMPORT_PROGRAM             TRUE

                          SYS                            JDM_SQL_APPLY_PROGRAM          TRUE

                          SYS                            JDM_TEST_PROGRAM               TRUE

                          SYS                            JDM_BUILD_PROGRAM              TRUE

                          SYS                            JDM_EXPORT_PROGRAM             TRUE

                          SYS                            BSLN_MAINTAIN_STATS_PROG       TRUE

                           

                          OWNER                          PROGRAM_NAME                   ENABL

                          ------------------------------ ------------------------------ -----

                          SYS                            AUTO_SQL_TUNING_PROG           TRUE

                          SYS                            AQ$_PROPAGATION_PROGRAM        TRUE

                          SYS                            HS_PARALLEL_SAMPLING           TRUE

                          SYS                            ORA$AGE_AUTOTASK_DATA          TRUE

                          SYS                            AUTO_SPACE_ADVISOR_PROG        TRUE

                          SYS                            GATHER_STATS_PROG              TRUE

                          SYS                            PURGE_LOG_PROG                 TRUE

                          DMSYS                          EXPLAIN_PROGRAM                TRUE

                          DMSYS                          PREDICT_PROGRAM                TRUE

                          DMSYS                          XFORM_PROGRAM                  TRUE

                          DMSYS                          IMPORT_PROGRAM                 TRUE

                           

                          OWNER                          PROGRAM_NAME                   ENABL

                          ------------------------------ ------------------------------ -----

                          DMSYS                          EXPORT_PROGRAM                 TRUE

                          DMSYS                          SQL_APPLY_PROGRAM              TRUE

                          DMSYS                          TEST_PROGRAM                   TRUE

                          DMSYS                          APPLY_PROGRAM                  TRUE

                          DMSYS                          BUILD_PROGRAM                  TRUE

                           

                          27 rows selected.

                           

                           

                          -- Display job details.

                           

                          SQL> SQL> SELECT owner, job_name, enabled FROM dba_scheduler_jobs;

                           

                          OWNER                          JOB_NAME                       ENABL

                          ------------------------------ ------------------------------ -----

                          SYS                            XMLDB_NFS_CLEANUP_JOB          FALSE

                          SYS                            BSLN_MAINTAIN_STATS_JOB        TRUE

                          SYS                            DRA_REEVALUATE_OPEN_FAILURES   TRUE

                          SYS                            ORA$AUTOTASK_CLEAN             TRUE

                          SYS                            HM_CREATE_OFFLINE_DICTIONARY   FALSE

                          SYS                            AUTO_SPACE_ADVISOR_JOB         FALSE

                          SYS                            GATHER_STATS_JOB               FALSE

                          SYS                            FGR$AUTOPURGE_JOB              FALSE

                          SYS                            PURGE_LOG                      TRUE

                          ORACLE_OCM                     MGMT_CONFIG_JOB                TRUE

                          ORACLE_OCM                     MGMT_STATS_CONFIG_JOB          TRUE

                           

                          11 rows selected.

                           

                           

                          -- Display job class details.

                          SELECT job_class_name, resource_consumer_group FROM dba_scheduler_job_class                                                                             es;

                           

                          JOB_CLASS_NAME                 RESOURCE_CONSUMER_GROUP

                          ------------------------------ ------------------------------

                          DEFAULT_JOB_CLASS

                          AUTO_TASKS_JOB_CLASS           AUTO_TASK_CONSUMER_GROUP

                          DBMS_JOB$

                          ORA$AT_JCURG_OS                ORA$AUTOTASK_URGENT_GROUP

                          ORA$AT_JCNRM_OS                ORA$AUTOTASK_STATS_GROUP

                          ORA$AT_JCMED_OS                ORA$AUTOTASK_MEDIUM_GROUP

                          ORA$AT_JCURG_SA                ORA$AUTOTASK_URGENT_GROUP

                          ORA$AT_JCNRM_SA                ORA$AUTOTASK_SPACE_GROUP

                          ORA$AT_JCMED_SA                ORA$AUTOTASK_MEDIUM_GROUP

                          ORA$AT_JCURG_SQ                ORA$AUTOTASK_URGENT_GROUP

                          ORA$AT_JCNRM_SQ                ORA$AUTOTASK_SQL_GROUP

                           

                          JOB_CLASS_NAME                 RESOURCE_CONSUMER_GROUP

                          ------------------------------ ------------------------------

                          ORA$AT_JCMED_SQ                ORA$AUTOTASK_MEDIUM_GROUP

                          AQ$_PROPAGATION_JOB_CLASS

                          XMLDB_NFS_JOBCLASS

                           

                          14 rows selected.

                          and about heavy redo generation time is not fixed its variable

                          here is is the query

                          SQL> select trunc(first_time, 'HH') , count(*)

                          from v$loghist

                          group by trunc(first_time, 'HH')

                          order by trunc(first_time, 'HH');

                           

                          TRUNC(FIRST_TIME,'HH')   COUNT(*)

                          -------------------------- ----------

                           

                          24-JUN-2013 00:00:00            1
                          24-JUN-2013 02:00:00            1
                          24-JUN-2013 06:00:00            1
                          24-JUN-2013 09:00:00            1
                          24-JUN-2013 12:00:00            1
                          24-JUN-2013 13:00:00            1
                          24-JUN-2013 14:00:00            2
                          24-JUN-2013 16:00:00            3
                          24-JUN-2013 17:00:00            3
                          24-JUN-2013 18:00:00            1
                          24-JUN-2013 19:00:00            8
                          24-JUN-2013 20:00:00            6
                          24-JUN-2013 21:00:00           15
                          24-JUN-2013 22:00:00            6
                          25-JUN-2013 01:00:00            1
                          25-JUN-2013 05:00:00            1
                          25-JUN-2013 08:00:00            1
                          25-JUN-2013 10:00:00            3
                          25-JUN-2013 11:00:00            3
                          25-JUN-2013 12:00:00            3
                          25-JUN-2013 13:00:00            3
                          25-JUN-2013 14:00:00            2
                          25-JUN-2013 15:00:00            3
                          25-JUN-2013 16:00:00            1
                          25-JUN-2013 17:00:00            2
                          25-JUN-2013 18:00:00            1
                          25-JUN-2013 20:00:00            1
                          25-JUN-2013 23:00:00            1
                          26-JUN-2013 02:00:00            1
                          26-JUN-2013 05:00:00            1
                          26-JUN-2013 09:00:00            1
                          26-JUN-2013 11:00:00            3
                          26-JUN-2013 12:00:00            2
                          26-JUN-2013 13:00:00            3
                          26-JUN-2013 14:00:00            2
                          26-JUN-2013 17:00:00            1
                          26-JUN-2013 20:00:00            1
                          26-JUN-2013 23:00:00            1
                          27-JUN-2013 02:00:00            1
                          27-JUN-2013 05:00:00            1
                          27-JUN-2013 09:00:00            1
                          27-JUN-2013 12:00:00            1
                          27-JUN-2013 15:00:00            1
                          27-JUN-2013 18:00:00            1
                          27-JUN-2013 20:00:00            1
                          28-JUN-2013 00:00:00            1
                          28-JUN-2013 03:00:00            1
                          28-JUN-2013 06:00:00            1
                          28-JUN-2013 09:00:00            1
                          28-JUN-2013 12:00:00            1
                          28-JUN-2013 15:00:00            1
                          28-JUN-2013 18:00:00            1
                          28-JUN-2013 20:00:00            1
                          28-JUN-2013 23:00:00            1
                          29-JUN-2013 02:00:00            1
                          29-JUN-2013 05:00:00            1
                          29-JUN-2013 09:00:00            1
                          29-JUN-2013 12:00:00            1
                          29-JUN-2013 15:00:00            1
                          29-JUN-2013 18:00:00            1
                          29-JUN-2013 20:00:00            1
                          29-JUN-2013 23:00:00            1
                          30-JUN-2013 03:00:00            1
                          30-JUN-2013 06:00:00            1
                          30-JUN-2013 09:00:00            1
                          30-JUN-2013 12:00:00            1
                          30-JUN-2013 15:00:00            1
                          30-JUN-2013 18:00:00            1
                          30-JUN-2013 21:00:00            1
                          01-JUL-2013 00:00:00            1
                          01-JUL-2013 03:00:00            1
                          01-JUL-2013 06:00:00            1
                          01-JUL-2013 09:00:00            1
                          01-JUL-2013 12:00:00            1
                          01-JUL-2013 15:00:00            1
                          01-JUL-2013 18:00:00            1
                          01-JUL-2013 21:00:00            1
                          02-JUL-2013 00:00:00            1
                          02-JUL-2013 03:00:00            1
                          02-JUL-2013 10:00:00            1
                          02-JUL-2013 11:00:00            1
                          02-JUL-2013 13:00:00            1
                          02-JUL-2013 15:00:00            1
                          02-JUL-2013 17:00:00            1
                          02-JUL-2013 18:00:00            3
                          02-JUL-2013 19:00:00            1
                          02-JUL-2013 22:00:00            1
                          03-JUL-2013 02:00:00            1
                          03-JUL-2013 05:00:00            1
                          03-JUL-2013 08:00:00            1
                          03-JUL-2013 11:00:00            1
                          03-JUL-2013 12:00:00            1
                          03-JUL-2013 15:00:00            1
                          03-JUL-2013 18:00:00            1
                          03-JUL-2013 20:00:00            1
                          04-JUL-2013 00:00:00            1
                          04-JUL-2013 03:00:00            1
                          04-JUL-2013 06:00:00            1
                          04-JUL-2013 09:00:00            1
                          04-JUL-2013 12:00:00            1
                          04-JUL-2013 14:00:00            1

                           

                          please share any queries with which we can find the scheduled job and how the dmls are being fired

                           

                          thanks

                          Zavi

                          • 10. Re: too many archive logs getting generated on 11.1.0.7
                            871455

                            Hi There,

                             

                            can any one give some information to solve this issue.

                             

                            thanks

                            Zavi

                            • 11. Re: too many archive logs getting generated on 11.1.0.7
                              $Amogh K

                              Hi Zavi,

                               

                              If you check the output of logminer you can see below tables are getting highly transacted.

                               

                              DELETE       SYS  WRI$_OPTSTAT_HISTHEAD_HIS     235644

                              DELETE       SYS  WRI$_OPTSTAT_IND_HISTORY       2130287

                              DELETE       SYS  WRI$_OPTSTAT_TAB_HISTORY      1518271

                              DELETE       SYS  WRI$_OPTSTAT_HISTHEAD_HIS     178932

                              INSERT        SYS  WRI$_OPTSTAT_IND_HISTORY       2503732

                              INSERT        SYS  WRI$_OPTSTAT_TAB_HISTORY      1465262

                              DELETE       SYS  WRI$_OPTSTAT_IND_HISTORY       2503717

                               

                              This tables are related to gathering statistics on database objects.

                               

                              Are gather statistic programs getting executed when archive generation is high?

                               

                              Kindly check the same.

                               

                              Thanks,

                              Amogh