If you use tablespace hot backups, it is a good idea not to place many
extremely active segments in one huge tablespace. Not only will you have
heavy redo generation during hot backup mode, but you will also have to
apply more redologs (bacause it took longer to back up) in order to
recover a single large active tablespace.
--
Jeremiah
jgroff wrote:
>
> So the only benefit you can get from splitting tables into seperate table
> spaces is the ability to place them on different devices?
>
> dave mausner wrote:
> >
> >>This is the first step, the next step ist to put this tablespaces on
> >>different disks...
> >>
> >>jgroff <jgroff_at_msn.com> schrieb...
> >>> We're experiencing some performance problems and we had a consultant
> >>> suggest that we split some of the more heavily accessed/updated
> >>> tables out into their own dedicated tablespaces.
Received on Tue Jan 11 2000 - 10:56:38 CST
