I have a large database which has many applications that connects to it.
These applications are forms/reports 10g applications that connect to the database. I want to sum up the amount of memory each application uses.
Each user has a role assigned to them so I can probably the dba_role_privs to determine the application .

Could someone pls tell me which table can I use to determine the amount of memory used for each user/server process for each application ?