9i on 11i: memory leaks

[pasquale_3]

hi

we have a v2200 running 11i. ever since we went to 9i, memory has been a problem. using glance, average oracle process size is about 50mb or more, where it used to be around 7mb.
has anybody else experienced this

thx

[Navin Bhat_2]

How are you seeing observing these values? Through top? or ps or measureware?

Can you give me the chatr outputs of both theversions?

[pasquale_3]

hi

im using glance, chatr im not familiar with

[Steven E. Protter]

The latest major patch set for Oracle available at http://metalink.oracle.com does deal with several significant issues, including memory leaks.

Also, you want to have the latest quarterly 11i patch set installed. That would be March of 2004.

Lastly see that all Oracle OS patches are installed, that list is often updated without notice at metalink.

SEP

[John Poff]

Hi,

Are the user processes gradually increasing the amount of memory used, or are they just using more memory? We upgraded our Oracle Financials to run on 9i a while back, and we found out that the user processes do use a lot more RAM. No memory leaks that we've seen, they just use much more RAM.

JP

[pasquale_3]

thx

the dbas are already checking the patching side. in glance, the processes start off with x amount n stay that way, not so much incremental increase of memory. its amazing
how much more 9i uses

[Navin Bhat_2]

The memory allocation requests in 9i is more that its previous versions. There are ways to cut down this usage but it is not recommended.

[Brian Crabtree]

Pasquale,

One thing to remember is that while 9i will use more process memory, glance and ps will show all memory associated with the process, which includes the text memory block that is shared from the SGA itself. It is not unheard of to see a process with a gig of memory showing in glance due to this process reading in that memory from the SGA because of queries.

I wouldn't worry about memory usage from the process level, but only on the system level.

Thanks,

Brian

[Eric Antunes]

Check note 263791.1 in Metalink about Bugs fixed in the 9.2.0.5 Patch Set...

[Eric Antunes]

Pasquale,

Are you steel with us?