BR0801I BRCONNECT 7.20 (17) BR0805I Start of BRCONNECT processing: cekntnfi.sta 2013-02-13 22.00.22 BR0484I BRCONNECT log file: /oracle/EPP/sapcheck/cekntnfi.sta BR0101I Parameters Name Value oracle_sid EPP oracle_home /oracle/EPP/112_64 oracle_profile /oracle/EPP/112_64/dbs/initEPP.ora sapdata_home /oracle/EPP sap_profile /oracle/EPP/112_64/dbs/initEPP.sap system_info eppadm/oraepp epprda AIX 1 6 00C43AF74C00 oracle_info EPP 11.2.0.3.0 8192 21 668725 epprda UTF8 UTF8 255271712 sap_info SAPSR3DB make_info rs6000_64 OCI_112 Sep 3 2011 command_line /usr/sap/EPP/SYS/exe/uc/rs6000_64/brconnect -u / -c -o summary -f stats -o SAPSR3DB -t all -p 8 stats_owner SAPSR3DB stats_table ALL stats_dbms_stats ALL:R:0 stats_change_threshold 50 stats_parallel_degree 8 stats_dict_cycle 0 stats_system_cycle 0 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.23 BR0813I Schema owners found in database EPP: APPQOSSYS, DBSNMP, DIP, OPS$EPPADM, OPS$ORAEPP, ORACLE_OCM, OUTLN, SAPSR3DB% BR0280I BRCONNECT time stamp: 2013-02-13 22.00.23 BR0814I Number of tables in schema of owner SAPSR3DB: 676 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.24 BR0815I Number of indexes in schema of owner SAPSR3DB: 1079 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.24 BR0807I Name of database instance: EPP BR0808I BRCONNECT action ID: cekntnfi BR0809I BRCONNECT function ID: sta BR0810I BRCONNECT function: stats BR0811I Owner of database schema for processing: SAPSR3DB BR0812I Database objects for processing: ALL BR0851I Number of tables with missing statistics: 83 Owner SAPSR3DB: 83 BR0852I Number of tables to delete statistics: 0 BR0854I Number of tables to collect statistics without checking: 1 Owner SAPSR3DB: 1 BR0855I Number of indexes with missing statistics: 0 BR0856I Number of indexes to delete statistics: 0 BR0857I Number of indexes to collect statistics: 0 BR0853I Number of tables to check (and collect if needed) statistics: 675 Owner SAPSR3DB: 675 BR0846I Number of threads that will be started in parallel to the main thread: 8 BR0126I Unattended mode active - no operator confirmation required BR0280I BRCONNECT time stamp: 2013-02-13 22.00.24 BR0817I Number of monitored/modified tables in schema of owner SAPSR3DB: 676/60 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.25 BR0877I Checking and collecting table and index statistics... BR0847I Thread 1 started successfully BR0847I Thread 2 started successfully BR0847I Thread 3 started successfully BR0847I Thread 4 started successfully BR0847I Thread 5 started successfully BR0847I Thread 6 started successfully BR0847I Thread 7 started successfully BR0847I Thread 8 started successfully BR0280I BRCONNECT thread 6: time stamp: 2013-02-13 22.00.26 BR0850I 1 of 83 objects processed - 0.002 of 0.138 units done BR0204I Percentage done: 1.20%, estimated end time: 22:00 BR0001I *_________________________________________________ BR0280I BRCONNECT thread 7: time stamp: 2013-02-13 22.00.26 BR0850I 2 of 83 objects processed - 0.003 of 0.138 units done BR0204I Percentage done: 2.41%, estimated end time: 22:00 BR0001I *_________________________________________________ BR0280I BRCONNECT thread 5: time stamp: 2013-02-13 22.00.26 BR0850I 5 of 83 objects processed - 0.008 of 0.138 units done BR0204I Percentage done: 6.02%, estimated end time: 22:00 BR0001I ***_______________________________________________ BR0280I BRCONNECT thread 2: time stamp: 2013-02-13 22.00.27 BR0850I 9 of 83 objects processed - 0.015 of 0.138 units done BR0204I Percentage done: 10.84%, estimated end time: 22:00 BR0001I *****_____________________________________________ BR0280I BRCONNECT thread 5: time stamp: 2013-02-13 22.00.27 BR0850I 13 of 83 objects processed - 0.022 of 0.138 units done BR0204I Percentage done: 15.66%, estimated end time: 22:00 BR0001I ********__________________________________________ BR0280I BRCONNECT thread 8: time stamp: 2013-02-13 22.00.27 BR0850I 17 of 83 objects processed - 0.028 of 0.138 units done BR0204I Percentage done: 20.48%, estimated end time: 22:00 BR0001I **********________________________________________ BR0280I BRCONNECT thread 4: time stamp: 2013-02-13 22.00.28 BR0850I 21 of 83 objects processed - 0.035 of 0.138 units done BR0204I Percentage done: 25.30%, estimated end time: 22:00 BR0001I *************_____________________________________ BR0280I BRCONNECT thread 8: time stamp: 2013-02-13 22.00.28 BR0850I 25 of 83 objects processed - 0.042 of 0.138 units done BR0204I Percentage done: 30.12%, estimated end time: 22:00 BR0001I ***************___________________________________ BR0280I BRCONNECT thread 2: time stamp: 2013-02-13 22.00.29 BR0850I 30 of 83 objects processed - 0.050 of 0.138 units done BR0204I Percentage done: 36.14%, estimated end time: 22:00 BR0001I ******************________________________________ BR0280I BRCONNECT thread 2: time stamp: 2013-02-13 22.00.29 BR0850I 34 of 83 objects processed - 0.057 of 0.138 units done BR0204I Percentage done: 40.96%, estimated end time: 22:00 BR0001I ********************______________________________ BR0280I BRCONNECT thread 4: time stamp: 2013-02-13 22.00.29 BR0850I 38 of 83 objects processed - 0.063 of 0.138 units done BR0204I Percentage done: 45.78%, estimated end time: 22:00 BR0001I ***********************___________________________ BR0280I BRCONNECT thread 2: time stamp: 2013-02-13 22.00.29 BR0850I 42 of 83 objects processed - 0.070 of 0.138 units done BR0204I Percentage done: 50.60%, estimated end time: 22:00 BR0001I *************************_________________________ BR0280I BRCONNECT thread 8: time stamp: 2013-02-13 22.00.29 BR0850I 46 of 83 objects processed - 0.077 of 0.138 units done BR0204I Percentage done: 55.42%, estimated end time: 22:00 BR0001I ****************************______________________ BR0280I BRCONNECT thread 4: time stamp: 2013-02-13 22.00.29 BR0850I 50 of 83 objects processed - 0.083 of 0.138 units done BR0204I Percentage done: 60.24%, estimated end time: 22:00 BR0001I ******************************____________________ BR0280I BRCONNECT thread 7: time stamp: 2013-02-13 22.00.29 BR0850I 54 of 83 objects processed - 0.090 of 0.138 units done BR0204I Percentage done: 65.06%, estimated end time: 22:00 BR0001I *********************************_________________ BR0280I BRCONNECT thread 2: time stamp: 2013-02-13 22.00.29 BR0850I 59 of 83 objects processed - 0.098 of 0.138 units done BR0204I Percentage done: 71.08%, estimated end time: 22:00 BR0001I ************************************______________ BR0280I BRCONNECT thread 4: time stamp: 2013-02-13 22.00.30 BR0850I 63 of 83 objects processed - 0.105 of 0.138 units done BR0204I Percentage done: 75.90%, estimated end time: 22:00 BR0001I **************************************____________ BR0280I BRCONNECT thread 7: time stamp: 2013-02-13 22.00.30 BR0850I 67 of 83 objects processed - 0.112 of 0.138 units done BR0204I Percentage done: 80.72%, estimated end time: 22:00 BR0001I ****************************************__________ BR0280I BRCONNECT thread 6: time stamp: 2013-02-13 22.00.30 BR0850I 71 of 83 objects processed - 0.118 of 0.138 units done BR0204I Percentage done: 85.54%, estimated end time: 22:00 BR0001I *******************************************_______ BR0280I BRCONNECT thread 3: time stamp: 2013-02-13 22.00.30 BR0850I 75 of 83 objects processed - 0.125 of 0.138 units done BR0204I Percentage done: 90.36%, estimated end time: 22:00 BR0001I *********************************************_____ BR0280I BRCONNECT thread 7: time stamp: 2013-02-13 22.00.30 BR0850I 76 of 83 objects processed - 0.127 of 0.138 units done BR0204I Percentage done: 91.57%, estimated end time: 22:00 BR0001I **********************************************____ BR0280I BRCONNECT thread 6: time stamp: 2013-02-13 22.00.30 BR0850I 77 of 83 objects processed - 0.128 of 0.138 units done BR0204I Percentage done: 92.77%, estimated end time: 22:00 BR0001I **********************************************____ BR0280I BRCONNECT thread 3: time stamp: 2013-02-13 22.00.30 BR0850I 78 of 83 objects processed - 0.130 of 0.138 units done BR0204I Percentage done: 93.98%, estimated end time: 22:00 BR0001I ***********************************************___ BR0280I BRCONNECT thread 2: time stamp: 2013-02-13 22.00.30 BR0850I 79 of 83 objects processed - 0.132 of 0.138 units done BR0204I Percentage done: 95.18%, estimated end time: 22:00 BR0001I ************************************************__ BR0280I BRCONNECT time stamp: 2013-02-13 22.00.31 BR0848I Thread 2 finished with return code 0 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.31 BR0848I Thread 3 finished with return code 0 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.31 BR0848I Thread 6 finished with return code 0 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.31 BR0848I Thread 7 finished with return code 0 BR0280I BRCONNECT thread 8: time stamp: 2013-02-13 22.00.31 BR0850I 80 of 83 objects processed - 0.133 of 0.138 units done BR0204I Percentage done: 96.39%, estimated end time: 22:00 BR0001I ************************************************__ BR0280I BRCONNECT thread 4: time stamp: 2013-02-13 22.00.31 BR0850I 81 of 83 objects processed - 0.135 of 0.138 units done BR0204I Percentage done: 97.59%, estimated end time: 22:00 BR0001I *************************************************_ BR0280I BRCONNECT time stamp: 2013-02-13 22.00.32 BR0848I Thread 4 finished with return code 0 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.32 BR0848I Thread 8 finished with return code 0 BR0280I BRCONNECT thread 1: time stamp: 2013-02-13 22.00.32 BR0850I 82 of 83 objects processed - 0.137 of 0.138 units done BR0204I Percentage done: 98.80%, estimated end time: 22:00 BR0001I *************************************************_ BR0280I BRCONNECT thread 5: time stamp: 2013-02-13 22.00.32 BR0850I 83 of 83 objects processed - 0.138 of 0.138 units done BR0204I Percentage done: 100.00%, estimated end time: 22:00 BR0001I ************************************************** BR0280I BRCONNECT time stamp: 2013-02-13 22.00.33 BR0848I Thread 1 finished with return code 0 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.33 BR0848I Thread 5 finished with return code 0 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.33 BR0879I Statistics checked for 675 tables BR0878I Number of tables selected to collect statistics after check: 0 BR0880I Statistics collected for 83/0 tables/indexes BR0894I Tables with the longest duration of collecting statistics for owner SAPSR3DB Pos. Owner Table Duration Rows/old Rows/new Meth./Samp. Space[KB] Used[KB:%] Data[KB:%] Lobs Space[KB] Used[KB:%] Data[KB:%] [m:s] 1 SAPSR3DB J2EE_CONFIGENTRY 0:04 -1 786950 E/P10 -1 113416:100 89915:79 0 0 0:0 0:0 2 SAPSR3DB J2EE_CONFIG 0:04 -1 140850 E/P10 -1 31184:100 26547:85 0 0 0:0 0:0 3 SAPSR3DB BC_COMP_CLS 0:03 -1 89777 E/P30 -1 3968:100 2455:62 0 0 0:0 0:0 4 SAPSR3DB EP_ATTR_VALUES3 0:03 -1 221550 E/P10 -1 35216:100 28126:80 0 0 0:0 0:0 5 SAPSR3DB BC_UDV3_TAXONOMY 0:02 -1 45783 E/P30 -1 3968:100 2459:62 0 0 0:0 0:0 6 SAPSR3DB EP_ATTR_HEADERS3 0:02 -1 49720 E/P30 -1 6992:100 5535:79 0 0 0:0 0:0 7 SAPSR3DB BC_DDDBDP 0:01 -1 1342 C -1 1952:100 1402:72 0 0 0:0 0:0 8 SAPSR3DB BC_SLD_INST 0:01 -1 3872 C -1 3968:100 3161:80 0 0 0:0 0:0 9 SAPSR3DB BC_UDV3_ELEM_KEY 0:01 -1 207 C -1 104:100 54:52 0 0 0:0 0:0 10 SAPSR3DB BC_SYNCLOG 0:01 -1 565 C -1 104:100 110:106 0 0 0:0 0:0 11 SAPSR3DB BC_UDV3_TM_MAIN 0:01 -1 206 C -1 160:100 153:96 0 0 0:0 0:0 12 SAPSR3DB BC_UDV3_ELEM_CB 0:01 -1 403 C -1 104:100 60:58 0 0 0:0 0:0 13 SAPSR3DB BC_SLD_CHANGELOG 0:01 -1 4065 C -1 2960:100 2406:81 0 0 0:0 0:0 14 SAPSR3DB EP_OBJECTS3 0:01 -1 9313 C -1 1952:100 1201:62 0 0 0:0 0:0 15 SAPSR3DB GLX_RRH_TEXTS 0:01 -1 14890 E/P30 -1 1952:100 1163:60 0 0 0:0 0:0 16 SAPSR3DB GLX_RR_DEPL_DELTA 0:01 -1 14573 E/P30 -1 1952:100 1252:64 0 0 0:0 0:0 17 SAPSR3DB EP_UNIT_ATTRS3 0:01 -1 33300 E/P30 -1 2960:100 2114:71 0 0 0:0 0:0 18 SAPSR3DB JPL_MOD_ACTN 0:01 -1 2224 C -1 104:100 59:56 0 0 0:0 0:0 19 SAPSR3DB GLX_RR_OBJ_CUR 0:01 -1 14767 E/P30 -1 1952:100 1226:63 0 0 0:0 0:0 20 SAPSR3DB JPL_MOD_ACTN_PERM 0:01 -1 12810 E/P30 -1 224:100 100:45 0 0 0:0 0:0 21 SAPSR3DB GLX_RR_OBJ_DEFS 0:01 -1 14830 E/P30 -1 1952:100 1608:82 0 0 0:0 0:0 22 SAPSR3DB SR_SD_GR_CLASS 0:01 -1 132 C -1 40:100 19:47 0 0 0:0 0:0 23 SAPSR3DB SR_SD 0:01 -1 66 C -1 104:100 53:51 0 0 0:0 0:0 24 SAPSR3DB SR_SRV 0:01 -1 33 C -1 40:100 11:26 0 0 0:0 0:0 25 SAPSR3DB TC_WDRR_LAYERS 0:01 -1 2 C -1 40:100 0:0 0 0 0:0 0:0 26 SAPSR3DB SR_SE 0:01 -1 38 E/P10 -1 40:100 34:86 0 0 0:0 0:0 27 SAPSR3DB UME_STRINGS_ACTN 0:01 -1 6887 C -1 2960:100 1944:66 0 0 0:0 0:0 28 SAPSR3DB UME_STRINGS_PERM 0:01 -1 12963 E/P30 -1 3968:100 3089:78 0 0 0:0 0:0 29 SAPSR3DB BC_COMPVERS 0:00 -1 2154 C -1 584:100 477:82 0 0 0:0 0:0 30 SAPSR3DB BC_COMP_INFO 0:00 -1 1330 C -1 104:100 57:55 0 0 0:0 0:0 31 SAPSR3DB BC_DDDBTABLERT 0:00 -1 676 C -1 760:100 547:72 0 0 0:0 0:0 32 SAPSR3DB BC_MON_AGREGATES 0:00 -1 2032 C -1 104:100 67:65 0 0 0:0 0:0 33 SAPSR3DB BC_SLD_ASSOC 0:00 -1 1268 C -1 104:100 46:44 0 0 0:0 0:0 34 SAPSR3DB BC_SLD_CLASS 0:00 -1 1096 C -1 880:100 726:82 0 0 0:0 0:0 35 SAPSR3DB BC_SLD_ASSINST 0:00 -1 5706 C -1 280:100 195:70 0 0 0:0 0:0 36 SAPSR3DB EP_SHORT_STRS 0:00 -1 3298 C -1 1952:100 1024:52 0 0 0:0 0:0 37 SAPSR3DB EP_HORIZ_ATTRS1 0:00 -1 1185 C -1 160:100 84:53 0 0 0:0 0:0 38 SAPSR3DB EP_ATTR_NAMES3 0:00 -1 6462 C -1 584:100 461:79 0 0 0:0 0:0 39 SAPSR3DB GLX_C_CLASSES 0:00 -1 233 C -1 464:100 379:82 0 0 0:0 0:0 40 SAPSR3DB GLX_C_CONFIG 0:00 -1 36 C -1 104:100 41:40 0 0 0:0 0:0 41 SAPSR3DB GLX_RR_GEN_CONT 0:00 -1 281 C -1 584:100 356:61 0 0 0:0 0:0 42 SAPSR3DB JPL_APP_ACTN 0:00 -1 1150 C -1 104:100 63:60 0 0 0:0 0:0 43 SAPSR3DB JPL_APP_ACTN_ROLE 0:00 -1 1202 C -1 104:100 63:61 0 0 0:0 0:0 44 SAPSR3DB JPL_APP_PC 0:00 -1 1015 C -1 104:100 75:72 0 0 0:0 0:0 45 SAPSR3DB JPL_MOD_PC 0:00 -1 2148 C -1 224:100 134:60 0 0 0:0 0:0 46 SAPSR3DB SDBAD 0:00 -1 3 C -1 40:100 0:1 0 0 0:0 0:0 47 SAPSR3DB SDBAH 0:00 -1 3 C -1 40:100 0:1 0 0 0:0 0:0 48 SAPSR3DB SEA_ISO_CODE_TEXTS 0:00 -1 971 C -1 104:100 53:51 0 0 0:0 0:0 49 SAPSR3DB SEA_UOM 0:00 -1 116 C -1 40:100 7:17 0 0 0:0 0:0 50 SAPSR3DB SEA_UOM_TEXTS 0:00 -1 108 C -1 40:100 7:18 0 0 0:0 0:0 51 SAPSR3DB SR_CG 0:00 -1 1 C -1 40:100 0:1 0 0 0:0 0:0 52 SAPSR3DB JPL_PERM 0:00 -1 12573 E/P30 -1 640:100 491:77 0 0 0:0 0:0 53 SAPSR3DB SEA_CURRENCY_TEXTS 0:00 -1 6142 C -1 584:100 444:76 0 0 0:0 0:0 54 SAPSR3DB SR_CG_CLASS 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 55 SAPSR3DB SR_CG_DESC 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 56 SAPSR3DB SR_CONFIG_VALS 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 57 SAPSR3DB SR_CG_GR_CLASS 0:00 -1 2 C -1 40:100 0:1 0 0 0:0 0:0 58 SAPSR3DB SR_CS_GR_VALUES 0:00 -1 90 C -1 40:100 6:15 0 0 0:0 0:0 59 SAPSR3DB SR_CS_GR_REF 0:00 -1 5 C -1 40:100 0:0 0 0 0:0 0:0 60 SAPSR3DB SR_CS_SYS_DESC 0:00 -1 43 C -1 40:100 8:19 0 0 0:0 0:0 61 SAPSR3DB SR_CS_SYS_PARAM 0:00 -1 403 C -1 40:100 12:30 0 0 0:0 0:0 62 SAPSR3DB SR_CS_VALUE 0:00 -1 145 C -1 40:100 19:47 0 0 0:0 0:0 63 SAPSR3DB SR_CS_SYS 0:00 -1 43 C -1 40:100 12:30 0 0 0:0 0:0 64 SAPSR3DB SR_KEY_GEN 0:00 -1 12 C -1 40:100 1:2 0 0 0:0 0:0 65 SAPSR3DB SR_CS_VALUES_VERS 0:00 -1 43 C -1 40:100 0:1 0 0 0:0 0:0 66 SAPSR3DB SR_CS_VALUE_DESC 0:00 -1 145 C -1 40:100 6:14 0 0 0:0 0:0 67 SAPSR3DB SR_PHS_CG 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 68 SAPSR3DB SR_PHS_SD 0:00 -1 66 C -1 40:100 0:1 0 0 0:0 0:0 69 SAPSR3DB SR_PHS 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 70 SAPSR3DB SR_PHS_CLASS 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 71 SAPSR3DB SR_SD_CLASS 0:00 -1 198 C -1 40:100 13:32 0 0 0:0 0:0 72 SAPSR3DB TC_WDRR_TYPES 0:00 -1 3 C -1 40:100 0:1 0 0 0:0 0:0 73 SAPSR3DB T_DOMAIN 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 74 SAPSR3DB TC_WDRR_MRO_FILES 0:00 -1 1100 C -1 1952:100 938:48 0 0 0:0 0:0 75 SAPSR3DB TC_WDRR_MRO_LUT 0:00 -1 1100 C -1 104:100 85:82 0 0 0:0 0:0 76 SAPSR3DB T_CHUNK 0:00 -1 27 C -1 40:100 20:50 0 0 0:0 0:0 77 SAPSR3DB XI_AF_CPA_FLAGS 0:00 -1 2 C -1 40:100 0:0 0 0 0:0 0:0 78 SAPSR3DB T_SESSION 0:00 -1 9 C -1 40:100 1:2 0 0 0:0 0:0 79 SAPSR3DB XI_AF_LIC_AGG_LOG 0:00 -1 2 C -1 40:100 0:0 0 0 0:0 0:0 80 SAPSR3DB XI_AF_LMS_STAMP 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 81 SAPSR3DB XI_AF_PROF_RUNTIME 0:00 -1 2 C -1 40:100 1:2 0 0 0:0 0:0 82 SAPSR3DB XI_SEC_ARCH 0:00 -1 1 C -1 40:100 0:0 0 0 0:0 0:0 83 SAPSR3DB UME_STRINGS 0:00 -1 1798 C -1 584:100 469:80 0 0 0:0 0:0 BR0900I Usage of space allocated in tablespaces for analyzed tables and indexes Pos. Tablespace Tables Analy. Space[KB] Used[KB:%] Data[KB:%] Indexes Valid. Space[KB] Used[KB:%] Data[KB:%] Lobs Proc. Space[KB] Used[KB:%] Data[KB:%] 1 PSAPSR3DB 676 83 -1 236784:100 183646:78 1079 0 0 0:0 0:0 0 0 0 0:0 0:0 BR0806I End of BRCONNECT processing: cekntnfi.sta 2013-02-13 22.00.33 BR0280I BRCONNECT time stamp: 2013-02-13 22.00.33 BR0802I BRCONNECT completed successfully