問題來至:http://www.itpub.net/555107.html
[@more@]select * from V$parameter where name like 'processes%'
processes=200
select count(*) from v$session 達到就會錯誤,
后發現 select count(*) from v$session where username='SYSMAN'
時高時低,高時會超過100數量,還有sysman兩個job中有EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
刪除一個job,問題還是存在?
today I know all these 'sysman' sessions will be related to the database control,which is configured for this 10g database. As long as the db console is up and running,these sessions will be present. This is required for presenting the performance data in the database control. The agent component of the db console will also collect information about the database metrics,which is seen from Database homepage -> All Metrics in the console page. I stopping the dbconsole for this db,these sessions are cleared.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7232662/viewspace-837659/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7232662/viewspace-837659/