Oracle数据库在负载测试期间收集指标(Oracle Database gather metrics during load test)

Oracle数据库在负载测试期间收集指标(Oracle Database gather metrics during load test)

我负载测试一个Web应用程序，并想知道是否有一种方法可以在负载测试期间获得我的Oracle数据库的健康状况。 任何想法或文章链接表示赞赏。

提前致谢

I am load testing a web application and wondering if there is a way I can get the health of the my oracle database during the load test. Any idea or links to articles is appreciated.

Thanks in advance

最满意答案

根据Oracle版本的不同，您是否被授权使用AWR（自动工作量资料档案库），或者是否安装了Statspack，第一次传递将是在测试之前和之后拍摄快照并运行AWR或Statspack报告。 这会告诉你系统在等待什么，已用时间是由于数据库等待，顶级SQL语句等原因造成的。

针对您的Oracle版本的性能和调优指南应该有一两章关于使用AWR或Statspack的内容。 例如，在10.2中，有关于管理AWR中的快照和生成AWR报告的章节

Depending on the Oracle version, whether you are licensed to use the AWR (Automatic Workload Repository), or whether you have Statspack installed, a first pass would be to take a snapshot before and after your test and run an AWR or Statspack report. That will show you what the system was waiting on, how much of the elapsed time was due to database waits, top SQL statements, etc.

The Performance and Tuning Guide for your version of Oracle should have a chapter or two on using either AWR or Statspack. For example, in 10.2, there is a section on managing snapshots in the AWR and on generating AWR reports