on 2012 May 29 8:17 AM
Hi,
As part of SAP's oracle performance optimization report, we implemented the scripts dbstatc10.sql attached to the note 403704 ; Maintained customer specific settings and implemented the script statistics.txt attached to the note 1020260. I ran brconnect to gather statistics (brconnect -u / -c -f stats -t ALL). I checked the LAST_ANALYZED field of the table dba_tables to determine when table statistics were collected for a table defined in DBSTATC with the Active flag set to 'A'. Surprisingly, the LAST_ANALYZED field of dba_tables did not return the date stamp of the recent brconnect run. I tested for a single table using DB21 and saw that the LAST_ANALYZED field was updated. brconnect documentation states that it picks the tables in DBSTATC whose Active flag is set to A. Any reasons why LAST_ANALYZED was not updated by brconnect?. Thanks for your time.
brconnect version: 7.00(52)
oracle: 10.2.0.2
Regards,
Hi Ajay,
Execute with the "-force" option, as below;
brconnect -u / -c force -f stats -t ALL
For the further information, you can read the thread http://scn.sap.com/thread/3154417
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It depends to the condition. If the changes are lower than %50, it is not necessary to update statistics for those tables. You can check the ratio on DB20. For the further information, check the Note 106047 - DB21: Customizing the DBSTATC
For your case, you can find the specific information in the note, as below;
A -> Statistics created if necessary.
BRCONNECT determines whether statistics are necessary, taking into account the number of table entries compared to the number of the table entries during the last statistics creation. If the variance exceeds a threshold value (default: stats_change_threshold = 50%), new statistics are created.
If you would like to force the system to collect statistics for all tables, you can execute the command, below;
brconnect -u / -c -f stats -t ALL -f collect,allsel,keep,locked
Best regards,
Orkun Gedik
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.