|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
External LOBs (BFILEs), 19 of 41
"Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES).
As you can see by comparing the code, these alternative methods are very similar. However, while you can continue to use the older
FILEISOPEN form, we strongly recommend that you switch to using
ISOPEN, because this facilitates future extensibility.
A limited number of
BFILEs can be open simultaneously per session. The maximum number is specified by using the
SESSION_MAX_OPEN_FILES initialization parameter.
SESSION_MAX_OPEN_FILES defines an upper limit on the number of simultaneously open files in a session. The default value for this parameter is 10. That is, a maximum of 10 files can be opened simultaneously per session if the default value is utilized. The database administrator can change the value of this parameter in the
ora file. For example:
If the number of unclosed files exceeds the
SESSION_MAX_OPEN_FILES value then you will not be able to open any more files in the session. To close all open files, use the