Re: Oracle/Windows question

On 8/9/05, Sweetser, Joe <Joe.Sweetser_at_i-structure.com> 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