v$event_histogram柱状图分析

最新推荐文章于 2025-02-12 08:01:26 发布

原创最新推荐文章于 2025-02-12 08:01:26 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql

ORACLE 专栏收录该内容

23 篇文章

订阅专栏

通过SQL查询v$event_histogram，获取了'latch: shared pool'事件的等待时间分布，显示等待时间从1毫秒到512毫秒的情况，详细列出了各等待时间对应的等待次数。

select event,wait_time_milli,wait_count from v$event_histogram where event = 'latch: shared pool';

SQL> /

EVENT                     WAIT_TIME_MILLI WAIT_COUNT
------------------------- --------------- ----------
latch: shared pool                      1     279009
latch: shared pool                      2      27979
latch: shared pool                      4      16220
latch: shared pool                      8       8848
latch: shared pool                     16       6704
latch: shared pool                     32       7977
latch: shared pool                     64       2158
latch: shared pool                    128        573
latch: shared pool                    256         76
latch: shared pool                    512         18

10 rows selected.