cancel
Showing results for 
Search instead for 
Did you mean: 

9i on 11i: memory leaks

pasquale_3
Occasional Contributor

9i on 11i: memory leaks

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
12 REPLIES
Navin Bhat_2
Trusted Contributor

Re: 9i on 11i: memory leaks

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
Occasional Contributor

Re: 9i on 11i: memory leaks

hi

im using glance, chatr im not familiar with
Steven E. Protter
Exalted Contributor

Re: 9i on 11i: memory leaks

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
John Poff
Honored Contributor

Re: 9i on 11i: memory leaks

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
Occasional Contributor

Re: 9i on 11i: memory leaks

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
Trusted Contributor

Re: 9i on 11i: memory leaks

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
Honored Contributor

Re: 9i on 11i: memory leaks

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
Honored Contributor

Re: 9i on 11i: memory leaks

Check note 263791.1 in Metalink about Bugs fixed in the 9.2.0.5 Patch Set...
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: 9i on 11i: memory leaks

Pasquale,

Are you steel with us?
Each and every day is a good day to learn.
R. Allan Hicks
Trusted Contributor

Re: 9i on 11i: memory leaks

We experienced memory leaks on 9i release 1, but the patch that antunes referenced cleared the problem. Our memory leaks were manifested by the system eventually running low on free memory and slowing over time.
"Only he who attempts the absurd is capable of achieving the impossible
pasquale_3
Occasional Contributor

Re: 9i on 11i: memory leaks

hi all

thx for all ur responses the dbas are testing 9205 patch as we speak.

thx again
Eric Antunes
Honored Contributor

Re: 9i on 11i: memory leaks

Hi pasquale,

Any news?
Each and every day is a good day to learn.