Re: PGA increasing continuously

Have you checked V$PROCESS_MEMORY? Here is the description:

SQL> desc v$process_memory

  Name                                      Null?    Type
  ----------------------------------------- -------- ----------------------------
  PID                                                NUMBER
  SERIAL#                                            NUMBER
  CATEGORY                                           VARCHAR2(15)
  ALLOCATED                                          NUMBER
  USED                                               NUMBER
  MAX_ALLOCATED                                      NUMBER
  CON_ID                                             NUMBER

SQL> You can find out which process allocated the most memory. There are some more details in V$PROCESS_MEMORY_DETAIL:

SQL> desc v$process_memory_detail

  Name                                      Null?    Type
  ----------------------------------------- -------- ----------------------------
  PID                                                NUMBER
  SERIAL#                                            NUMBER
  CATEGORY                                           VARCHAR2(15)
  NAME                                               VARCHAR2(26)
  HEAP_NAME                                          VARCHAR2(15)
  BYTES                                              NUMBER
  ALLOCATION_COUNT                                   NUMBER
  HEAP_DESCRIPTOR                                    RAW(8)
  PARENT_HEAP_DESCRIPTOR                             RAW(8)
  CON_ID                                             NUMBER

This can give you valuable information about the processes which have allocated memory. You can also dump PGA for the process and drill down to the SQL level.

On 12/4/20 2:57 PM, Purav Chovatia wrote:
> Thanks. We applied the Oct 2020 RU, so I guess it should have got
> included, but checking...

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l