--v$process进程
select * from v$process order by spid;
select pid oracle_pid,
serial# oracle_serial#,
spid server_OS_pid,
program OS_program
from v$process
--v$session会话
select * from v$session
select
machine machine在哪台机器上,
terminal terminal使用什么终端,
osuser osuser操作系统用户是谁, --客户端
program program通过什么客户端程序,
process process操作系统分配给的进程号, --即客户端进程在客户端机器上的进程ID号
logon_time logon_time在什么时间,
username username以什么oracle的帐号登录,
command command执行了什么类型的SQL命令,
sql_hash_value sql_hash_valueSQL语句信息
from v$session
----v$session和v$process
SELECT s.Sid AS "Sid ",
s.Serial# AS "Serial# ",
p.spid AS "ThreadID_os_pid ",
s.OSUser AS "OSUser ",
s.Program AS "Program "
FROM V$Process p, V$session s
WHERE p.addr=s.paddr(+)
ORDER BY s.Sid
--alter system kill session'231,9625 '
v$session和v$process
最新推荐文章于 2022-10-11 15:47:10 发布