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.
