Copyright © 2011, 2015, Oracle and/or its affiliates. All rights reserved.
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