oracle学习之-查询热点数据1

--热点1
select t.INST_ID,
t.SID,
t.SERIAL#,
t.SADDR,
t1.SPID,
t.PROGRAM,
t3.EVENT,
t3.P1TEXT,
t3.P1,
t3.P2TEXT,
t3.P2,
t3.P3TEXT,
t3.P3,
t.SQL_ID
/* t2.SQL_TEXT,
t2.SQL_FULLTEXT*/
from gv$session t, gv$process t1, gv$sqlarea t2, gv$session_wait t3
where t.PADDR = t1.ADDR
and t.SQL_ID = t2.SQL_ID(+)
and t.SID = t3.SID
and t3.WAIT_CLASS not in('Idle','Network')
and t.INST_ID=t1.INST_ID
and t.INST_ID=t3.INST_ID
order by 1;