Question on TEMP tablespace...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Question on TEMP tablespace...

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    Question on TEMP tablespace...

    Hi,

    I have TEMP tablespace 4 GB.

    Which one of the following is better solution.

    1. TEMP tablespace having one data file 4 GB.

    2. TEMP tablespace having two data files , each having 2 GB in one file system.

    3. TEMP tablespace having two data files , each having 2 GB distributed to two file systems.

    4. TEMP tablespace having 2 GB and TEMP1 tablespace having 2GB of size.

    OR any other solution..?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    i would prefer temp files or anyfiles less than 2Gb..if the mount points are under two different disks under two different controllers then for balancing out IO..i would go for choice 3

    regards
    Hrishy

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you are using RAID 0 then there is not difference between 2 and 3 really

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by pando
    if you are using RAID 0 then there is not difference between 2 and 3 really
    Why do you say that? IMHO, two TEMP files on two different RAID 0 filesystems is definitely better than two TEMP files on one RAID 0 filesystem.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well that if two are in two seperate controllers

  6. #6
    Join Date
    Jul 2002
    Posts
    205
    4. TEMP tablespace having 2 GB and TEMP1 tablespace having 2GB of size.

    Well in your views number 4. is not a good solution.. I mean two TEMP tablespace

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Depends. If you have two distinct users doing massive sorts at the same time it might be worthwhile.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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