hello,

we have a 3 tier app that seems to consistantly drive up the
ram usage of our oracle.exe process (on winNT)

so generally we get to the point where we can't connect to it and get the ORA-04030 error (the memory never goes down much). i restart the app and the process begins all over.

here's what i really want to do: find out what oracle processes are taking up what memory when the oracle.exe process is maxing out. ie at any point in time, see what is taking up so much memory?

is it clients/server processes, or lgwr or dbwr et... what's killing us?