Re: Oracle/Windows question

On 8/9/05, Sweetser, Joe <Joe.Sweetser@xxxxxxxxxxxxxxx> wrote:
> Oracle 9.2.0.4.0
> Windows 2000 SP4
> 3gb memory
> 
> The database is about 100gb.  I seem to be having a problem with system
> resources that is causing new connections to the database to not happen
> during peak times.  Last time this occurred, I increased the processes
> parameter (from 300 to 400) and this alleviated the problem at the time.
> But now it happened again.  I just restarted the database and all is
> well for the time being, but I want to figure out what's happening.
> 
> There are no errors in the alert log.  The listener.log shows repeated
> entries similar to this (I substituted actual names with <>'s):
> 
> 09-AUG-2005 11:06:56 * (CONNECT_DATA=
>   (SERVICE_NAME=<TNS service name>)
>   (CID=(PROGRAM=C:\Temp\<xxxxxx>\1df\PCXWIN.EXE)
>   (HOST=<source-hostname>)(USER=<username>)))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=<IP address>)(PORT=2948))
> * establish * <TNS service name> * 12500
> TNS-12500: TNS:listener failed to start a dedicated server process
>  TNS-12540: TNS:internal limit restriction exceeded
>   TNS-12560: TNS:protocol adapter error
>    TNS-00510: Internal limit restriction exceeded
>     32-bit Windows Error: 8: Exec format error
> 
> Metalink research for the TNS 510 error (Note:171636.1) indicates there
> is a system resource issue.  My problem is that I'm pretty green on
> Windows ("unix weenie, am I" -Yoda) and don't know where to look to see
> what's being used up.  Task manager doesn't show any constraints with
> memory or CPU.
> 
> Any/all suggestions/hints/ideas are welcome.
> 
> Thanks,
> -joe

Joe,

Try using the pstools suite from sysinternals.
This will show the virtual memory allocated:

C:\> pslist -m oracle

That is what you are up against for a process limit, not the
"committed" memory that appears in task manager.

hth.

Paul

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: