Re: Oracle - Undo questions

From: Powell, Mark <mark.powell2_at_hpe.com>
Date: Thu, 17 Nov 2016 16:37:49 +0000
Message-ID: <DF4PR84MB0204F91149F09D41821A541BCCB10_at_DF4PR84MB0204.NAMPRD84.PROD.OUTLOOK.COM>

Sanjay, I would expect the full error stack to identify where the error occurred but if you do not have access to the actual error message display then check the alert log for both databases. There should be an entry for the ORA-01555 error.

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: Thursday, November 17, 2016 11:25:53 AM To: Oracle-L Freelists
Subject: Oracle - Undo questions

I have a ver big Insert using APPENd hint running on Database A and it is selecting data from Database B using Dblink from multiple Tables with lots of joins/subqueries and inserting several million rows (around 5-10 Mil). It failed few time with ORA-0155 error. 1. Does that mean issue with UNDO on Database A or B? 2. Is there way to troubleshoot and get some sizing estimate for UNDO on Database A or Database B(Based on Point 1) that give some clear picture like quering v$undostat or so if the issue happened today and Undostat have anyway data for few days.

Thanks for the time

Sanjay

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2016 - 17:37:49 CET