I am looking through our system and running the predicted reorganization benefit report. I do not see some objects which I expected to see - so I have gone into the system and looked at the properties for one such object and I noticed that even though the Last analyzed date shows as 3/14/2011, the message above says that "Statistics recorded in Quest Repository for this object are not current. Allocation of the last analysis was 118gb. this does not match the current allocation of 141gb. analyze again to update statistics." I and worried about the Analyze option on this screen - will it run in parallel, etc. As well, I can show from within SAP that the stats were collected last night on this object, so apparently Quest isn't recognizing that fact.
The reason you are getting "Statistics recorded in Quest Repository for this object are not current" is because you have not copied the existing Oracle Data Dictionary Statistics to the Space Manager repository. For SAP users, you should not use Space Manager to update the Oracle Data Dictionary statistics, rather use SAP interface, BRTools, to gather statistics for your tables then use Space Manager Analysis Group to copy the statistics to the repository. Below are the steps to copy the statistics from SAP over to the Space Manager Repository:
1. Go to Manage menu | New analysis group
2. Add all the objects that you would like to setup in the analysis group. By default, we would exclude SYS and SYSTEM user
3. In the Analyze options tab, make sure to select copy current data dictionary statistics into repository. You can schedule the job to run daily, weekly or etc.
As for the Predicted Reorg Benefit Report, it can be run to use data from any of the following:
1. Oracle Data Dictionary
2. Space Manager Repository
3. DBMS_SPACE (when tablespace is Locally Managed and set with ASSM)
The report is highly dependent on the source in which to retrieve the data. The option that determines what source to display the report from can be set in the Report Options page and Statistics Source at the bottom right of the screen. If you do not have the Space Manager Repository updated with current statistics, then 1st preference is to use Oracle Data Dictionary, the 2nd preference to DBMS_SPACE and the 3rd preference to Space Manager Repository. The 2nd and 3rd preference may also be set to None.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center