Oracle 高CPU SQL查找

先top命令，找到PID，再在SQL界面用管理员权限查询

select sql_text,spid,v$session.program,process from 
v$sqlarea,v$session,v$process
where v$sqlarea.address=v$session.sql_address
and v$sqlarea.hash_value=v$session.sql_hash_value
and v$session.paddr=v$process.addr
and v$process.spid in (16088);