grep q00
oracle 1464 1462 0 15:27 pts/1 00:00:00 grep q00
oracle 26534 1 0 15:08 ? 00:00:00 ora_q002_jy1
oracle 31538 1 0 15:21 ? 00:00:00 ora_q000_jy1
SQL>
SQL> alter system set aq_tm_processes = 0 scope=both sid='jy1';
System altered.
SQL> create pfile='/tmp/pfile12.ora' from spfile;
File created.
SQL> show parameter aq
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
SQL> !ps -ef(北联网教程,专业提供视频软件下载)
……
