SQL調整

--下面是查找Oracle那句SQL語法執行比較慢

SELECT * FROM

(

SELECT PARSING_USER_ID

EXECUTIONS,

SORTS,

COMMAND_TYPE,

DISK_READS,

sql_text

FROM v$sqlarea

ORDER BY disk_reads DESC

)

WHERE ROWNUM<10 ;

--下面是查找那句SQL語法執行時佔CPU比較高

SELECT a.username, a.machine, a.program, a.sid, b.spid, a.serial#, a.status,

c.piece, c.sql_text

FROM v$session a, v$process b, v$sqltext c

WHERE  b.addr = a.paddr

AND a.sql_address = c.address(+)

AND b.spid ='27999'  -- TOP PID

ORDER BY c.piece;