Default: TRUE
Purpose
The DNFS_ENABLE parameter lets you enable and disable use of the Direct NFS Client on input data files during a SQL*Loader operation.
Syntax and Description
DNFS_ENABLE=[TRUE|FALSE]
The Direct NFS Client is an API that can be implemented by file servers to allow improved performance when an Oracle database accesses files on those servers.
SQL*Loader uses the Direct NFS Client interfaces by default when it reads data files over 1 GB. For smaller files, the operating system's I/O interfaces are used. To use the Direct NFS Client on all input data files, use DNFS_ENABLE=TRUE.
To disable use of the Direct NFS Client for all data files, specify DNFS_ENABLE=FALSE.
The DNFS_READBUFFERS parameter can be used to specify the number of read buffers used by the Direct NFS Client; the default is 4.
Oracle Grid Infrastructure Installation Guide for your platform for more information about enabling the Direct NFS Client
Example
The following example disables use of the Direct NFS Client on input data files during the load.
DNFS_ENABLE=FALSE