ORA 01555 alerts have been captured in my Database 
Statement 1:
Thu Aug 13 20:26:44 2009
ORA-01555 caused by SQL statement below (Query Duration=17189 sec, SCN: 0x0000.384babc2):
Thu Aug 13 20:26:44 2009
Select r.item_name, r.value, r.mdlid, r.rowsort, r.year, r.stmtid from ( select t.item_grpflag, t.item_name as item_name, round(t.value, 0) as value, t.mdlid, t.item_id as rowsort, t.year, t.stmtid from( select l.item_grpflag, l.item_name as item_name, l.value, l.mdlid, l.item_id, l.stmtid, m.year from ( select a.item_grpflag, nvl(b.stmtid, 0) as stmtid, a.fm_row, d.mdlid, lpad(a.item_name, length(a.item_name)+((a.tr_lvl-1)*5), ' ') as item_name, b.value, a.item_id from coaitems a, coabalances b, coatree c, model d where a.coaid = b.coaid  and a.tr_id = b.tr_id  and a.item_id = b.item_id  and a.fm_row = b.coarow  and a.coaid = c.coaid and a.tr_id = c.tr_id and a.coaid = d.mdlid and trim(lower(c.tr_name)) = 'balance sheet' and a.item_id > 0 and d.mdlid =2 and b.borrid  = 3875 and b.user_id  = 1956 order by a.coaid, a.fm_row ) l, ( select 0 as stmtid, '0' as year from dual union all select n.stmtid, '(' || rownum || ')' || chr(13) || n.year from ( select x.stmtid, z.auditmethod_name||' '||


Statement 2:
Thu Aug 13 20:26:44 2009
ORA-01555 caused by SQL statement below (Query Duration=17293 sec, SCN: 0x0000.384b9cd6):
Thu Aug 13 20:26:44 2009
Select r.item_name, r.value, r.mdlid, r.rowsort, r.year, r.stmtid from ( select t.item_grpflag, t.item_name as item_name, round(t.value, 0) as value, t.mdlid, t.item_id as rowsort, t.year, t.stmtid from( select l.item_grpflag, l.item_name as item_name, l.value, l.mdlid, l.item_id, l.stmtid, m.year from ( select a.item_grpflag, nvl(b.stmtid, 0) as stmtid, a.fm_row, d.mdlid, lpad(a.item_name, length(a.item_name)+((a.tr_lvl-1)*5), ' ') as item_name, b.value, a.item_id from coaitems a, coabalances b, coatree c, model d where a.coaid = b.coaid  and a.tr_id = b.tr_id  and a.item_id = b.item_id  and a.fm_row = b.coarow  and a.coaid = c.coaid and a.tr_id = c.tr_id and a.coaid = d.mdlid and trim(lower(c.tr_name)) = 'balance sheet' and a.item_id > 0 and d.mdlid =2 and b.borrid  = 3875 and b.user_id  = 1956 order by a.coaid, a.fm_row ) l, ( select 0 as stmtid, '0' as year from dual union all select n.stmtid, '(' || rownum || ')' || chr(13) || n.year from ( select x.stmtid, z.auditmethod_name||' '||



Statement 3:
Thu Aug 13 20:38:58 2009
ORA-01555 caused by SQL statement below (Query Duration=13090 sec, SCN: 0x0000.384fa14f):
Thu Aug 13 20:38:58 2009
UPDATE AUD_SUBJECTIVE_PRM_TRANS AUDT SET AUDT.USER_ID = :V00001, AUDT.TRANS_DATETIME = SYSDATE WHERE AUDT.ID = :V00002 AND AUDT.DBACTIONTYPE = :V00003