| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> resizing/moving datafiles for performance ??
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: oraoraora_at_rediffmail.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). Received on Fri Jul 19 2002 - 03:58:19 CDT
 |
 |