Oracle undo tablespace不断增长并无法回缩

问题:一客户出现 oracle undo tablespace不断增长并无法回缩

解决方法:

1.新建一新的undo tablespace,如:undotbs2

2.alter system set undo_tablespace=undotbs2 scope=both;

3.drop tablespace undotbs1 including contents and datafiles;

但这是事后的解决方法,如何让 oracle 自动管理的undo tablespace自动收缩,如何合理的设置undo tablespace的大小,正在寻找答案中……

  
« libclntsh.so is up to date            Home            MSCS一个节点的Cluster Service无法启动 »

No Comments

Be the first to comment on this entry.

Leave a comment

Name(required)
Mail (will not be published)(required)
Website

Fields in bold are required. Email addresses are never published or distributed.

Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
URLs must be fully qualified (eg: http://www.dbifan.com),and all tags must be properly closed.

Line breaks and paragraphs are automatically converted.

Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.

    搜索本站

    站点日历

    5月 2005
    « 4   6 »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    订阅本站

    文章分类

    最新日志

    热点文章

    日志存档

    常用标签