I’m listing below some of the queries I have created to see various oracle session related memory statistics. Replace all occurrences of XXXXXXXXXXXXXXXX with your database username. Please drop a comment below if these queries are useful for you guys. Query for getting ‘session pga memory’ usage for inactive sessions: select sum(ROUND(s.value/1024)) || ‘ KB’ [...]