ORA-01555 caused by SQL statement below (Query Duration=46906 sec, SCN: 0x093c.38520a4e):
Please help on the below issue that how can i avoid this snapshot too old error which are coming continously and how can i calculate required undo tablespace to avoid thes type of issues.
ORA-01555 caused by SQL statement below (Query Duration=46906 sec, SCN: 0x093c.38520a4e):
Sun Feb 12 00:27:24 2012
SELECT 'REPORT' REPORT, BUCKET_SEQUENCE_NUM, CUSTOMER_ID, PERIOD_NAME, 'O/S AGING' AMT_TYPE, SUM (BALANCE) AMOUNT FROM (SELECT ARBL.REPORT_HEADING1 PERIOD_NAME, BUCKET_SEQUENCE_NUM, DAYS_TO, DAYS_START FROM AR_AGING_BUCKETS ARAB, AR_AGING_BUCKET_LINES ARBL WHERE ARBL.AGING_BUCKET_ID = ARAB.AGING_BUCKET_ID AND ARAB.STATUS = 'A' AND ARAB.AGING_BUCKET_ID = :B12 ) PERIOD, (SELECT CLASS_CODE, CLASS_CODE_DESC, ACCOUNT_NO, CUSTOMER_NAME, PO_BOX, ADDRESS, CITY, COUNTRY, DOC_DATE, DOC_CATEGORY, TRX_NUMBER DOC_NO, DECODE(SIGN(SUM(AMOUNT)),1,SUM(AMOUNT),0) AMOUNT_DR, DECODE(SIGN(SUM(AMOUNT)),-1,ABS(SUM(AMOUNT)),0) AMOUNT_CR, DECODE(SIGN(SUM(AMOUNT-AMOUNT_APPLIED+ADJ_AMT)),1,SUM(AMOUNT-AMOUNT_APPLIED+ADJ_AMT