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 >[EMAIL PROTECTED] >homepage: http://www.jawa.at >--------- privat ----------- >E-mail: [EMAIL PROTECTED] >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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
