We have an inhouse oracle 10 based application (largely java). It is the only application using oracle. We see the total PGA allocated increasing day by day whilst the application is running. How can I help the developer identify what processes in the application are using increasing amounts of pga? John