|
-
 Originally Posted by ebrian
You could try to perform the following:
Code:
SQL> exec dbms_stats.gather_fixed_objects_stats;
Hi,
I have had a look at this command. It seems recommended to do after upgrade to 10g once you have reached typical workload and only ever do once (unless significant change in circumstances (hardware, software, workload)
This wasn't done after upgrade (some 9 months ago). We did do dbms_gather_database_stats though.
Is it safe to run dbms_stats.gather_fixed_objects_stats so late on after the upgrade?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote