If I don't specify OPTIMAL in Rollback Seg , will the rollback seg space be used up and never shrink ?
Printable View
If I don't specify OPTIMAL in Rollback Seg , will the rollback seg space be used up and never shrink ?
In RBS the key word OPTIMAL is used to shrink back the extents if exceeded OPTIMAL limit and going towards MAXEXTENTS. It's very useful to cut down unnecessary space usage. Yeah, if you don't mention OPTIMAL then it will go on increasing towards the MAXEXTENTS and will not decrease unless you issue the SHRINK command.