[oracle]檢查目前事件

https://community.oracle.com/thread/358789?start=15&tstart=0

select a.event , a.WAIT_TIME , c.SQL_TEXT , c.PHYSICAL_READ_BYTES / 1024 / 1024 / 1024 "GB_READ" , c.PHYSICAL_WRITE_BYTES / 1024 / 1024 / 1024 "GB_WRITE"

from v$session_wait a , v$session b , v$sql c

where a.SID = $SID

and a.sid = b.sid

and b.SQL_ID = c.SQL_ID;