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

NetComrade wrote:
> 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)

And you do. It is that to which I referred.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)