thread of the year....gotta be :D
Printable View
thread of the year....gotta be :D
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.
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.
Thanks All!! Espacially Davey And Bore ,i Learn A Lot .
good spirit liakat!!