That was the sqlnet.ora on the client. And btw, our system was Oracle 11.2.0.3 on Windows 2008 R2, too. Regards Ingrid On 25.09.2013 21:16, David Ramírez Reyes wrote: > Where did you configure that?, on the client or the listener? > > David Ramírez Reyes > Profesión: Padre de Familia > > > > On 25 September 2013 14:01, Ingrid Voigt <GiantPanda@xxxxxxx > <mailto:GiantPanda@xxxxxxx>> wrote: > > Hi, > > I have seen the exact same symptoms when an older client (Forms 6i) > was trying to connect with SQLNET.AUTHENTICATION_SERVICES > set to (NTS). Every attempted connection blocked a CPU core. > The problem went away when using (NONE). > > (We never did proper troubleshooting to find the underlying cause, > just compared with a working client.) > > > Best regards > Ingrid Voigt > > > > > On 25.09.2013 20:07, David Ramírez Reyes wrote: > > Hi All, > I have an Oracle 11g R2 over a windows server 2008 (am the first > of hating > Windows, but that's what I have...); it has 10 GB of SGA, 500 > process limit > -400 processes avg-, db on archive mode. > > The server has 16 GB of physical memory and 8 cpu cores. > > Now the problem is this: > > On the last days, the cpu usage has been growing up about every > 12-16 > hours, it starts at 8-10 avg, then goes to 28-35, then 65-75, > 90-95 and > then 100 pick, once it goes to 100% the db hungs (and the > server itself > hungs) and there's no other solution than restart the instance. > > that the heavy load of cpu usage is on 6 processes which are the > following: > > SYSTEM 190 ORACLE.EXE (SHAD) > SYSTEM 25 ORACLE.EXE (SHAD) > SYSTEM 5 ORACLE.EXE (SHAD) > SYSTEM 211 ORACLE.EXE (SHAD) > SYSTEM 167 ORACLE.EXE (SHAD) > SYSTEM 2 ORACLE.EXE (SHAD) (cut a bit to avoid overquoting) . -- //www.freelists.org/webpage/oracle-l