Initialization Parameters, 166 of 188

SESSION_MAX_OPEN_FILES

Parameter type:	Integer
Parameter class:	Static
Default value:	10
Range of values:	1 to either 50 or the value of `MAX_OPEN_FILES` defined at the OS level, whichever is less.
`SESSION_MAX_OPEN_FILES` specifies the maximum number of BFILEs that can be opened in any session. Once this number is reached, subsequent attempts to open more files in the session using `DBMS_LOB`.`FILEOPEN`() or OCILobFileOpen() will fail. The maximum value for this parameter depends on the equivalent parameter defined for the underlying operating system.
See Also: Oracle8i Application Developer's Guide - Large Objects (LOBs) for information on LOBs in general and BFILEs in particular. Oracle8i Supplied PL/SQL Packages Reference for information on the `DBMS_LOB.FILEOPEN()` procedure. Oracle Call Interface Programmer's Guide for information on the OCILobFileOpen() procedure.