1、测试前添加一个快照点call dbms_workload_repository.create_snapshot();。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d6cde683fb090828381e30fdaa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后开始测试.或者程序运行完。测试完后,再加一个快照点。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c81ffd9040cb23eb13532fa4063?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、打开toad for oracle软件连接oracle数据库。如果连接不上,需要配置系统环境变量,把Oracle的客户端目录配置下。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513d23c6473a336d55fbb3fbd9e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、环境变量配置好的之后,打开小娃【连接】-->【连接参数】自动识别Oracle的.ora文件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0dd7912397dda144ecb34456bcb7d0a20df4869f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后【数据库】-【监视】-【AWR报告】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d68876289940aac27d1ed21b242f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后选择前后的快照点。然后run。最好的选择html文件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6d81800a19d8bc3e302c2d2e8c8ba61ea8d34529?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)