| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Disk config. for datafiles of Temp Tablespace
What about mount point on same controller? Split them on different
controller if not ? What is the maximum usage of your TEMP tablespace ? and
size of datafiles...? Try to reduce size of your temp tablespace as it looks
very large....
Better solution is
Datfiles of 501MB each split on different mount points configured with
different contollers...Please also check for such querries resulting in
Cartesian Joins resulting lot of IO's and temp usage...
Regards
MOHAMMAD RAFIQ
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Tue, 14 Aug 2001 07:56:46 -0800
Hi All,
We have data warehouse which uses arround 34 GB of temporary tablespace. The datafiles for this are tempfiles and the tablespace is LMT.
We use EMC storage.
The tempfiles are on two file systems which inturn are
mirrored and striped across three 8 GB disks.
We are seeing heavy IO on these files and Our direct path write waits are high.
Could you guys suggest a better file layout of disk configuration?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: joni_65_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Aug 14 2001 - 11:31:38 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |