Sets the parameters during a database scan:

• Number of Scanning Processes

  Controls the number of worker threads that can convurrently 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 yieslds 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