Hi,
Since u r working on an OLTP database - I would recommend u to use the automatic behaviour of undo segments present in 9i onwards. As this releives u from making new undo segments as and when required since Oracle automatically takes care of this feature.
Thanx




Reply With Quote