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

Hi, first we when we started up with oracle we had problems with these params: processes, open_cursors, max_enabled_roles After a week or so oracle was not able to allocate shared memory, something like this: ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","TRIGGER$","sga heap","state objects") ORA-00604: error occurred at (remember I'm allways talking about Oracle under Linux) This had 2 reasons: 1. wrong kernel-params (shared-memory-limits and semaphore-limits) 2. a memory leak in Oracle 8.1.7 (applying patchset 3 resolved this) bye, Steve Farmer wrote:

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

-- -------------------------------------- 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