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

1. problem description

Generate database AWR report: August 22, 10:00 to 18:00, TOP1 SQL: 3g5996z6awjux, run times: 217677 times, execution time of each time: 7.38 seconds, total database resources (elapsed time): 43.22%.

2. problem analysis

SQL statement:

bind variable gets from v$sql_bind_capture

4. Summary Via Access Path Optimization: Execution time before optimization: 614 seconds, after optimization: 83 seconds.

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.