2 Replies Latest reply: Feb 9, 2013 3:28 AM by Richard Harrison . RSS

    stats options

    user511621
      hi - how do i find that what options are set in below command( except schemaname)..?

      I found this in one of the existing script and wanted to get info about the below specified options

      exec dbms_stats.gather_schema_stats('schemaname',NULL,FALSE, 'FOR ALL COLUMNS SIZE 1',NULL, 'DEFAULT',TRUE,NULL,NULL,'GATHER');

      this is oracle 10.2
        • 1. Re: stats options
          sb92075
          user511621 wrote:
          hi - how do i find that what options are set in below command( except schemaname)..?

          I found this in one of the existing script and wanted to get info about the below specified options

          exec dbms_stats.gather_schema_stats('schemaname',NULL,FALSE, 'FOR ALL COLUMNS SIZE 1',NULL, 'DEFAULT',TRUE,NULL,NULL,'GATHER');

          this is oracle 10.2
          when all else fails Read The Fine Manual

          http://www.oracle.com/pls/db112/search?word=dbms_stats&partno=
          • 2. Re: stats options
            Richard Harrison .
            Hi,
            Desc dbms_stats

            is a good place to start.

            Cheers,
            Harry