What are the client connections using for memory? Oracle SGA is just
part of the equation. What does the host have for file buffer caching,
etc? Look at ps -ef (or other flags as appropriate) and see what
proceeses are using for memory.

M

>>> "Mark Regensberg "
<oracledba-ezmlmshield-x96234340.[Email address protected] 4/1/2006
4:49:52 PM >>>
Maybe I shouldn't be working this late at night...

Oracle on an IBM x366/ RHEL AS 4 with 16GB of ram... SGA max is set to
8GB, buffer_cache at 6GB with a 2GB variable size.

In my mind, max oracle memory consumption should be 8GB?

However, memory usage is around 15/16GB with the occasional forage
into
swap when I drive the load up. Top gives me oracle as the primary
consumer. Performance is shot to hell on a machine that should be
faster
than a greased brick down a mine shaft.

Xwindows and other usual suspects are off.

What am I missing here?

--markr

--
Mark Regensberg
Technical Manager - Achievement Awards Group
Office: +27 21 700-2300 Mobile: 082 377 4750


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page