auto-auto-extending files
Running a 19.16 database on Solaris Sparc 64, getting this behaviour
I add a new file to a tablespace
I set the size to 1 GB, autoextend on to 32 GB, and enable autoextend
Nice, file created 1 GB. No problem.
Somewhat later I check, and the file is 32 GB.
It is NOT because the file has data added:
The usage of this file is 1 MB (not 1 GB, 1 MB)
There are OTHER files in the tablespace, and they still have free space, as they had before I added this new file.
What I expect is that the database enlarges the file, IF it reaches around 1 GB by means of data expansion in that file, and then add ONE next block of whatever set in NEXT.