now as mentioned in oracle documents for the first 20,000 extents asm file growth is 8*au , now let's say i have new created asm file
select file#,CREATE_BYTES, bytes/(1024*1024) size_mb,blocks,name from v$datafile where file#=6
SQL> /
FILE# CREATE_BYTES SIZE_MB BLOCKS NAME
---------- ------------ ---------- ---------- --------------------------------------------------
6 1048576 1 128 +DATA/testdb1/datafile/test_ts1.267.928352753
and i keep inserting in a table belonging to that file until it is full
ERROR at line 1:
ORA-01653: unable to extend table TEST_TS1_USER.EMP by 8 in tablespace TEST_TS1
till this point the size of the file is still 1mb , i decide to make the file AUTOEXTEND and inserted some rows in a table in that datafile and check the size of my file
SQL> select file#,CREATE_BYTES, bytes/(1024*1024) size_mb,blocks,name from v$datafile where file#=6;
FILE# CREATE_BYTES SIZE_MB BLOCKS NAME
---------- ------------ ---------- ---------- --------------------------------------------------
6 1048576 3.0625 392 +DATA/testdb1/datafile/test_ts1.267.928352753
*** SO the file growth is not 8*au , (my au is 1 mb) , IS NOT THE FILE SUPPOSE TO GROW BY 8 MB OR I AM MISSING SOMETHING?
thanks all.