RE: Question About Deferred Rollback Segments

[Steve Adams]

Hi there,

You can see deferred rollback segments in X$KTTVS or in DBA_SEGMENTS.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Thursday, 18 October 2001 16:55
To: Multiple recipients of list ORACLE-L


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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Question About Deferred Rollback Segments

[Rachel Carmichael]

dba_rollback_segs will tell you the status of the rollback segment,
including whether or not it's deferred


--- WinterSun Zhao [EMAIL PROTECTED] 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.phprd=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.phprd=1
 ²»¿´ÊÇÄãµÄ´í£¬²»ÔÙ¿´ÊÇÎÒµÄ´í¡£
 http://adinfo.21cn.com
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: WinterSun Zha
   INET: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).