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