It depends if the process is captured either through workload or top 30.
If it was it would be in the CAXPROCD table, Total_Mem
All the process are captured in UDR. You can using Windows Investigate pre TSCO 11.0 or Web Investigate in TSCO 11.0 to look at SIZE or RSS directly via a sorted drill down or charts.
The issue for me is what drill down or chart?
You would drill down on Process Statistics.
Sort by SIZE or RSS.
Then select the processes of interest and chart the SIZE or RSS as a function of time.