Re: Any way to disable UNDO (rollback) with temporary tables?

Daniel,

If you're referring to the 'events' part of my original post (e.g. an unsupported parameter), I will have to disagree with you.. Oracle, besides having some bugs, also seems to hide some semi-bugs, or performance enhancers as 'events'. E.g. I have an event set (btw, as suggested by Oracle support) to disable histogram lookups for remote queries, since we have lots of queries over the link, and w/o the parameter set we had significant latch contention.

If there was such an event, I wouldn't put it into production w/o Oracle's consent

The goal of my post was
1) To see if someone would prove me wrong (e.g. why in my case do I need undo)
2) To see if someone will come up with a better solution than using temporary tables

On Tue, 02 Dec 2003 14:15:34 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:
>
>Excuse me ... but you don't have a point. Oracle can not and will
>not function as you wish it to. Well actually it can with some
>unsupported parameters in the init.ora. But it will also crash and
>burn in quite short order.
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Dec 02 2003 - 16:49:04 CST