Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)

Part Number A88879-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

External LOBs (BFILEs), 19 of 41


Two Ways to See If a BFILE is Open

Figure 12-15 Use Case Diagram: Two Ways to See If a BFILE is Open


Text description of adl12bf9.gif follows This link takes you back to the External LOBs (BFILES) main diagram. This link takes you to the diagram, Checking If BFILE is Open Using FILEISOPEN. This link takes you to the diagram, Checking If a BFILE is Open Using ISOPEN.
Text description of the illustration adl12bf9.gif

See Also:

"Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES). 

Recommendation: Use OPEN to Open BFILE

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.

    1. Checking If the BFILE is Open with FILEISOPEN

    2. Checking If a BFILE is Open Using ISOPEN

Specify the Maximum Number of Open BFILEs: SESSION_MAX_OPEN_FILES

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 init.ora file. For example:

SESSION_MAX_OPEN_FILES=20

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 FILECLOSEALL call.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback