dba_rollback_segs will tell you the status of the rollback segment,
including whether or not it's deferred
- WinterSun Zhao <wintersun_zhao_at_21cn.com> wrote:
> Hi, DBAs:
> From Oracle Online Manual:
> " When a tablespace goes offline so that transactions cannot be
> rolled back immediately, Oracle writes to a deferred rollback
> segment. The deferred rollback segment contains the rollback entries
> that could not be applied to the tablespace, so that they can be
> applied when the tablespace comes back online. These segments
> disappear as soon as the tablespace is brought back online and
> recovered. Oracle automatically creates deferred rollback segments in
> the SYSTEM tablespace. "
> How can I find out the "deferred rollback segments", which
> dictionary view needed to be queried?
> I execute a query, insert some datas into the table, and not
> commited it, then I offline the tablespace with immediate option.
> Then I issued "rollback", it rolled back immediate although the
> tablespace is offline. I know it has been rolled back with "Diferred
> Rollback Segments", But where can I find it?
> Thank you for your help.
>
> WinterSun Zhao
>
>
>
> ------------------------------------------------
> 21CN网络产品诚征代理
> http://agent.21cn.com
> 想免受广告信的骚扰，请马上升级为21CN经济邮用户。
>
http://news.21cn.com/cgibin/urlhit2-mcounter.php3?url=http://member.21cn.com/economy/upgrade.php&rd=1
> 不看是你的错，不再看是我的错。
> http://adinfo.21cn.com
>
>
>
> ------------------------------------------------
> 21CN网络产品诚征代理
> http://agent.21cn.com
> 想免受广告信的骚扰，请马上升级为21CN经济邮用户。
>
http://news.21cn.com/cgibin/urlhit2-mcounter.php3?url=http://member.21cn.com/economy/upgrade.php&rd=1
> 不看是你的错，不再看是我的错。
> http://adinfo.21cn.com
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: WinterSun Zha
> INET: wintersun_zhao_at_21cn.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 18 2001 - 08:29:17 CDT
