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: Ganesh Raja <gans_r_at_rediffmail.com>
Date: Thu, 29 May 2003 10:20:14 -0800
Message-ID: <F001.005A5DC3.20030529102014@fatcity.com>


A Large Load or Update Before the Exp ...

Delyed Block Clean out is one Reason that really pops out.

HTH Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474



Live to learn... forget... and learn again.

-----Original Message-----
Sent: Friday, May 30, 2003 12:15 AM
To: Multiple recipients of list ORACLE-L

A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem?

(Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control).

Befuddled in Bozeman,
Walt and Steve
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Orr, Steve
  INET: sorr_at_rightnow.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ganesh Raja
  INET: gans_r_at_rediffmail.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:20:14 CDT

Original text of this message

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