Re: Pls Help..Huge Memory Usage on Oracle/Solaris

I had the same problem on Solaris, but it turned out to be just a parameter being set too large in the init<SID>.ora initialisation file. The ones to check are db_block_buffers and shared_pool_size. We had DB_BLOCK_BUFFERS set at something like 20,000 which multiplied by the block size of 8192 hogged approx 163MB of memory!!!

Hope this helps,
Martin

>owheaton_at_my-dejanews.com wrote in message
<6jd4dr$ehl$1_at_nnrp1.dejanews.com>...
>Hi:
>We are running into memory problems running oracle 7.3.3.00 on an
enterprise
>3000 with 4 gigs of main memory..we have several oracle processes(7-8)
>which consisently show us they are using 200-240 megs of memory each!!!
>I have never seen this kind of memory usage on any other configuration..and
>they appear to be simple listener processes...There are approx 5 databases
>on this machine, neither of which are considered large in size..Is there
>a setting screwed up or what has gone wrong..Pls help becasue it's
>starting to affect other processes that are ending due to insufficent
memory!
>
>Any and all help would be greatly appreciated..we have reported this to
Oracle
>and we are not getting any answers...

>Owen
>owheaton_at_appgroup.com
Received on Thu May 14 1998 - 20:05:43 CDT