i created a temporary tablespace without setup autoextent to one.
later on, i
alter database tempfile 'mytempfile' autoextend on ;
i query dba_temp_file.
it tells me increment_by is 1.
what does that mean? why 1?
alter database tempfile 'mytempfile' autoextend on next 10m.
and query dba_temp_files again.
it gives me 1280 for increment_by.
if increment by is the number temp file will extend.
then what will happen if i didn't give the value for next,
how much will oracle extend, 1*8k?
guru is on the way!!!!
1280 is the number of blocks to extend (ie.
YOu have a block size of 8192
8192 * 1280 = 10485760
10485760/1024 = 10240 (10 Mb)
OCP 8i, 9i DBA
yes , i understand that.
my question is when i didn't put value for next,
it will gives me value 1,
does that mean by default it will extend 1*8k which is 8k each time it need to extend?
Click Here to Expand Forum to Full Width