I could be wrong, but I don't believe that redo, temp or undo
are taken into account for either SBRT or MBRT.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 3/9/06, Joseph Amalraj <joseph_at_amalrajinc.com> wrote:
>
> That is a great paper, Mike ault also has done some research in this
> field.
>
> SSD is good for redo, temp and undo.
>
> I do not know how optimizer will handle other tablespaces. As currently
> the optimizer uses the single block read time and multiblock read time. And
> this will change if some tablespaces are on hard disks and others in SSDs.
>
> Joseph Amalraj
>
>
> * <jo_holvoet_at_amis.com>*
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 09 2006 - 18:01:16 CST
