在Oracle中，PMON清理失败进程的频率是多长？

SYS@LHRDB> SELECT a.INDX,
  2         a.KSPPINM NAME,
  3         a.KSPPDESC,
  4         b.KSPPSTVL 
  5  FROM   x$ksppi  a,
  6         x$ksppcv b
  7  WHERE  a.INDX = b.INDX
  8  and lower(a.KSPPINM) like  lower('%&parameter%');
Enter value for parameter: _PKT_PMON_INTERVAL
old   8: and lower(a.KSPPINM) like  lower('%&parameter%')
new   8: and lower(a.KSPPINM) like  lower('%_PKT_PMON_INTERVAL%')

 INDX NAME                   KSPPDESC                             KSPPSTVL
----- ---------------------- ------------------------------------ --------------------
   61 _pkt_pmon_interval     PMON process clean-up interval (cs)  50

SYS@LHRDB > alter system set "_PKT_PMON_INTERVAL"=50;

System altered.

SYS@orclasm > ! oerr ora 10246
10246, 00000, "print trace of PMON actions to trace file"
// *Cause:
// *Action:

SYS@orclasm > SELECT PID, SPID FROM V$PROCESS P WHERE P.PROGRAM LIKE '%PMON%';

       PID SPID
---------- ------------------------
         2 4014

SYS@orclasm > oradebug wakeup 2
Statement processed.
SYS@orclasm > 
复制