SQL> @pga/details.sql 774

       SID SPID                     TOTAL_ALLOCATED PID       SERIAL# CATEGORY         ALLOCATED       USED MAX_ALLOCATED
---------- ------------------------ --------------- ------ ---------- --------------- ---------- ---------- -------------
       774 5116                          3642606990 162            19 SQL             3411314896 2698366168    3411314896
       774 5116                          3642606990 162            19 Other            230992014                230992014
       774 5116                          3642606990 162            19 PL/SQL              300080     284144        341264
PID = 162
Statement processed.
Statement processed.

       PID    SERIAL# CATEGORY        NAME                       HEAP_NAME            BYTES ALLOCATION_COUNT HEAP_DESCRIPTOR  PARENT_HEAP_DESC     CON_ID
---------- ---------- --------------- -------------------------- --------------- ---------- ---------------- ---------------- ---------------- ----------
       162         19 SQL             dredrow                    kxs-heap-w      2758480896          2498624 000000005D0B0550 000000005803DE70          0
       162         19 SQL             free memory                kxs-heap-w       639634928           832864 000000005D0B0550 000000005803DE70          0
       162         19 Other           free memory                session heap     203963280            55627 000000005803DE70 0000000029C02F20          0
       162         19 Other           kxsFrame4kPage             session heap        851176              205 000000005803DE70 0000000029C02F20          0
       162         19 Other           permanent memory           pga heap            337352               35 0000000029BFCD60 00                        0
       162         19 Other           kxsFrame32kPage            session heap        229768                7 000000005803DE70 0000000029C02F20          0