1 Reply Latest reply: Mar 5, 2013 7:06 AM by John O'Toole RSS

    create table taking 3MIN 32 SECS

    user753198
      Hi

      Create table taking 3 min 32 secs. Basically this is .table file which runs while loading db components.

      We see from the FAPMgrDiagnosticsSummary_apply log that
      during the "Create Tables" phase (which
      took a total of 5 mins and 49 secs to complete 489 tasks with 24 parallel
      adpatch threads), the create table task
      "crm/components/crmCommon/hz/parties/dbSchema/database/fusionDB/FUSION/HZ_GROU
      P_PROFILES.table"
      takes 3 mins and 32 secs to execute.

      From FAPMgrDiagnosticsSummary_apply log:
      -------------------------------------------------------------------------
      Mode: Database
      Phase : Create Tables
      Product Family : crm
      Task :
      crm/components/crmCommon/hz/parties/dbSchema/database/fusionDB/FUSION/HZ_GROUP
      _PROFILES.table

      [Arguments : owner_un=&un_apps apps_un=&un_apps jdbc_protocol=&jdbc_protocol
      jdbc
      _db_addr=&jdbc_db_addr xdf_mode=table
      xdf_file_name=&fullpath:crm:crm/components
       
      /crmCommon/hz/parties/dbSchema/database/fusionDB/FUSION:HZ_GROUP_PROFILES.tabl
      e
      no_error=y index_category=small  parallel_index_threshold=20000]

      Status: Success
      Duration (hh:mi:ss.SSS) :00:03:32.180


      What could be the reason?