Ora-01555

[mrchrispy]

thread of the year....gotta be

[ams-jamali]

Thanks Bore,

I have learned new concepts(actual working) of UNDO SEGMENT from this thread.
I will try reducing undo retention on testing server and then implement on production.

[reydp]

Why spending much time understanding the nature of ORA-01555, where in fact most of the cases if not all it is caused by query that is not optimized. I have to agree with Tamil.

[liakat]

Thanks All!! Espacially Davey And Bore ,i Learn A Lot .

[abhaysk]

good spirit liakat!!