DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 11.0.3 Gether schema statistics

  1. #1
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    11.0.3 Gether schema statistics

    Dear friend
    My Application is on 11.0.3 with 8.0.5.2
    i want to gether the schema statistices using DBMS_UTILITY.
    and my optimizer mode is RBO .
    before gethering the statistices do i have to change the optimizer mode to CHOOSE first, then gether statistices and after completing the statistices back to RBO.
    i am bit confused what is right way.
    Gether schema statistices what does it do? does it improve the performance if yes then how
    please explain
    Sonu

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    The statistics you gather will be in use only for CBO. Optimizer will choose CBO if statistics exists otherwise it will use RBO.

    So, its really doesn't matter when you switch to CHOOSE. You can do before or after gathering stats.
    Reddy,Sam

  3. #3
    Join Date
    Jul 2003
    Posts
    30
    As far as I know, 11.0.3 was developed with rule based optimization. 11i, 11.5.x is the first release of applications that uses cost based optimization. In addition to that, there is a concurrent program that you can run to gather schema statistics. Furthermore, this is done via fnd_stats (not the supplied dbms_utility package). I would reconsider gathering stats using this method if at all - 1103 is rule based. Gathering statistics may adversely effect the applications.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width