temp extent size for DMT
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: temp extent size for DMT

  1. #1
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116

    temp extent size for DMT

    I read Oracle Doc recommendation that the best extent size for TEMP tablespace (DMT) is sort_area_size (or multiple) + db_block_size. When i applied this to my DB 5 minutes later it hit an error.. unable to extent tablespace TEMP.... when i change back to original extent sizinh which is 520k, the db running with no error.
    DB 8.1.7 on Solaris
    Any idea on this?
    The man called Zorro

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    So what size did you change it to?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    changed to sort_area_size + db_block_size
    first time
    524288*2 + 8192 = 1056768 <- hit error
    second time
    524288 + 8192 = 532480 <- also hit error

    now init 520k next 520k..
    so far 2 week runnign without any problem... any idea slimdave?
    Last edited by zainalj; 04-16-2004 at 02:32 AM.
    The man called Zorro

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    i suspect if you may have specified 1056768 K or M?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    Originally posted by abhaysk
    i suspect if you may have specified 1056768 K or M?
    i did't specify anything.. where it should be on bytes.
    The man called Zorro

  6. #6
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    any idea???
    The man called Zorro

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Just try giving

    524288*1 + 8192 = 532480
    -nagarjuna

  8. #8
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    Originally posted by nagarjuna
    Just try giving

    524288*1 + 8192 = 532480

    ??? if you read my msg above.. i did tried this formula and hit error

    anybody may explain why?
    The man called Zorro

  9. #9
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Uhhh I don't remember mentioning that to you.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  10. #10
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by zainalj
    ??? if you read my msg above.. i did tried this formula and hit error

    anybody may explain why?
    I am sorry.. I missed it out. Try the following..

    initial ==> 524288*1 + 8192 = 532480
    next ==> 524288
    -nagarjuna

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