查看SGA是否出现抖动

最新推荐文章于 2021-04-08 22:40:40 发布

逝鸿

最新推荐文章于 2021-04-08 22:40:40 发布

阅读量699

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/qq_21127313/article/details/78519925

SQL> select START_TIME,OPER_TYPE from V$SGA_RESIZE_OPS;

START_TIM OPER_TYPE
--------- -------------
13-NOV-17 GROW
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 GROW
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 SHRINK
13-NOV-17 SHRINK
13-NOV-17 INITIALIZING

START_TIM OPER_TYPE
--------- -------------
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 STATIC
13-NOV-17 GROW
13-NOV-17 SHRINK

20 rows selected.