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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
