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: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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?
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_________________________________________________________________
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
