Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: exp, dbms_stats, RMAN and rollback segments

RE: exp, dbms_stats, RMAN and rollback segments

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Thu, 29 May 2003 10:51:41 -0800
Message-ID: <F001.005A5E8E.20030529105141@fatcity.com>


Steve,
 You may have to dig a little further...  What happened to those table(s) in that schema prior to starting the export? Heavy DML, may be?  

 This could be a case of 'delayed block cleanout'. Export triggered the cleanout and wanted to access the rollback segments.

 If no table data was modified after export started reading that table, then there is no need to read RBS info (except for the DBC case, IMO).


Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: kirtikumar_deshpande_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 May 29 2003 - 13:51:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US