Finding Slow SQL

Once you've identified slow SQL you can start reviewing its execution plan to make it faster.
But... how do you know which SQL statements to tune?!
You need to capture execution stats for the whole process to find the slowest parts. This session shows you how to do this using SQL trace and the PL/SQL profiler.
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
asktom.oracle.com/
Oracle Developers portal: developer.oracle.com/
Sign up for an Oracle Cloud trial: cloud.oracle.com/en_US/tryit

[@kevinzhang8974]

what is the difference between dbms_profiler and dbms_hprof (hirearchy profiler)? Thanks!