oracle 应用程序性能分析

查看session等待事件：
        select sid,event from v$session_wait where event not like 'rdbms%' and event not like 'SQL*Net message%';
按pid查看正在执行的程序：
        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;