Session_max_open_files

This is a discussion on Session_max_open_files within the Oracle FAQ forums in Oracle Database category; Type:Integer Default:10 Modify:No Range:1 to either 50 or the value of MAX_OPEN_FILES defined at the operating system level, whichever is less Notes: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 by 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....

Go Back   Database Forum > Oracle Database > Oracle FAQ

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 02-04-2008, 07:29 AM
Post Session_max_open_files

Type:Integer
Default:10
Modify:No
Range:1 to either 50 or the value of MAX_OPEN_FILES defined at the operating system level, whichever is less
Notes: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 by 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.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 08:16 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.