QNMn process memory leak현상

사이트에서 발생했던 현상.
오라클 버젼은 9.2.0.1

SQL> r
  1  select spid, program, trunc(pga_used_mem/1024/1024) USED,
  2  trunc(pga_alloc_mem/1024/1024) ALLOC , trunc(pga_max_mem/1024/1024) MAX
  3  from v$process
  4* order by pga_alloc_mem asc

SPID         PROGRAM                                         USED       ALLOC         MAX
------------ ---------------------------------------- ----------- ----------- -----------
             PSEUDO                                           .00         .00         .00
-------------------중략-----------------------------------------------------------------
847          oracle@xxxx.kr (QMN0)                  256.00      256.00      256.00

49 rows selected.

SQL> alter system set aq_tm_processes=0;
System altered.

SQL> alter system set aq_tm_processes=1;
System altered.

SQL> r
  1  select spid, program, trunc(pga_used_mem/1024/1024) USED,
  2  trunc(pga_alloc_mem/1024/1024) ALLOC , trunc(pga_max_mem/1024/1024) MAX
  3  from v$process
  4* order by pga_alloc_mem asc

SPID         PROGRAM                                         USED       ALLOC         MAX
------------ ---------------------------------------- ----------- ----------- -----------
             PSEUDO                                           .00         .00         .00
-------------------------------------중략-----------------------------------------------
20461        oracle@xxxx.kr (QMN0)                     .00         .00         .00

 

버그였다.. 패치하던지 저 과정을 프로시저로 만들어서 잡으로 돌리던지 하자

관련 메타링크 정보
Queue Monitor process Memory Consumption increases due to a Leak [ID 233101.1]