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
>> [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
>
>
--
--------------------------------------
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
