查询Oracle正在执行的SQL语句 | 隔叶黄莺 Yanbin Blog

2009-05-05 | 阅读(620)

支持左连接的 Oracle 9i 以上版本

select OSUSER, PROGRAM, USERNAME, SCHEMANAME, B.Cpu_Time, STATUS, B.SQL_TEXT
  from V$SESSION A
  LEFT JOIN V$SQL B ON A.SQL_ADDRESS = B.ADDRESS
                   AND A.SQL_HASH_VALUE = B.HASH_VALUE
 order by b.cpu_time desc

select OSUSER, PROGRAM, USERNAME, SCHEMANAME, B.Cpu_Time, STATUS, B.SQL_TEXT

from V$SESSION A

LEFT JOIN V$SQL B ON A.SQL_ADDRESS = B.ADDRESS

AND A.SQL_HASH_VALUE = B.HASH_VALUE

order by b.cpu_time desc

Oracle 8i 及以前的版本中

select OSUSER, PROGRAM, USERNAME, SCHEMANAME, STATUS, B.SQL_TEXT
  from V$SESSION A, V$SQL B
 where A.SQL_ADDRESS = B.ADDRESS
   AND A.SQL_HASH_VALUE = B.HASH_VALUE

   --后面可以加上你要的约束条件
   and OSUSER = 'Unmi' AND USERNAME = 'APPS' and PROGRAM = 'JDBC-1.0-Client'

select OSUSER, PROGRAM, USERNAME, SCHEMANAME, STATUS, B.SQL_TEXT

from V$SESSION A, V$SQL B

where A.SQL_ADDRESS = B.ADDRESS

AND A.SQL_HASH_VALUE = B.HASH_VALUE

--后面可以加上你要的约束条件

and OSUSER = 'Unmi' AND USERNAME = 'APPS' and PROGRAM = 'JDBC-1.0-Client'

自行决定要查询出来的字段以及约束条件。

本文链接 https://yanbin.blog/oracle-what-sql-executing/, 来自隔叶黄莺 Yanbin Blog

Polo on 想选一种动态语言＋跨平台界面组件的组合，希望大家给点意见Perl + Tkx
best coffee on SciPy 最优化之最小化I wanted to take a moment to commend you on the outstanding quality of...
seetimee on 体验 Python FastAPI 的并发能力及线, 进程模型感谢
Yanbin on Mockito 3.4.0 开始可 Mock 静态方法有一个补救，新写了一篇 https://yanbin.blog/mockito-mock-static-method-in-multiple...
Yanbin on 升级到 Spring Boot 3 后 javax.inject.Named 不可用怎么，被抄袭了！算是被机器翻译引用的？

M	T	W	T	F	S	S
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30