Re: OCIPLogon , maximum number of sessions apache/php <-> Oracle

Hi Michael, So what you are saying is that apache/php will keep opening sessions until oracle runs out of processes or cursors or memory or hits session_per_user maximum ?? I was thinking of experimenting with the profile parameter IDLE_TIME Profile Parameter to make oracle close open sessions after a certain amount of time , have you any experience with this? I have open_cursors = 500 processes = 200 max_enabled_roles = 30 regards Steve At 8:24 AM +0200 9/7/02, Michael Bretterklieber wrote:

Hi, this depends on your settings in the init<instance>.ora in the directory /opt/oracle/OraHome1/admin/<instance>/pfile dir. Here are some settings: processes = 150 open_cursors = 300 max_enabled_roles = 30 you also have to set the sizes of the shared-memory pool. bye, Steve Farmer wrote:

Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve

-- -------------------------------------- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 Michael.Bretterklieber@jawa.at homepage: http://www.jawa.at --------- privat ----------- E-mail: mbretter@inode.at homepage: http://www.inode.at/mbretter -------------------------------------- "...the number of UNIX installations has grown to 10, with more expected..." - Dennis Ritchie and Ken Thompson, June 1972

-- ------------------------------------------------- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: hts@hts.com.au Tel: 612 9982 6767 Fax: 612 9981 3081