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

At 8:24 AM +0200 9/7/02, Michael Bretterklieber wrote:
>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.
>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?
>Michael Bretterklieber
>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
>homepage: http://www.jawa.at
>--------- privat -----------
>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

Reply via email to