Originally posted by hacketta1

SELECT pool, name, bytes / (1024*1024) FROM V$SGASTAT WHERE name = 'free memory'

I have check for the shared pool and it show about 50 - 100 meg free space which is OK. I am trying to find the right buffer cache size. Currently it is set to 6.4 G.

Also I am seeing a lot of inactive oracle processes but each one of them is using up around 7 meg memory. Guess that's how siebel is set up. Since there are about 1000 process(may be 200 of them inactive) uses a total of 7 G memory.