Thread started: Dec 27 2007, 5:58 AM EST
Watch
Hi Experts,
We have a four disk solaris production server without RAID configuration.
Many SQL queries of the application would perform huge sort operations. In order to use the available I/O bandwidth optimally we created 3 temp files on different disks for our TEMP tablespace.
While monitoring the I/O performance we realized that only one tempfile is used extensively though the data being sorted is too huge compared to the extent size.
In case of data files(multiple datafiles per TS) Oracle would allocate extents in a round ronbin fashion.
Would like to know why the same seems to be not happening in our case. Any pointers?
2
out of
13 found this valuable.
Do you find this valuable?
Do you?
Show Last Reply
|
|
Last Reply:
RE: Multiple temp files
By: ,
Jan 2 2008, 12:00 PM EST
Exactly, that was a try to say you that you won't get a significant improvement in performance.
Regards
0
out of
3 found this valuable.
Do you find this valuable?
Do you?
|
