原帖由 microsoft_fly 于 2007-12-21 14:07 发表
select count(*) from v$session看下总的会话数
这个结果是58。。
具体如下:
STATUS SCHEMANAME OSUSER PROGRAM
INACTIVE SDE NT AUTHORITY\SYSTEM gsrvr.exe
INACTIVE SDE NT AUTHORITY\SYSTEM gsrvr.exe
INACTIVE SDE NT AUTHORITY\SYSTEM gsrvr.exe
INACTIVE SDE NT AUTHORITY\SYSTEM gsrvr.exe
INACTIVE SDE NT AUTHORITY\SYSTEM gsrvr.exe
INACTIVE SDE NT AUTHORITY\SYSTEM gsrvr.exe
INACTIVE SDE NT AUTHORITY\SYSTEM gsrvr.exe
INACTIVE SDE NT AUTHORITY\SYSTEM giomgr.exe
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA X3850A\Administrator Spline.exe
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Thin Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA work plsqldev.exe
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
ACTIVE SZDBA work plsqldev.exe
INACTIVE SZDBA Administrator JDBC Connect Client
INACTIVE SZDBA Administrator JDBC Connect Client
ACTIVE SYS
ACTIVE SYS
ACTIVE SYS
ACTIVE SYS SYSTEM ORACLE.EXE (q001)
ACTIVE SYS SYSTEM ORACLE.EXE (q009)
ACTIVE SYS SYSTEM ORACLE.EXE (q007)
ACTIVE SYS
ACTIVE SYS SYSTEM ORACLE.EXE (q003)
ACTIVE SYS SYSTEM ORACLE.EXE (q002)
ACTIVE SYS SYSTEM ORACLE.EXE (q000)
ACTIVE SYS SYSTEM ORACLE.EXE (q004)
ACTIVE SYS SYSTEM ORACLE.EXE (q008)
ACTIVE SYS
ACTIVE SYS
ACTIVE SYS SYSTEM ORACLE.EXE (q005)
ACTIVE SYS
ACTIVE SYS SYSTEM ORACLE.EXE (MMNL)
ACTIVE SYS SYSTEM ORACLE.EXE (QMNC)
ACTIVE SYS SYSTEM ORACLE.EXE (CJQ0)
ACTIVE SYS SYSTEM ORACLE.EXE (RECO)
ACTIVE SYS SYSTEM ORACLE.EXE (SMON)
ACTIVE SYS SYSTEM ORACLE.EXE (CKPT)
ACTIVE SYS SYSTEM ORACLE.EXE (LGWR)
ACTIVE SYS SYSTEM ORACLE.EXE (q006)
ACTIVE SYS SYSTEM ORACLE.EXE (DBW0)
ACTIVE SYS SYSTEM ORACLE.EXE (MMON)
ACTIVE SYS SYSTEM ORACLE.EXE (MMAN)
ACTIVE SYS SYSTEM ORACLE.EXE (PMON)