Question on TEMP tablespace...

[skdas]

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..?

[hrishy]

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

[pando]

if you are using RAID 0 then there is not difference between 2 and 3 really

[marist89]

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.

[pando]

well that if two are in two seperate controllers

[skdas]

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

[marist89]

Depends. If you have two distinct users doing massive sorts at the same time it might be worthwhile.