Description of the illustration threed.gif

This is a screenshot of the Set Parameters page of the Scan wizard. It allows you to set the following parameters during a database scan:

• Number of Scanning Processes

  Controls the number of worker threads that can concurrently employ the table scan task. The default is the number of CPUs, which you should use unless you have a specific reason not to.

• Scan Buffer Size

  Controls the byte size of the buffer that is used for the table scan. A larger buffer size yields better performance as long as SYS resources are sufficient.

• Rowid options:

  • Collect rowids only according to 'Rowids to Collect' table property

  • Collect also rowids for update Convertible Rows conversion method

  • Do not collect rowids

• Check for index key size violations

  If a table column must be modified to accommodate the larger size of the converted data, the maximum size of the index key defined on that column increases too. If the resulting index key size would be too large, given the index tablespace blocksize, report it in the scan report. This option is enabled by default.