By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
I am looking at installing some new modules in our Oracle 11i ERP environment. Can I get some statistics regarding the memory requirements for each concurrent user?
The V$PROCESS view shows the amount of PGA memory used (PGA_USED_MEM) for each process in the database. You can map this to the session by a query similar to the following:
FROM v$session s, v$process p