-
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?
then i
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)
Cheers
OCP 8i, 9i DBA
Brisbane Australia
-
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?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|