BR0801I BRCONNECT 7.20 (30) BR0805I Start of BRCONNECT processing: cesxqrzd.sta 2016-04-11 08.41.21 BR0484I BRCONNECT log file: /oracle/EPP/sapcheck/cesxqrzd.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 oraepp/oraepp epprda AIX 1 6 00C43AF74C00 oracle_info EPP 11.2.0.3.0 8192 6674 1251258764 epprda UTF8 UTF8 255849424 &EPP sap_info SAPSR3DB make_info rs6000_64 OCI_112 Feb 4 2013 command_line /usr/sap/EPP/SYS/exe/run/brconnect -p initEPP.sap -l E -u / -f stats -t all -p 1 stats_table ALL stats_dbms_stats ALL:R:0 stats_change_threshold 50 stats_parallel_degree 1 stats_dict_cycle 0 stats_system_cycle 0 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.22 BR0813I Schema owner found in database EPP: SAPSR3DB% BR0280I BRCONNECT time stamp: 2016-04-11 08.41.22 BR0814I Number of tables in schema of owner SAPSR3DB: 1520 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.23 BR0815I Number of indexes in schema of owner SAPSR3DB: 2500 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.23 BR0807I Name of database instance: EPP BR0808I BRCONNECT action ID: cesxqrzd BR0809I BRCONNECT function ID: sta BR0810I BRCONNECT function: stats BR0812I Database objects for processing: ALL BR0851I Number of tables with missing statistics: 0 BR0852I Number of tables to delete statistics: 0 BR0854I Number of tables to collect statistics without checking: 0 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: 1520 Owner SAPSR3DB: 1520 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.23 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT: BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0257I Your reply: 'c' BR0259I Program execution will be continued... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0817I Number of monitored/modified tables in schema of owner SAPSR3DB: 1520/98 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0877I Checking and collecting table and index statistics... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0883I Table selected to collect statistics after check: SAPSR3DB.BC_JMSQUEUE (0/11:0:11) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0881I Collecting statistics for table SAPSR3DB.BC_JMSQUEUE with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0884I Statistics collected for table: SAPSR3DB.BC_JMSQUEUE, rows old/new: 0/0 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0850I 1 of 14 objects processed - 0.002 of 0.027 units done BR0204I Percentage done: 7.14%, estimated end time: 8:41 BR0001I ****______________________________________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0883I Table selected to collect statistics after check: SAPSR3DB.BC_MON_AGREGATES (25935/55600:0:57416) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.26 BR0881I Collecting statistics for table SAPSR3DB.BC_MON_AGREGATES with method/sample E/P30 ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.BC_MON_AGREGATES, rows old/new: 25935/24373 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 2 of 14 objects processed - 0.004 of 0.027 units done BR0204I Percentage done: 14.29%, estimated end time: 8:41 BR0001I *******___________________________________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.BC_MON_ID_ALLOC (2/0:561:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.BC_MON_ID_ALLOC with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.BC_MON_ID_ALLOC, rows old/new: 2/2 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 3 of 14 objects processed - 0.006 of 0.027 units done BR0204I Percentage done: 21.43%, estimated end time: 8:41 BR0001I ***********_______________________________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.BC_MSG_JOB (3/0:2:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.BC_MSG_JOB with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.BC_MSG_JOB, rows old/new: 3/3 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 4 of 14 objects processed - 0.008 of 0.027 units done BR0204I Percentage done: 28.57%, estimated end time: 8:41 BR0001I **************____________________________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.CBS_LOCK (8/0:33246:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.CBS_LOCK with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.CBS_LOCK, rows old/new: 8/8 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 5 of 14 objects processed - 0.010 of 0.027 units done BR0204I Percentage done: 35.71%, estimated end time: 8:41 BR0001I ******************________________________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.CBS_NODE (2/0:3189:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.CBS_NODE with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.CBS_NODE, rows old/new: 2/2 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 6 of 14 objects processed - 0.012 of 0.027 units done BR0204I Percentage done: 42.86%, estimated end time: 8:41 BR0001I *********************_____________________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.GLX_C_MONITOR (2/638:0:638) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.GLX_C_MONITOR with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.GLX_C_MONITOR, rows old/new: 2/2 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 7 of 14 objects processed - 0.014 of 0.027 units done BR0204I Percentage done: 50.00%, estimated end time: 8:41 BR0001I *************************_________________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.KMC_CMCC_TABLE (1/0:2:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.KMC_CMCC_TABLE with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.KMC_CMCC_TABLE, rows old/new: 1/1 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 8 of 14 objects processed - 0.016 of 0.027 units done BR0204I Percentage done: 57.14%, estimated end time: 8:41 BR0001I *****************************_____________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.KMC_DBRM_DELNODES (0/4:0:4) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.KMC_DBRM_DELNODES with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.KMC_DBRM_DELNODES, rows old/new: 0/0 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 9 of 14 objects processed - 0.018 of 0.027 units done BR0204I Percentage done: 64.29%, estimated end time: 8:41 BR0001I ********************************__________________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.KMC_DBRM_MODCOUNT (8/0:16:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.KMC_DBRM_MODCOUNT with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.KMC_DBRM_MODCOUNT, rows old/new: 8/8 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 10 of 14 objects processed - 0.020 of 0.027 units done BR0204I Percentage done: 71.43%, estimated end time: 8:41 BR0001I ************************************______________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.KMC_EB_EVENT (0/18:0:18) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.KMC_EB_EVENT with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.KMC_EB_EVENT, rows old/new: 0/0 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 11 of 14 objects processed - 0.022 of 0.027 units done BR0204I Percentage done: 78.57%, estimated end time: 8:41 BR0001I ***************************************___________ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.KMC_EB_PARAM (0/18:0:18) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.KMC_EB_PARAM with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.KMC_EB_PARAM, rows old/new: 0/0 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 12 of 14 objects processed - 0.024 of 0.027 units done BR0204I Percentage done: 85.71%, estimated end time: 8:41 BR0001I *******************************************_______ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.KMC_UWL_CACHE_LOG (713/0:193067:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.KMC_UWL_CACHE_LOG with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.KMC_UWL_CACHE_LOG, rows old/new: 713/713 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 13 of 14 objects processed - 0.026 of 0.027 units done BR0204I Percentage done: 92.86%, estimated end time: 8:41 BR0001I **********************************************____ BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0883I Table selected to collect statistics after check: SAPSR3DB.XI_AF_LIC_AGG_LOG (2/0:254:0) BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0881I Collecting statistics for table SAPSR3DB.XI_AF_LIC_AGG_LOG with method/sample C ... BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0884I Statistics collected for table: SAPSR3DB.XI_AF_LIC_AGG_LOG, rows old/new: 2/2 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0850I 14 of 14 objects processed - 0.027 of 0.027 units done BR0204I Percentage done: 100.00%, estimated end time: 8:41 BR0001I ************************************************** BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0879I Statistics checked for 1520 tables BR0878I Number of tables selected to collect statistics after check: 14 BR0880I Statistics collected for 14/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 BC_MON_AGREGATES 0:01 25935 24373 E/P30 -1 2960:100 904:31 0 0 0:0 0:0 2 SAPSR3DB BC_JMSQUEUE 0:00 0 0 C -1 40:100 0:0 0 0 0:0 0:0 3 SAPSR3DB BC_MON_ID_ALLOC 0:00 2 2 C -1 40:100 0:0 0 0 0:0 0:0 4 SAPSR3DB BC_MSG_JOB 0:00 3 3 C -1 40:100 0:1 0 0 0:0 0:0 5 SAPSR3DB CBS_LOCK 0:00 8 8 C -1 40:100 0:0 0 0 0:0 0:0 6 SAPSR3DB CBS_NODE 0:00 2 2 C -1 40:100 0:0 0 0 0:0 0:0 7 SAPSR3DB GLX_C_MONITOR 0:00 2 2 C -1 40:100 1:3 0 0 0:0 0:0 8 SAPSR3DB KMC_CMCC_TABLE 0:00 1 1 C -1 40:100 0:0 0 0 0:0 0:0 9 SAPSR3DB KMC_DBRM_DELNODES 0:00 0 0 C -1 40:100 0:0 0 0 0:0 0:0 10 SAPSR3DB KMC_DBRM_MODCOUNT 0:00 8 8 C -1 40:100 0:0 0 0 0:0 0:0 11 SAPSR3DB KMC_EB_EVENT 0:00 0 0 C -1 104:100 0:0 0 0 0:0 0:0 12 SAPSR3DB KMC_EB_PARAM 0:00 0 0 C -1 40:100 0:0 0 0 0:0 0:0 13 SAPSR3DB KMC_UWL_CACHE_LOG 0:00 713 713 C -1 104:100 33:32 0 0 0:0 0:0 14 SAPSR3DB XI_AF_LIC_AGG_LOG 0:00 2 2 C -1 40:100 0:0 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 1520 14 -1 3608:100 940:26 2500 0 0 0:0 0:0 0 0 0 0:0 0:0 BR0806I End of BRCONNECT processing: cesxqrzd.sta 2016-04-11 08.41.27 BR0280I BRCONNECT time stamp: 2016-04-11 08.41.27 BR0802I BRCONNECT completed successfully