Re: Trying to understand PGA usage (20GB) for ONE process/session

  • From: Andy Klock <andy@xxxxxxxxxxxxxxx>
  • To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
  • Date: Mon, 13 Nov 2017 12:35:26 -0500

On Mon, Nov 13, 2017 at 12:23 PM, Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:


How can I have a session with 25GB of pga memory allocated?  Just trying
to understand how one session can chew up so much.


You can dig a little deeper in v$sql_workarea_active

See Tanel's writeup for more details :
http://blog.tanelpoder.com/2014/03/26/oracle-memory-troubleshooting-part-4-drilling-down-into-pga-memory-usage-with-vprocess_memory_detail/


Andy K

Other related posts: