DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: temp file

  1. #1
    Join Date
    Jun 2001
    Posts
    193
    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!!!!

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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

  3. #3
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    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?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    yes
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width