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.