ORA-01555 caused by SQL statement below

Sun Jul 27 15:59:34 2014
ORA-01555 caused by SQL statement below (SQL Id:6cttns598np15, Query duration=1699 sec, scn:0x0001.086b282b):
INSERT into rp_retail001 (ID, ad_client_id, ad_org_id, ownerID, ISACTIVE, Billdate, Docno, Retailbilltype, creater, C_stor e_id, DESCRIPTION, c_vip_id, salesrep_id, m_product_id, m_attributesetinstance_id, QTY, pricelist, Tot_amt_list, Priceactual, Tot_amt_actual, DISCOUNT, TYPE, Refno, Percost, m_product_alias_id, Markdisamt, Item_description, C_ markbaltype_id, Statustime, ad_pi_id, c_retailtype_id) SELECT b.id, b.ad_client_id, b.ad_org_id, B.OWNERID, B.ISACTIVE, A.billdate, A.docno, A.retailbilltype, A.ownerid as creater, a.c_store_id, A.description, a.c_vip_id, B.SALESREP_ID, B.M _product_id, b.m_attributesetinstance_id, B.qty, B.pricelist, B.tot_amt_list, B.priceactual, B.TOT_AMT_ACTUAL, B. DISCOUNT, B.type, A.refno, (SELECT k.percost from fa_product_cuscost K WHERE k.c_customer_id = a.c_customer_id and K.m_pro duct_id = b.m_product_id) as Percost, b.m_productalias_id as m_product_alias_id, b.tot_amt_actual * 0, B.DESCRIPTION ITEM_ DESCRIPTION, b.c_markbaltype_id, A.statustime,: B5, A.c_retailtype_id from M_r
Sun Jul 27 16:12:03 2014

Today is the weekend, it is rare to take a break, 8 o'clock to the Office to check the situation of the library, found a log error, this statement is familiar with, that is, these days have been and development over there to communicate a report of the stored procedure, the statement has been dominating the ADDM performance analysis accounted for the top SQL Statements first, on July 18 when the statement fills the undo table space, the log appears ORA-01555 caused by SQL statement below prompt, so look at the undo table space immediately,

20:25:00 [email protected]> select sum (maxbytes)/1024/1024/1024,sum (user_bytes)/1024/1024/1024 from Dba_data_ Files where tablespace_name= ' UNDOTBS1 ';

SUM (maxbytes)/1024/1024/1024 sum (user_bytes)/1024/1024/1024
---------------------------- ------------------------------
63.9999695 63.9989624

elapsed:00:00:00.02
20:25:02 [email protected]> select sum (maxbytes)/1024/1024/1024,sum (user_bytes)/1024/1024/1024 from Dba_data_ Files where tablespace_name= ' UNDOTBS2 ';

SUM (maxbytes)/1024/1024/1024 sum (user_bytes)/1024/1024/1024
---------------------------- ------------------------------
63.9999695 63.9989624

20:10:46 [email protected]> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Undo_management string AUTO
Undo_retention Integer 900
Undo_tablespace string UNDOTBS1

The table space is almost no use, actually look at the size of the table space I will be through the OEM view more straightforward;

20:29:02 [email protected]> SELECT DISTINCT STATUS, COUNT (*), SUM (BYTES)/1024/1024/1024 from Dba_undo_extent S GROUP by STATUS;

STATUS COUNT (*) SUM (BYTES)/1024/1024/1024
--------- ---------- -------------------------
EXPIRED 2739 11.5249634
Unexpired 957 1.08874512
ACTIVE 5.01171875