Re: Trying to understand PGA usage (20GB) for ONE process/session
From: Andy Klock <andy_at_oracledepot.com>
Date: Mon, 13 Nov 2017 12:35:26 -0500
Message-ID: <CADo_RaO907yg5-T-dSmyTOJikm=yH2zLibMh3rbXk8o6AzZ+yw_at_mail.gmail.com>
Date: Mon, 13 Nov 2017 12:35:26 -0500
Message-ID: <CADo_RaO907yg5-T-dSmyTOJikm=yH2zLibMh3rbXk8o6AzZ+yw_at_mail.gmail.com>
On Mon, Nov 13, 2017 at 12:23 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 13 2017 - 18:35:26 CET