Data Set Options for Relational Databases |
Specifies whether to limit the
number of connections to the DBMS
server for a threaded read.
Default value: |
YES
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Oracle
|
DB_ONE_CONNECT_PER_THREAD=YES | NO
|
- YES
-
enables this option, allowing only one connection per partition.
- NO
-
disables this option.
Use this option if you want to have only one connection
per partition. By default, the number of connections is limited to the maximum
number of allowed threads. If the value of the maximum number of allowed threads
is less than the number of partitions on the table, a single connection reads
multiple
partitions.
Autopartitioning Scheme for Oracle
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.