DBAs.

Recently, one long query (duration around 1 hour) keeps failing with ora-01555. I increased the undo to 1.5g from 1g. It still gets the same error. Any good suggestion or work around to solve this problem?

Thanks!