Hi, Moving to different Tablespaces will not do u any good.
To learn more there was big List of Disscussion on... Comp.databases.oracle.server [ Google Groups http://groups.google.com ] You can go and seasrch there seperating Tables and Indexes. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 ========================================== Live to learn... forget... and learn again. ========================================== -----Original Message----- oraora Sent: Thursday, July 11, 2002 7:29 PM To: Multiple recipients of list ORACLE-L Thanx Thomas . i am pretty new to RAID. will not moving my tables and indexes to seperate tablespace reduce my i/o ? my h/w setup is: there is a logical partition D: of size 80GB with RAID5. is it enough that i move to seperate tablespace ? os should i create another partition like D: and put my files there ? i am novice DBA . plz. guide me Thomas. On Thu, 11 Jul 2002 Thomas Day wrote : > >If you can move the indexes to a separate physical device (and >their own >tablespace/datafile) then you will reduce I/O contention. If >the >tablespace/datafile is on the same RAID device then you will be >using the >same r/w heads and you will not reduce I/O contention. > > > > oraora > oraora To: Multiple >recipients of list ORACLE-L > <oraoraora ><[EMAIL PROTECTED]> > @rediffmail.c cc: > om> Subject: sequential >reads/scattered reads > Sent by: root > > > 07/11/2002 > 07:33 AM > Please > respond to > ORACLE-L > > > > > > >Guys, > >Querying my v$session_wait shows 10 rows each DB FILE >SEQUENTIAL >READ and DB FILE SCATTERED READ. > >manuals explain it all b'coz of I/O. > >there are 33 tables and 110 indexes in the same USERS >tablespace >with only one datafile USERS01.DAT of size 12GB. > >it's physically laid out in D:\oracle\data. >but the hard disk capacity is 100GB with 8 disk heads and >RAID5. > >will not moving the tables and indexes to seperate tablespace reduce >I/O traffic ? my manager here says that since it is configured with >RAID5 and 8 disk heads , it's not a problem. > >is it so ? is he right ? >plz. clarify me. i need to explain him. >it's urgent.he is sitting on my head. > >TIA. >_________________________________________________________ >There is always a better job for you at Monsterindia.com. >Go now http://monsterindia.rediff.com/jobs > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: oraora oraora > 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). > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Thomas Day > 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). _________________________________________________________ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja 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).