home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 325 of 2,288   
   lycovian to All   
   Re: The dreaded TNS-12500 error.   
   04 Sep 03 18:31:34   
   
   From: member38182@dbforums.com   
      
   Had the same problem.  In our case the oracle.exe process was crossing   
   3GB boundry.  Try this, monitor the Virtual Bytes of your application   
   with PERFMON.  Watch the VB count rise as users log in.  You may see   
   that as you cross the 3GB Virtual  Bytes boundry that you get this   
   error.  If that is the case then your user count (~2.7MB/user) is slowly   
   driving you over the max process size that Win2K allows with the /3GB   
   boot.ini switch enabled.  If that is the case recommend a) switching to   
   MTS and b) resizing your SGA such that it fits completely with in the   
   3GB boundry.   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca