Re: Which RBS is my Update using ?

Hi Pablo and all

Oracle is full of options and alternatives. So long as you know what the options are, so long as you are aware of the pros and cons of each option and so long as you apply an option in a manner that is appropriate to your environment then you won't get too much of an argument from me.

Using the SET TRANSACTION command is just another option. It has pros (such as controlling the size of RBSs when storage might be an issue) and cons (such as making an application reliant on the availability of an RBS and subject to abuse if too many concurrent transactions need access to the same RBS). If you are aware of the various issues then the correct and valid option can then be applied.

My thoughts

Richard

"Pablo Sanchez" <pablo_at_dev.null> wrote in message news:Xns928C9FE856127pingottpingottbah_at_192.168.1.1...
> Tanel Poder <tanel_at_peldik.kom> wrote in
> news:3d8799c0$1_1_at_news.estpak.ee:
>
> > So, having all same sized rollback segmnents is a good, best
> > practice in general conditions, but still, I don't see what use
> > would I get by resizing all of my rbs'es to a huge size. So far
> > I'm following the golden rule of all engineers - If it works,
> > don't touch it ;)
> >
> > Or am I missing something here?
> >
>
> Dogmatically following a rule is pointless as we all know there are
> exceptions. What you state Tanel is a fact of DBA life. Your end
> user's don't care about the purity of the setup, they want their
> data and that's all there is to it. You have to balance purity with
> their needs and do what's best.
>
> What you listed sounds to me to be a good balance.
> --
> Pablo Sanchez, High-Performance Database Engineering
> http://www.hpdbe.com
Received on Tue Sep 17 2002 - 19:20:08 CDT