Hi Folks,

Oracle recomends putting blob data in a table to a seperate table
space.(internally a different data file)
So advantage of this can be that , the wait that might be caused due the
reading of BLOB data from the same data file(if present in same table space)
will be reduced by having a different datafile for blob data.

Any clues on how to verify /confirm this.

Please highlight if there are any other performance improvement got by
moving blob data to a different tablespace.

Thanks and Regards,
Dinesh


\|/
(@ @)
---------------------------oOO--(_)--OOo-----------------------------------
``` '''
"Always code as if the guy who ends up maintaining, or testing your
code will be a violent psychopath who knows where you live."
---------------------------------------------------------------------------


Oracle LazyDBA home page