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('%¶meter%');
Enter value for parameter: _PKT_PMON_INTERVAL
old 8: and lower(a.KSPPINM) like lower('%¶meter%')
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 >