I'm learning Oracle coming from a MSSQL background. I may be wrong, but I'm comparing the AUTOEXTEND option with MSSQL Auto Grow option. I set the Auto Grow setting a bit large just to minimize on physical disk fragmentation. Generally, a small auto grow setting can create disk fragmentation as it grows. Obviously there are ways to cut down on this, but that's another issue.
With AUTOEXTEND, is it generally better to use a large fixed amount, or a smaller fixed amount. I'm surprised by the small numbers used in training material so I'm questioning my understanding of this.
I appreciate a little clarification!!