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

If this is a UNIX box, each server process will be reported to be around 4-8MB bigger than the entire size of your SGA. This is because each process attaches to the segments.

Try it out, write a little C using "shmat" and see what happens.

Steve

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
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu May 14 1998 - 02:17:31 CDT