664: COMMIT;
665:
666:
667: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
668: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
669: TABNAME => 'ISC_DBI_CHANGE_LOG');
670: END IF;
671:
672:
702: BIS_COLLECTION_UTILITIES.Put_Line(' ');
703: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
704: FII_UTIL.Start_Timer;
705: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
706: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
707: TABNAME => 'ISC_TMP_BOOK_SUM2');
708: END IF;
709: FII_UTIL.Stop_Timer;
710: FII_UTIL.Print_Timer('Analyzed table ISC_TMP_BOOK_SUM2 in ');
2432: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
2433: FII_UTIL.Start_Timer;
2434:
2435: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');
2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2434:
2435: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');
2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2441: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2442: END IF;
2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');
2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2441: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2442: END IF;
2443:
2444: FII_UTIL.Stop_Timer;
2612: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
2613: FII_UTIL.Start_Timer;
2614:
2615: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');
2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2614:
2615: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');
2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2621: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2622: END IF;
2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');
2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2621: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2622: END IF;
2623:
2624: FII_UTIL.Stop_Timer;