Sign in or 

oradba5339 |
Latest page update: made by oradba5339
, Oct 23 2009, 8:28 PM EDT
(about this update
About This Update
Edited by oradba5339
4 words deleted view changes - complete history) |
|
Keyword tags:
Oracle Performance Tuning
Oracle Tuning
Performance Tuning
PT
Tuning
More Info: links to this page
|
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| redferrariteam | Multiple temp files | 5 | Jan 2 2008, 12:00 PM EST by HayrolR | ||
|
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?
Keyword tags:
Oracle Performance Tuning
Oracle Tuning
Performance Tuning
PT
Tuning
|
|||||