From daemon Sun Dec 24 03:18:35 1995
Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM)
 id AA16630; Sun, 24 Dec 1995 03:18:32 -0500
Message-Id: <9512240818.AA16630@alice.jcc.com>
Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3)
   with BSMTP id 0169; Sun, 24 Dec 95 02:55:25 EST
Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 0884; Sun, 24 Dec 1995 02:55:23 -0500
Date:         Sun, 24 Dec 1995 13:29:06 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
Sender: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
From: "PL. Rukmani" <mani@TC4HQ.CMC.STPH.NET>
Subject:      Re: ORA-600 and memory space leak
X-To:         ORACLE-L@ccvm.sunysb.edu
To: Multiple recipients of list ORACLE-L <ORACLE-L@ccvm.sunysb.edu>
In-Reply-To:  <no.id> from "Oracle Dba" at Dec 22, 95 08:06:44 am

> 2- the 2nd way is : To have the following line in ur init.ora
>
> event="10262 trace name context forever,level2000"
>
> This will ignore the space leaks of less than 2000 bytes .If u have leak
> more than 2000 bytes , it is better to call oracle again !!!
>
> I show you the contents of the trace file:

>
>
> error 2194 detected in background process
> OPIRIP: Uncaught error 447. Error stack:
> ORA-00447: fatal error in background process
> ORA-02194: event specification syntax error 230 (minor error 214) near
 'LEVEL200
> 0'
>
> ORA-2194 indicates a "syntax error" within the event statement.
>
> Does anyone know the proper syntax for that statement?
>
>

Paul,

  I just tried

     event="10262 trace name context forever,level 2000"

  and Oracle came up without any error.  ('level2000' is changed to
  'level 2000').

  We are running Ver 7.1.3 on NCR Unix SVR4 with TOPEND using XA interface to
  talk to Oracle.  A memory leak is a regular affair whenever the DB is
  shutdown with existing connections (either shutdown immediate or killing the
  sessions and then shutdown normal).  May I know if you are also getting the
  memory leak in the same situations ?  Also, if you are setting the above
  event, can you please tell if it helps you ?

  Thanks,
  Rukmani.
  (mani@tc4hq.cmc.stph.net)