Guys, the DB is on 8.1.6 / Win2K.
there entire DB ( 33 tables and 110 indexes) is in USERS tablespace. the USERS tablespace has only one datafile USERS.DAT of size 12GB. it's on 8 * 10 GB HDD with RAID 5. we are facing performance bottleneck now. V$SESSION_WAIT shows many rows for DB FILE SCATTERED READ and DB FILE SEQUENTIAL READ. all these events wait for USERS.DAT to be read. it's a highly read OLTP site. So,will moving the table and index data to different tablespaces with relatively smaller datafiles ( say 1 GB ) improve performance ? OR since it is on RAID5 , will moving make any difference ? 10-20 MB of data gets added to the DB daily. if resizing/moving improves performance,what should be the size of my datafile ? kindly give me a solution guys. TIA. -- 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).
