Re: Still struggling with ORA-01555

From: Pei L. Ku <pku_at_gte.net>
Date: 22 May 1998 14:55:46 GMT
Message-ID: <6k43li$ll4$1@gte1.gte.net>

There are more insidious reasons that can cause ora-1555 and can't really be cured by larger rbs... If you have access to Oracle manuals and Oracle support's WWW Metalink, look up 'fetch across commit' and 'delayed dirty db block cleanout'. If you need more help from me, you can email me a description of your applications and what they are doing and see what we can do (oh yes, many times ora-1555 is caused by bad handling/understanding of Oracle's transaction processing, not something can be fixed by DBAs at db level)

Pei
pku_at_aol.com

larionov_at_yahoo.com wrote in article <6k41k0$is8$1_at_nnrp1.dejanews.com>...
> I am still struggling with ORA-01555.
> One of the recomendations was to increase
> the rollback segments.
> Does it mean:
> a. Increase INITIAL extent
> b. Increase MINEXTENTS
> c. Increas MAXEXTENTS
>
> Which of the above helps the problem best?
>
> Thank you!
>
> Michael.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Fri May 22 1998 - 09:55:46 CDT