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.
查看SGA是否出现抖动
最新推荐文章于 2021-04-08 22:40:40 发布