Re: Oracle - Undo questions

Mark
Sorry my mistake and error was ORA-01555 as that is why mentioned to get help on UNDO details. There was no error reported in Database B for this error but App team running the query reported the error. So that is why looking to see if this has to increase the size on UNDO in Database B or Database A.  Database A is the place where data is inserted Database B is the place from where query initiated from Database A using Database link is reading the data. RgdsSanjay

    On Thursday, November 17, 2016 11:38 AM, "Powell, Mark" <mark.powell2_at_hpe.com> wrote:  

 #yiv1127899845 #yiv1127899845 -- P {margin-top:0;margin-bottom:0;}#yiv1127899845 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