Are you sure that these are the ones that are slowing
the system down ? Did you try to find out at what
time of the day the system is really slow and execute
your wait/event queries at that time ? Did you get
a slice of 10046 data when the application was actually
running slow ?You could be
If your D partition is just a logical device then, 'No'. Only moving to a
different physical device will reduce I/O contention.
oraora
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)
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
Cary Millsap,
i selected the top 25 SQL statements in the system over various
periods . all are SELECT statements only waiting for reads.
querying v$session_wait also shows more than 10 records each for
DB FILE SCATTERED READS and DB FILE SEQUENTIAL READS.does not it
mean that it's b'coz of I