RE: Infamous 4031 error on 817

<FONT face=Arial

size=2>Satish,
Bug 1397603 causes
ORACLE to leak about 4k of memory for every 100 connections, so if you have lots of connections, you end up getting an ORA-4031.  There is a patch for it, or a workaround is to set _db_handles_cached = 0.  Both the patch and the workaround have worked for us.
<FONT face=Arial

size=2>Gary
<FONT face=Arial

size=2> 
Gary
Kirsh
Next Extent,
Inc
<FONT face=Arial

size=2> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Satish Iyer   [mailto:Satish.Iyer_at_ci.seattle.wa.us]Sent: Friday, July 13, 2001   3:36 PMTo: Multiple recipients of list ORACLE-LSubject:   Infamous 4031 error on 817
  Hi Folks,
  We are currently on 815 and moving on to 817 shortly on AIX 4.3.3. Read a   forum posing on Metalink stating that there are some known bugs related to the   ORA-4031 error on 8.1.7. Now is this limited only to products like sqlldr or a   more generic kind of bug. If yes , is there a patch after 8.1.7.1.0b which   solves this problem.
   
  Thanks
   
   
  Satish IyerDBACCSS Team
684-3016 Received on Fri Jul 13 2001 - 14:56:02 CDT