查看ORACLE哪条SQL占资源最大

break on sid skip 1
set linesize 300
set pagesize 999
column sid format 99999
column sql_text format a100
column machine format a20
column username format a10
column client_info format a15

select a.sid, a.serial#,a.username,a.machine,a.last_call_et ,to_char(logon_time,'yy-mm-dd:hh24:mi'),client_info,b.sql_text
from v$session a,v$sqltext b
where a.username is not null
and   a.status = 'ACTIVE'
and   a.sql_address = b.address and a.username<>'SYSTEM'
order by a.last_call_et,a.sid,b.piece;

阅读更多
上一篇msn messenger8.0 的80048820 错误号修正!
下一篇windows Server 2003更改序列号
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭