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@xxxxxxxxxxxxxx> 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@xxxxxxxx>* >