而且这些进程,给定用户登录的时间都是今天的凌晨。
SQL>
SQL> select to_char(b.LOGON_TIME,'yyyy-mm-dd hh:mm:ss'), b.status,b.server,b.username,b.sid,b.machine FROM v$session b WHERE b.paddr = (SELECT addr FROM v$process c WHERE c.spid = 32061);
TO_CHAR(B.LOGON_TIM STATUS SERVERUSERNAME
SID
------------------- -------- --------- ------------------------------ ----------
MACHINE
----------------------------------------------------------------
2012-08-13 05:08:55 ACTIVE DEDICATED GAIBAN
158
bbs-af36f37fbf5
SQL> select to_char(b.LOGON_TIME,'yyyy-mm-dd hh:mm:ss'), b.status,b.server,b.username,b.sid,b.machine FROM v$session b WHERE b.paddr = (SELECT addr FROM v$process c WHERE c.spid = 29687);
TO_CHAR(B.LOGON_TIM STATUS SERVERUSERNAME
SID
------------------- -------- --------- ------------------------------ ----------
MACHINE
----------------------------------------------------------------
2012-08-13 04:08:50 ACTIVE DEDICATED GAIBAN
183
bbs-af36f37fbf5
但是top最前面都是显示他,oracle出问题了?
|