How can I tell if the optimal parameter has been set for my roll back segments
Printable View
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