ITPub博客

首页 > 应用开发 > IT综合 > Process m000 started up but failed with error = 20 問題查找

Process m000 started up but failed with error = 20 問題查找

原创 IT综合 作者:Derek-Zeng 时间:2006-05-25 09:56:21 0 删除 编辑

問題來至: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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-09-13

  • 博文量
    12
  • 访问量
    72294