Re: drop user hangs

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F4BF4E7.456C1CD3_at_exxesolutions.com>...
> Joel Garry wrote:
> > Well, ORA-155x is supposed to be long-gone with undo, but I'm
> > wondering if something is so messed up it hangs and can't tell you
> > about it. That could be an error that is supposed to come back to
> > you, rather than the alert log.
> >
> > Are you sure you aren't running into a maxsize parameter on your
> > autoextend ts? I would be worried about a 98% filled system ts just
> > on general principle, but then again I'm old-fashioned.
> >
> > jg
> > --
> > @home.com is bogus.
> > http://www.zone-h.org/en/news/read/id=3287/
>
> UNDO decreases the incidence of ORA-01555 but does not eliminate it. And most certainly can not solve the problem
> of badly written code such as incremental commits inside a loop.

I knew that, I just can't resist obscure digs at Oracle marketroids who claimed "no more ora-1555" in so many words when 9 came out. Or was it 9iR2? :-O

jg

--
@home.com is bogus.
http://philip.greenspun.com/wtr/dead-trees/53013.htm