22.1 OFS Configuration Parameters

The following table specifies all the parameters that enable NFS access in the database.

Table 22-1 OFS Configuration Parameters

Parameter Name Description

OFS_THREADS

This parameter is used to set the number of OFS worker threads to handle OFS requests.

Possible values:

  • An integer value in the range of 2–128

  • Default value is 4

22.1.1 OFS Client Interface

The OFS interface includes views and procedures that support OFS operations.

22.1.1.1 DBMS_FS Package

The DBMS_FS package enables users to perform operations on Oracle file system (make, mount, unmount and destroy) in the Oracle database.

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about Oracle OFS procedures.

The following example illustrates the use of DBMS_FS package.

BEGIN
 DBMS_FS.MAKE_ORACLE_FS (
  fstype           => 'dbfs',
  fsname           => 'dbfs_fs1',
  mount_options    => 'TABLESPACE=dbfs_fs1_tbspc');
END;
/
BEGIN
 DBMS_FS.MOUNT_ORACLE_FS (
  fstype           => 'dbfs',                              
  fsname           => 'dbfs_fs1',                              
  mount_point      => '/oracle/dbfs/testfs',                              
  mount_options    => 'default_permissions, allow_other, persist'); 
END;
/
/************** Now you can access the file system. All the FS operations go here ***************/

BEGIN
 DBMS_FS.UNMOUNT_ORACLE_FS (
  fsname           => 'dbfs_fs1',                              
  mount_point      => '/oracle/dbfs/testfs',
  mount_options    => 'force'); 
END;
/
BEGIN
 DBMS_FS.DESTROY_ORACLE_FS (
  fstype           => 'dbfs',
  fsname           => 'dbfs_fs1');
END;
/

22.1.1.2 Views for OFS

The views that support OFS operations start with V$OFS .

See Also:

Oracle Database Reference for the columns and data types of these views.