Shulou(Shulou.com)06/01 Report--

-- View the disk statements that consume the most disk read and write rates

Select *

From (select v.sql_id

V.child_number

V.sql_text

V.elapsed_time

V.cpu_time

V.disk_reads

Rank () over (order by v.disk_reads desc) elapsed_rank

From v$sql v) a

Where elapsed_rank

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.