[Home] [Help]
635: --6602290 : Stats gather through profile
636: l_stats_profile NUMBER := NVL(FND_PROFILE.VALUE('EGO_GATHER_STATS'),100);
637: BEGIN
638: Debug_Conc_Log('Starting Gather_Stats_For_Intf_Tables');
639: l_inv_installed := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema);
640:
641: /* Bug 12669090 : Commenting the Gather Stats.
642: As mentioned in the note 1208945.1 and suggested by performance team,
643: for any performance issues we need to gather stats manualy so no need to gather stats in the code.
648: SELECT COUNT(1) INTO l_records
649: FROM MTL_SYSTEM_ITEMS_INTERFACE
650: WHERE SET_PROCESS_ID = p_data_set_id;
651:
652: l_inv_installed := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema);
653: IF (l_records > l_stats_profile) AND l_inv_installed AND l_schema IS NOT NULL THEN
654: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
655: Debug_Conc_Log('Collected Statistics on MTL_SYSTEM_ITEMS_INTERFACE');
656: END IF;
676: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
677: Debug_Conc_Log('Collected Statistics on MTL_ITEM_CATEGORIES_INTERFACE');
678: END IF;
679:
680: l_ego_installed := FND_INSTALLATION.GET_APP_INFO('EGO', l_status, l_industry, l_schema);
681: -- checking whether stats needs to be collected on EGO_ITEM_PEOPLE_INTF
682: SELECT COUNT(1) INTO l_records
683: FROM EGO_ITEM_PEOPLE_INTF
684: WHERE DATA_SET_ID = p_data_set_id;