Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the implementation of AWR TOP SQL". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1 sort by the number of parsing

Select a. Parse, to_char (substr (b.sqltextje 1pr 4000)) from (select dhs.sql_id, sum (parse_calls_delta) parse, sum (executions_delta) exec_nums Dhs.MODULE from dba_hist_sqlstat dhs where snap_id > 22438 and snap_id 22438 and snap_id

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.