或者，您可以生成一个 自动工作负载存储库 (AWR ) 或 Statspack报告变更前后。 AWR 报告需要与我在上一段中讨论的相同的性能和调整包许可证。 Statspack 报告将包含与 AWR 报告中的大部分相同信息，尽管它有点旧并且确实需要一些努力来设置。
You linked to a report that provides information about the performance of a single SQL statement. That doesn't seem to fit with the rest of your question. If you are making changes to the application and monitoring the effect in the database, that would normally imply that you are changing the SQL statement in some way. You might be reducing the number of times that a SQL statement is called, in which case you wouldn't want nearly that level of detail about the performance of the SQL statement-- you'd just want to count the number of times it was executed and potentially a handful of statistics about the SQL statement.
Assuming that what you are really interested in is the performance of the database as a whole and assuming that you have the enterprise edition of the database with the Performance and Tuning Pack (which would be required to produce the report you linked to), you probably want to use the Enterprise Manager Database Control which is a web-based application for managing the Oracle database. Within Enterprise Manager, there are a number of real-time performance graphs. You can also invoke the Automatic Database Diagnostic Monitor (ADDM) within Enterprise Manager to monitor performance before and after the changes are made.
Alternately, you could generate an Automatic Workload Repository (AWR) or Statspack report before and after the changes. An AWR report would require the same Performance and Tuning Pack license that I was discussing in the prior paragraph. A Statspack report would have much of the same information that would be on the AWR report though it is a little older and does require a bit of effort to set up.
发布评论
评论（1）
您链接到一个报告，该报告提供有关单个 SQL 语句的性能的信息。这似乎与你的问题的其余部分不符。如果您正在对应用程序进行更改并监视数据库中的效果，这通常意味着您正在以某种方式更改 SQL 语句。您可能会减少调用 SQL 语句的次数，在这种情况下，您不需要 SQL 语句性能的详细信息 — 您只想计算它被调用的次数。已执行的信息以及可能有关 SQL 语句的一些统计信息。
假设您真正感兴趣的是数据库的整体性能，并且假设您拥有带有性能和调优包的数据库企业版（生成您链接到的报告时需要它），您可能想要使用 Enterprise Manager Database Control，它是一个基于 Web 的应用程序，用于管理 Oracle 数据库。在企业管理器中，有许多实时性能图表。您还可以调用自动数据库诊断监视器 (ADDM ) 在企业管理器中监控更改前后的性能。
或者，您可以生成一个 自动工作负载存储库 (AWR ) 或 Statspack报告变更前后。 AWR 报告需要与我在上一段中讨论的相同的性能和调整包许可证。 Statspack 报告将包含与 AWR 报告中的大部分相同信息，尽管它有点旧并且确实需要一些努力来设置。
You linked to a report that provides information about the performance of a single SQL statement. That doesn't seem to fit with the rest of your question. If you are making changes to the application and monitoring the effect in the database, that would normally imply that you are changing the SQL statement in some way. You might be reducing the number of times that a SQL statement is called, in which case you wouldn't want nearly that level of detail about the performance of the SQL statement-- you'd just want to count the number of times it was executed and potentially a handful of statistics about the SQL statement.
Assuming that what you are really interested in is the performance of the database as a whole and assuming that you have the enterprise edition of the database with the Performance and Tuning Pack (which would be required to produce the report you linked to), you probably want to use the Enterprise Manager Database Control which is a web-based application for managing the Oracle database. Within Enterprise Manager, there are a number of real-time performance graphs. You can also invoke the Automatic Database Diagnostic Monitor (ADDM) within Enterprise Manager to monitor performance before and after the changes are made.
Alternately, you could generate an Automatic Workload Repository (AWR) or Statspack report before and after the changes. An AWR report would require the same Performance and Tuning Pack license that I was discussing in the prior paragraph. A Statspack report would have much of the same information that would be on the AWR report though it is a little older and does require a bit of effort to set up.