菜单 学习猿地 - LMONKEY

VIP

开通学习猿地VIP

尊享10项VIP特权 持续新增

知识通关挑战

打卡带练!告别无效练习

接私单赚外块

VIP优先接,累计金额超百万

学习猿地私房课免费学

大厂实战课仅对VIP开放

你的一对一导师

每月可免费咨询大牛30次

领取更多软件工程师实用特权

入驻
399
0

【翻译自mos文章】v$undostat视图没有依照每10分钟进行更新,v$undostat仅仅有1行(one rows)

原创
05/13 14:22
阅读数 82551


v$undostat视图没有依照每10分钟进行更新,v$undostat仅仅有1行(one rows)

參考原文:
The V$UNDOSTAT view is not getting updated in every 10 minutes. (Doc ID 1206365.1)

适用于:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.


症状:
The V$UNDOSTAT view is not getting updated every 10 minutes.

SQL> select BEGIN_TIME,END_TIME, UNDOBLKS from v$undostat;

BEGIN_TIME END_TIME UNDOBLKS
-------------------- -------------------- ----------
21-aug-2010 03:48:44 07-sep-2010 11:02:14 75016989

以上查询仅仅返回1行。

变化:
SQL> sho parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_in_memory_undo boolean FALSE
_undo_autotune boolean FALSE     --->注意此行记录。
undo_management string AUTO
undo_retention integer 3600
undo_tablespace string UNDOTBS1

 

The parameter "_undo_autotune" has been set to FALSE.
This has disabled automatic undo tuning.

解决方式:

设置"_undo_autotune" parameter to TRUE:

SQL> alter system set "_undo_autotune"=true;

This disables the standard tracking of UNDO statistics in V$UNDOSTAT.  You can see only the one row of data as noted in this case.

 

发表评论

0/200
399 点赞
0 评论
收藏
为你推荐 换一批