oracle之session会话

1.select * from v$session;

2.备注：v$session 里的session 数不准确， 没有计算recursive call 的session 数, 用下面的来查看

   语句：select 'total session num' as name, count(*) as scount from x$ksuse where bitand(ksspaflg,1) !=0;

   追加：必须以sys用户登录sqlplus,切换用户：conn sys as sysdba.

3.这里有个网址：Recursive Sessions and ORA-00018: maximum number of sessions exceeded.
http://tech.e2sn.com/oracle/oracle-internals-and-architecture/recursive-sessions-and-ora-00018-maximum-number-of-sessions-exceeded.