Home » RDBMS Server » Server Administration » Error in alert log (Oracle 9i)
Error in alert log [message #418370] Fri, 14 August 2009 07:29 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

I again got the error in the alert log.I can understand these are Long runing queries.

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


The query when I am trying to run is taking very small amount of time.Why this error in coming in alert log.What I should do to resolve the ORA-01555 ERROR IN the alert log.When I am trying to fire the query in the backend the query is taking very small amount of time aproximately 2 seconds.Why this error have come in the alert log.?.What could be the cause of the above issue?.As well as How is the query Duration so much.So wanted to know what is the cause of the issue and how can I resolve the above issue?


Re: Error in alert log [message #418382 is a reply to message #418370] Fri, 14 August 2009 08:01 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Remove the commits from your loops.
Previous Topic: uable to create INITIAL extent for segment in tablespace PREMIA.
Next Topic: Refresh group for Materialized views monitoring
Goto Forum:
  


Current Time: Sun Dec 11 03:55:22 CST 2016

Total time taken to generate the page: 0.17378 seconds