oracle Ó¦ÓóÌÐòÐÔÄÜ·ÖÎö

²é¿´sessionµÈ´ýʼþ£º
        select sid,event from v$session_wait where event not like 'rdbms%' and event not like 'SQL*Net message%';
°´pid²é¿´ÕýÔÚÖ´ÐеijÌÐò£º
        select sid,program from v$session b where paddr in (select addr from v$process where spid=&pid);
°´pid²é¿´ÕýÔÚÖ´ÐеÄsqlÓï¾ä
        select sql_text from v$sqltext where hash_value in (select sql_hash_value from v$session where  
        PADDR in (select addr from v"$process where spid=$pid)) order by piece;