Andras Kovacs wrote:
>If you have write performance issues having two separate tablespaces
>is better. Typical case: If you want to rebuild your index having 2
>separate table spaces is much better. In addition two tablespaces must
>be on separate physical disks!
>
>For read performance number of tablespaces is not important.
>
>
Tablespaces are irrelevant. Oracle does not write to a tablespaces ...
it writes to datafiles. And two different tablespaces, with separate
datafiles, can still be on the same disk: And often are when people
aren't discussing the actual issue.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Sep 17 2003 - 18:11:24 CDT
