Re: tag 'Thre' poolmon

Problem found!

Oracle Release 10.2.0.1.0 is the memory leaker!
The next Release will have the problem solved or a downgrade is needed.

I hope this post helped.

Regards,
Ricardo Marques

On Oct 20, 12:35 pm, ric...@xxxxxxxxx wrote:
Hi again,

I have been tracing my .NET and C windows services and I found nothing.
but there is one particulary... some services calls (via command
prompt) the SQL Loader of oracle 10G.

I notice that each time I called the SQL Loader the 'Thre'tag
increased.
I have manually call SQL loader, with some data files, a dosen times
and the 'Thre'tagstill increases.

I have other servers with Oracle 9G in windows 2003 and this problem
does NOT happen.
I think Oracle 10G or the sql loader is The bug!

I will carry on my "Yet another day in the life of a memory leak
hunter" and post my investigations!

Regards,
Ricardo Marques

ric...@xxxxxxxxx wrote:
Hello,

after searching for 3 days and trying to solve the problem from what I
have read, I still did not found the solution for my server.

The IIS 6 on my windows server 2003, after 15 days refuses connections
and I have to reboot the server. Checkingpoolmon, the 'Thre'tagis
the responsible, keeps growing until there is no more memory available.

Memory: 3931640K Avail: 2079024K PageFlts:212081 InRam Krnl: 2476K
P:66856K
Commit:1950980K Limit:5355120K Peak:2003080K Pool N:36408K
P:67940K
System pool information
Tag Type Allocs Frees Diff Bytes
Per Alloc

MmSt Paged 3460051 ( 444) 3447653 ( 435) 12398 11728424 (
9288) 945
UlHT Paged 1 ( 0) 0 ( 0) 1 8392704 ( 0)
8392704
ThreNonp 5346516 ( 533) 5333274 ( 531) 13242 8263008 ( 1248)
624
NAI0 Nonp 148990990 (11902) 148986633 (11902) 4357 5264808 (
0) 1208
NtfF Paged 10116 ( 1) 6656 ( 2) 3460 3238560 ( -936)
936
LSwi Nonp 1 ( 0) 0 ( 0) 1 2584576 ( 0)
2584576
Gh35 Paged 276551 ( 273) 276115 ( 273) 436 2418344 ( 0)
5546

*I have reboot the server today so the 'Thre'taghas a low value.

I have some .NET services running on the server. If I stop them the
'Thre'tagstops growing.
I upgrade my server recently, it was windows server 2000 with IIS 5 and
this problem did not happen.

Checking the threads, memory, handles, objects and classes loaded of
each .NET service everything seems OK, all values are stable during
days (I used process explorer and some profile tools). The version of
the .NET platform is 1.1.

Is the .NET platform of server 2000 diferent from server 2003?
Maybe some other 3rd app affect my .NET services?

I stop the AV which is Mcafee 8.0 and the 'Thre'tagseems to slow down
a bit.

Some help would be great.

Thanks in advance.
Regards,
Ricardo Marques

.

Relevant Pages

  • [HPADM] Summary: vmunix: file: table is full & oracle client ORA-12500: TNS:listener failed
    ... Oracle, we never have this issue as the settings closely ... NFILE should be changed to 5000, ... 4Gb memory and he ever encounter a case on this server that if these are ...
    (HP-UX-Admin)
  • Re: Oracle 10g on Windows 2003 x64 Memory Useage
    ... We are running Oracle 10g on a Quad Dual Core Windows 2003 x64 ... Enterprise Server with 16GB of memory. ... I notice that the Oracle ...
    (comp.databases.oracle.server)
  • 64-bit: Memory issue with Oracle Provider for OLE DB
    ... When executing "SELECT INTO" queries from linked Oracle servers using the ... Is there a OLE DB Provider for Windows 2003 ... Datacentre Server 64-bit ia64? ... Is there a fix for the memory leak on the ...
    (microsoft.public.data.oledb)
  • Re: Suggestions on how to efficiently search a large table
    ... loaded from a comma delimited file exported from a SQL Server ... Oracle b*tree indexes do not index null values. ... aren't running at the same time in order to minimize response time. ... is bulk processing being used if sql loader is not being used? ...
    (comp.databases.oracle.server)
  • Re: Oracle on AIX/Power5 LPARs
    ... > running AIX with our Oracle application server and database server ... > installations running in AIX logical partitions (LPARs) on the same ... Dynamic allocation of CPU and memory is easy and works well. ...
    (comp.databases.oracle.server)