Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] ORACLE memory utilization reach 99%

Anton Dischner

2006-10-09

Replies:

oerr ora 18
00018, 00000, "maximum number of sessions exceeded"
// *Cause: All session state objects are in use.
// *Action: Increase the value of the SESSIONS initialization parameter.

oerr ora 25
00025, 00000, "failed to allocate %s"
// *Cause: Out of memory.
// *Action: Restart with larger sga heap.

don't forget to shutdown/startup your database if modifiying this
parameters,

regards,

Toni

Am 09.10.2006 um 13:49 schrieb CLEMENS.BLEILE@(protected):

>
> What IS the "database connection error" ? I.e. what is the actual
> ORA-error message?
>
> E.g. ORA-18 or ORA-25 ???
>
> Ciao
>
> Clemens
>

--
+-----------------------------------------------------------------+
| Anton Dischner, Unix admin, Oracle-DBA   Phone: +49 89 70953202|
| Institut fuer Klinische Chemie        Fax : +49 89 70958888|
| Klinikum Grosshadern               Home : +49 89 69708766|
| Ludwig Maximilians Universitaet Muenchen Mobil: +49 172 8388880|
| 81366 Muenchen Germany                            |
| Marchioninistr. 15   Anton.Dischner"at"med.uni-muenchen.de   |
+-----------------------------------------------------------------+



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.