²é¿´µ±Ç°oracleÖÐÕýÔÚÖ´ÐеÄsqlÓï¾ä£¬´æ´¢¹ý³Ì

1 ÕýÔÚÖ´ÐеÄsql

select a.program, b.spid, c.sql_text,c.SQL_ID
  from v$session a, v$process b, v$sqlarea c
 where a.paddr = b.addr
   and a.sql_hash_value = c.hash_value
   and a.username is not null;

2 ÕýÔÚÖ´ÐеĴ洢¹ý³Ì

select owner,name from v$db_object_cache where type like '%PROCE%' and locks >0 and
 pins >0;