select * from V$parameter where name like 'processes%'
select count(*) from v$session 達到就會錯誤,
后發現 select count(*) from v$session where username='SYSMAN'
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/，如需转载，请注明出处，否则将追究法律责任。