今天收到系统ALERT REPORT报某个数据库有INDEX STATUS 为UNUSABLE.
马上登陆数据库从DBA_INDEXES查询相关索引状态.结果发现那几个INDEX的STATUS为N/A,以前从来没有碰到过
这个.到METALINK 上搜了一把,找到了解释.记录一下,方便自己查询.
Subject: WHY IS STATUS COLUMN OF DBA_INDEXES, USER_INDEXES, ALL_INDEXES = N/A
Doc ID: Note:1039614.6 Type: BULLETIN
Last Revision Date: 12-APR-2001 Status: PUBLISHED
Why is the Status Column of DBA_INDEXES, USER_INDEXES or ALL_INDEXES = ‘N/A’? More…
Starting in Oracle9i, rollback segments are re-named undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued, at which point it was made available for overlaying.
Best of all, automatic undo management allows the DBA to specify how long undo information should be retained after commit, preventing “snapshot too old” errors on long running queries.
Loading...
今天收到系统ALERT REPORT报某个数据库有INDEX STATUS 为UNUSABLE.
马上登陆数据库从DBA_INDEXES查询相关索引状态.结果发现那几个INDEX的STATUS为N/A,以前从来没有碰到过
这个.到METALINK 上搜了一把,找到了解释.记录一下,方便自己查询.
Subject: WHY IS STATUS COLUMN OF DBA_INDEXES, USER_INDEXES, ALL_INDEXES = N/A
Doc ID: Note:1039614.6 Type: BULLETIN
Last Revision Date: 12-APR-2001 Status: PUBLISHED
Why is the Status Column of DBA_INDEXES, USER_INDEXES or ALL_INDEXES = ‘N/A’?
More…
Popularity: 26% [?]
From:http://www.akadia.com/services/ora_optimize_undo.html
Overview
Starting in Oracle9i, rollback segments are re-named undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued, at which point it was made available for overlaying.
Best of all, automatic undo management allows the DBA to specify how long undo information should be retained after commit, preventing “snapshot too old” errors on long running queries.
Popularity: 19% [?]
大学时候看的一部很喜欢的经典影片。放在这里测试一下我新装的多媒体播放插件：Anarchy_media
[kml_flashembed movie="http://player.youku.com/player.php/sid/XMTE2MzMxOTI=/v.swf" width="250" height="250" wmode="transparent" /]想看全部内容，自己到Youku去吧。：）Popularity: 19% [?]
Oracle Database Clone Refresh ->BCP(Business Continuance Process)->BCV(Business Continuance Volume)->EMC Timefinder->EMC Storage Technology
在工作中很多简写的专业词汇不知道是什么意思，今天想到BCP。经过一番GOOGLE，就出现了以上的Trace.唉！要学的东西还真多。努力吧！Let me start from here.
Popularity: 17% [?]
很早就想拥有一个自己的域名，一个自己的个人博客网站。那个很早其实已经有近两年了，说起来还真是有点惭愧。
这次看到NinGoo.net的空间合租广告，终于出手了。买了NinGoo 的DreamHost合租空间。说起来这也是大大前天(2008/02/23)的事情，我是先找到空间然后才买了域名的，经过NinGoo的推荐，我从GoDaddy上买了域名，招行的信用卡直接刷，花了20.38刀，很方便，而且感觉域名直接就生效了。遗憾的是没有找一找优惠方法，我是买了后才在网上看到优惠购买方法的。其实开始我先找到的Yahoo的Small Business，打算从那里买域名，没想到在买的过程中网页死活打不开，可能是Yahoo的服务器Down了?哈哈，Yahoo错失我这一笔小生意了。
一切准备就绪就装了Wordpress2.3.3,因为以前在Linux虚拟机上装过这个东西，所以很顺利就装上了。接下来就是要选一个好的主题进行修改和安装一些有用的插件。这个任务对我来说有点艰巨，本人不懂PHP,对网页制作也是一无所知，今天装了几个插件，image-headlines、pinyin-slug、fckeditor_for_wordpress，暂时只有pinyin-slug能用，不过慢慢来吧。HoHo.
最后，感谢NinGoo物美价廉的空间以及友情帮助。
不早了，要睡觉了，祝我的Ring做个好梦吧！开心点！
Popularity: 19% [?]