Re: ORA-01555 error

Hello,

There are about 4 cases for ora-1555. Add following event to init.ora:

event = "1555 trace name errorstack, level 3"

After that, whenever Oracle encounteres ora-1555, a trace file will be generated. Send trace file, let's look at what is happenning.

regards...

"Farnsworth, Dave" wrote:

> I got this error last night;
>
> SCT51 - FETCH FROM DRP DRIVER CURSOR FOR DRP PROCESSING FAILED. MSG =
>
> SCT SCP_DRP_DRIVER PRODDB ORA-01555: snapshot too old: rol
>
> lback segment number 15 with name "RB1
>
> Do I just need to increase the size of the rollback segment to fix this or
> is there something else I need to be looking at?
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--

Web: http://www.unal-bilisim.com
*********
Questions and Answers: http://www.unal-bilisim.com/qa/discus/
*********
itrprof SQL Analyzer:
http://www.unal-bilisim.com/products/itrprof/itrprof.html

itrprof SQL Analyzer is a web based tool which analyzes
SQL_TRACE/Event10046 trace files of Oracle,
finds bottlenecks and offersinformation on how to tune them.
*********
iOraBugFinder:
http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html

iOraBugFinder is a web based tool which scans Oracle's alert log files,
ORA-600 and ORA-7445 trace files; extracts relevant information from them
and generates URL links to relevant bugs, notes, forums at Metalink.
*********


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).