如何分析html格式的oracle statspack？

发布于 2024-11-23 16:39:29 字数 276 浏览 3 评论 0原文

我有一个 html 版本的 Oracle Statspack 报告。我试图解释报告上的数据以提取许多不同的值，但我不确定在哪里查看。特别是，我试图找到

对数据库的查询数量、
提交数量、
回滚数量
、写入数据库
的会话数量、
网络流量、
初始数量
、数量增长率。

任何知道如何获取这些数据的人值，因为它们在 html 中不明显？抱歉，我无法分享 html。

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

不必了 2024-11-30 16:39:29

这些信息应该全部位于 Statspack 报告最顶部的负载配置文件部分中。以此示例报告为例

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:             71,177.49              4,528.86
              Logical reads:             38,275.00              2,435.35
              Block changes:                419.22                 26.67
             Physical reads:              6,416.62                408.27
            Physical writes:                123.09                  7.83
                 User calls:              1,448.24                 92.15
                     Parses:                467.38                 29.74
                Hard parses:                  0.41                  0.03
                      Sorts:                475.13                 30.23
                     Logons:                  7.20                  0.46
                   Executes:              2,101.90                133.74
               Transactions:                 15.72

  % Blocks changed per Read:    1.10    Recursive Call %:     68.39
 Rollback per transaction %:    0.10       Rows per Sort:    250.70

执行的是SQL的数量执行的语句。在这种情况下，平均每秒执行 2,101.9 个查询，平均每个事务执行 133.74 个查询。

Transactions 是事务的数量（即提交数量+回滚数量）。在这种情况下，平均每秒有 15.72 个。

Rollback per transaction % 是回滚的事务的百分比。由于只有 0.10% 的事务是回滚，因此 99.9% 的事务是提交。如果您愿意，您可以将该分数与事务总数结合起来，以获得每秒提交数和每秒回滚数。

对于您感兴趣的其他项目，

会话次数对您意味着什么？您可能需要创建的新会话数，这可能是登录值，即平均每秒创建 7.20 个会话。

您对网络流量或等待网络通信所花费的时间感兴趣吗？统计数据

bytes received via SQL*Net from c        166,752,176      114,213.8      7,267.2
bytes sent via SQL*Net to client         282,458,320      193,464.6     12,309.7

告诉您，在快照持续时间内，大约 159 MB 的数据从客户端发送到数据库，同时大约 269 MB 的数据从数据库发送到客户端。

我不知道你所说的“初始体积”或“体积增长率”是什么意思。您测量的体积是多少？您测量的增长率是多少？

That information should all be in the load profile section at the very top of the Statspack report. Taking this sample report as an example

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:             71,177.49              4,528.86
              Logical reads:             38,275.00              2,435.35
              Block changes:                419.22                 26.67
             Physical reads:              6,416.62                408.27
            Physical writes:                123.09                  7.83
                 User calls:              1,448.24                 92.15
                     Parses:                467.38                 29.74
                Hard parses:                  0.41                  0.03
                      Sorts:                475.13                 30.23
                     Logons:                  7.20                  0.46
                   Executes:              2,101.90                133.74
               Transactions:                 15.72

  % Blocks changed per Read:    1.10    Recursive Call %:     68.39
 Rollback per transaction %:    0.10       Rows per Sort:    250.70

Executes is the number of SQL statements that are executed. In this case, 2,101.9 queries were executed on average per second and 133.74 were executed on average per transaction.

Transactions is the number of transactions (i.e. the number of commits + the number of rollbacks). In this case, there were on average 15.72 per second.

Rollback per transaction % is the percentage of transactions that were rollbacks. Since just 0.10% of the transactions were rollbacks, 99.9% of the transactions were commits. You could combine the that fraction with the total number of transactions to get the number of commits per second and the number of rollbacks per second if you so desired.

For the additional items you're interested in

What does the number of sessions mean to you? Potentially, you want the number of new sessions that are created which would probably be the Logons value, i.e. an average of 7.20 sessions were created every second.

Are you interested in the volume of network traffic or in the amount of time spent waiting on network communication? Statistics like

bytes received via SQL*Net from c        166,752,176      114,213.8      7,267.2
bytes sent via SQL*Net to client         282,458,320      193,464.6     12,309.7

tell you that roughly 159 MB of data was sent to the database from the clients over the duration of the snapshot while roughly 269 MB of data was sent to the clients from the database.

I don't know what you mean by "initial volume" or "volume increase rate". What volume are you measuring? What rate of increase are you measuring?

回复收藏 0 原文

~没有更多了~