How can I tell if the optimal parameter has been set for my roll back segments
SELECT OPTSIZE FROM V$ROLLSTAT; You can also join this view with V$ROLLNAME to get the information by RBS name
John Doyle
Forum Rules