** Tested with UNIX / Linux operating system.
1. Connect to BRTOOLS via ora<SID>.
> brtools BR0651I BRTOOLS 7.00 (32)
2. Select 7 for Database statistics.
BR0280I BRTOOLS time stamp: 2011-03-25 11.04.54 BR0656I Choice menu 1 - please make a selection ------------------------------------------------------------------------------- BR*Tools main menu 1 = Instance management 2 - Space management 3 - Segment management 4 - Backup and database copy 5 - Restore and recovery 6 - Check and verification 7 - Database statistics 8 - Additional functions 9 - Exit program Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 7 BR0280I BRTOOLS time stamp: 2011-03-25 11.05.06 BR0663I Your choice: '7'
3. Select 1 to Update database statistics.
BR0280I BRTOOLS time stamp: 2011-03-25 11.05.06 BR0656I Choice menu 13 - please make a selection ------------------------------------------------------------------------------- Processing database statistics 1 = Update database statistics 2 - Collect missing statistics 3 - Delete harmful statistics 4 - Manage database statistics 5 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: 1 BR0280I BRTOOLS time stamp: 2011-03-25 11.05.21 BR0663I Your choice: '1'
4. This page is the main options for update statistic. Type ‘c’ to continue. (or select 11, to update a specific table)
BR0280I BRTOOLS time stamp: 2011-03-25 11.05.21 BR0657I Input menu 42 - please check/enter input values ------------------------------------------------------------------------------- BRCONNECT main options for update statistics 1 - BRCONNECT profile (profile) ......... [initSID.sap] 2 - Database user/password (user) ....... [/] 3 ~ Collection method (method) .......... [] 4 ~ Sample size (sample) ................ [] 5 ~ Bucket count (bucket) ............... [] 6 ~ DBMS_STATS parallel degree (degree) . [] 7 ~ Change threshold (change) ........... [] 8 ~ Database owner for update (owner) ... [] 9 ~ Ignore DBSTATC table (ignore) ....... [] 10 ~ Exclude from update (exclude) ....... [] 11 ~ Tables for update (table) ........... [all] Standard keys: c - cont, b - back, s - stop, r - refr, h - help ------------------------------------------------------------------------------- BR0662I Enter your choice: c BR0280I BRTOOLS time stamp: 2011-03-25 11.05.55 BR0663I Your choice: 'c' BR0259I Program execution will be continued...
5. This page is the additional options for update statistics. Type ‘c’ to continue.
BR0280I BRTOOLS time stamp: 2011-03-25 11.05.55
BR0657I Input menu 43 - please check/enter input values
-------------------------------------------------------------------------------
Additional BRCONNECT options for update statistics
1 - Confirmation mode (confirm) ......... [yes]
2 - Query mode (query) .................. [no]
3 - Parallel threads (parallel) ......... [1]
4 - Update history tables (history) ..... [no]
5 - Retain old statistics (retain) ...... [no]
6 ~ Time limit in minutes (limit) ....... []
7 ~ Force options (force) ............... []
8 # Time interval in minutes (interval) . []
9 - Extended output (output) ............ [no]
10 - Message language (language) ......... [E]
11 - BRCONNECT command line (command) ....
[-p initSID.sap -l E -f stats -t "all" -p 1]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2011-03-25 11.06.09
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRCONNECT will be started with options
'-p initSID.sap -l E -f stats -t "all" -p 1'
6. This step is to check the statistics. Type ‘c’ to continue.
BR0280I BRTOOLS time stamp: 2011-03-25 11.06.09 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort: c BR0280I BRTOOLS time stamp: 2011-03-25 11.06.16 BR0257I Your reply: 'c' BR0259I Program execution will be continued... ############################################################################### BR0801I BRCONNECT 7.00 (32) BR0805I Start of BRCONNECT processing: cefnarie.sta 2011-03-25 11.06.16 BR0484I BRCONNECT log file: /oracle/SID/sapcheck/cefnarie.sta BR0280I BRCONNECT time stamp: 2011-03-25 11.06.22 BR0813I Schema owners found in database SID: SAPSR3*, SAPSR3DB% BR0280I BRCONNECT time stamp: 2011-03-25 11.08.18 BR0814I Number of tables in schema of owner SAPSR3: 69961 BR0836I Number of info cube tables found for owner SAPSR3: 49 BR0814I Number of tables in schema of owner SAPSR3DB: 318 BR0280I BRCONNECT time stamp: 2011-03-25 11.08.53 BR0815I Number of indexes in schema of owner SAPSR3: 83697 BR0815I Number of indexes in schema of owner SAPSR3DB: 466 BR0280I BRCONNECT time stamp: 2011-03-25 11.08.54 BR0818I Number of tables found in DBSTATC for owner SAPSR3: 390 BR0280I BRCONNECT time stamp: 2011-03-25 11.08.54 BR0807I Name of database instance: SID BR0808I BRCONNECT action ID: cefnarie 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: 70279
7. Type ‘c’ to proceed with the statistics. Please wait a moment untill the statistics update is done.
BR0280I BRCONNECT time stamp: 2011-03-25 11.08.54 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT: c BR0280I BRCONNECT time stamp: 2011-03-25 11.13.43 BR0850I 21 of 22 objects processed - 0.112 of 0.117 units done BR0204I Percentage done: 95.45%, estimated end time: 11:13 BR0001I ************************************************__ BR0280I BRCONNECT time stamp: 2011-03-25 11.13.43 BR0883I Table selected to collect statistics after check: SAPSR3.USR41 (0/2:0:1) BR0280I BRCONNECT time stamp: 2011-03-25 11.13.43 BR0881I Collecting statistics for table SAPSR3.USR41 with method/sample C ... BR0280I BRCONNECT time stamp: 2011-03-25 11.13.44 BR0884I Statistics collected for table: SAPSR3.USR41, rows old/new: 0/1 BR0280I BRCONNECT time stamp: 2011-03-25 11.13.44 BR0850I 22 of 22 objects processed - 0.117 of 0.117 units done BR0204I Percentage done: 100.00%, estimated end time: 11:13 BR0001I ************************************************** BR0280I BRCONNECT time stamp: 2011-03-25 11.13.44 BR0879I Statistics checked for 70279 tables BR0878I Number of tables selected to collect statistics after check: 22 BR0880I Statistics collected for 22/0 tables/indexes BR0806I End of BRCONNECT processing: cefnarie.sta 2011-03-25 11.13.45 BR0280I BRCONNECT time stamp: 2011-03-25 11.13.47 BR0802I BRCONNECT completed successfully ############################################################################### BR0292I Execution of BRCONNECT finished with return code 0
